| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____00B7 | SID-Tabelle fuer Basic material | 3 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
2 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 26 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
3 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 26 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
4 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 27 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
5 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 26 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
6 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 26 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
7 | HRBW_REC_DT | PY-XX-RECON : Country specific reports detailed results | 4 | WRKST | Worksite | nvarchar | 2 | 0 | | |
8 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 4 | WRKST | Character length 2 | nvarchar | 2 | 0 | | |
9 | T7RU52ST | Text for work condition degree | 4 | WRKST | Work Condition Degree | nvarchar | 2 | 0 | | |
10 | T7RU52W | Percent bonus for Work Conditions | 6 | WRKST | Work Condition Degree | nvarchar | 2 | 0 | | |
11 | T7RU52WC | Class ans Degree of Work Condition | 3 | WRKST | Work Condition Degree | nvarchar | 2 | 0 | | |
12 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 26 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
TOPCross-Application Components |
13 | MMARA | General material data | 26 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
TOPMaterial Master |
14 | MARA | General Material Data | 26 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
15 | MARA_TMP | File for Incorrect Data in Direct Input | 33 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
16 | MVRA | Cross-version fields for MARA | 26 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
17 | TWSPR | Check Table for Basic Material Field | 2 | WRKST | Basic Material | nvarchar | 48 | 0 | | |
TOPValue-Added Services |
18 | LVVOR | VAS orders | 4 | WRKST | Work Center | nvarchar | 20 | 0 | | |
19 | LVVWC | VAS work center determination | 3 | WRKST | Work Center | nvarchar | 20 | 0 | | |