点击此处---> 群内免费提供SAP练习系统(在群公告中)
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
您好,IBP专家,
我在以下位置引用帮助文档:
使用某些过滤器(包括:KF_FILTER)构建oData URL来提取IBP数据。
我的问题是如何应用多个KF_FILTER。 我需要对具有非零值的多个关键指标应用过滤器。
我尝试过的示例语法是(排除零):
KF_FILTER eq'[{" KF":" FINALCONSENSUSDEMAND"," SIGN":" E"," OPERATOR":" EQ"," IS_ABSOLUTE":" X"," VALUE":" 0"},{ " KF":" FINALCONSENSUSDEMAND"," SIGN":" E"," OPERATOR":" EQ"," IS_ABSOLUTE":" X"," VALUE":" 0"}]''
但这仍然返回全零。
我在URL中也有其他过滤条件,如SAP帮助页面上所述。
非常感谢您的帮助。
嗨,
您可以尝试这个例子吗?
KF_FILTER eq'[{"" KF":" FINALCONSENSUSDEMAND"," SIGN":" I"," OPERATOR":" GT"," IS_ABSOLUTE":" X"," VALUE":" 0"}]]'
示例代码:
https://您的服务器-api/sap/opu/odata/IBP/EXTRACT_SRV/extract_kf?$ filter = BUSINESS_USER eq'您的业务用户'和PLAARE eq'您的计划区域'以及CONVERSION_ATTRIBUTES eq'[[{" ATTRIBUTE ":" UOMTOID"," VALUE":" KG"},{" ATTRIBUTE":" CURRTOID"," VALUE":" USD"}]'和KF_IN eq'FINALCONSENSUSDEMAND,DELIVQTY'和PERIOD_FILTER_VALUE eq'JAN 2016'和 KF_FILTER eq'[{" KF":" FINALCONSENSUSDEMAND"," SIGN":" I"," OPERATOR":" GT"," IS_ABSOLUTE":" X"," VALUE":" 12"}]'和ATTR_IN eq 'BRAND,PERIODID3,PRDDESCR'和VERSIONS eq'[{"" VERSION_NAME":"您的版本"," SCENARIO_NAME":""}]'和SORT_BY eq'[{" SORT_BY":" ATTRIBUTES"," SORT_TYPE":" 降序"}]'saml2 = disabled
最好的问候
Lingaiah
感谢Lingaiah的回复...
我认为,我之前的问题不太清楚。
我正在寻找如何在查询中添加多个过滤条件的方法,但是,我不知道多个KF_FILTER的语法,SAP帮助页面仅显示了1个过滤器的语法。 因此,我什至不确定是否可以在查询中应用多个过滤器。
当我编写多个过滤器时:
KF_FILTER eq'[{" KF":" IFINQTY"," SIGN":" E"," OPERATOR":" EQ"," IS_ABSOLUTE":" X"," VALUE":" 0"},{ " KF":" IREVSHIPQTYACT"," SIGN":" E"," OPERATOR":" EQ"," IS_ABSOLUTE":" X"," VALUE":" 0"}]''
第一个关键指标过滤器已正确应用,但是第二个关键指标过滤器似乎无法正常工作,并且也返回了零。
感谢任何帮助...
谢谢
Shetul
一周热门 更多>