06-28-2008 10:03 AM
hii,I m creating order confirmation report for SALES AND DISTRIBUTION. Can any one tell me the tables where i can get the fields listed below.
packing slip number,
GRN no.,
destination address,
transport,
freight,
payment terms.
06-28-2008 10:33 AM
hi,
plz refer the link below u will get all the tables
http://goldenink.com/abap/files_in_sap.html
ragards,
pritam.
06-28-2008 10:33 AM
hi,
plz refer the link below u will get all the tables
http://goldenink.com/abap/files_in_sap.html
ragards,
pritam.
06-28-2008 11:09 AM
Hi,
Order Confirmation in S& D we go for Tcodes VA01.
Tables related to that are-
VBAK-Sales Document: Header Data
VBAP-(Sales-Items)
VBUK- (Sales Document: Header Status and Administrative Data)
VBUP-Sales Document: Item Status
LIKP-Delivery Header- From this table get the SHip to party and from that number (KUNNR) try to get the address from KNA1 table..
BKKPOHD (Payment Order, Header Data)
MKPF(MAterial Doc:Header)
VTTK(SHipment Tbale)
packing slip number(Refer to Delivery nite number while in transportation it is given)
GRN no.(LIP-XABLN refer to BELNR)
destination address(get the Ship to party from VBAK and then get the KUNNR adress dfrom KNA1),
transport (VTTK-TKNUM)
freight (VBAP-MFRGR)
payment terms (VBKD).
Reward if helpful.
Best Wishes,
Chandralekha
06-28-2008 11:58 AM
thanks, but could u ppl plz let me know the fields,because the names given in the table are really confusing.
Edited by: dakshu kanojia on Jun 28, 2008 7:01 AM
06-28-2008 12:03 PM
field for transport name???
and
packing slip no.??
and
destination??
Edited by: dakshu kanojia on Jun 28, 2008 7:17 AM
Edited by: dakshu kanojia on Jun 28, 2008 7:19 AM