11-29-2007 6:33 AM
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
11-29-2007 7:08 AM
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.
11-29-2007 6:39 AM
11-29-2007 6:42 AM
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
11-29-2007 6:46 AM
Hi,
You can check table VBUP for the statuses of Delivery, Sales Order etc.
Regards,
Himanshu
11-29-2007 6:48 AM
hi,
thnx alot for your reply can u tell me how to get sales document number against a delivery number ?
rgds
11-29-2007 7:14 AM
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.
11-29-2007 7:08 AM
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.
11-29-2007 7:13 AM
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