TDS_ORDTRACK SAP (Structure: Order Tracking) Structure details
Description: Structure: Order Tracking
Structure field list including key, data, relationships and ABAP select examples
TDS_ORDTRACK is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure: Order Tracking" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_TDS_ORDTRACK TYPE TDS_ORDTRACK.
The TDS_ORDTRACK table consists of various fields, each holding specific information or linking keys about Structure: Order Tracking data available in SAP. These include AUART (Sales Document Type), AUART_T (Description), KUNAG (Sold-to party), KUNAG_T (Name 1).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP TDS_ORDTRACK structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
AUART | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
AUART_T | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
KUNAG_T | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ZPAVW | Partner Function | PARVW | CHAR | 2 | Assigned to domain | PARVW | PARVW | PAR | |
ZPERS | Person responsible | DZPERS | NUMC | 8 | PERNR | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
AWAHR | Sales probability | AWAHR_AK | NUMC | 3 | AWAHR | ||||
PZPERS_T | Name of Employee Responsible | PZPERS_BEZ | CHAR | 35 | NAME | ||||
PARVW_T | Description of partner function | PARVW_BEZ | CHAR | 20 | TEXT20 | ||||
VKORG_T | Description of sales organization | VKORG_BEZ | CHAR | 20 | TEXT20 | ||||
VTWEG_T | Description of distribution channel | VTWEG_BEZ | CHAR | 20 | TEXT20 | ||||
SPART_T | Description of division | SPART_BEZ | CHAR | 20 | TEXT20 | ||||
VKBUR_T | Description of sales office | VKBUR_BEZ | CHAR | 20 | TEXT20 | ||||
VKGRP_T | Description of Sales Group | VKGRP_BEZ | CHAR | 20 | TEXT20 | ||||
SPSTG | Overall blocked status | SPSTG | CHAR | 1 | STATV | ||||
AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | Assigned to domain | AUGRU | |||
AUGRU_T | Description of sales order reason | AUGRU_BEZ | CHAR | 40 | TEXT40 | ||||
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | Assigned to domain | VSBED | |||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | Assigned to domain | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZTERM_T | Description of terms of payment | DZTERM_BEZ | CHAR | 30 | TEXT30 | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
VBTYP_T | Description of sales and distribution document category | VBTYP_TXT | CHAR | 60 | AS4TEXT | ||||
POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
ABGRU | Reason for rejection of quotations and sales orders | ABGRU | CHAR | 2 | ABGRU | ||||
ABGRU_T | Description of reason for rejection | ABGRU_BEZ | CHAR | 40 | TEXT40 | ||||
KDMAT | Material belonging to the customer | KDMAT | CHAR | 35 | IDNEX | ||||
NETWR | Net value of the order item in document currency | NETWR_AP | CURR | 15(2) | WERTV8 | ||||
KWMENG | Cumulative Order Quantity in Sales Units | KWMENG | QUAN | 15(3) | MENG15 | ||||
KBMENG | Cumulative confirmed quantity in sales unit | KBMENG | QUAN | 15(3) | MENG15 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FAKSP | Billing block for item | FAKSP_AP | CHAR | 2 | Assigned to domain | FAKSP | |||
LIFSP_ITEM | Delivery Block Flag at Schedule Line Level | 0 | |||||||
LFSTA | Delivery status | LFSTA | CHAR | 1 | STATV | ||||
FKSAA | Billing Status for Order-Related Billing Documents | FKSAA | CHAR | 1 | STATV | ||||
ABSTA | Rejection status for SD item | ABSTA_VB | CHAR | 1 | STATV | ||||
UVALL | General Incompletion Status of Item | UVALL_UP | CHAR | 1 | STATV | ||||
VBELN_VL | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
POSNR_VL | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
LIFMG | Delivery qty | LIFMG | QUAN | 13(3) | MENG13 | ||||
KOQUA | Confirmation status of picking/putaway | KOQUA | CHAR | 1 | STATV | ||||
PKSTA | Packing status of item | PKSTA | CHAR | 1 | STATV | ||||
KOSTA | Picking status/Putaway status | KOSTA | CHAR | 1 | STATV | ||||
LVSTA | Status of warehouse management activities | LVSTA | CHAR | 1 | STATV | ||||
WBSTA | Goods movement status | WBSTA | CHAR | 1 | STATV | ||||
FKSTA | Billing status of delivery-related billing documents | FKSTA | CHAR | 1 | STATV | ||||
FKIVP | Intercompany Billing Status | FKIVP | CHAR | 1 | STATV | ||||
PDSTA | POD status on item level | PDSTA | CHAR | 1 | STATV | ||||
BANFN | Purchase Requisition Number | BANFN | CHAR | 10 | ALPHA | BANFN | BAN | MBAN_C | |
COSTA | Confirmation status for ALE | COSTA_D | CHAR | 1 | COSTA | ||||
PSTYV | Sales document item category | PSTYV | CHAR | 4 | Assigned to domain | PSTYV | |||
RRSTA | Revenue determination status | RR_STATUS | CHAR | 1 | STATV | ||||
OLFMNG | Open quantity to be delivered (in sales unit) | OLFMNG | QUAN | 13(3) | MENG13 | ||||
BNFPO | Item Number of Purchase Requisition | BNFPO | NUMC | 5 | Assigned to domain | BNFPO | BAP | ||
OVSTA | Overall processing status of the SD document item | GBSTA | CHAR | 1 | STATV | ||||
OSTEXT | Description of rule | BEZEI60 | CHAR | 60 | TEXT60 | ||||
LFGSA | Overall delivery status of the item | LFGSA | CHAR | 1 | STATV | ||||
BILSTA | Billing status of delivery-related billing documents | FKSTA | CHAR | 1 | STATV | ||||
OVDST | Overall processing status of document | GBSTK | CHAR | 1 | STATV | ||||
WBSTX | Description of rule | BEZEI60 | CHAR | 60 | TEXT60 | ||||
OVSTX | Description of rule | BEZEI60 | CHAR | 60 | TEXT60 | ||||
COSTX | Description of rule | BEZEI60 | CHAR | 60 | TEXT60 | ||||
GBSTA | Overall processing status of the SD document item | GBSTA | CHAR | 1 | STATV | ||||
GBSTK | Overall processing status of document | GBSTK | CHAR | 1 | STATV |
Key field | Non-key field |
How do I retrieve data from SAP structure TDS_ORDTRACK using ABAP code?
As TDS_ORDTRACK is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TDS_ORDTRACK as there is no data to select.How to access SAP table TDS_ORDTRACK
Within an ECC or HANA version of SAP you can also view further information about TDS_ORDTRACK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects