retrieve some data from vbak vbap and keko tables

[Former Member]

Hi,

I want to retrieve some data from vbak vbap and keko tables.

what should be the condition?

thanks

[former_member188685 · Accepted solution]

the realtions between them. ..

VBAK-VBELN = VBAP-VBELN

and VBAP- VBELN = KEKO-VBELN

VBAP-POSNR = KEKO-POSNR

VBAP-KALNR = KEKO-KALNR

[TMNielsen]

Link from VBAP to KEKO via KANZ.

[Former Member]

Hello,

You can use the Following conditions.

VBAK-VBELN = VBAP-VBELN.

Then, based on the Data in VBAP Table, check the Conditions VBAP-VBELN = KEKO-VBELN and

VBAP-POSNR = KEKO-POSNR and

VBAP-MATNR = KEKO-MATNR and

VBAP-WERKS = KEKO-WERKS.

Hope it would be Helpful.

Thanks and Regards,

Venkat Phani Prasad Konduri