SAP Table ENT6066
Generated Table for View
ENT6066 (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 ENT6066 to other SAP tables.
ENT6066 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||
VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||
VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||
LVORM | Ind.: Flag material for deletion at distribution chain level | LVOVK | CHAR | 1 | 0 |
Possible values
|
||||||
VERSG | Material statistics group | STGMA | TVSM | CHAR | 1 | 0 | ||||||
BONUS | Volume rebate group | BONUS | TVBO | CHAR | 2 | 0 | ||||||
PROVG | Commission group | PROVG | TVPR | CHAR | 2 | 0 | ||||||
SKTOF | Cash discount indicator | SKTOF | CHAR | 1 | 0 |
Possible values
|
||||||
VMSTA | Distribution-chain-specific material status | VMSTA | TVMS | CHAR | 2 | 0 | ||||||
VMSTD | Date from which distr.-chain-spec. material status is valid | VMSTD | DATS | 8 | 0 | |||||||
AUMNG | Minimum order quantity in base unit of measure | MINAU | QUAN | 13 | 3 | |||||||
LFMNG | Minimum delivery quantity in delivery note processing | MINLF | QUAN | 13 | 3 | |||||||
EFMNG | Minimum make-to-order quantity | MINEF | QUAN | 13 | 3 | |||||||
SCMNG | Delivery unit | SCHRT | QUAN | 13 | 3 | |||||||
SCHME | Unit of measure of delivery unit | SCHME | T006 | UNIT | 3 | 0 | ||||||
VRKME | Sales unit | VRKME | T006 | UNIT | 3 | 0 | ||||||
MTPOS | Item category group from material master | MTPOS | TPTM | CHAR | 4 | 0 | ||||||
DWERK | Delivering Plant (Own or External) | DWERK_EXT | TVKWZ | CHAR | 4 | 0 | ||||||
PRODH | Product hierarchy | PRODH_D | T179 | CHAR | 18 | 0 | ||||||
PMATN | Pricing Reference Material | PMATN | MARA | CHAR | 18 | 0 | ||||||
KONDM | Material Pricing Group | KONDM | T178 | CHAR | 2 | 0 | ||||||
KTGRM | Account assignment group for this material | KTGRM | TVKM | CHAR | 2 | 0 |
ENT6066 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
ENT6066 | BONUS | ENT6066 | MANDT | TVBO | Sales Rebate Groups | MANDT |
ENT6066 | BONUS | ENT6066 | BONUS | TVBO | Sales Rebate Groups | BONUS |
ENT6066 | DWERK | ENT6066 | DWERK | TVKWZ | Org.Unit: Allowed Plants per Sales Organization | WERKS |
ENT6066 | DWERK | ENT6066 | MANDT | TVKWZ | Org.Unit: Allowed Plants per Sales Organization | MANDT |
ENT6066 | DWERK | ENT6066 | VKORG | TVKWZ | Org.Unit: Allowed Plants per Sales Organization | VKORG |
ENT6066 | DWERK | ENT6066 | VTWEG | TVKWZ | Org.Unit: Allowed Plants per Sales Organization | VTWEG |
ENT6066 | KONDM | ENT6066 | MANDT | T178 | Conditions: Groups for Materials | MANDT |
ENT6066 | KONDM | ENT6066 | KONDM | T178 | Conditions: Groups for Materials | KONDM |
ENT6066 | KTGRM | ENT6066 | MANDT | TVKM | Materials: Account Assignment Groups | MANDT |
ENT6066 | KTGRM | ENT6066 | KTGRM | TVKM | Materials: Account Assignment Groups | KTGRM |
ENT6066 | MANDT | ENT6066 | MANDT | T000 | Clients | MANDT |
ENT6066 | MATNR | ENT6066 | MANDT | MARA | General Material Data | MANDT |
ENT6066 | MATNR | ENT6066 | MATNR | MARA | General Material Data | MATNR |
ENT6066 | MTPOS | ENT6066 | MTPOS | TPTM | Materials: Item Category Groups in Material Master | MTPOS |
ENT6066 | MTPOS | ENT6066 | MANDT | TPTM | Materials: Item Category Groups in Material Master | MANDT |
ENT6066 | PMATN | ENT6066 | PMATN | MARA | General Material Data | MATNR |
ENT6066 | PMATN | ENT6066 | MANDT | MARA | General Material Data | MANDT |
ENT6066 | PRODH | ENT6066 | MANDT | T179 | Materials: Product Hierarchies | MANDT |
ENT6066 | PRODH | ENT6066 | PRODH | T179 | Materials: Product Hierarchies | PRODH |
ENT6066 | PROVG | ENT6066 | MANDT | TVPR | Commission Groups | MANDT |
ENT6066 | PROVG | ENT6066 | PROVG | TVPR | Commission Groups | PROVG |
ENT6066 | SCHME | ENT6066 | MANDT | T006 | Units of Measurement | MANDT |
ENT6066 | SCHME | ENT6066 | SCHME | T006 | Units of Measurement | MSEHI |
ENT6066 | VERSG | ENT6066 | VERSG | TVSM | Material statistics groups | STGMA |
ENT6066 | VERSG | ENT6066 | MANDT | TVSM | Material statistics groups | MANDT |
ENT6066 | VKORG | ENT6066 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
ENT6066 | VKORG | ENT6066 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
ENT6066 | VMSTA | ENT6066 | MANDT | TVMS | Materials: Status in Sales and Distribution | MANDT |
ENT6066 | VMSTA | ENT6066 | VMSTA | TVMS | Materials: Status in Sales and Distribution | VMSTA |
ENT6066 | VRKME | ENT6066 | VRKME | T006 | Units of Measurement | MSEHI |
ENT6066 | VRKME | ENT6066 | MANDT | T006 | Units of Measurement | MANDT |
ENT6066 | VTWEG | ENT6066 | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
ENT6066 | VTWEG | ENT6066 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |