| 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 | 117 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 117 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 118 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 117 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 117 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
6 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 121 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
TOPBatches |
7 | PRDKZ | SLED Period Indicator | 2 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
8 | PRDKZT | Language-dependent texts for SLED period indicator | 3 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
9 | MMARA | General material data | 121 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
TOPInventory Management |
10 | MWZDM07M2 | ZDM07M2 | 210 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
TOPMaterial Master |
11 | MARA | General Material Data | 121 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
12 | MARA_TMP | File for Incorrect Data in Direct Input | 128 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
13 | MVRA | Cross-version fields for MARA | 121 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
TOPMaterials Management |
14 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 144 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
TOPPurchasing |
15 | EBAN | Purchase Requisition | 136 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
16 | EINE | Purchasing Info Record: Purchasing Organization Data | 67 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |
17 | EKPO | Purchasing Document Item | 197 | IPRKZ | Period Indicator for Shelf Life Expiration Date | nvarchar | 1 | 0 | | |