Skip to Content
avatar image
Former Member

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 # 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 !

AuC.jpg (49.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 21, 2015 at 05:30 AM

    Hi Ashish.

    Have you tried in CJB1 or CJB2 with your scenario.

    Regards

    Terence

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Oct 21, 2015 at 05:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2015 at 12:03 PM

    Best thing would be to create a custom upload program.

    Add comment
    10|10000 characters needed characters exceeded