运行分配:百分比逻辑

2020-09-28 03:14发布

         点击此处--->   EasySAP.com群内免费提供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% * XDIM_COUNT = )

//存储所有操作成本

*当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脚本逻辑中应用哪些更改才能满足要求。

谢谢。

         点击此处--->   EasySAP.com群内免费提供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% * XDIM_COUNT = )

//存储所有操作成本

*当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脚本逻辑中应用哪些更改才能满足要求。

谢谢。

付费偷看设置
发送
7条回答
Violet凡
1楼-- · 2020-09-28 03:33

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

一周热门 更多>