- Home
- Resources
- SAP Tables
- SDLSVB - Structure for CMDS: Fields from VBAP, VBAK and Others
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.
Source: SDLSVB (Structure for CMDS: Fields from VBAP, VBAK and Others)
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
|