SAP ABAP Table TDS_ORDTRACK (Structure: Order Tracking)

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_ORDTRACK	Table Relationship Diagram
Short Description	Structure: Order Tracking

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	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
3	AUART_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
4	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
5	KUNAG_T	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
6	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
7	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
10	ZPERS	☐	DZPERS	PERNR	NUMC	8	0	Person responsible
11	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
12	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
13	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
14	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
15	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
16	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
17	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
18	PZPERS_T	☐	PZPERS_BEZ	NAME	CHAR	35	0	Name of Employee Responsible
19	PARVW_T	☐	PARVW_BEZ	TEXT20	CHAR	20	0	Description of partner function
20	VKORG_T	☐	VKORG_BEZ	TEXT20	CHAR	20	0	Description of sales organization
21	VTWEG_T	☐	VTWEG_BEZ	TEXT20	CHAR	20	0	Description of distribution channel
22	SPART_T	☐	SPART_BEZ	TEXT20	CHAR	20	0	Description of division
23	VKBUR_T	☐	VKBUR_BEZ	TEXT20	CHAR	20	0	Description of sales office
24	VKGRP_T	☐	VKGRP_BEZ	TEXT20	CHAR	20	0	Description of Sales Group
25	SPSTG	☐	SPSTG	STATV	CHAR	1	0	Overall blocked status
26	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
27	AUGRU_T	☐	AUGRU_BEZ	TEXT40	CHAR	40	0	Description of sales order reason
28	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
29	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
30	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
31	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
32	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
33	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
34	ZTERM_T	☐	DZTERM_BEZ	TEXT30	CHAR	30	0	Description of terms of payment
35	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
36	VBTYP_T	☐	VBTYP_TXT	AS4TEXT	CHAR	60	0	Description of sales and distribution document category
37	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
38	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
39	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
40	ABGRU	☐	ABGRU	ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
41	ABGRU_T	☐	ABGRU_BEZ	TEXT40	CHAR	40	0	Description of reason for rejection
42	KDMAT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
43	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
44	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
45	KBMENG	☐	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
46	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
47	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
48	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	*
49	LIFSP_ITEM	☐			CHAR	1	0
50	LFSTA	☐	LFSTA	STATV	CHAR	1	0	Delivery status
51	FKSAA	☐	FKSAA	STATV	CHAR	1	0	Billing Status for Order-Related Billing Documents
52	ABSTA	☐	ABSTA_VB	STATV	CHAR	1	0	Rejection status for SD item
53	UVALL	☐	UVALL_UP	STATV	CHAR	1	0	General Incompletion Status of the Item
54	VBELN_VL	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
55	POSNR_VL	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
56	LIFMG	☐	LIFMG	MENG13	QUAN	13	3	Delivery qty
57	KOQUA	☐	KOQUA	STATV	CHAR	1	0	Confirmation status of picking/putaway
58	PKSTA	☐	PKSTA	STATV	CHAR	1	0	Packing status of item
59	KOSTA	☐	KOSTA	STATV	CHAR	1	0	Picking Status/Putaway Status
60	LVSTA	☐	LVSTA	STATV	CHAR	1	0	Status of warehouse management activities
61	WBSTA	☐	WBSTA	STATV	CHAR	1	0	Goods movement status
62	FKSTA	☐	FKSTA	STATV	CHAR	1	0	Billing status of delivery-related billing documents
63	FKIVP	☐	FKIVP	STATV	CHAR	1	0	Intercompany billing status
64	PDSTA	☐	PDSTA	STATV	CHAR	1	0	POD status on item level
65	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
66	COSTA	☐	COSTA_D	COSTA	CHAR	1	0	Confirmation status for ALE
67	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
68	RRSTA	☐	RR_STATUS	STATV	CHAR	1	0	Revenue determination status
69	OLFMNG	☐	OLFMNG	MENG13	QUAN	13	3	Open quantity to be delivered (in sales unit)
70	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
71	OVSTA	☐	GBSTA	STATV	CHAR	1	0	Overall Processing Status of the SD Document Item
72	OSTEXT	☐	BEZEI60	TEXT60	CHAR	60	0	Description of rule
73	LFGSA	☐	LFGSA	STATV	CHAR	1	0	Overall Delivery Status of the Item
74	BILSTA	☐	FKSTA	STATV	CHAR	1	0	Billing status of delivery-related billing documents
75	OVDST	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
76	WBSTX	☐	BEZEI60	TEXT60	CHAR	60	0	Description of rule
77	OVSTX	☐	BEZEI60	TEXT60	CHAR	60	0	Description of rule
78	COSTX	☐	BEZEI60	TEXT60	CHAR	60	0	Description of rule
79	GBSTA	☐	GBSTA	STATV	CHAR	1	0	Overall Processing Status of the SD Document Item
80	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document

History

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