March 05, 2009

Table2 SalesOrder

Table VBAK

* VBAK is Sales Order Header table. But I don't explain for relation with other table,
you can download sap-table.exe in www.sap-interface.com or you can search it in google.
VBAK is used for saving Sales Order Header data, Sales Inquiry Header, Sales Quotation Header and Return Order Header data.

Some fields which i will explain, have special attention for me.
Vbeln = Sales Document
Audat = document date
Vbtyp = SD Document Category
A = Inquiry
B = Quotation
C = Order
I = Order w/o charge
H = Returns
etc
Auart = Sales Document type
This is for specific document. It depends on customizing from the functional.
Netwr = Net Value of the Sales Order in Document Currency
This value don't include Tax Amount. So, if you want to get Pricing condition, you can search on KONV table (Please read my blog about table KONV& KONP)
Waerk = SD document currency
Vkorg = Sales Organization
Vtweg = Distribution Channel
SPart = Division
Vkgrp = Sales group
Vkbur = Sales office
BSTnk = Customer purchase order number
Kunnr = Sold to Party (Customer)
VGBel = Document number of the reference document. Reference Document from Quotation
KNUMV = Number of the document condition (Relation for table KONV)

* VBAP is Sales Order Detail table.It is nothing special for me, so i just copy paste fields which are almost used every creating report
VBELN = Sales Document (Related with VBAK.VBELN)
POSNR = Sales Document Item
MATNR = Material Number
KWMENG = Cumulative order quantity in sales units
VRKME = Sales unit
MEINS = Base Unit of Measure
SPART = Division
NETWR = Net value of the order item in document currency
WAERK = SD document currency
Plant = Plant (Own or External)
LGORT = Storage Location
VSTEL = Shipping Point/Receiving Point
KNUMH = Number of condition record from batch determination (Relation for table KONP)

*VBPA is Partner table of Sales Document. You can get Sales Employee field from this table.
VBELN = Sales and Distribution Document Number (Related with VBAK.VBELN)
POSNR = Item number of the SD document
PARVW = Partner function
AG = Sold to party
RE = Bill to party
RG = Payer
WE = Ship to Party
VE = Sales Employee
KUNNR = Customer Number 1
PERNR = Personnel Number

*VBKD is Business data table of Sales Document. You can get Exchange Rate amount and Sales District fields.
VBELN = Sales and Distribution Document Number (Related with VBAK.VBELN)
POSNR = Item number of the SD document (Related with VBAP.POSNR)
Be Careful..untuk exchange rate amount sebenarnya berdasarkan item number,
jika customizing bisa menyatakan satu document hanya berlaku satu currency maka POSNR berisi '000000'
BZIRK = Sales district
KURSK = Exchange Rate for Price Determination
ZTERM = Terms of payment key

No comments:

Post a Comment