SAP table TDS_SALESDOC (Lean Order: Sales Document)

Field Description Data Type Length Decimals Checktable Data Element
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
TRVOG Transaction Group CHAR 1 0 TRVOG_GEN
0 Order
1 Inquiry
2 Offer
3 Scheduling Agreement
4 Contract
TRVOG_T Description CHAR 20 0 BEZEI20
AUART Sales Document Type CHAR 4 0 AUART
AUART_T Description CHAR 20 0 BEZEI20
KUNAG Sold-to Party CHAR 10 0 KUNAG
KUNAG_T Name 1 CHAR 40 0 AD_NAME1
BSTKD Customer Reference CHAR 35 0 BSTKD
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ZPAVW Partner Function CHAR 2 0 PARVW
ZPERS Person responsible NUMC 8 0 DZPERS
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
SPART Division CHAR 2 0 SPART
VKBUR Sales office CHAR 4 0 VKBUR
VKGRP Sales group CHAR 3 0 VKGRP
DATAB Quotation or contract valid from DATS 8 0 DATAB_VI
DATBI Quotation or contract valid to DATS 8 0 DATBI_VI
WAERK SD Document Currency CUKY 5 0 WAERK
NETWR Net Value of the Sales Order in Document Currency CURR 15 2 NETWR_AK
AWAHR Sales probability NUMC 3 0 AWAHR_AK
PZPERS_T Name of Employee Responsible CHAR 35 0 PZPERS_BEZ
PARVW_T Description of partner function CHAR 20 0 PARVW_BEZ
VKORG_T Description of sales organization CHAR 20 0 VKORG_BEZ
VTWEG_T Description of distribution channel CHAR 20 0 VTWEG_BEZ
SPART_T Description of division CHAR 20 0 SPART_BEZ
VKBUR_T Description of sales office CHAR 20 0 VKBUR_BEZ
VKGRP_T Description of Sales Group CHAR 20 0 VKGRP_BEZ
SPSTG Overall Block Status (Header) CHAR 1 0 SPSTG
ABSTK Rejection Status (All Items) CHAR 1 0 ABSTK
GBSTK Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
UVALS Incompletion Status (All Items) CHAR 1 0 UVALL_SU
UVALL Incompletion Status (Header) CHAR 1 0 UVALL_UK
UVVLS Delivery Incompletion Status (All Items) CHAR 1 0 UVVLS_SU
UVFAS Billing Incompletion Status (All Items) CHAR 1 0 UVFAK_SU
UVVLK Delivery Incompletion Status (Header) CHAR 1 0 UVVLK_UK
UVFAK Billing Incompletion Status (Header) CHAR 1 0 UVFAK_UK
UVPRS Pricing Incompletion Status (All Items) CHAR 1 0 UVPRS_UK
CMGST Overall Status of Credit Checks CHAR 1 0 CMGST
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 (All Items) CHAR 1 0 LFSTK
FSSTK Billing Block Status (All Items) CHAR 1 0 FSSTK
LSSTK Overall Delivery Block Status (All Items) CHAR 1 0 LSSTK_G
AUGRU Order Reason (Reason for the Business Transaction) CHAR 3 0 AUGRU
AUDAT Document Date (Date Received/Sent) DATS 8 0 AUDAT
VSBED Shipping Conditions CHAR 2 0 VSBED
GUEBG Valid-From Date (Outline Agreements, Product Proposals) DATS 8 0 GUEBG
GUEEN Valid-To Date (Outline Agreements, Product Proposals) DATS 8 0 GUEEN
BSTDK Customer Reference Date DATS 8 0 BSTDK
INCO1 Incoterms (Part 1) CHAR 3 0 INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZTERM_T Description of terms of payment CHAR 30 0 DZTERM_BEZ
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
VBTYP_T Description of sales and distribution document category CHAR 60 0 VBTYP_TXT
POSNR Sales Document Item NUMC 6 0 POSNR_VA
MATNR Material Number CHAR 40 0 MATNR
ARKTX Short text for sales order item CHAR 40 0 ARKTX
KWMENG Cumulative order quantity in sales units QUAN 15 3 KWMENG
VRKME Sales unit UNIT 3 0 VRKME
KBMENG Cumulative Confirmed Quantity in Sales Unit QUAN 15 3 KBMENG
KDMAT Material Number Used by Customer CHAR 35 0 MATNR_KU
ABGRU Reason for Rejection of Sales Documents CHAR 2 0 ABGRU_VA
ABGRU_T Description of reason for rejection CHAR 40 0 ABGRU_BEZ
MEINS Base Unit of Measure UNIT 3 0 MEINS
ZMENG Target Quantity in Sales Units QUAN 13 3 DZMENG
ZWERT Target Value for Outline Agreement in Document Currency CURR 13 2 DZWERT
ZIEME Target Quantity UoM UNIT 3 0 DZIEME
NETPR Net Price CURR 11 2 NETPR
WERKS Plant (Own or External) CHAR 4 0 WERKS_EXT
UMZIZ Factor for Converting Sales Units to Base Units (Target Qty) DEC 5 0 UMZIZ
UMZIN Factor for Converting Sales Units to Base Units (Target Qty) DEC 5 0 UMZIN
POSEX Item Number of the Underlying Purchase Order CHAR 6 0 POSEX
FAKSP Billing Block for Item CHAR 2 0 FAKSP_AP
CMPRE Item credit price CURR 11 2 CMPRE
BEDAE Requirements type CHAR 4 0 BEDAE
CHARG Batch Number CHAR 10 0 CHARG_D
PSTYV Sales document item category CHAR 4 0 PSTYV
PSTYV_T Description of item category CHAR 20 0 PSTYV_BEZ
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
VGTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
PRCTR Profit Center CHAR 10 0 PRCTR
OBJNR Object Number at Item Level CHAR 22 0 OBJPO
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
POSID Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
POST1 PS: Short description (1st text line) CHAR 40 0 PS_POST1