SAP Table SDLSVB

Structure for CMDS: Fields from VBAP, VBAK and Others

SDLSVB (Structure for CMDS: Fields from VBAP, VBAK and Others) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SDLSVB to other SAP tables.

SDLSVB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
VBKLT SD document indicator VBKLT CHAR 1 0
NULL No classification
A Billing request (line item billing)
B Delivery order
C Scheduling agreement with delivery order
D Invoice correction request
E Delivery order correction
F Repair processing: Leading serviceable material
G Repair processing: Leading service product
H Scheduling agreement with external service agent processing
I Consignment issue by external service agent
K Correct consignment issue by external service agent
R Order for Billing Between Company Codes (RRICB)
AUART Sales Document Type AUART CHAR 4 0
VBELN Sales Document VBELN_VA CHAR 10 0
POSNR Sales Document Item POSNR_VA NUMC 6 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
GUEBG Valid-from date (outline agreements, product proposals) GUEBG DATS 8 0
GUEEN Valid-to date (outline agreements, product proposals) GUEEN DATS 8 0
ABDIS MRP for delivery schedule types ABDIS CHAR 1 0
NULL Delivery schedules are not used
A Requiremnts acc. to fore.dlv.sched/Delivery acc. to validity
B Requirements and deliveries according to validity
C Requirements acc. to fore.dlv.sched/Deliveries acc. to JIT
D Requirements acc. to validity/Deliveries acc. to JIT
E JIT delivery schedules are not used
PLAVO Planning delivery schedule instruction PLAVO CHAR 4 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
VRKME Sales unit VRKME UNIT 3 0
MEINS Base Unit of Measure MEINS UNIT 3 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
KDMAT Material Number Used by Customer MATNR_KU CHAR 35 0
KTEXT Search term for product proposal KTEXT_V CHAR 40 0
BSTKD Customer purchase order number BSTNK CHAR 20 0
BSTZD Purchase order number supplement BSTZD CHAR 4 0
ABRVW Usage Indicator ABRVW CHAR 3 0
IHREZ Your Reference IHREZ CHAR 12 0
KUNNR Sold-to party KUNAG CHAR 10 0
LPRIO Delivery Priority LPRIO NUMC 2 0
MATKL Material Group MATKL CHAR 9 0
ROUTE Route ROUTE CHAR 6 0
VSBED Shipping Conditions VSBED CHAR 2 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
VPZUO Allocation Indicator VPZUO CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
ABLFZ Rounding quantity for delivery ABLFZ QUAN 13 3
UPDKZ Update indicator UPDKZ_D CHAR 1 0