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