点击此处---> 群内免费提供SAP练习系统(在群公告中)
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
我们有一个要求,即企业希望在总帐和成本中心基础上进行分配。
让我向您介绍当前的分配过程:
1)在营业费用单上输入交易数据。
例如:
ACCOUNT COST_CENTRE AMOUNT
CC_001 1000
B CC_002 2000
2)输入分配百分比
例如:
COST_CENTRE分配百分比
CC_003 30%
CC_004 30%
CC_005 40%
3)运行分配逻辑:
* XDIM_MEMBERSET VERSION =%VERSION_SET%
* XDIM_MEMBERSET COST_CENTER =%COST_CENTER_SET%
* XDIM_MEMBERSET LEDGER =%LEDGER_SET%
* XDIM_MEMBERSET TIME =%TIME_SET%
//存储所有操作成本
*当COST_CENTER
* IS%COST_CENTER_SET%
* REC(FACTOR = 1,COMPANY_CODE =" CO_NONE",COST_CENTER =" CC_NONE",FUNCTIONAL_AREA =" FA_NONE",PROFIT_CENTER =" PC_NONE",SEGMENT = " SEG_NONE",LINE_OF_BUSINESS =" LOB_NONE",RISK_LOCATION =" RL_NONE",RISK_REGION =" RR_NONE",CLAIM_YEAR =" CY_NONE",AUDIT_TRAIL =" AT_BPC_CC_ALLOC")
* ENDWHEN
//分配操作成本到成本中心
* XDIM_MEMBERSET VERSION =%VERSION_SET%
* XDIM_MEMBERSET LEDGER =%LEDGER_SET%
* XDIM_MEMBERSET TIME =%TIME_SET%
* RUNALLOCATION
* FACTOR =使用
* DIM_NONAGGR P_ACCOUNT WHAT = BAS(A_12); WHERE = << ;; USING = S_ALLOC
* DIM COMPANY_CODE WHAT = CO_NONE; WHERE = >>>;
* DIM COST_CENTER WHAT = CC_NONE; WHERE = >>>;
* DIM PROFIT_CENTER WHAT = PC_NONE; WHERE = >>>;
//* DIM FUNCTIONAL_AREA WHAT = FA_NONE; WHERE = >>>;
* DIM SEGMENT WHAT = SEG_NONE; WHERE = >>>;
//* DIM LINE_OF_BUSINESS WHAT = LOB_NONE; WHERE = >>>;
* DIM RISK_LOCATION WHAT = RL_NONE; WHERE = >>>;
* DIM RISK_REGION WHAT = RR_NONE; WHERE = >>>;
* DIM CLAIM_YEAR WHAT = CY_NONE; WHERE = >>>;
* DIM LINE_OF_BUSINESS WHAT = LOB_NONE; WHERE = >>>;
> * DIM AUDIT_TRAIL WHAT = AT_BPC_CC_ALLOC; WHERE = << ;; USING = AT_BPC_INPUT
* ENDALLOCATION
4)结果:
它将以COST_CENTER分配百分比表中提到的相同百分比在A和B上分配金额。
例如:
ACCOUNT COST_CENTRE AMOUNT
CC_003 300
CC_004 300
CC_005 400
B CC_003 600
B CC_004 600
B CC_005 800
新要求:
现在,企业希望对不同的帐户应用不同的%进行分配过程。
1)在营业费用单上输入交易数据。
例如:
ACCOUNT COST_CENTRE AMOUNT
CC_001 1000
B CC_002 2000
2)输入分配百分比
例如:
ACCOUNT COST_CENTRE分配百分比
CC_003 30%
CC_004 30%
CC_005 40%
B CC_003 10%
B CC_004 60%
B CC_005 30%
3)运行分配逻辑。 (需要更改)
4)结果:-
它将以COST_CENTER分配百分比表中提到的不同百分比在A和B上分配金额。
例如:
ACCOUNT COST_CENTRE AMOUNT
CC_003 300
CC_004 300
CC_005 400
B CC_003 200
B CC_004 1200
B CC_005 600
问题:
我无法理解我应该在RUN ALLOCATION脚本逻辑中应用哪些更改才能满足要求。
谢谢。
Hi Floks,
我尝试通过提供帐户来更改此脚本,因为下面的用户选择是我的代码,但是仍然没有人能帮助我。?
*当COST_CENTER
* IS%COST_CENTER_SET%
* REC(FACTOR = 1,COMPANY_CODE =" CO_NONE",COST_CENTER =" CC_NONE",FUNCTIONAL_AREA =" FA_NONE",PROFIT_CENTER =" PC_NONE",SEGMENT = " SEG_NONE",LINE_OF_BUSINESS =" LOB_NONE",RISK_LOCATION =" RL_NONE",RISK_REGION =" RR_NONE",CLAIM_YEAR =" CY_NONE",AUDIT_TRAIL =" AT_BPC_CC_ALLOC")
* ENDWHEN
* COMMIT
/以成本为中心的运营成本
* XDIM_MEMBERSET VERSION =%VERSION_SET%
* XDIM_MEMBERSET LEDGER =%LEDGER_SET%
* XDIM_MEMBERSET TIME =%TIME_SET%
* XDIM_MEMBERSET P_ACCOUNT =%P_ACCOUNT_SET% 运行分配
* RUNALLOCATION
* FACTOR =使用
* DIM P_ACCOUNT WHAT =%P_ACCOUNT_SET%; WHERE = <<<; USING = S_ALLOC//添加了行
* DIM COMPANY_CODE WHAT = CO_NONE; WHERE = >>>;
* DIM COST_CENTER WHAT = CC_NONE; WHERE = >>>;
* DIM PROFIT_CENTER WHAT = PC_NONE; WHERE = >>>;
* DIM SEGMENT WHAT = SEG_NONE; WHERE = >>>;
* DIM RISK_LOCATION WHAT = RL_NONE; WHERE = >>>;
* DIM RISK_REGION WHAT = RR_NONE; WHERE => >>;
* DIM CLAIM_YEAR WHAT = CY_NONE; WHERE = >>>;
* DIM LINE_OF_BUSINESS WHAT = LOB_NONE; WHERE = >>>;
* DIM AUDIT_TRAIL WHAT = AT_BPC_CC_ALLOC; WHERE = <<<< ; USING = AT_BPC_INPUT
* ENDALLOCATION
此致
Toufq
一周热门 更多>