BPC脚本逻辑-具有多维组合的查找

2020-09-13 16:52发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)大家好, 如果我呼叫一个区...

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

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


大家好,

如果我呼叫一个区域,下面的代码可以正常工作。

* XDIM_MEMBERSET TIME =%TIME_SET%
* XDIM_MEMBERSET CATEGORY =%CATEGORY_SET%
* XDIM_MEMBERSET CUSTOMER = 99999999//-一位特定客户
* XDIM_MEMBERSET VIEW = OPERATIONAL

//-地区是北美
* XDIM_MEMBERSET REGION = BAS(R_NAM)//北美国家/地区等级

* LOOKUP CUST_LOG

* DIM REGION = C_NAM//北美地区的bas国家

* DIM AUDITIDM = CALC//bas审核
* DIM COSTCENTER = NO_CC//bas cc
* DIM VIEW = OPERATIONAL//bas视图
* DIM ACCOUNT = INCOME_AGR//bas account
* DIM CUST1:CUSTOMER = ALL_CLASS//bas客户
* DIM CUST2:CUSTOMER = V_AUT//bas客户
* DIM CUST3:CUSTOMER = V_RET//bas客户
* DIM CUST4: CUSTOMER = V_CON//bas客户
* DIM CUST5:CUSTOMER = V_IND//bas客户
* DIM CUST6:CUSTOMER = V_3PL//bas客户

* ENDLOOKUP


*当帐户
* IS BAS(ALL_EXPENSE)//费用帐户的父帐户
* REC(FACTOR = LOOKUP(CUST2)/LOOKUP(CUST1),COSTCENTER = CC_USREG,CUSTOMER = V_AUT, AUDITIDM =" VERTADJ",REGION =" C_NAM"
* REC(FACTOR = LOOKUP(CUST3)/LOOKUP(CUST1),COSTCENTER = CC_USREG,CUSTOMER = V_RET,AUDITIDM =" VERTADJ",REGION =" C_NAM")< br> * REC(FACTOR = LOOKUP(CUST5)/<=> REC(FACTOR = LOOKUP(CUST4)/LOOKUP(CUST1),COSTCENTER = CC_USREG,CUSTOMER = V_CON,AUDITIDM =" VERTADJ",REGION =" C_NAM") LOOKUP(CUST1),COSTCENTER = CC_USREG,CUSTOMER = V_IND,AUDITIDM =" VERTADJ",REGION =" C_NAM")
* REC(FACTOR = LOOKUP(CUST6)/LOOKUP(CUST1),COSTCENTER = CC_USREG,CUSTOMER = V_3PL ,AUDITIDM =" VERTADJ",REGION =" C_NAM")
* ENDWHEN

该代码在一个区域正常运行。 我希望对4个区域(NAM/SAS/LAM/NAS)执行相同的代码

放置* For循环时出现错误,因为它会根据区域数进行4次调用查找。

请让我知道是否有其他方法可以解决此逻辑。 任何帮助将不胜感激。

致谢

Priyanka