What are the join conditions for creating SAP Query by joining tables- VBAK, VBAP, LIKP, LIPS, VBRK & VBRP

[Former Member]

Hi All,

Please let me know the join conditions for creating SAP Query by joining tables- VBAK, VBAP, LIKP, LIPS, VBRK & VBRP.

Thanks & Regards

Hema

[former_member184701]

dear,

before to build a new sap query make sure you did try all relevant standard reports

regards,

[Former Member]

Hi Hema ,

May i know what kind of report you are planning to develop? If you can give a gist, it would be easy.

With Regards

Vinu

[venkateswaran_k]

STudy the VBFA table

That has all link for the document flows.

Look at the columsn,,  vbeln, vbelv, vbtyp_n, vbtyp_v

Regards,

Venkat

[suman_sardar2]

Hi ,

The VBAK-VBELN=VBAP-VBELN and LIPS-VGBEL=VBAP-VBELN and LIKP-VBELN=LIPS-VBELN

similarly VBRK-VBELN=VBRP-VBELN and VBRP-VGBEL=LIPS-VBELN & VBRP-AUBEL=VBAP-VBELN

You can also refer the table VBFA.

Also find the below link helpful for you;

http://www.recercat.cat/bitstream/handle/2072/5419/PFCLopezRuizAnnex3.pdf?sequence=4

Thanks,

Suman

[Former Member]

Thanks Suman, your inputs were really useful. I added join conditions:- VBAP-POSNR=LIPS-VGPOS & LIPS-POSNR=VBRP-VGPOS & VBAP-POSNR=VBAP-AUPOS along with the join condition stated by you and the query ran well.