Mass settlement rule upload for updating Multiple WBS
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|
|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.