Selecting Deliveries which shipment has not been created

[Former Member]

Hi All,

I need to select the deliveries from the table LIKP which shipment has not been created.

Can anybody please tell me what is the field for checking that and the value to check in that table.

Urgent.. Thanks in advance

Vasu...

[Former Member]

Hi Vasu,

Check in the VTTP table. Give the delivery and check if shipment is available.

Regards

Arun

[Former Member]

Hi Kumar,

Thanks for your reply.

Is there any otherway to check in the LIKP table itself.

[Former Member]

Hi

Fetch all he deliveries from LIKP into table ITAB

then for all these deliveries check the shipments in Table VTTP

by equating VTTP-VBELN = LIKP-VBELN. ( and take these deliveries into ITAB1)

Fetch these deliveries and delete them from the originally fetched deliveries from LIKP.

ITAB - ITAB1 will give the deliveries for which Shipment was not created.

check the field SPE_SHP_INF_STS in LIKP table also.

<b>Reward points for useful Answers</b>

Regards

Anji

Message was edited by:

Anji Reddy Vangala

[Former Member]

Check in table<b> VBUK</b> field <b>trsta</b>. If the value of the field = 'C'. Then there will be shipment for the delivery.

Let me know if you need more info.

Thanks,

Krishna