| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000177000 | PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item | 28 | EAN11 | | nvarchar | 18 | 0 | | |
2 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 44 | EAN11 | | nvarchar | 18 | 0 | | |
3 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 54 | EAN11 | | nvarchar | 18 | 0 | | |
4 | /BIC/B0000180000 | PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch. | 40 | EAN11 | | nvarchar | 18 | 0 | | |
5 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 34 | EAN11 | | nvarchar | 18 | 0 | | |
6 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 39 | EAN11 | | nvarchar | 18 | 0 | | |
7 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 35 | EAN11 | | nvarchar | 18 | 0 | | |
8 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 30 | EAN11 | | nvarchar | 18 | 0 | | |
9 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 50 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
10 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 50 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
11 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 51 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
12 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 50 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
13 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 50 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
14 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 51 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
15 | ZEIM_LIPS | SD document: Delivery: Item data | 88 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
16 | ZEIM_VBAP | Sales Document: Item Data | 121 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPAdvertising Management |
17 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 40 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPAssortment |
18 | WRF_APC_PAUOM | Planned Article Units of Measure | 6 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPAssortment List |
19 | WBBP | Assortment list item | 7 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPAustralia |
20 | PA0701 | HR Terminations Data Container : Infotype 0701 | 227 | EAN11 | Number | decimal | 7 | 2 | | |
TOPBilling |
21 | VBRP | Billing Document: Item Data | 87 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPConditions |
22 | A070 | EAN per Plant | 8 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
23 | A072 | EAN per SOrg/DstCh | 7 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
24 | MMARA | General material data | 51 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
25 | VVBAP | Sales Document: Item Data | 121 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPDSD Connector |
26 | /DSD/ME_MAT_HD | DSD CN: Material Data for Downloading to HH | 9 | EAN11 | DSD Connector: International article number | nvarchar | 18 | 0 | | |
27 | /DSD/ME_MAT_UOM | DSD CN: Material Alternative Units of Measure | 7 | EAN11 | DSD Connector: International article number | nvarchar | 18 | 0 | | |
TOPExternal Services |
28 | ASMD | Service Master: Basic Data | 12 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPInventory Management |
29 | MWZDM07M2 | ZDM07M2 | 50 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPInvoice Verification |
30 | RBDIFFME | Batch Invoice Verification - Quantity Differences | 5 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
31 | RBDRSEG | Batch IV: Invoice Document Items | 80 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPLocalization |
32 | J_1IRAINDTL | Article Inward Note Detail | 15 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
33 | SAFTPT_IMAT | SAFT PT : Tax Like materials | 5 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPLogistics - General |
34 | WBHI | Trading Contract: Item Data | 56 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPMaterial Master |
35 | MARA | General Material Data | 51 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
36 | MARA_TMP | File for Incorrect Data in Direct Input | 58 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
37 | MARM | Units of Measure for Material | 7 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
38 | MARM_TMP | File for Incorrect Data in Direct Input | 10 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
39 | MEA1_TMP | File for Incorrect Data in Direct Input | 7 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
40 | MEAN | International Article Numbers (EANs) for Material | 5 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
41 | MLEA | Vendor-Specific EANs | 6 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
42 | MVRA | Cross-version fields for MARA | 51 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
43 | MVRM | Units of Measure for Material | 7 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPMedia Product Sales and Distribution |
44 | JKSDUNSOLDITEM | IS-M: Item Data on Unsold Copies/Credit Memos | 77 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
45 | JPTMG0 | IS-M: Media Product Issue Sequence | 17 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPMerchandise and Assortment Planning |
46 | TWISPC_MARA | Retail Planning: Materials for Provisional Planning | 15 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPPendulum List Indirect Sales |
47 | /BEV4/PLDANFKON | Converted Request Table with Reporting Period | 28 | EAN11 | EAN/UPC CODE | nvarchar | 18 | 0 | | |
TOPPOS Interface |
48 | WVFB | DRS Interface, Intermediate Buffer, Order Item FM | 30 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPPurchasing |
49 | EKPO | Purchasing Document Item | 94 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
50 | /BEV1/RBVBAP | Sales Document: Item Data | 121 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPRetail Pricing |
51 | WKBP | Pricing document: item | 17 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPSales |
52 | SLS_TMPL_ITEM | Sales: Template Item | 8 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
53 | VBAP | Sales Document: Item Data | 121 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPShipping |
54 | LIPS | SD document: Delivery: Item data | 88 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
TOPSimulation |
55 | VSVBAP_CN | Version: Sales document: Item data | 122 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |