1. Home
  2. Resources
  3. SAP Tables
  4. TDS_SALESDOC - Lean Order: Sales Document

SAP Table TDS_SALESDOC

Lean Order: Sales Document

TDS_SALESDOC (Lean Order: Sales Document) 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 TDS_SALESDOC to other SAP tables.

TDS_SALESDOC table fields

Field Data element Checktable Datatype Length Decimals
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
TRVOG Transaction Group TRVOG_GEN CHAR 1 0
0 Order
1 Inquiry
2 Offer
3 Scheduling Agreement
4 Contract
TRVOG_T Description BEZEI20 CHAR 20 0
AUART Sales Document Type AUART CHAR 4 0
AUART_T Description BEZEI20 CHAR 20 0
KUNAG Sold-to party KUNAG CHAR 10 0
KUNAG_T Name 1 AD_NAME1 CHAR 40 0
BSTKD Customer purchase order number BSTKD CHAR 35 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ZPAVW Partner Function PARVW CHAR 2 0
ZPERS Person responsible DZPERS NUMC 8 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
VKBUR Sales Office VKBUR CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
DATAB Quotation or contract valid from DATAB_VI DATS 8 0
DATBI Quotation or contract valid to DATBI_VI DATS 8 0
WAERK SD Document Currency WAERK CUKY 5 0
NETWR Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
AWAHR Sales probability AWAHR_AK NUMC 3 0
000 Sales order probability
PZPERS_T Name of Employee Responsible PZPERS_BEZ CHAR 35 0
PARVW_T Description of partner function PARVW_BEZ CHAR 20 0
VKORG_T Description of sales organization VKORG_BEZ CHAR 20 0
VTWEG_T Description of distribution channel VTWEG_BEZ CHAR 20 0
SPART_T Description of division SPART_BEZ CHAR 20 0
VKBUR_T Description of sales office VKBUR_BEZ CHAR 20 0
VKGRP_T Description of Sales Group VKGRP_BEZ CHAR 20 0
SPSTG Overall blocked status SPSTG CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
ABSTK Overall rejection status of all document items ABSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
GBSTK Overall processing status of document GBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALS Total incompletion status of all items in general UVALL_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALL General incompletion status of the header UVALL_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVVLS Total incompletion status of all items: Delivery UVVLS_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAS Total incompletion status of all items: Billing UVFAK_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVVLK Header incompletion status concerning delivery UVVLK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAK Header incompletion status with respect to billing UVFAK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPRS Document is incomplete with respect to pricing UVPRS_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
CMGST Overall status of credit checks CMGST CHAR 1 0
NULL Credit check was not executed/Status not set
A Credit check was executed, document OK
B Credit check was executed, document not OK
C Credit check was executed, document not OK, partial release
D Document released by credit representative
LFSTK Delivery status LFSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FSSTK Overall billing block status FSSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LSSTK Overall delivery block status LSSTK_G CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
AUGRU Order reason (reason for the business transaction) AUGRU CHAR 3 0
AUDAT Document Date (Date Received/Sent) AUDAT DATS 8 0
VSBED Shipping Conditions VSBED 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
BSTDK Customer purchase order date BSTDK DATS 8 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZTERM_T Description of terms of payment DZTERM_BEZ CHAR 30 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
VBTYP_T Description of sales and distribution document category VBTYP_TXT CHAR 60 0
POSNR Sales Document Item POSNR_VA NUMC 6 0
MATNR Material Number MATNR CHAR 18 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
KWMENG Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
VRKME Sales unit VRKME UNIT 3 0
KBMENG Cumulative confirmed quantity in sales unit KBMENG QUAN 15 3
KDMAT Material Number Used by Customer MATNR_KU CHAR 35 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
ABGRU_T Description of reason for rejection ABGRU_BEZ CHAR 40 0
MEINS Base Unit of Measure MEINS UNIT 3 0
ZMENG Target quantity in sales units DZMENG QUAN 13 3
ZWERT Target Value for Outline Agreement in Document Currency DZWERT CURR 13 2
ZIEME Target quantity UoM DZIEME UNIT 3 0
NETPR Net price NETPR CURR 11 2
WERKS Plant (Own or External) WERKS_EXT CHAR 4 0
UMZIZ Factor for converting sales units to base units (target qty) UMZIZ DEC 5 0
UMZIN Factor for converting sales units to base units (target qty) UMZIN DEC 5 0
POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
FAKSP Billing block for item FAKSP_AP CHAR 2 0
CMPRE Item credit price CMPRE CURR 11 2
BEDAE Requirements type BEDAE CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
PSTYV Sales document item category PSTYV CHAR 4 0
PSTYV_T Description of item category PSTYV_BEZ CHAR 20 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
VBELV Originating document VBELV CHAR 10 0
POSNV Originating item POSNV NUMC 6 0
VGBEL Document number of the reference document VGBEL CHAR 10 0
VGPOS Item number of the reference item VGPOS NUMC 6 0
VGTYP Document category of preceding SD document VBTYP_V 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
PRCTR Profit Center PRCTR CHAR 10 0
OBJNR Object number at item level OBJPO CHAR 22 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
POST1 PS: Short description (1st text line) PS_POST1 CHAR 40 0