| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /OPT/VIM_1ITEM_S | Document Item | 8 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 2 | /OPT/VIM_TITEM | Document Item | 8 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 3 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 198 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 4 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 198 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 5 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 199 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 6 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 198 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 7 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 198 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 8 | CNV_20551_MATNR | Material numbers scheduled for deletion | 8 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 9 | FSH_XREF_T | Product Descriptions | 4 | MAKTX | Character String 60 | nvarchar | 60 | 0 | | |
| 10 | IDGT_GTDI | GT Document Item | 5 | MAKTX | Material Description | nvarchar | 60 | 0 | | |
| 11 | IDGT_VATI | VAT Invoice Item | 7 | MAKTX | Material Description | nvarchar | 60 | 0 | | |
| 12 | J1IEX_LICUTL_LOG | EXIM : License Detail | 13 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 13 | J_1I_LICDTL | EXIM : License Detail | 13 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 14 | REFXCN_MATIL | Material data | 4 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 15 | YVIM_1ITEM | Document Item | 8 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 16 | ZDT_MATINFO | Material Information | 3 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 17 | ZEIMMAKT | USING FOR EIM MAKT DATA | 4 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 18 | ZGWPAM_INVENTORY | GWPAM Demo Material Inventory | 9 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 19 | ZST_MAKT | Material Descriptions | 4 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPAdditionals Management |
| 20 | WRF_WTAD_AD_WL | Additionals: Temporary Storage of Work Data | 5 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPAerospace Defence Industry Solution |
| 21 | ORFCALC | Data Record ORF Calculation, ATTENTION: MOVE-CORR! | 33 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPAllocation |
| 22 | AUPO | Allocation Table Document Item | 21 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPBasic Functions |
| 23 | MMPREF_PRO_02 | Log table - Main component - Information | 7 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 24 | MMPREK_PRO_02 | Log table - Main component - Information | 10 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 25 | MMPREW_PRO_02 | Preference CPG: Log main component - Information | 9 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPBasis Components |
| 26 | ZMATERIAL_IDES | Material Master(IDES Demo) | 3 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPCross-Application Components |
| 27 | YTSS_MACOST | TSS: Zuordnung Material - Kostenstelle | 4 | MAKTX | Materialkurztext | nvarchar | 40 | 0 | | |
| TOPData Collection |
| 28 | S117 | Receipt/article | 28 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 29 | S953 | BW Vorl.für BON/Artikel S117 | 28 | MAKTX | Materialkurztext | nvarchar | 40 | 0 | | |
| TOPFinancial Accounting |
| 30 | /OPT/VIM_1ITEM | Document Item | 8 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPInventory Management |
| 31 | MWZDM07M1 | ZDM07M1 | 11 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPLocalization |
| 32 | IDGT_INFO | GTI China: Data sent to GT | 29 | MAKTX | Material Description | nvarchar | 60 | 0 | | |
| 33 | J_1BNFLIN | Nota Fiscal line items | 9 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 34 | J_1IEXCDTL | Excise invoice line item details | 17 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 35 | J_1ILICDTL | Excise Bonding: License detail | 6 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 36 | J_1IPART1 | Excise part I detials | 17 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 37 | J_1IQRDEP | Quarterly Returns Depot structure | 19 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 38 | J_1IRG1 | Excise RG1 details | 15 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 39 | J_1IRG23D | RG23D register for the depot | 24 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 40 | J_1ITCJCUPDATE | Updatation table for open documents | 9 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 41 | J_3RSEXTRACTD | Exctract details (obsolete) | 57 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPLogistics - General |
| 42 | HBSFSP | Help dummy table | 15 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPMain Process |
| 43 | /VSO/M_I_DLY_ITM | Input Data: Delivery Items (Vehicle Space Optimization) | 6 | MAKTX | Material Short Text (Vehicle Space Optimization) | nvarchar | 40 | 0 | | |
| TOPMaintenance Orders |
| 44 | /MRSS/D_REPL_CAR | Vehicle Data | 7 | MAKTX | Description of Vehicle Model | nvarchar | 40 | 0 | | |
| TOPManufacturer Part Number |
| 45 | ADPIC_HOLD_MIGO | Store BADI goitem for MIGO hold / restore functionality | 12 | MAKTX | Material Short Text with Field Label 'Material' | nvarchar | 40 | 0 | | |
| TOPMaster Data |
| 46 | MDCOV | Table with Range of Coverage Information | 6 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPMaterial Master |
| 47 | MAKT | Material Descriptions | 4 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 48 | MAKT_TMP | File for Incorrect Data in Direct Input | 7 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 49 | MVKT | Material descriptions | 4 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 50 | WSTN_PP_DESC | Prepack definition - Description table | 4 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPMedia Product Sales and Distribution |
| 51 | JPTMG0 | IS-M: Media Product Issue Sequence | 15 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPNetwork Operations |
| 52 | GHO_PP_PTABLE_IT | Item Table for Results of GHO Planning Table | 9 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPPurchasing |
| 53 | WDFR1 | Requirements Planning for Perishables | 7 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 54 | WDFR_POS | Perishables Planninng Item | 31 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPR2-R3 Link |
| 55 | LDK05 | Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master | 13 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPRecycling Administration Core Functions |
| 56 | J_7LV01T | REA Packaging Master: Short Texts | 5 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 57 | J_7LV2K | REA Assortment Declaration Declar. Objects: Header | 14 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPRepetitive Manufacturing |
| 58 | RMIO | Input Structure of Repetitive Manufacturing Confirmation | 39 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPSales and Distribution |
| 59 | J_1USEXTRACTD | EXTRACTD | 57 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 60 | J_1USEXTRACTD_MM | EXTRACTD_MM | 12 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPService Station Retailing |
| 61 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 141 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 62 | OIRC_MRREJ | SSR Meters - Meter readings rejected records | 73 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 63 | OIRC_PRLOG_DIF | SSR Pricing - Price update differences | 5 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPShipping |
| 64 | DVM01 | R/2-R/3 Link: R/3 Input Data for Material Master | 15 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPStructures Workbench |
| 65 | /ISDFPS/FDP_WFST | Workflow Status for Cross-System Material Requisitions | 25 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPUnique Identification |
| 66 | IUID_MAN_DATA | Manually Maintained Values for IUID Messages | 9 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| 67 | IUID_PEDIGREE | UII IDoc Message Data for Supporting Supplier Collaboration | 9 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPWarehouse Management |
| 68 | LTAP | Transfer order item | 89 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
| TOPWaste Management |
| 69 | EWA_ROUTE_BULK | Bulk Refuse Objects for Route | 5 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | |
