| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 100 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 100 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 101 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 100 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 100 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
6 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 103 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
7 | ZEIM_LIPS | SD document: Delivery: Item data | 163 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
TOPCompany Pension Scheme Germany |
8 | P01CBE | Active CPS Contributions | 18 | KZUMW | Indicator for Deferred Compensation | nvarchar | 1 | 0 | | |
9 | P01VA_BE | Actual Contributions CPS for Pension Equalization Payment | 19 | KZUMW | Indicator for Deferred Compensation | nvarchar | 1 | 0 | | |
10 | P01VA_CBE | Reduction Amounts for Actual Contributions CPS | 19 | KZUMW | Indicator for Deferred Compensation | nvarchar | 1 | 0 | | |
11 | T5DCA | Entitlements / Benefit Types | 54 | KZUMW | Indicator for Deferred Compensation | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
12 | MMARA | General material data | 103 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
TOPData Retention Tool |
13 | TXW_S_LIPS | Retrieve LIPS from archive | 25 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
TOPMaterial Master |
14 | MARA | General Material Data | 103 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
15 | MARA_TMP | File for Incorrect Data in Direct Input | 110 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
16 | MVRA | Cross-version fields for MARA | 103 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |
TOPShipping |
17 | LIPS | SD document: Delivery: Item data | 163 | KZUMW | Environmentally Relevant | nvarchar | 1 | 0 | | |