Mass settlement rule upload for updating Multiple WBS

[Former Member]

Hi Experts,

I have AUC creation setup for CAPEX projects where AuC is auto created upon WBS release. After posting all the cost to be capitalized,AuC settlement run is executed month end using line item settlement CJ8G/CJ88 and AuC rules are auto generated.

After AuC is completed, there are 2 requirements

1.       Settle 100% AUC cost to multiple Final Assets within same asset class when AUC is completed.

2.       Correction of any cost settled to AuC during Asset construction to cost centre which is not to be capitalized to final asset.

WBS #	Category	Settlement Receiver	Receiver Text	%	Sequance	Settlement Type	Period from	Year	Period to	Year
L.N.C15N.NNS.XX0001.AC	CTR	1C301000	CEO Office	20		PRE	9	2015	9	2015
	FXA	11000000000-0	RRU 850MHz	30		FULL	9	2015	9	2015
	FXA	11000000001-0	Site GPS antenna and feeder	50		FULL	9	2015	9	2015
L.N.C15N.NNS.XX0001.AD	FXA	11000000002-0	CME Sharing – Telco	100		FULL	9	2015	9	2015
L.N.S15N.NNS.XX0003.AC	FXA	11000000003-0	Functional software - Others	30		FULL	10	2015	10	2015
	FXA	11000000004-0	Site GPS antenna and feeder	70		FULL	10	2015	10	2015
L.N.C15N.WCL.XX001.AD	FXA	11000000005-0	Services for AAA	100		FULL	9	2015	9	2015

There are over 800 WBS/AuC where settlement rules needs to be created manually for settling to final multiple assets.

I have checked table COBRB but do not know how to update it for creating settlement rules for multiple WBS.

I would like to know from experts what are the tables i can use and the logic to achieve above excel based mass upload so client don't need to do it manually.

Thanks in advance.

Cheers !

[MTerence]

Hi Ashish.

Have you tried in CJB1 or CJB2 with your scenario.

Regards

Terence

[Former Member]

Hi Maria,

CJB1/CJB2 will create settlement rules based on Strategy to 1 receiver with 100% whereas for my requirement i have to settle AUC to multiple final assets based on % distribution where 3 information are variable.

1. # of final assets (Settlement receivers)

2. % distribution of AUC value for final assets

Example :

If I have capitalized $10000 to AuC and Final Asset for equipment cost is FXA1 and Services FXA2,i want to split 10000 to 30% & 70% to FXA1 and FXA2 respectively which will  change for other WBS.

I am not sure if CJB1 can be used to achieve this ? Kindly suggest.

Ashish

[MTerence]

Hi Ashish,

I dont think it is possible via CJB1, it cannot determine multiple FXA.

If you already have a data like Project, WBS element and FXA, then try by creating an LSMW to create the settlement rule.

Else a custom transaction to built this solution (Batch Input), you need to upload an excel file.

Regards

Terence

[Former Member]

Best thing would be to create a custom upload program.

[sunil_yadav2]

Hi Ashish,

try FM 'K_SETTLEMENT_RULE_SAVE_ALL' to update settlement rules.

if you are using CJIC than its not possible to update via any BAPI so alternate is BDC recording for CJIC.

thanks

Sunil