topic Re: Relationship between tables in Application Development and Automation Discussions

Relationship between tables

Former Member — Thu, 08 Feb 2007 04:57:06 GMT

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.

Re: Relationship between tables

Former Member — Thu, 08 Feb 2007 05:01:41 GMT

Hi,

BKPF-AWKEY = VBRK-VBELN.

LIKP-VBELN = VBRP-VGBEL.

Thanks,

Naren

Re: Relationship between tables

Former Member — Thu, 08 Feb 2007 05:03:51 GMT

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^

Re: Relationship between tables

Former Member — Thu, 08 Feb 2007 05:07:21 GMT

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...

Re: Relationship between tables

Former Member — Thu, 08 Feb 2007 05:11:24 GMT

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

Re: Relationship between tables

Former Member — Thu, 08 Feb 2007 05:33:41 GMT

Hi,

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

Thanks,

Amit.