SAP ABAP Table TDS_SALESDOC (Lean Order: Sales Document)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_O2C_SLS (Package) ERP Sales Order 2 Cash - Sales

Basic Data

Table Category	INTTAB	Structure
Structure	TDS_SALESDOC	Table Relationship Diagram
Short Description	Lean Order: Sales Document

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
2	TRVOG	☐	TRVOG_GEN	TRVOG_GEN	CHAR	1	0	Transaction Group
3	TRVOG_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
4	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
5	AUART_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
6	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
7	KUNAG_T	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
8	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
9	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
11	ZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
12	ZPERS	☐	DZPERS	PERNR	NUMC	8	0	Person responsible
13	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
14	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
15	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
16	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
17	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
18	DATAB	☐	DATAB_VI	DATUM	DATS	8	0	Quotation or contract valid from
19	DATBI	☐	DATBI_VI	DATUM	DATS	8	0	Quotation or contract valid to
20	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
21	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
22	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
23	PZPERS_T	☐	PZPERS_BEZ	NAME	CHAR	35	0	Name of Employee Responsible
24	PARVW_T	☐	PARVW_BEZ	TEXT20	CHAR	20	0	Description of partner function
25	VKORG_T	☐	VKORG_BEZ	TEXT20	CHAR	20	0	Description of sales organization
26	VTWEG_T	☐	VTWEG_BEZ	TEXT20	CHAR	20	0	Description of distribution channel
27	SPART_T	☐	SPART_BEZ	TEXT20	CHAR	20	0	Description of division
28	VKBUR_T	☐	VKBUR_BEZ	TEXT20	CHAR	20	0	Description of sales office
29	VKGRP_T	☐	VKGRP_BEZ	TEXT20	CHAR	20	0	Description of Sales Group
30	SPSTG	☐	SPSTG	STATV	CHAR	1	0	Overall blocked status
31	ABSTK	☐	ABSTK	STATV	CHAR	1	0	Overall rejection status of all sales document items
32	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
33	UVALS	☐	UVALL_SU	STATV	CHAR	1	0	Total incompletion status of all items in general
34	UVALL	☐	UVALL_UK	STATV	CHAR	1	0	General incompletion status of the header
35	UVVLS	☐	UVVLS_SU	STATV	CHAR	1	0	Total incompletion status of all items: Delivery
36	UVFAS	☐	UVFAK_SU	STATV	CHAR	1	0	Total incompletion status of all items: Billing
37	UVVLK	☐	UVVLK_UK	STATV	CHAR	1	0	Header incompletion status concerning delivery
38	UVFAK	☐	UVFAK_UK	STATV	CHAR	1	0	Header incompletion status with respect to billing
39	UVPRS	☐	UVPRS_UK	STATV	CHAR	1	0	Document is incomplete with respect to pricing
40	CMGST	☐	CMGST	CMGST	CHAR	1	0	Overall status of credit checks
41	LFSTK	☐	LFSTK	STATV	CHAR	1	0	Delivery status
42	FSSTK	☐	FSSTK	STATV	CHAR	1	0	Overall billing block status
43	LSSTK	☐	LSSTK_G	STATV	CHAR	1	0	Overall delivery block status
44	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
45	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
46	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
47	GUEBG	☐	GUEBG	DATUM	DATS	8	0	Valid-from date (outline agreements, product proposals)
48	GUEEN	☐	GUEEN	DATUM	DATS	8	0	Valid-to date (outline agreements, product proposals)
49	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
50	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
51	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
52	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
53	ZTERM_T	☐	DZTERM_BEZ	TEXT30	CHAR	30	0	Description of terms of payment
54	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
55	VBTYP_T	☐	VBTYP_TXT	AS4TEXT	CHAR	60	0	Description of sales and distribution document category
56	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
57	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
58	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
59	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
60	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
61	KBMENG	☐	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
62	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
63	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
64	ABGRU_T	☐	ABGRU_BEZ	TEXT40	CHAR	40	0	Description of reason for rejection
65	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
66	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
67	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
68	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	*
69	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
70	WERKS	☐	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	*
71	UMZIZ	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
72	UMZIN	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
73	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
74	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	*
75	CMPRE	☐	CMPRE	WERTV6	CURR	11	2	Item credit price
76	BEDAE	☐	BEDAE	BEDAE	CHAR	4	0	Requirements type	*
77	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
78	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
79	PSTYV_T	☐	PSTYV_BEZ	TEXT20	CHAR	20	0	Description of item category
80	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
81	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
82	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	*
83	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	*
84	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
85	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
86	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
87	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
88	OBJNR	☐	OBJPO	J_OBJNR	CHAR	22	0	Object number at item level	*
89	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
90	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
91	POST1	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)

History

Last changed by/on	SAP	20130529
SAP Release Created in	602