| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000189000 | PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line | 96 | ATTYP | | nvarchar | 2 | 0 | | |
2 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 81 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
3 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 81 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
4 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 82 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
5 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 81 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
6 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 81 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
7 | AUAB | Settlement Document: Distribution Rules | 9 | ATTYP | Distribution Type for the Posting Rule | nvarchar | 2 | 0 | | |
8 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 83 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPActual CostingMaterial Ledger |
9 | FCML_MAT | ML Characteristics for Material (Selection Criteria) | 29 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPAdditionals Management |
10 | WTADAB | Additionals: Documents | 54 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPAllocation |
11 | AUPO | Allocation Table Document Item | 61 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPAssortment |
12 | WRF_APC_PABD | Planned Article Basic Data | 12 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
13 | WRF_APC_PLAS | Purchasing List Assigned Quantities | 6 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
14 | WRF_APC_PLI | Purchasing List Items | 35 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
15 | WRF_APC_PLPOQ | Purchasing List Purchase Order Quantities | 8 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
16 | WRF_APC_WLPL | Worklist of Purchasing List Items for Follow-Up Processes | 5 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPClinical System |
17 | N2DLV_RECEIVER | i.s.h.med: Dispatch - Recipient | 7 | ATTYP | Address Type: Type (Key) | nvarchar | 10 | 0 | | |
18 | TN2DLV_ADTYP | i.s.h.med: Dispatch - Address Types | 3 | ATTYP | Address Type: Type (Key) | nvarchar | 10 | 0 | | |
19 | TN2DLV_ADTYP_T | i.s.h.med: Address Types (Text) | 3 | ATTYP | Address Type: Type (Key) | nvarchar | 10 | 0 | | |
20 | TN2DLV_RECART | i.s.h.med: Dispatch Control - Recipient Types | 4 | ATTYP | Address Type: Type (Key) | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
21 | MMARA | General material data | 83 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPData Collection |
22 | S117 | Receipt/article | 22 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
23 | S953 | BW Vorl.für BON/Artikel S117 | 22 | ATTYP | Materialtyp | nvarchar | 2 | 0 | | |
TOPDefense Forces and Public Security |
24 | /ISDFPS/ZEBAN | Copy of EBAN | 92 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPInventory Management |
25 | ISEG | Physical Inventory Document Items | 53 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
26 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 127 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
27 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 127 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
28 | WRF_STOCK_SITUAT | Stock Situation Table | 8 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPMaterial Master |
29 | MARA | General Material Data | 83 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
30 | MARA_TMP | File for Incorrect Data in Direct Input | 90 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
31 | MVRA | Cross-version fields for MARA | 83 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
32 | TWZLA | Splitting types for structured materials | 3 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
33 | WRF_DISCONT_POS | Worklist Items: Discontinuation for Seasonal Procurement | 13 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
34 | WSTN_AL_ALLOC | Prepack allocation planning lines | 7 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
35 | WSTN_AL_PTWAY | Prepack DC put away planning lines | 5 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPMaterials Management |
36 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 97 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPMerchandise and Assortment Planning |
37 | TWISPC_MARA | Retail Planning: Materials for Provisional Planning | 8 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPPerishables Procurement |
38 | FIP_D_ORDER_LINE | Order lines for FIP | 14 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPPrice Planning Workbench |
39 | WRF_PPW_WORKLERR | PPW Worklist Error Table | 30 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
40 | WRF_PPW_WORKLIST | PPW Worklist | 31 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPProcess Monitoring Infrastructure |
41 | SSPI_OV_ATT | SPI: Attributes of Component Overview | 5 | ATTYP | SPI: Attribute Data Type | tinyint | 3 | 0 | | |
TOPProduct Catalog |
42 | WLBM | Layout area item | 11 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPPromotion |
43 | WMFP | Markdown Planning - item data (materials) | 9 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPPurchasing |
44 | EBAN | Purchase Requisition | 92 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
45 | EKPO | Purchasing Document Item | 122 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
46 | MEREQX | Purchase Requisition Change Parameter | 92 | ATTYP | Updated information in related user data field | nvarchar | 1 | 0 | | |
47 | WDFR_POS | Perishables Planninng Item | 33 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
48 | WRF_POHF_POL | Order list | 28 | ATTYP | Material Category | nvarchar | 2 | 0 | | |
TOPSimulation |
49 | VSEBAN_CN | Version: Purchase requisition | 92 | ATTYP | Material Category | nvarchar | 2 | 0 | | |