脚本逻辑:将数据发布到属性的维成员属性

2020-08-24 17:33发布

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

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


专家您好,

产品版本:-

CPMBPC 810 0015 SAPK-81015INCPMBPC(BPC10.1 SP 15)

SAP_BW 740 0020 SAPKW74020

Netweaver:740

在人数模型中,我们具有HC_Account(A),CATEGORY(C),COST CENTER(User-def),FUNCTIONAL AREA(User-def),TIME(T),ENTITY(E),HC_Employee( 用户定义)

在HC_Account(A)维中,有以下成员:HCOUNT,BONUS,BONUS_PCT,BONUS_PAY

在COSTCENTER维度中,我们有一个名为BONUS_CC(奖金成本中心)和功能区域的属性。

我们想通过数据管理器软件包计算奖金。 用户提供COSTCENTER,CATEGORY,TIME,并将奖金发布到BONUS_CC。

脚本:

 * SELECT(%YR%," YEAR"," CATEGORY",[ID =%CATEGORY_SET%])

//使用上方的year变量创建当前年份时间段。

 * SELECT(%TIM%," ID"," TIME",[YEAR =%YR%])

//因奖金成本中心而异

 * SELECT(%BC%,[BONUS_CC]," COSTCENTER"," [ID] =%COSTCENTER_SET%")

//填充成本中心的成本中心范围。 实体,功能区域和范围
 基于这些成本中心的利润中心。

 * SELECT(%CSTCTR%," ID"," COSTCENTER"," [ID] =%COSTCENTER_SET%AND [BONUS_CC] <>""")
 * SELECT(%ENT%,[ENTIY]," COSTCENTER"," [ID] =%CSTCTR%")
 * SELECT(%FA%,[FUNC_AREA]," COSTCENTER"," [ID] =%CSTCTR%")
 * SELECT(%PCTR%,[PROFIT_CENTER]," COSTCENTER"," [ID] =%CSTCTR%")

 * XDIM_MEMBERSET CATEGORY =%CATEGORY_SET%
 * XDIM_ADDMEMBERSET CATEGORY = ACTUAL
 * XDIM_MEMBERSET TIME =%TIMESET%,
 * XDIM_MEMBERSETCOSTCENTER =%CSTCTR%
 * XDIM_MEMBERSET HC_EMPLOYEE = BAS(雇员)
 * XDIM_MEMBERSET RPTCURRENCY = LC
 * XDIM_MEMBERSET ENTITY =%ENT%
 * XDIM_MEMBERSET FUNCTIONALAREA =%FA%
 * XDIM_MEMBERSET PROFITCENTER =%PCTR%
 * XDIM_ADDMEMBERSET HC_ACCOUNT = HCOUNT

//奖金计算//* FOR%CCTR%=%COSTCTR%
 *当HC_ACCOUNT
 *是计数
 *审核时
 *输入
 *类别时
 * IS%CATEGORY_SET%
 *当COSTCENTER
 * IS%CSTCTR%
 *当RPTCURRENCY
 * IS LC
 *当功能区
 * IS%FA%
