Relationship between tables

[Former Member]

Hi,

I have lifnr(lfa1), bukrs(lfb1), augdt(bsik) fields and i have to find relationship between tables bseg ,vbrk, likp,and vbrp,

Thanks,

Amit.

[Former Member]

Hi,

BKPF-AWKEY = VBRK-VBELN.

LIKP-VBELN = VBRP-VGBEL.

Thanks,

Naren

[Former Member]

hi

good

you cant directly access the BSEG table bcz it is a cluster table ,BSEG TABLE is the combination of 4 other table,so first check table from which table you r going to access the data and than find the relationship with other table,i hope definitely you ll get the relationship.

Thanks

mrutyun^

[Former Member]

Hi Amit,

I did not understand what exactly is ur requirement, however u can relate the tables:

LIKP -SD Document: Delivery Header Data field: VBELN

VBRK-Billing Document: Header Data : VBELN, BUKRS

VBRP-Billing Document: Item Data : VBELN

BSEG-Accounting Document Segment : BUKRS

Hope this answers ur query...

Mark useful answers...

[Former Member]

Hi

VBRP-vbeln = VBRk-vbeln

likp-vbeln = VBRk-vbeln

bseg-BELNR = vbrk-BELNR

bseg-Bukrs = vbrk-bukrs

bseg-gjahr = vbrk-gjahr

likp-lifnr = bseg-lifnr

Regards

Shiva

[Former Member]

Hi,

Thanks for the reply. But how to get vbeln from bukrs, lifnr, augdt.

Thanks,

Amit.