Delivery document

[Former Member]

hi all,

can anyone plz tell me which table contains the status of delivery documents which r deleted??

points would be awarded to all.

rgds

[former_member386202]

Hi,

check tables LIKP LIPS

Regards,

Prashant

[Former Member]

hi,

when i execute vl22 if i give delivery number i get the status of the delivery.wht i want to knw is which table contain the status of deleted delivery document??

rgds

[Former Member]

Hi,

You can check table VBUP for the statuses of Delivery, Sales Order etc.

Regards,

Himanshu

[Former Member]

hi,

thnx alot for your reply can u tell me how to get sales document number against a delivery number ?

rgds

[Former Member]

Hi

how to get sales document number against a delivery number ?

go to VBFA table

gave delivery number in VBELN, VBTYP_N = J and VBTYP_V = C

in field VBELV you will get Sales Order.

[Former Member]

Hey Delivery details will be removed from LIKP and othe related tables once it is deleted.

The info will not be available in any SAP tables.

[Former Member]

Hi,

For a delivery you can get the corresponding Sales Order Number as well as the Invoice Number from table VBFA.

If you put the Subsequent Docmnt as Delivery number and the Document type as 'Delivery', it will give you the Sales Order Number in Preceding Document column. However if u put the Preceeding Doc number as Delivery Number, then it will return u the Invoice as Subseqent Doc.

Regards,

Himanshu