Massive Assignment of Settlement Rules for WBS Elements

[Former Member]

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.

[former_member190901]

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

[Former Member]

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,

[former_member625494]

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

[Former Member]

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

[former_member195427]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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,