Skip to Content
Author's profile photo Ajay Maheshwari

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

SCN.jpg

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

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very useful, thank you for sharing this.

      Author's profile photo Ajay Maheshwari
      Ajay Maheshwari
      Blog Post Author

      You are welcome Jonathan

      Author's profile photo Abhinav Sinha
      Abhinav Sinha

      Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      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.

       

      Author's profile photo Former Member
      Former Member

      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!

      Author's profile photo Antonin Pavelka
      Antonin Pavelka

      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.