| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____00C6 | SID-Tabelle fuer Industry sector | 3 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
2 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
3 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
4 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 12 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
5 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
6 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
7 | CNV_20551_MATNR | Material numbers scheduled for deletion | 6 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
8 | USRMM | User settings: material master | 3 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
9 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
10 | ZSMAT | Materialschlüssel der Fluggesellschaften | 5 | MBRSH | Branche | nvarchar | 1 | 0 | | |
TOPActual CostingMaterial Ledger |
11 | FCML_MAT | ML Characteristics for Material (Selection Criteria) | 24 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPAssortment Maintenance |
12 | TWPA | General Parameters for Retail Control | 13 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPBasis Components |
13 | ZMATERIAL_IDES | Material Master(IDES Demo) | 7 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
14 | MMARA | General material data | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPInterface to Terminal Automation System |
15 | OIKTPIRD | TPI: SD doc. - obsolete - but needed for XPRA ROIKXTPIREL | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
16 | TOIKTRV | LID TAS relevance determination | 10 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPMaintenance Orders |
17 | /CUM/CUTYPE | CU: Compatible Unit Type | 6 | MBRSH | CU: Default Industry Sector for Compatible Unit | nvarchar | 1 | 0 | | |
TOPMaterial Categories |
18 | /ISDFPS/CNODMART | Assignment of iPPE Node Types to Material Types | 4 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPMaterial Master |
19 | MARA | General Material Data | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
20 | MARA_TMP | File for Incorrect Data in Direct Input | 18 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
21 | MOFF | Outstanding Material Master Records | 14 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
22 | MVRA | Cross-version fields for MARA | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
23 | T137 | Industries for materials | 2 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
24 | T137T | Industry Descriptions | 3 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
25 | USRM0 | Material Master User Settings: Screen Reference "User" | 4 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
26 | USRM1 | Material Master User Settings: Organizational Levels | 4 | MBRSH | Deactivated | nvarchar | 1 | 0 | | |
TOPR2-R3 Link |
27 | LDK05 | Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master | 11 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPRecycling Administration Core Functions |
28 | J_7LV1P | REA Document: Item Data | 64 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
29 | NWCHGALDAT | IS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat) | 6 | MBRSH | Settore industriale | nvarchar | 1 | 0 | | |
TOPShipping |
30 | DVM01 | R/2-R/3 Link: R/3 Input Data for Material Master | 13 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPTraders and Schedulers Workbench |
31 | TOI0_REL_MM | Relevance customizing for MM Documents | 21 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
32 | TOI0_REL_SD | IS-OIL: Relevance customizing for SD Documents | 13 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
33 | TOI0_REL_TC | TSW relevance table for trading contract | 19 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
TOPWaste Management |
34 | TEWABEHGRPSD | Allocation of Group Types to Material Types | 4 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |
35 | TEWAIBASESD | Allocation of IBASE Categories to Material Types | 4 | MBRSH | Industry sector | nvarchar | 1 | 0 | | |