| 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 | 43 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 43 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 44 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 43 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 43 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
6 | A009 | Additional Selling Plant/EAN | 5 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
7 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 43 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
8 | ZEIM_LIPS | SD document: Delivery: Item data | 67 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
9 | ZEIM_VBAP | Sales Document: Item Data | 104 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
TOPBasic Data |
10 | NBAU | IS-H: Building Units | 29 | EANNR | International Article Number (EAN) | nvarchar | 13 | 0 | | |
11 | NORG | IS-H: Organizational Units | 76 | EANNR | International Article Number (EAN) | nvarchar | 13 | 0 | | |
TOPBilling |
12 | VBRP | Billing Document: Item Data | 66 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
TOPCross-Application Components |
13 | MMARA | General material data | 43 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
14 | VVBAP | Sales Document: Item Data | 104 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
TOPData Collection |
15 | S120 | Sales as per receipts | 8 | EANNR | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
16 | S120BIW1 | S120BIW1 * Sales as Per Receipts | 8 | EANNR | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
17 | S120BIW2 | S120BIW2 * Sales as Per Receipts | 8 | EANNR | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
18 | S120E | S120 - Structural Information | 8 | EANNR | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPHospital Structure |
19 | HRP6081 | Table for Infotype Administrative Data OU | 23 | EANNR | International Article Number (EAN) | nvarchar | 13 | 0 | | |
20 | HRP6091 | Table for Infotype Adminstrative Data BU | 20 | EANNR | International Article Number (EAN) | nvarchar | 13 | 0 | | |
TOPMaterial Master |
21 | MARA | General Material Data | 43 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
22 | MARA_TMP | File for Incorrect Data in Direct Input | 50 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
23 | MARM | Units of Measure for Material | 6 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
24 | MARM_TMP | File for Incorrect Data in Direct Input | 9 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
25 | MVRA | Cross-version fields for MARA | 43 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
26 | MVRM | Units of Measure for Material | 6 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
27 | /BEV1/RBVBAP | Sales Document: Item Data | 104 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
TOPSales |
28 | VBAP | Sales Document: Item Data | 104 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
TOPService Station Retailing |
29 | OIREUPLPXXXX | SSR PC: DTF table for item information | 12 | EANNR | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPShipping |
30 | LIPS | SD document: Delivery: Item data | 67 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |
TOPSimulation |
31 | VSVBAP_CN | Version: Sales document: Item data | 105 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | |