relationship between likp and vttk

[anupam_srivastava2]

Is there any relationship between table LIKP and VTTK, for the delivery in LIKP vbeln I want to get the shipment no from VTTK - tknum.

can any body suggest how can I do this.

thanks

C

[Former Member · Accepted solution]

Hi,

The relation ship will be this only..... Create a query with these two tables and maintain left outer join of this

VTTP-VBELN = LIPS-VBELN

And from this u can get shipment number,

Thanks,

Raja

[former_member188076]

Hi

There are two ways:-

1. Take the LIKP-VBELN ( delivery No) and go to table VBFA and fill the VBELN in field VBELV and pick the VBELN where VBTYP_N = 8, this will be Shipment No.

2. Take the LIKP-VBELN and fill that in VBELN of table VTTP (Line item of Shipment) and Pick the TKNUM (Shipment No).

However there is no direct link between Shipment No. and Delivery No. as far as I am aware.

Regards

Amitesh

[Former Member]

Hi

Generate a query by joining LIKP and VTTK..there will be couple of fields which are similar one among them is VBLEN...generate in SQVI and select the fields from VTTK and execute it.

Hope it helps

Regards

Rohit