How you can lower down your support costs for SAP validations and substitutions. And ease your own life.

Dmitry Kaglik

November 25, 2012

SAP

4 Comments

SAP Validations
SAP Validations

Substitutions and validations are an inevitable part of a SAP project. You always need to chec

k that the document is entered correctly, or replace values in certain fields.
SAP allows you to write subs and vals in an easy-to-use interface similar to the constructor. A few mouse clicks, a few keystrokes and you’re sorted.
But how often do you need to amend validations or substitutions back and forth to allow something restricted to happen? Often? Then probably we need to look at the way your subs and vals are coded.
Say your validation is about tax codes which you created after the tax rate change. It says

  • Prerequisite: BKPF-BLART = ‘KR’ OR BKPF-BLART = ‘RE’
  • Validation: NOT ( BSEG-MWSKZ = ‘V1’ OR BSEG-MWSKZ = ‘V2’ OR BSEG-MWSKZ = ‘V3’ )
  • Message: “Please do not use old tax codes”

Obviously, V1, V2 and V3 are old tax codes which you should not use after the tax switch date.
But now and then an odd invoice comes for services which were provided when the old tax rate was in use. It should be posted with one of the old tax codes. What do you do in this case? You need to create another transport, change validation and move the new validation across the systems’ landscape to the Production system. Then you need to do same process again to put the restrictions back.
Is it possible to optimize the process and simplify both the support process and your own life?
Yes!
SAP allows you to use sets in validations. The benefit of using sets is that they can be changed directly in the Production system without any transports.
First, you need to create sets in Development: transaction code GS01 helps you here.
Second, you use sets in your validations. For the example above, you can rewrite the validation like this:

  • Prerequisite: BKPF-BLART IN Z_SET_OF_BLART
  • Validation: NOT BSEG-MWSKZ IN Z_SET_OF_MWSKZ
  • Message: “Please do not use old tax codes”

Third, you move your validation across to Production. Once only!
Then you only need to maintain sets in the transaction code GS02 if restrictions are to be temporary lifted, or more document types or tax codes added.

Easy? Yes!

Quick? Yes!

Clear? Surely yes!

Related Posts

Top SAP Expert posts from 2021

Dmitry Kaglik

January 10, 2022

SAP

No Comment

The year 2021 is behind us. There were many articles published on SAP Expert blog that year, as well as during previous years. Let’s see what were the most read posts from 2021. Search Strings: Powerhorse of Electronic Bank Statement More Free SAP Training Do you need help with SAP Job interviews? As for the […]

Read More

Merry Christmas and Happy New Year 2022 from SAP Expert

Dmitry Kaglik

December 25, 2021

SAP

No Comment

My dear readers! It is holiday season again upon us! Another year has gone. 2021 comes to the end. The year of surprises, struggle, success and wins. Christmas is today, and New Year is just around the corner. Let’s celebrate these! Let’s make new and better plans for future year. SAP Expert had its ups […]

Read More

4 Comments

  • Michele on February 20, 2013

    I would like to know why the MWSKZ is deactivated for sap standard for the substitutions. We have to go and reactivate it, but is this best practice?

    • Dmitry Kaglik on February 20, 2013

      Hello Michele,
      The system that I have access to, includes the field MWSKZ in the list of availble for substitution, even though we’ve never subsstituted it.
      My other projects did include tax code substitution, and I don’t remember me making this field available.
      So, maybe this is something very specific in your system(s)?

  • Arkoni on February 6, 2014

    Hi,
    I habe a case where i need to use validation. How can I create validation of the two first letters invoice number?

    • Dmitry Kaglik on February 6, 2014

      Validation maintenance is in transaction OB28 and GGB0.
      There is a constructor available for easy building the validation rules. If you want additional SAP Expert’s assistance, please contact for help.

Leave a Reply

Your email address will not be published. Required fields are marked *

Search this site

Polls

Will you be happy to pay for the 3rd edition of the book FREQUENTLY ASKED QUESTIONS ON SAP FINANCE?

View Results

Loading ... Loading ...

Search this site

Subscribe!

You can subscribe to our regular updates here.

Follow Us!

Polls

Will you be happy to pay for the 3rd edition of the book FREQUENTLY ASKED QUESTIONS ON SAP FINANCE?

View Results

Loading ... Loading ...
Disclaimer and privacy policy