Create a Master Data Group excluding certain values
In this document, I intend to share how to create master data groups excluding certain values. The concept applies to any of the master data groups like Cost Center Groups, Cost Element Groups, Internal Order, etc.
I take the example of Cost Element Groups to explain this
Assume you want to create a Cost Element Group which includes all the Cost Elements except a few. For this, you have options like
1) Manually enter all the Cost Elements except those you want to exclude
2) Manually enter the From…To Range of Cost Elements, carefully ignoring the Cost Elements you want to exclude. Eg: Cost Elements 1 to 105, 107 to 197, 199 to 399 and so on
The above two approaches would be tedious and are prone to issues incase a new GL numbering convention evolves in future. Hence, instead of these options, one can create a Dynamic Cost Element Group, following the steps below
1. Create a Selection Variant for the Cost Elements using Program RKKOASEL
2. I created the Variant OCOS_OTHER. While creating the variant, exclude the Cost Elements that must not form part of the Cost Element Group, as below
3. Now your Cost Element Group would be .OCOS_OTHER (i.e. Prefix the name of the Variant with a dot)
4. You can now include this Cost Element Group in your Allocation Cycles (Assessment / Distribution) or in your Reports (Eg: S_ALR*)
Isn’t it that simple? All you need to know is the name of the Program that can create a Selection Variant for you
For CC – Program is RKKSTSEL
For IO – Program is RKOSEL00
You can search in SE38 as RK*SEL* and that should get you the list of relevant programs to choose from
Regards
Ajay Maheshwari
Very useful, thank you for sharing this.
You are welcome Jonathan
Thanks for sharing.
Dear Ajay, thanks for sharing. But is it possible to create the variant for cost element group per the last several characters?
e.g. cost elements are: 51010044, 51010144, 51010244 and 51030044, 51030144, 51030244.
I tried to use 510+++44 in the variant, but system does not accept that.
Dear Ajay,
Can you please look into my question in below link on Variable and Fixed PUP in cost component structure using CKM3
https://answers.sap.com/questions/198843/how-to-break-product-cost-pup-on-cost-component-st.html
Thanks in advance!
I have question.
Works fine for exmaple for orders, cost centers.
But i can't use this feature for WBS (RKPSEL00). I have created variant, but .+Varinat name is no possibe to use in KSV1 transakcion (allocation cycles).
Any idea?
Thank You.