Skip to Content
avatar image
Former Member

Massive Assignment of Settlement Rules for WBS Elements

Hi gurus.

I've been assigned a requirement and I really don't know where to start.

Every time we open a new restaurant, huge quantities of WBS elements are created, each of these needs a settlement rule assigned (whether it's an asset, cost center, etc.)

At the time, they have to enter each settlement rule one by one to each WBS element, and some of these projects have over 400 elements!
As you can see, this takes a lot of time.

I was assigned to create/develop a way to mass assign these settlement rules to each WBS element so that it takes less time.
At first I thought LSMW was ideal but I can't really think of a way to select each different element and assign the kind of rule it will have (CC, Asset) and the number.

Any ideas?
Can this be done through LSMW or do you know any other ways? I would prefer if we don't need to use ABAP/Development

Many many thanks.

Borja.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

8 Answers

  • avatar image
    Former Member
    Jun 27, 2014 at 07:17 PM

    Hi Borja,

    Maintain a differentiating parameter in the WBS elements based on where they are settled. For e.g. you can make use of the user fields in the WBS element to identify if the settlement for this WBS needs to be done to an Asset or a Cost center etc..

    Once this is done you can make use of the BADI "WBS_SETTLEMENT_RULE" and write the required validation rule that will determine what settlement rule to create based on the input in the user field of the WBS element. Now, this suggestion might work in case the settlement receiver ie. asset, cost center remains the same and does not change dynamically.

    This is just a suggestion that came to my mind instantly. There can be better ways of doing this.

    Try it out and let us know if the suggestion above helps.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 28, 2014 at 05:50 AM

    I think, you can achieve thru BDC/LSMW. In one of our project,we have develop a BDC of mass assignment of settlement rule on WBS.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 28, 2014 at 06:04 AM

    Hi Borja,

    You can serttle it through LSMW . actaulally we are doing settlemets monthly through LSMW only.

    Or you can settle it through t-code : CJ8G by creating Varient (select multiple projects and wbs elements).

    -

    Krishna

    Message was edited by: KRISHNAREDDY ALIKEPALLI

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 29, 2014 at 03:32 AM

    Hi

    This is not a std. functionality. You need to create BDC prog. to update WBS with settlement rule.Check the following std. BADI's

    WBS_SETTLEMENT_RULE

    WBS_SETTLEMENT_RULE_NEW


    Regards

    Saurabh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 30, 2014 at 10:23 AM

    Hi Borja,

    we had similar stuff in our older version ECC 5.0

    There we divided the project structure(from 2nd level) into Capex(capital expenditure that needs to capitalized asset) & Opex.(Operational expenditure that needs to capitalized CC).

    Capex are sttled to AUC when we run CJ88/CJ8G in moth end, then we have enhanced BDC program to set settlement rule in CJIC using upload file then run CJ88/CJ8G again to settle them to fix asset.

    In our case since opex postings are fewer we settle those manually. If you have high volume you can find some solution to settle opex also in mass upload settlement rule

    hope you can get some thing out of our past experience.

    Regards,

    Sampath

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26, 2016 at 05:33 PM

    Has anyone tried KRISHNAREDDY ALIKEPALLI process CJ8G? if so please let Borja Sanz-Agero know this is a valid solution.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 27, 2016 at 06:37 AM

    From what i understand on the question, he is asking on maintenance of settlement rule(CJ20N, CJb1, CJb2) and NOT actual settlement (CJ88, CJ8G)

    1. YES, it is definitely possible to use LSMW to upload settlement rules.

    2. However, it depends on your actual requirement. (e.g. details needed, # of rules per WBS)

    If you can come up with a file/list of WBS elements with its own settlement receiver category and settlement receiver, then I think LSMW can work.

    Try using CJ12 to create the recording.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 04, 2016 at 07:44 PM

    Hi,

    I know this comes late but, for the record, I would suggest using FM K_ORDER_SRULE_ADD as BAPI to upload and maintain settlement rules in internal orders.

    Regards,

    Filipe

    Add comment
    10|10000 characters needed characters exceeded