topic Re: Delivery document in Application Development and Automation Discussions

Delivery document

Former Member — Thu, 29 Nov 2007 06:33:24 GMT

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

Re: Delivery document

former_member386202 — Thu, 29 Nov 2007 06:39:30 GMT

Hi,

check tables LIKP LIPS

Regards,

Prashant

Re: Delivery document

Former Member — Thu, 29 Nov 2007 06:42:53 GMT

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

Re: Delivery document

Former Member — Thu, 29 Nov 2007 06:46:01 GMT

Hi,

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

Regards,

Himanshu

Re: Delivery document

Former Member — Thu, 29 Nov 2007 06:48:44 GMT

hi,

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

rgds

Re: Delivery document

Former Member — Thu, 29 Nov 2007 07:08:28 GMT

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.

Re: Delivery document

Former Member — Thu, 29 Nov 2007 07:13:44 GMT

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

Re: Delivery document

Former Member — Thu, 29 Nov 2007 07:14:03 GMT

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.