SAP Table ENT6019
Generated Table for View
ENT6019 (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ENT6019 to other SAP tables.
Source: ENT6019 (Generated Table for View)
ENT6019 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||||||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||
| BEGRU | Authorization Group | BEGRU | CHAR | 4 | 0 | |||||||||||||
| LOEVM | Deletion flag for customer (sales level) | LOEVM_V | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| VERSG | Customer Statistics Group | STGKU | TVSD | CHAR | 1 | 0 | ||||||||||||
| AUFSD | Customer order block (sales area) | AUFSD_V | TVAST | CHAR | 2 | 0 | ||||||||||||
| KALKS | Pricing procedure assigned to this customer | KALKS | TVKD | CHAR | 1 | 0 | ||||||||||||
| KDGRP | Customer group | KDGRP | T151 | CHAR | 2 | 0 | ||||||||||||
| BZIRK | Sales district | BZIRK | T171 | CHAR | 6 | 0 | ||||||||||||
| KONDA | Price group (customer) | KONDA | T188 | CHAR | 2 | 0 | ||||||||||||
| PLTYP | Price list type | PLTYP | T189 | CHAR | 2 | 0 | ||||||||||||
| AWAHR | Order probability of the item | AWAHR | NUMC | 3 | 0 |
Possible values
|
||||||||||||
| INCO1 | Incoterms (Part 1) | INCO1 | TINC | CHAR | 3 | 0 | ||||||||||||
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | 0 | |||||||||||||
| LIFSD | Customer delivery block (sales area) | LIFSD_V | TVLS | CHAR | 2 | 0 | ||||||||||||
| AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1 | 0 | |||||||||||||
| KZTLF | Partial delivery at item level | KZTLF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| CHSPL | Batch split allowed | CHSPL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| LPRIO | Delivery Priority | LPRIO | TPRIO | NUMC | 2 | 0 | ||||||||||||
| EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12 | 0 | |||||||||||||
| VSBED | Shipping Conditions | VSBED | TVSB | CHAR | 2 | 0 | ||||||||||||
| FAKSD | Billing block for customer (sales and distribution) | FAKSD_V | TVFS | CHAR | 2 | 0 | ||||||||||||
| MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PERFK | Invoice dates (calendar identification) | PERFK | TFACD | CHAR | 2 | 0 | ||||||||||||
| PERRL | Invoice list schedule (calendar identification) | PERRL | TFACD | CHAR | 2 | 0 | ||||||||||||
| KVAKZ | Cost estimate indicator (inactive) | KVAKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| KVAWT | Value limit for cost estimate (inactive) | KVAWT | CURR | 13 | 2 | |||||||||||||
| WAERS | Currency | WAERS_V02D | TCURC | CUKY | 5 | 0 | ||||||||||||
| KLABC | Customer classification (ABC analysis) | KLABC | CHAR | 2 | 0 | |||||||||||||
| KTGRD | Account assignment group for this customer | KTGRD | TVKT | CHAR | 2 | 0 | ||||||||||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | 0 | |||||||||||||
| VWERK | Delivering Plant (Own or External) | DWERK_EXT | TVKWZ | CHAR | 4 | 0 | ||||||||||||
| VKGRP | Sales Group | VKGRP | TVBVK | CHAR | 3 | 0 | ||||||||||||
| VKBUR | Sales Office | VKBUR | TVBUR | CHAR | 4 | 0 | ||||||||||||
| VSORT | Item proposal | VSORT | VBUK | CHAR | 10 | 0 | ||||||||||||
ENT6019 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ENT6019 | AUFSD | ENT6019 | AUFSD | TVAST | Sales Document Blocking Reasons: Texts | AUFSP |
| ENT6019 | AUFSD | SYST | LANGU | TVAST | Sales Document Blocking Reasons: Texts | SPRAS |
| ENT6019 | AUFSD | ENT6019 | MANDT | TVAST | Sales Document Blocking Reasons: Texts | MANDT |
| ENT6019 | BZIRK | ENT6019 | MANDT | T171 | Customers: Sales Districts | MANDT |
| ENT6019 | BZIRK | ENT6019 | BZIRK | T171 | Customers: Sales Districts | BZIRK |
| ENT6019 | FAKSD | ENT6019 | MANDT | TVFS | Billing: Reasons for Blocking | MANDT |
| ENT6019 | FAKSD | ENT6019 | FAKSD | TVFS | Billing: Reasons for Blocking | FAKSP |
| ENT6019 | INCO1 | ENT6019 | INCO1 | TINC | Customers: Incoterms | INCO1 |
| ENT6019 | INCO1 | ENT6019 | MANDT | TINC | Customers: Incoterms | MANDT |
| ENT6019 | KALKS | ENT6019 | KALKS | TVKD | Customer Pricing Procedures | KALKS |
| ENT6019 | KALKS | ENT6019 | MANDT | TVKD | Customer Pricing Procedures | MANDT |
| ENT6019 | KDGRP | ENT6019 | MANDT | T151 | Customers: Customer Groups | MANDT |
| ENT6019 | KDGRP | ENT6019 | KDGRP | T151 | Customers: Customer Groups | KDGRP |
| ENT6019 | KONDA | ENT6019 | MANDT | T188 | Conditions: Groups for Customer Classifications | MANDT |
| ENT6019 | KONDA | ENT6019 | KONDA | T188 | Conditions: Groups for Customer Classifications | KONDA |
| ENT6019 | KTGRD | ENT6019 | MANDT | TVKT | Customers: Account Assignment Groups | MANDT |
| ENT6019 | KTGRD | ENT6019 | KTGRD | TVKT | Customers: Account Assignment Groups | KTGRD |
| ENT6019 | KUNNR | ENT6019 | MANDT | KNA1 | General Data in Customer Master | MANDT |
| ENT6019 | KUNNR | ENT6019 | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| ENT6019 | LIFSD | ENT6019 | MANDT | TVLS | Deliveries: Blocking Reasons/Criteria | MANDT |
| ENT6019 | LIFSD | ENT6019 | LIFSD | TVLS | Deliveries: Blocking Reasons/Criteria | LIFSP |
| ENT6019 | LPRIO | ENT6019 | LPRIO | TPRIO | Customers: Delivery Priorities | LPRIO |
| ENT6019 | LPRIO | ENT6019 | MANDT | TPRIO | Customers: Delivery Priorities | MANDT |
| ENT6019 | MANDT | ENT6019 | MANDT | T000 | Clients | MANDT |
| ENT6019 | PERFK | ENT6019 | PERFK | TFACD | Factory calendar definition | IDENT |
| ENT6019 | PERRL | ENT6019 | PERRL | TFACD | Factory calendar definition | IDENT |
| ENT6019 | PLTYP | ENT6019 | PLTYP | T189 | Conditions: Price List Categories | PLTYP |
| ENT6019 | PLTYP | ENT6019 | MANDT | T189 | Conditions: Price List Categories | MANDT |
| ENT6019 | SPART | ENT6019 | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| ENT6019 | SPART | ENT6019 | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| ENT6019 | VERSG | ENT6019 | MANDT | TVSD | Customers: Statistics groups | MANDT |
| ENT6019 | VERSG | ENT6019 | VERSG | TVSD | Customers: Statistics groups | STGKU |
| ENT6019 | VKBUR | ENT6019 | VKBUR | TVBUR | Organizational Unit: Sales Offices | VKBUR |
| ENT6019 | VKBUR | ENT6019 | MANDT | TVBUR | Organizational Unit: Sales Offices | MANDT |
| ENT6019 | VKGRP | ENT6019 | VKGRP | TVBVK | Organizational Unit: Sales Groups per Sales Office | VKGRP |
| ENT6019 | VKGRP | ENT6019 | MANDT | TVBVK | Organizational Unit: Sales Groups per Sales Office | MANDT |
| ENT6019 | VKGRP | ENT6019 | VKBUR | TVBVK | Organizational Unit: Sales Groups per Sales Office | VKBUR |
| ENT6019 | VKORG | ENT6019 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| ENT6019 | VKORG | ENT6019 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| ENT6019 | VSBED | ENT6019 | VSBED | TVSB | Shipping Conditions | VSBED |
| ENT6019 | VSBED | ENT6019 | MANDT | TVSB | Shipping Conditions | MANDT |
| ENT6019 | VSORT | ENT6019 | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| ENT6019 | VSORT | ENT6019 | VSORT | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| ENT6019 | VTWEG | ENT6019 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| ENT6019 | VTWEG | ENT6019 | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| ENT6019 | VWERK | ENT6019 | VWERK | TVKWZ | Org.Unit: Allowed Plants per Sales Organization | WERKS |
| ENT6019 | VWERK | ENT6019 | VTWEG | TVKWZ | Org.Unit: Allowed Plants per Sales Organization | VTWEG |
| ENT6019 | VWERK | ENT6019 | VKORG | TVKWZ | Org.Unit: Allowed Plants per Sales Organization | VKORG |
| ENT6019 | VWERK | ENT6019 | MANDT | TVKWZ | Org.Unit: Allowed Plants per Sales Organization | MANDT |
| ENT6019 | WAERS | ENT6019 | MANDT | TCURC | Currency Codes | MANDT |
| ENT6019 | WAERS | ENT6019 | WAERS | TCURC | Currency Codes | WAERS |
