Validation Rule - Tcode GGB0

[#1]

Hello,

Tcode GGB0 and I am in need to create a validation rule to check the postings made by the Tcode F-63, 55 to the supplier, where accounting records can be only 422205 or 446000.

Can someone help me.

I'm not able to develop the condition nor check.

Thanks,

Cristiane

Edited by: Cristiane França da Silva on Oct 11, 2011 10:28 PM

[Former Member]

Hi,

Pre-requisite

BKPF-BLART = 'KR' AND BKPF-TCODE IN ZBKPF-TCODE

Create a set ZBKPF-TCODE using transaction code GS01 for the list of tranasction codes which you need to provide in pre-requsisite

Check

BSEG-LIFNR IN ZBSEG-LIFNR

Create a set ZBSEG-LIFNR using transaction code GS01 for all the vendors which need to be checked and provide the same in Check

This should work and it is working for me for transactions FBV1 & F.63

Its better to use sets always rather than too many "AND'S & OR'S" in validation

Regards

Palani

I

Edited by: Palani2506 on Oct 20, 2011 12:47 AM

[Former Member]

Hi Palani,

Here you have several options to create a SET:

Basic SET;

SET-dimensional;

SET multidimensional;

SET indices.

What you used?

Regards,

[Former Member]

Please use the basic set

Give the table as "BKPF" and field "TCODE" for first set

Give the table as "BSEG" and field "LIFNR" for second set.

The field will popup once you enter the table and press "enter"

Regards

Edited by: Palani2506 on Oct 20, 2011 4:53 AM

[Former Member]

Hi Palani,

-> When I run the Validation Rule in this way, it blocks the other suppliers to the ledger account 322205:

condition:

BKPF-BLART = 'KR' AND

BKPF-TCODE IN ZBKPF-TCODE

verification:

BSEG- LIFNR IN ZBSEG-LIFNR

-> When I run the validation rule this way, it releases the other vendors to release in the ledger account 322205 (picture right), and 55 to the supplier, it blocks all the ledger accounts.

condition:

BKPF-BLART = 'KR' AND

BKPF-TCODE IN ZBKPF-TCODE AND

BSEG-LIFNR IN ZBSEG-LIFNR

verification:

BSEG-HKONT IN ZBSEG-HKONT (informed only the account that is allowed launch, 422,205)

Do you have any idea how to allow entries only in the ledger account 422205?

Regards,

Edited by: Cristiane França da Silva on Oct 20, 2011 3:06 PM

[Former Member]

Hi,

Have you assigned your validation to the company code in transaction OB28?

Please also run program RGUGBR00 to regenerate the validation.

You can also activate the trace under extras in transaction GGB0 and check why your validation is not triggered. hope that helps

Regards

[Former Member]

hi,

Validation is already assigned in OB28, and has also run the program RGUGBR00.

But still I'm not getting writing this in the Validation Stage.

We are currently trying to put this logic:

condition:

BKPF-Blart = 'KR' AND

BKPF-TCODE = 'F-63' OR

BKPF-TCODE = 'FBV1'

verification:

BSEG-LIFNR = '55 'AND BSEG-HKONT = '446000' OR

BSEG-LIFNR = '55 'AND BSEG-HKONT = '422205'

Regards,

[vivek_srivastava12]

Hi,

Please try giving BSEG-LIFNR = '0000000055" AND BSEG-HKONT = '0000446000'

similary for second line as well.

Br,Vivek

[Former Member]

I performed this test, but it seems that the validation rule is not reading the vendor '0000000055 ', because the F-63 even with the Rule by accepting this rule is created for other vendors.

example:

The same message is for the supplier 0000000055, 0000000620 also occurs for. This should not happen, this rule is only for 0000000055.

What can be?

Regards,

[vivek_srivastava12]

Dear,

First of all check the document created by F-63 is available in BSEG or not.

if it is available then your Validation should work if it is not then it will not work.

Br,Vivek

[Former Member]

It was created to solve an exit.

[vivek_srivastava12]

Hi,

In Pre-requisite please write the below:

Transaction Code = 'F-63' or Transaction Code = 'F-55' AND ACCOUNT TYPE = 'K'

Check:

BSEG-HKONT = '422205' or BSEG-HKONT= '446000'

Message:

Create your own Z message.

Please let me know if you face any issues.

Br,Vivek

[Former Member]

Hi, Vivek,

In this case need to put this validation to the vendor 55, as I do that?

Hugs.

[Former Member]

Hi,

Please try the by giving the Check as BSEG-HKONT = u2018422205u2019 OR BSEG-HKONT=u2019446000u2019 AND BSEG-LIFNR=u201955u2019

Regards,

Kiron Kumar T.

[Former Member]

Hello Kiron,

I have included the field BSEG-LIFNR = '55 ', and looked like this:

Condition: SYST-TCODE = 'F-63' AND BSEG-KOART = 'k'

Verification: BKPF-Blart = 'kr' AND BSEG-HKONT = '422205 'OR BSEG-HKONT = '446000' AND BSEG-LIFNR = '55 '

But it still does not validate. When I run the test in TCODE: F-63 in another account accountant he still accepts the release.

What else is there?

[Former Member]

Hi, SYST-TCODE it's not the same which code in the sap easy access.

You can simulate validation and check why it's not working. in GGB0 select you validation , and pass in menu Validation-Simulate

Also you need to use signs () in your logic

Edited by: Aleksey Tkachenko on Oct 13, 2011 3:45 PM

[Former Member]

Hi Aleksey,

What do you suggest for me to replace the SYST-TCODE?

Includes signs () as follows:

Verification: (BSEG-HKONT = '422205 'OR BSEG-HKONT = '446000')

AND BSEG-LIFNR = '55 '.

For simulating the validation where I find this option, I looked on my screen here and not found.

Regards,

[Former Member]

Hi, to run simulation you need to select Node which superior of your step.

Eg Validation QQ1 has steps- Step1, step2. So you need to select QQ1, and then choose in Menu Validation-Simulation.

"Verification: (BSEG-HKONT = '422205 'OR BSEG-HKONT = '446000')

AND BSEG-LIFNR = '55 '." -that's looks better.

"What do you suggest for me to replace the SYST-TCODE?" may be. I suggest you to simulate and see which value of SYST-TCODE.

[Former Member]

Hi Aleksey,

I am doing validation as you instructed me, and it happens that the "condition" is incorrect.

The Validation Rule in GGB0 looks like:

condition: SYST-TCODE = 'F-63' AND BSEG-KOART = 'k'

verification: (BSEG-HKONT = '422205 'OR BSEG-HKONT = '446000') AND

BSEG-LIFNR = '55 '

what can be?

[Former Member]

Hi, I think here the issue "SYST-TCODE = 'F-63' ", just run simulation and check which value SYST-TCODE has

[vivek_srivastava12]

Hi,

F-63, is for parking of Documents and by parking system do not update any table such as BSEG, BSIS etc.

So In your case validation will not work.

Br,Vivek