SAP ABAP Table TDS_HEAD_COMV (Lean Order - Header Data (Values))
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ SD-SLS (Application Component) Sales
⤷ ERP_SALES_LORD (Package) ERP Sales Lean Order
⤷ SD-SLS (Application Component) Sales
⤷ ERP_SALES_LORD (Package) ERP Sales Lean Order
Basic Data
Table Category | INTTAB | Structure |
Structure | TDS_HEAD_COMV | Table Relationship Diagram |
Short Description | Lean Order - Header Data (Values) |
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 | HANDLE | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
2 | AUART | AUART | AUART | CHAR | 4 | 0 | Sales Document Type | * | |
3 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
4 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
5 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
6 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVKBZ | |
7 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVBVK | |
8 | VBELN | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
9 | KUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
10 | KUNWE | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
11 | BSTKD | BSTKD | BSTKD | CHAR | 35 | 0 | Customer purchase order number | ||
12 | BSTDK | BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date | ||
13 | VDATU | EDATU_VBAK | DATUM | DATS | 8 | 0 | Requested delivery date | ||
14 | KETDAT | KETDAT | ETDAT | CHAR | 10 | 0 | Requested delivery date of the document | ||
15 | KPRGBZ | KPRGBZ | PRGBZ | CHAR | 1 | 0 | Date type of the requested delivery date | * | |
16 | DWERK | DWERK_EXT | WERKS | CHAR | 4 | 0 | Delivering Plant (Own or External) | * | |
17 | AUGRU | AUGRU | AUGRU | CHAR | 3 | 0 | Order reason (reason for the business transaction) | * | |
18 | LIFSK | LIFSK | LIFSP | CHAR | 2 | 0 | Delivery block (document header) | TVLS | |
19 | FAKSK | FAKSK | FAKSP | CHAR | 2 | 0 | Billing block in SD document | * | |
20 | PRSDT | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
21 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
22 | KURSK_INT | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
23 | KURSK_EXT | CHAR | 12 | 0 | |||||
24 | INCO1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | TINC | |
25 | INCO2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
26 | FKDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
27 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
28 | AUTLF | AUTLF | XFELD | CHAR | 1 | 0 | Complete delivery defined for each sales order? | ||
29 | AUDAT | AUDAT | DATUM | DATS | 8 | 0 | Document Date (Date Received/Sent) | ||
30 | ANGDT | ANGDT_V | DATUM | DATS | 8 | 0 | Quotation/Inquiry is valid from | ||
31 | BNDDT | BNDDT | DATUM | DATS | 8 | 0 | Date until which bid/quotation is binding (valid-to date) | ||
32 | GUEBG | GUEBG | DATUM | DATS | 8 | 0 | Valid-from date (outline agreements, product proposals) | ||
33 | GUEEN | GUEEN | DATUM | DATS | 8 | 0 | Valid-to date (outline agreements, product proposals) | ||
34 | VSBED | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | * | |
35 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | * | |
36 | DELCO | DELCO | DELCO | CHAR | 3 | 0 | Agreed delivery time | ||
37 | VBEGDAT | VBDAT_VEDA | DATUM | DATS | 8 | 0 | Contract start date | ||
38 | VENDDAT | VNDAT_VEDA | DATUM | DATS | 8 | 0 | Contract End Date | ||
39 | VBEGREG | VBREG_VEDA | VDREG_VEDA | CHAR | 2 | 0 | Rule for calculating contract start date | * | |
40 | VENDREG | RGVTE | VDREG_VEDA | CHAR | 2 | 0 | Rule for contract end date | * | |
41 | KTEXT | KTEXT_V | TEXT40 | CHAR | 40 | 0 | Search term for product proposal | ||
42 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | * | |
43 | KONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | * | |
44 | BZIRK | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
45 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
46 | BSARK | BSARK | BSARK | CHAR | 4 | 0 | Customer Order Type | * | |
47 | VSART | VSARTTR | VERSART | CHAR | 2 | 0 | Shipping type | T173 | |
48 | ABLAD | ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
49 | EMPST | EMPST | TEXT25 | CHAR | 25 | 0 | Receiving point | ||
50 | CPD_NAME | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
51 | CPD_STREET | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
52 | CPD_HNUM | HSNMR | NUMC6 | NUMC | 6 | 0 | House Number | ||
53 | CPD_PCODE | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
54 | CPD_CITY | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
55 | CPD_COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
56 | CPD_LANGU_INT | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
57 | CPD_LANGU_EXT | SPRAS_ISO | LAISO | CHAR | 2 | 0 | ISO code for language key | ||
58 | KVGR1 | KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | * | |
59 | KVGR2 | KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | * | |
60 | KVGR3 | KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | * | |
61 | KVGR4 | KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | * | |
62 | KVGR5 | KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | * | |
63 | KDKG1 | KDKG1 | KDKGR | CHAR | 2 | 0 | Customer condition group 1 | * | |
64 | KDKG2 | KDKG2 | KDKGR | CHAR | 2 | 0 | Customer condition group 2 | * | |
65 | KDKG3 | KDKG3 | KDKGR | CHAR | 2 | 0 | Customer condition group 3 | * | |
66 | KDKG4 | KDKG4 | KDKGR | CHAR | 2 | 0 | Customer condition group 4 | * | |
67 | KDKG5 | KDKG5 | KDKGR | CHAR | 2 | 0 | Customer condition group 5 | * | |
68 | VBELN_GRP | VBELN_GRP | VBELN | CHAR | 10 | 0 | Group Master Contract | * | |
69 | CCINS | CCINS | CCINS | CHAR | 4 | 0 | Payment cards: Card type | * | |
70 | CCNUM | CCNUM | CCNUM | CHAR | 25 | 0 | Payment cards: Card number | * | |
71 | CCDATBI | EXDATBI_CC | CHAR10 | CHAR | 10 | 0 | Payment cards: Expiration date | ||
72 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
73 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
74 | TAXK1 | TAXK1_AK | TAXKD | CHAR | 1 | 0 | Alternative tax classification | * | |
75 | WAKTION | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | * | |
76 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
77 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
78 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
79 | CVVAL | CVVAL | CVVAL | CHAR | 6 | 0 | Card Verification Value | ||
80 | CCNAME | CCNAME | TEXT40 | CHAR | 40 | 0 | Payment Cards: Name of Cardholder | ||
81 | ABRUF_PART | ABRUF_PART | ABRUF_PART | CHAR | 1 | 0 | Check partner authorizations | ||
82 | XBLNR | XBLNR_V1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
83 | SPPAYM | SPPAYM | SPPAYM | CHAR | 2 | 0 | Payment Form for Special Payment Method | ||
84 | SCHEME_GRP | SCHEME_GRP | SCHEME_GRP | CHAR | 4 | 0 | Referencing requirement: Procedure | * | |
85 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
86 | PAY_TYPE | SEPA_PAY_TYPE | SEPA_PAY_TYPE | CHAR | 1 | 0 | SEPA: Payment Type | ||
87 | SEPON | SD_SEPA_FLAG | SD_SEPA_FLAG | CHAR | 1 | 0 | SEPA-Relevance | ||
88 | CPD_HNUM_LONG | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
89 | CPD_ADRNR | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TDS_HEAD_COMV | CPD_COUNTRY | T005 | LAND1 | REF | C | CN |
2 | TDS_HEAD_COMV | INCO1 | TINC | INCO1 | REF | C | CN |
3 | TDS_HEAD_COMV | LIFSK | TVLS | LIFSP | |||
4 | TDS_HEAD_COMV | VKBUR | TVKBZ | VKBUR | REF | C | CN |
5 | TDS_HEAD_COMV | VKGRP | TVBVK | VKGRP | REF | C | CN |
6 | TDS_HEAD_COMV | VSART | T173 | VSART | |||
7 | TDS_HEAD_COMV | WAERK | TCURC | WAERS | REF | C | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 700 |