Doubts on validation and substitution

[Former Member]

Hi,

I have few question on validation and substitutions.

1) Does the validation and substitution will availiable for MM, SD, PP modules also or those availiable for Accounting only

2) In same we application shall we call validation and substitution. If yes in which case we can use the both

3) I want to validation for this scenario:

I have 2 gl accounts. if i choose 100000 gl account my business area should be: 1000

if gl 200000 is business area should be: 2000

business area field is not appearing in substitution list.

So what i have to do. There is any configuration required?

Please guide me

[former_member346047 · Accepted solution]

Hi Sateesh

Execute SM30. Select table VWTYGB01. Maintain. Select

Boolean Class: 9

Class Type: S

Table: BSEG

FIELD: GSBER

Untick Exclude field.

Save. Business Area field shall be available for substitution

[Former Member]

Dear all

What is differance bitween validation & substitution , what is importance ? . give me detail.

Regards

Purushottam

[Former Member]

Hi Purushottam,

With a validation you look if the value keyed in as alowed.

Like When costcenter 1000 is used with g/l account 400000 give an error

With a substitution you fill in values based on your rule's

Like: when CC is 1000 and G/L account is 500000 then the profit center is 10000000

Search on this Forum validation and substitution and you will found more information about this. There are some examples set up in your system TC OBBH an OBBH.

For the SAP help look to the area special ledger

[Former Member]

validatios are used to check control the screan apperance for documents postings.this is achived

through general ledger accounting.

substitutions:It replaces files and fields with out user knowledge.

like

Pc

text

functional area

[Former Member]

Validations and substitutions are available for all modules

GGB0 and GGB1

It depends on the scenario if you can use both of them simultaneously.

Your scenario is not clear as u say you want to create validation and say a field is missing in substitution list.

Thanks

[Former Member]

Hi Ashok,

You said exactly correct. I want to substitute business area but that field not appearing in substitution list.

Where i have add that one.

please guide me

sateesh

[Former Member]

hi

try to use constant value as a business area in substitution

Thanks & Regards

phaneendra

[Former Member]

Hi Phaneendra,

If i want to use constant value field should be there, otherwise how can i use them.

sateesh

[iklovski]

Hi,

Some fields are defined by default as non-substituable. However, this definition could be changed. You can go to SE16N, choose table GB01 and switch off the 'Exclude' flag for the field in question.

Regards,

Eli

[Former Member]

Hi Eli,

Thanks for the quick answer.

I added that field in gb01 and now that field is coming to substitutable fields in GGB1.

I created my substitution like this:

prerequisite:

bseg-saknr='10001'

substitution:

bkpf-gsber='1000'

i saved and activated in obbh with callup point 2.

i tested in fb01, it is not working.

what could be the wrong from my side.

please guide me

sateesh

[iklovski]

Hi Sateesh,

I'd try to do it on call point 3, with a user-exit behind it. Could be that this solution won't be successful (because Business Area belongs to the 'sensitive' fields, and SAP might prevent correcting it), but you can try.

Regards,

Eli

[Former Member]

Hi Sateesh,

You can test a substitution with the menu path Extra and the options:

Activate trace

Activate total trace

Expert trace set braekpoint

Make a posting with 2 lines and you see the result in the trace.

In some cases bseg-saknr='10001' is wrong and it should be '00010001'

It is better not to use direct g/l account in a siubstitution/ validation but store the values in a set. Then with new accounts you have only change the set.

In the substitution you say then:

BSEG-HKONT IN TAXACCTS.

Sets you create with: GS01 it is a basic set with table/ field name BSEG-HKONT (for this case)

It is possible that the field bussines are is not alowed in a substitutions!!!