点击此处---> 群内免费提供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
一周热门 更多>