将多个值输入参数传递给HANA Calculation View时出错

2020-09-09 23:52发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


嗨,我正在尝试将多个值传递给启用了多重输入的输入参数PLANVER,我正在使用以下表达式在"过滤器表达式"中过滤该多次输入的参数

in(" PLANDATE",rightstr('$$ PLANVER $$',10))

通过AFO运行此程序并传递多个输入条目以及通过sql运行时,出现以下错误。

选择" PLANNINGVERSIONNAME"," PLANDATE"," Z_PLAN_DATE"," PERIODID"," WEEK_SEQ_NO"," PRODUCT"," LOCATION"," Z_PLAN_HZ_WEEK"," MONTH_SEQ_NO"," PLANNINGVERPLUSPLANDATE",sum(" FORECASTCONSTR") 作为" _SYS_BIC"中的" FORECASTCONSTR"。" FlowGraph/CA_TEST_MULTIPLE_ENTRY"('PLACEHOLDER'=('$ PLANVER $','''BASE_2019-03-11''))GROUP BY" PLANNINGVERSIONNAME"," PLANDATE"," Z_PLAN_DATE"," PERIODID"," WEEK_SEQ_NO"," PRODUCT"," LOCATION"," Z_PLAN_HZ_WEEK"," MONTH_SEQ_NO"," PLANNINGVERPLUSPLANDATE"

传递多个iput参数时出错捕获到异常:异常70034023:计算模型的实例化失败\ $ message \ $ =计算模型的实例化失败;异常306002:发生内部错误(42014)

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


嗨,我正在尝试将多个值传递给启用了多重输入的输入参数PLANVER,我正在使用以下表达式在"过滤器表达式"中过滤该多次输入的参数

in(" PLANDATE",rightstr('$$ PLANVER $$',10))

通过AFO运行此程序并传递多个输入条目以及通过sql运行时,出现以下错误。

选择" PLANNINGVERSIONNAME"," PLANDATE"," Z_PLAN_DATE"," PERIODID"," WEEK_SEQ_NO"," PRODUCT"," LOCATION"," Z_PLAN_HZ_WEEK"," MONTH_SEQ_NO"," PLANNINGVERPLUSPLANDATE",sum(" FORECASTCONSTR") 作为" _SYS_BIC"中的" FORECASTCONSTR"。" FlowGraph/CA_TEST_MULTIPLE_ENTRY"('PLACEHOLDER'=('$ PLANVER $','''BASE_2019-03-11''))GROUP BY" PLANNINGVERSIONNAME"," PLANDATE"," Z_PLAN_DATE"," PERIODID"," WEEK_SEQ_NO"," PRODUCT"," LOCATION"," Z_PLAN_HZ_WEEK"," MONTH_SEQ_NO"," PLANNINGVERPLUSPLANDATE"

传递多个iput参数时出错捕获到异常:异常70034023:计算模型的实例化失败\ $ message \ $ =计算模型的实例化失败;异常306002:发生内部错误(42014)

付费偷看设置
发送
2条回答
SKY徐
1楼 · 2020-09-10 00:48.采纳回答

首先,如果使用多值输入参数,则在定义参数时不应使用单引号。 其次,您不能在多值输入参数上应用函数(仅单值参数允许使用它们)。 有效表达式应如下所示:

 in(" PLANDATE",$$ PLANVER $$)
compass1988
2楼-- · 2020-09-10 00:52

感谢Konrad的快速答复

一周热门 更多>