Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Mass settlement rule upload for updating Multiple WBS

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 #CategorySettlement ReceiverReceiver Text%SequanceSettlement TypePeriod fromYearPeriod toYear
L.N.C15N.NNS.XX0001.ACCTR1C301000CEO Office20 PRE9201592015
FXA11000000000-0RRU 850MHz30 FULL9201592015
FXA11000000001-0Site GPS antenna and feeder50 FULL9201592015
L.N.C15N.NNS.XX0001.AD FXA11000000002-0CME Sharing – Telco100 FULL9201592015
L.N.S15N.NNS.XX0003.AC FXA11000000003-0Functional software - Others30 FULL102015102015
FXA11000000004-0Site GPS antenna and feeder70 FULL102015102015
L.N.C15N.WCL.XX001.AD FXA11000000005-0Services for AAA100 FULL9201592015

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 !

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question