TDS_HEAD_COMV SAP (Lean Order - Header Data (Values)) Structure details
Description: Lean Order - Header Data (Values)
Related tables to TDS_HEAD_COMV
Access table TDS_HEAD_COMV
Structure field list including key, data, relationships and ABAP select examples
TDS_HEAD_COMV 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 "Lean Order - Header Data (Values)" 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_HEAD_COMV TYPE TDS_HEAD_COMV.
The TDS_HEAD_COMV table consists of various fields, each holding specific information or linking keys about Lean Order - Header Data (Values) data available in SAP. These include AUART (Sales Document Type), VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division).. 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_HEAD_COMV 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 |
HANDLE | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | SYSUUID_C | ||||
AUART | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
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 | TVKBZ | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
VBELN | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
KUNWE | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
VDATU | Requested delivery date | EDATU_VBAK | DATS | 8 | DATUM | ||||
KETDAT | Requested delivery date of the document | KETDAT | CHAR | 10 | ETDAT | ||||
KPRGBZ | Date type of the requested delivery date | KPRGBZ | CHAR | 1 | Assigned to domain | PRGBZ | |||
DWERK | Delivering Plant (Own or External) | DWERK_EXT | CHAR | 4 | Assigned to domain | WERKS | SH_DWERK_EXTS | ||
AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | Assigned to domain | AUGRU | |||
LIFSK | Delivery block (document header) | LIFSK | CHAR | 2 | TVLS | LIFSP | |||
FAKSK | Billing block in SD document | FAKSK | CHAR | 2 | Assigned to domain | FAKSP | |||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
KURSK_INT | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
KURSK_EXT | Exchange Rate for Pricing (External Format) | 0 | |||||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
ANGDT | Quotation/Inquiry is valid from | ANGDT_V | DATS | 8 | DATUM | ||||
BNDDT | Date until which bid/quotation is binding (valid-to date) | BNDDT | DATS | 8 | DATUM | ||||
GUEBG | Valid-from date (outline agreements, product proposals) | GUEBG | DATS | 8 | DATUM | ||||
GUEEN | Valid-to date (outline agreements, product proposals) | GUEEN | DATS | 8 | DATUM | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | Assigned to domain | VSBED | |||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | Assigned to domain | ZLSCH | |||
DELCO | Agreed delivery time | DELCO | CHAR | 3 | DELCO | ||||
VBEGDAT | Contract start date | VBDAT_VEDA | DATS | 8 | DATUM | ||||
VENDDAT | Contract end date | VNDAT_VEDA | DATS | 8 | DATUM | ||||
VBEGREG | Rule for calculating contract start date | VBREG_VEDA | CHAR | 2 | Assigned to domain | VDREG_VEDA | |||
VENDREG | Rule for contract end date | RGVTE | CHAR | 2 | Assigned to domain | VDREG_VEDA | |||
KTEXT | Search term for product proposal | KTEXT_V | CHAR | 40 | TEXT40 | ||||
PLTYP | Price list type | PLTYP | CHAR | 2 | Assigned to domain | PLTYP | VPL | ||
KONDA | Price group (customer) | KONDA | CHAR | 2 | Assigned to domain | KONDA | VKA | ||
BZIRK | Sales district | BZIRK | CHAR | 6 | Assigned to domain | BZIRK | BZI | ||
KDGRP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | Assigned to domain | BSARK | |||
VSART | Shipping type | VSARTTR | CHAR | 2 | T173 | VERSART | |||
ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
EMPST | Receiving point | EMPST | CHAR | 25 | TEXT25 | ||||
CPD_NAME | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
CPD_STREET | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
CPD_HNUM | House Number | HSNMR | NUMC | 6 | NUMC6 | ||||
CPD_PCODE | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
CPD_CITY | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
CPD_COUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
CPD_LANGU_INT | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
CPD_LANGU_EXT | ISO code for language key | SPRAS_ISO | CHAR | 2 | LAISO | ||||
KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | Assigned to domain | KVGR1 | |||
KVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | Assigned to domain | KVGR2 | |||
KVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | Assigned to domain | KVGR3 | |||
KVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | Assigned to domain | KVGR4 | |||
KVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | Assigned to domain | KVGR5 | |||
KDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2 | Assigned to domain | KDKGR | |||
VBELN_GRP | Mster contract number | VBELN_GRP | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
CCINS | Payment cards: Card type | CCINS | CHAR | 4 | Assigned to domain | CCINS | |||
CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | Assigned to domain | CCNUM | |||
CCDATBI | Payment cards: Expiration date | EXDATBI_CC | CHAR | 10 | CHAR10 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
TAXK1 | Alternative tax classification | TAXK1_AK | CHAR | 1 | Assigned to domain | TAXKD | |||
WAKTION | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
CVVAL | Card Verification Value | CVVAL | CHAR | 6 | CVVAL | ||||
CCNAME | Payment cards: Name of cardholder | CCNAME | CHAR | 40 | TEXT40 | ||||
ABRUF_PART | Check partner authorizations | ABRUF_PART | CHAR | 1 | ABRUF_PART | ||||
XBLNR | Reference Document Number | XBLNR_V1 | CHAR | 16 | XBLNR1 | ||||
SPPAYM | Payment Form for Special Payment Method | SPPAYM | CHAR | 2 | SPPAYM | ||||
SCHEME_GRP | Referencing requirement: Procedure | SCHEME_GRP | CHAR | 4 | Assigned to domain | SCHEME_GRP | |||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
PAY_TYPE | SEPA: Transaction Type | SEPA_PAY_TYPE | CHAR | 1 | SEPA_PAY_TYPE | ||||
SEPON | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
CPD_HNUM_LONG | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
CPD_ADRNR | Address | ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
.INCLU--AP | 0 | ||||||||
PEROP_BEG | Period of Performance Start Date | FM_PEROP_SD_LOW | DATS | 8 | DATUM | ||||
PEROP_END | Period of Performance End Date | FM_PEROP_SD_HIGH | DATS | 8 | DATUM | ||||
PSM_BUDAT | Posting Date in the Document | PSM_BUDAT | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP structure TDS_HEAD_COMV using ABAP code?
As TDS_HEAD_COMV 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_HEAD_COMV as there is no data to select.How to access SAP table TDS_HEAD_COMV
Within an ECC or HANA version of SAP you can also view further information about TDS_HEAD_COMV 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