////奖金计算
 * REC(EXPRESSION =(%VALUE%> 0)*(([[HC_ACCOUNT]。[6100000],[AUDITTRAIL]。[CALC],[CATEGORY]。[%CATEGORY_SET%])*([HC_ACCOUNT]。[BONUS_PCT]  ,[AUDITTRAIL]。[INPUT],[TIME]。[%YR%.INP],[CATEGORY]。[%CATEGORY_SET%])*([HC_ACCOUNT]。[BONUS_PAY],[JOB_CODE]。[NO_JOB_CODE],[  FUNCTIONALAREA]。[NO_FA],[COSTCENTER]。[NO_COSTCENTER],[PROFITCENTER]。[NO_PROFITCENTER],[ENTITY]。[NO_ENTITY],[HC_EMPLOYEE]。[NO_EMP],[HC_EMP_TYPE]。[NO_TYPE],[CATEGORY]  。[%CATEGORY_SET%])),HC_ACCOUNT = BONUS,AUDITTRAIL = CALC,COSTCENTER = COSTCENTER.BONUS_CC,FUNCTIONALAREA = COSTCENTER.FUNC_AREA)

 *结束
 *结束
 *结束
 *结束
 *结束
 * COMMIT 

维成员映射示例:成本中心(200)具有BONUS_CC(500)和功能区域(2)

成本中心维度(500){这也是COSTCENTER维度的BONUS_CC属性}具有功能区域(5)

数据管理器提示:成本中心为200(已映射到功能区域2和BONUS_CC 500)

结果:奖金已发布到BONUS_CC(500)和功能区域(2)

预期结果::将BONUS发布到BONUS_CC(500),并将功能区映射到BONUS_CC,其中5。

此致

Richa Pathak

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

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


专家您好,

产品版本:-

CPMBPC 810 0015 SAPK-81015INCPMBPC(BPC10.1 SP 15)

SAP_BW 740 0020 SAPKW74020

Netweaver:740

在人数模型中,我们具有HC_Account(A),CATEGORY(C),COST CENTER(User-def),FUNCTIONAL AREA(User-def),TIME(T),ENTITY(E),HC_Employee( 用户定义)

在HC_Account(A)维中,有以下成员:HCOUNT,BONUS,BONUS_PCT,BONUS_PAY

在COSTCENTER维度中,我们有一个名为BONUS_CC(奖金成本中心)和功能区域的属性。

我们想通过数据管理器软件包计算奖金。 用户提供COSTCENTER,CATEGORY,TIME,并将奖金发布到BONUS_CC。

脚本:

 * SELECT(%YR%," YEAR"," CATEGORY",[ID =%CATEGORY_SET%])

//使用上方的year变量创建当前年份时间段。

 * SELECT(%TIM%," ID"," TIME",[YEAR =%YR%])

//因奖金成本中心而异

 * SELECT(%BC%,[BONUS_CC]," COSTCENTER"," [ID] =%COSTCENTER_SET%")

//填充成本中心的成本中心范围。 实体,功能区域和范围
 基于这些成本中心的利润中心。

 * SELECT(%CSTCTR%," ID"," COSTCENTER"," [ID] =%COSTCENTER_SET%AND [BONUS_CC] <>""")
 * SELECT(%ENT%,[ENTIY]," COSTCENTER"," [ID] =%CSTCTR%")
 * SELECT(%FA%,[FUNC_AREA]," COSTCENTER"," [ID] =%CSTCTR%")
 * SELECT(%PCTR%,[PROFIT_CENTER]," COSTCENTER"," [ID] =%CSTCTR%")

 * XDIM_MEMBERSET CATEGORY =%CATEGORY_SET%
 * XDIM_ADDMEMBERSET CATEGORY = ACTUAL
 * XDIM_MEMBERSET TIME =%TIMESET%,
 * XDIM_MEMBERSETCOSTCENTER =%CSTCTR%
 * XDIM_MEMBERSET HC_EMPLOYEE = BAS(雇员)
 * XDIM_MEMBERSET RPTCURRENCY = LC
 * XDIM_MEMBERSET ENTITY =%ENT%
 * XDIM_MEMBERSET FUNCTIONALAREA =%FA%
 * XDIM_MEMBERSET PROFITCENTER =%PCTR%
 * XDIM_ADDMEMBERSET HC_ACCOUNT = HCOUNT

//奖金计算//* FOR%CCTR%=%COSTCTR%
 *当HC_ACCOUNT
 *是计数
 *审核时
 *输入
 *类别时
 * IS%CATEGORY_SET%
 *当COSTCENTER
 * IS%CSTCTR%
 *当RPTCURRENCY
 * IS LC
 *当功能区
 * IS%FA%
////奖金计算
 * REC(EXPRESSION =(%VALUE%> 0)*(([[HC_ACCOUNT]。[6100000],[AUDITTRAIL]。[CALC],[CATEGORY]。[%CATEGORY_SET%])*([HC_ACCOUNT]。[BONUS_PCT]  ,[AUDITTRAIL]。[INPUT],[TIME]。[%YR%.INP],[CATEGORY]。[%CATEGORY_SET%])*([HC_ACCOUNT]。[BONUS_PAY],[JOB_CODE]。[NO_JOB_CODE],[  FUNCTIONALAREA]。[NO_FA],[COSTCENTER]。[NO_COSTCENTER],[PROFITCENTER]。[NO_PROFITCENTER],[ENTITY]。[NO_ENTITY],[HC_EMPLOYEE]。[NO_EMP],[HC_EMP_TYPE]。[NO_TYPE],[CATEGORY]  。[%CATEGORY_SET%])),HC_ACCOUNT = BONUS,AUDITTRAIL = CALC,COSTCENTER = COSTCENTER.BONUS_CC,FUNCTIONALAREA = COSTCENTER.FUNC_AREA)

 *结束
 *结束
 *结束
 *结束
 *结束
 * COMMIT 

维成员映射示例:成本中心(200)具有BONUS_CC(500)和功能区域(2)

成本中心维度(500){这也是COSTCENTER维度的BONUS_CC属性}具有功能区域(5)

数据管理器提示:成本中心为200(已映射到功能区域2和BONUS_CC 500)

结果:奖金已发布到BONUS_CC(500)和功能区域(2)

预期结果::将BONUS发布到BONUS_CC(500),并将功能区映射到BONUS_CC,其中5。

此致

Richa Pathak

付费偷看设置
发送

一周热门 更多>