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

Automatic period closing in SAP Finance

Share the knowledgeFacebookGoogle+TwitterLinkedinDiggemailPeriod closing is a process that involves many steps in different SAP modules. Even if we take SAP Finance (FI) alone, period closing activities include various steps in GL, AP, AR, Assets and other submodules. To ensure the period closing is complete and reports are finalized, users maintain a table with periods open […]

Read More

What was your first SAP project?

Share the knowledgeFacebookGoogle+TwitterLinkedinDiggemailMy dear readers! I believe the majority of you work in SAP world. Some of you have just started, some of you work with SAP all your life. But do you actually remember how your SAP life stared? What was your first project? What was your first task? Let us share the experience, […]

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

Subscribe!

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