Connection of VBAP and LIKP

[Former Member]

Hi ,

Can anyone point me the connecting field between LIKP and VBAP, I am trying to join them to fetch an information, any idea how they connect.?

Tina.

[Former Member]

In case, its for an ABAP report/query, you can use the table VBFA.

VBFA-VBELV = VBAP-VBELV and

VBFA-POSNV = VBAP-POSNV and

VBFA-VBELN = LIKP-VBELN and

VBFA-POSNN = LIKP-POSNR and

VBFA-VBTYP_N = J and

VBFA-VBTYP_V = C

Can be read as

Preceding doc # = sales order doc # and

Preceding doc item # = sales order line # and

subsequent doc# = delivery# and

subsequent doc position# = delivery line# and

subsequent doc category = delivery and

preceding document category = sales order

Regards,

Gauravjit.

reward points if the solution is helpful.

[Former Member]

Hi Tina,

You didnt have any direct relationship between LIKP and VBAP directly.

As each line item can have multiple deliveries, so you will the realtion ship between LIPS and VBAP.

You will find the sales order number and line item of sales order number from LIPS table in the field VGBEL and VGPOS respectively.

LIPS-VGBEL is the sales order number = VBAP-VBELN and

LIPS-VGPOS is the line item of sales order = VBAP-POSNR.

I think you use mutiple join on table LIKP, LIPS and VBAP for your requirement.

Thanks,

Vinay

[Former Member]

Hi ,

We can find link to LIPS and VBAP tables.

Because one delivery contains more than one sales order so SAP has provided

sales order number in line item only.

Here LIPS-VGBEL = VBAP-VBELN.

thanks,

shyla

[Former Member]

Hi Tina,

I believe you would have got the link by now from the above posts.

Also, have a look at the below link which lists SD tables and link between them. This will help you to understand better and in any future doubts.

http://www.erpgenie.com/sap/abap/tables_sd.htm

Regards,

Please award points if useful

[Former Member]

LIKP is the delivery header table and so could have multiple orinating sales orders, so SAP does not provide a field on LIKP with the originating order number on it. However, this field is on the delivery item table - LIPS. So you can join LIPS to LIKP by VBELN and then join LIPS-VBELV to VBAP-VBELN.

Please award points if useful.

Thanks

Jon

[Former Member]

Hi Tina.,

I copy controls carry the data over here to delivery

Regards

Narayana

Message was edited by:

manam narayana