SAP ABAP Table ESO_S_MTART (Enterprise Search: material type)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MGA (Package) Application development R/3 material master from 3.0
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MGA (Package) Application development R/3 material master from 3.0
Basic Data
Table Category | INTTAB | Structure |
Structure | ESO_S_MTART | Table Relationship Diagram |
Short Description | Enterprise Search: material type |
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 | .INCLUDE | 0 | 0 | Material Types | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | MTART | MTART | MTART | CHAR | 4 | 0 | Material type | * | |
4 | MTREF | MTREF | MAREF | CHAR | 4 | 0 | Reference material type | ||
5 | MBREF | MBREF | MAREF | CHAR | 4 | 0 | Screen reference depending on the material type | ||
6 | FLREF | FLREF_MG | FLREF_MG | CHAR | 4 | 0 | Field reference for material master | T130A | |
7 | NUMKI | NUMKR | CHAR2 | CHAR | 2 | 0 | Number range | ||
8 | NUMKE | NUMKR | CHAR2 | CHAR | 2 | 0 | Number range | ||
9 | ENVOP | ENVOP | XFELD | CHAR | 1 | 0 | External Number Assignment Without Validation | ||
10 | BSEXT | BSEXT | BSEXT | CHAR | 1 | 0 | External Purchase Orders Allowed | ||
11 | BSINT | BSINT | BSINT | CHAR | 1 | 0 | Internal purchase orders allowed | ||
12 | PSTAT | PSTAT_D | PSTAT | CHAR | 15 | 0 | Maintenance status | ||
13 | KKREF | KKREF | KKREF | CHAR | 4 | 0 | Account category reference | T025K | |
14 | VPRSV | VPRSV | VPRSV | CHAR | 1 | 0 | Price control indicator | ||
15 | KZVPR | KZVPR | XFELD | CHAR | 1 | 0 | Price Control Mandatory | ||
16 | VMTPO | VMTPO | MTPOS | CHAR | 4 | 0 | Default value for material item category group | TPTM | |
17 | EKALR | CK_EKALREL | XFELD | CHAR | 1 | 0 | Material Is Costed with Quantity Structure | ||
18 | KZGRP | KZGRP | KZGRP | CHAR | 1 | 0 | Grouping indicator | ||
19 | KZKFG | KZKFG | XFELD | CHAR | 1 | 0 | Configurable Material | ||
20 | BEGRU | BEGRM | BEGRM | CHAR | 4 | 0 | Authorization group in the material master | * | |
21 | KZPRC | KZPRC | XFELD | CHAR | 1 | 0 | Material Master Record for a Process | ||
22 | KZPIP | KZPIP | XFELD | CHAR | 1 | 0 | Pipeline Handling Mandatory | ||
23 | PRDRU | POSPRDRUCK | XFELD | CHAR | 1 | 0 | Display price on cash register display and print on receipt | ||
24 | ARANZ | POSARTANZ | XFELD | CHAR | 1 | 0 | Display material on cash register display | ||
25 | WMAKG | WMAK | WMAK | CHAR | 1 | 0 | Material type ID | ||
26 | IZUST | IZUST | IZUST | CHAR | 1 | 0 | Initial status of a new batch | ||
27 | ARDEL | ARDEL | NUM4 | NUMC | 4 | 0 | Time in days until a material is deleted | ||
28 | KZMPN | MPNMTART | XFELD | CHAR | 1 | 0 | Manufacturer Part | ||
29 | MSTAE | MSTAE | MMSTA | CHAR | 2 | 0 | Cross-Plant Material Status | T141 | |
30 | CCHIS | CC_HIST_MAT | CC_HIST_MAT | CHAR | 1 | 0 | Control (time) of history requirement: Material | ||
31 | CTYPE | KLASSENART_M | KLASSENART | CHAR | 3 | 0 | Class Type | TCLA | |
32 | CLASS | KLASSE_M | KLASSE | CHAR | 18 | 0 | Class number | ||
33 | CHNEU | CHNEU | CHNEU | CHAR | 1 | 0 | Control: create batch (automatically/manually) | ||
34 | .INCLU--AP | 0 | 0 | Version fields for T134 | |||||
35 | VTYPE | VERSIONTYPE | VERSIONTYPE | CHAR | 10 | 0 | Version Category | MGVTYPE | |
36 | VNUMKI | NUMKR | CHAR2 | CHAR | 2 | 0 | Number range | ||
37 | VNUMKE | NUMKR | CHAR2 | CHAR | 2 | 0 | Number range | ||
38 | .INCLU--AP | 0 | 0 | Append Structure for Returnable Packaging Logistics | |||||
39 | KZRAC | KZRAC | XFELD | CHAR | 1 | 0 | Returnable Packaging Logistics is mandatory |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ESO_S_MTART | CTYPE | TCLA | KLART | |||
2 | ESO_S_MTART | FLREF | T130A | FLREF | REF | 1 | CN |
3 | ESO_S_MTART | KKREF | T025K | KKREF | REF | 1 | CN |
4 | ESO_S_MTART | MSTAE | T141 | MMSTA | |||
5 | ESO_S_MTART | VMTPO | TPTM | MTPOS | REF | 1 | CN |
6 | ESO_S_MTART | VTYPE | MGVTYPE | VTYPE |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in | 604 |