SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9BSEG345Accounting Document Segment
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

147 columns | Print definition?ERP 6.0  | MTART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPLM/SWCONF_POSSW configs : relation POSTP <--> MTART2MTARTMaterial Typenvarchar40
2/SCRM/MTART_FILMaterial Type Filter2MTARTMaterial Typenvarchar40
3/SMD/MD_____00C3SID-Tabelle fuer Material Type3MTARTMaterial Typenvarchar40
4/SMD/MD_____00U0SID-Tabelle fuer MRP group4MTARTMRP Groupnvarchar40
5/SMERP/STG_MM001Data staging - Material master plant view complex table10MTARTMaterial Typenvarchar40
6/SMERP/STG_MM002Data staging - Material storage location view complex table10MTARTMaterial Typenvarchar40
7/SMERP/STG_MM003Data staging - Material UoM view complex table11MTARTMaterial Typenvarchar40
8/SMERP/STG_MM004Data staging - Material warehouse view complex table10MTARTMaterial Typenvarchar40
9/SMERP/STG_MM005Data staging - Material batch view complex table10MTARTMaterial Typenvarchar40
10CNV_20551_MATNRMaterial numbers scheduled for deletion5MTARTMaterial Typenvarchar40
11J_1UF_TAXDEC_SELSelections for tax declaration16MTARTMaterial Typenvarchar40
12MDG_BS_MAT_MTARTMDG: Pricing Auditing, Filter by Material Type2MTARTMaterial Typenvarchar40
13S610ES610 - Structural information3MTARTMaterial Typenvarchar40
14T064SStock Mngmt Levels for Inventory Sampling4MTARTMaterial Typenvarchar40
15T134WInitial Status of Batch3MTARTMaterial Typenvarchar40
16T258FCO-PA access control for Product Costing5MTARTMaterial Typenvarchar40
17T409Relationships between task list types and material types3MTARTMaterial Typenvarchar40
18T449USettings for Collective Display of MRP List54MTARTMaterial Typenvarchar40
19TAPOLAutomatic Allocation of Materials to LIFO Pools3MTARTMaterial Typenvarchar40
20TMVFUScope of Availability Check (Default Values)2MTARTMaterial Typenvarchar40
21TNIW5Lowest Value: Deval. by Rge of Coverage3MTARTMaterial Typenvarchar40
22TNIW6Lowest Value: Deval. for Reasons of Slow/Non-Movement3MTARTMaterial Typenvarchar40
23TPTMZItem Category Groups per Material Type2MTARTMaterial Typenvarchar40
24ZEIMMARAUSING FOR STORING EIM MARA DATAS10MTARTMaterial Typenvarchar40
25ZEIMT134TUSING FOR EIM T134T(Material Type Descriptions)3MTARTMaterial Typenvarchar40
26ZEIM_LIPSSD document: Delivery: Item data59MTARTMaterial Typenvarchar40
27ZGWPAM_INVENTORYGWPAM Demo Material Inventory10MTARTMaterial Typenvarchar40
28ZSMATMaterialschlüssel der Fluggesellschaften4MTARTMaterialartnvarchar40
TOPAccounting Interface
29GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)237MTARTMaterial Typenvarchar40
30GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)237MTARTMaterial Typenvarchar40
TOPActual CostingMaterial Ledger
31CKMLMV011Costing run: Object list7MTARTMaterial Typenvarchar40
32CKMLMV011FCosting Run: Filter Table for Object List7MTARTMaterial Typenvarchar40
33CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 91298423MTARTMaterial Typenvarchar40
34FCML_MATML Characteristics for Material (Selection Criteria)23MTARTMaterial Typenvarchar40
TOPAdditional Material Functions
35WSDT_MAT_LAYOUTCustomizing for Material Creation2MTARTMaterial Typenvarchar40
36WSDT_MAT_MTARTMaterial Type available in Material Creation2MTARTMaterial Typenvarchar40
37WSD_REF_MATERIALReference Materials2MTARTMaterial Typenvarchar40
TOPAdvertising Management
38JJTDIENIS-M/AM: Service6MTARTMaterial Typenvarchar40
TOPAgency Business Global Trade
39WBRPAgency business: Item26MTARTMaterial Typenvarchar40
TOPAssortment
40WRFT_APC_GENOperational APC: General Customizing11MTARTDefault Material Type (Operational APC)nvarchar40
41WRF_APC_PABDPlanned Article Basic Data3MTARTMaterial Typenvarchar40
TOPBalance Sheet Valuation Procedures
42TNIW5NLowest Value: Devaluation by Range of Coverage (w. Version)5MTARTMaterial Typenvarchar40
43TNIW5WLowest Value: Devaluatn by Range of Cov. for Each Val. Area3MTARTMaterial Typenvarchar40
44TNIW6NLowest Value: Devaluation by Slow/Non-Movement (w. Version)5MTARTMaterial Typenvarchar40
45TNIW6WLowest Value: Devaluation for Slow/Non-movement by Val.Area3MTARTMaterial Typenvarchar40
TOPBasis Components
46ZMATERIAL_IDESMaterial Master(IDES Demo)4MTARTMaterial Typenvarchar40
TOPBatches
47TCUDB_PRODUCTDocumentary Batch - Product (Material Type)2MTARTMaterial Typenvarchar40
TOPClinical System
48TN2MATKLASIS-H*MED: Classification of the Materials4MTARTMaterial Typenvarchar40
TOPConditions
49A043Purchasing Organization/Material Type5MTARTMaterial Typenvarchar40
TOPConstruction Equipment Management
50/SAPCEM/EMTLADMADefault Activity Type for Material3MTARTMaterial Typenvarchar40
51J_3GABRMTARTSettlement Indicator in CEM/MM per Material Type2MTARTMaterial Typenvarchar40
52J_3GBAMTARTAllowed Material Types per Document Type3MTARTMaterial Typenvarchar40
53J_3GBELAMAAssign Sale/Repurchase for Material Deliveries3MTARTMaterial Typenvarchar40
54J_3GERLMTARTAllowed Material Types2MTARTMaterial Typenvarchar40
55J_3GLAMTARTActivity Types per Material Type2MTARTMaterial Typenvarchar40
56J_3GMTARTCEM/MM Inventory Mgmt per Material Type and Recipient Type2MTARTMaterial Typenvarchar40
TOPCross-Application Components
57MMARAGeneral material data10MTARTMaterial Typenvarchar40
58YTSS_MTART_LEIHTSS: Materialarten ohne Bestellung2MTARTMaterialartnvarchar40
TOPData Collection
59S032Statistics: Current Stock and Grouping Terms11MTARTMaterial Typenvarchar40
60S039Statistics: Inventory Controlling13MTARTMaterial Typenvarchar40
61S039ES039 - Structural Information8MTARTMaterial Typenvarchar40
62S117Receipt/article23MTARTMaterial Typenvarchar40
63S610BC610 Example info structure8MTARTMaterial Typenvarchar40
64S953BW Vorl.für BON/Artikel S11723MTARTMaterialartnvarchar40
TOPData Retention Tool
65TXW_S_EKPORetrieve EKPO from archive13MTARTMaterial Typenvarchar40
66TXW_S_LIPSRetrieve LIPS from archive22MTARTMaterial Typenvarchar40
TOPDSD Connector
67/DSD/ME_MAT_TYPEDSD CN: Material Types3MTARTMaterial Typenvarchar40
TOPEmpties Management
68/BEV1/EMMTARTMaterial Types That Determine Empties2MTARTMaterial Typenvarchar40
TOPFinancial Accounting
69/CCEE/SIFIDDVEXMaterial types for Exclude2MTARTMaterial Typenvarchar40
70ACCTITCompressed Data from FI/CO Document96MTARTMaterial Typenvarchar40
TOPForeign Trade
71/SAPSLL/TBTCMR3GTS: BOM Transfer: Exclusion of Material Type - Country5MTARTMaterial Type for Global Trade Servicesnvarchar40
72/SAPSLL/TBTGMR3GTS: BOM Transfer: Exclusion of Material Type - Global4MTARTMaterial Type for Global Trade Servicesnvarchar40
73/SAPSLL/TBTPMR3GTS: BOM Transfer: Exclusion of Material Type - Plant6MTARTMaterial Type for Global Trade Servicesnvarchar40
TOPIndustry Solution Catch Weight Management
74/CWM/IDGT_MATTYAssign Material Types to UoM2MTARTMaterial Typenvarchar40
75/CWM/TAB_T134CWM Material Types2MTARTMaterial Typenvarchar40
TOPInterface to Terminal Automation System
76OIKTPIRDTPI: SD doc. - obsolete - but needed for XPRA ROIKXTPIREL12MTARTMaterial Typenvarchar40
77TOIKTRVLID TAS relevance determination11MTARTMaterial Typenvarchar40
TOPInventory Management
78MWXVM07MFields: Update Control of Module Pool SAPMM07M64MTARTMaterial Typenvarchar40
79MWZVM07MFields: Update Control of Module Pool SAPMM07M64MTARTMaterial Typenvarchar40
80SBSEStock Mngmt Levels for Inventory Sampling10MTARTMaterial Typenvarchar40
81T134MControl of Qty/Value Update3MTARTMaterial Typenvarchar40
TOPLocalization
82IDGT_UOM_CONVUoM Conversion2MTARTMaterial Typenvarchar40
TOPLogistics - General
83IVPH_MTARTPharma IView - material type table2MTARTMaterial Typenvarchar40
TOPLogistics Basic Data
84DMF_D_MTARTRelevant Article Types3MTARTMaterial Typenvarchar40
TOPMaintenance Orders
85/CUM/CUTYPECU: Compatible Unit Type5MTARTCU: Material Type for Compatible Unitsnvarchar40
86T418VItem category proposal for component assignment2MTARTMaterial Typenvarchar40
TOPMaster Data
87EWATSPCMPNTWASTEService Product Component - Waste4MTARTMaterial Typenvarchar40
88MDCOVTable with Range of Coverage Information9MTARTMaterial Typenvarchar40
89MDKPHeader Data for MRP Document20MTARTMaterial Typenvarchar40
90MDKPDBHeader Data for MRP Document21MTARTMaterial Typenvarchar40
91T438MControl Parameter for MRP -Material Level-3MTARTMRP Groupnvarchar40
92T444BSettings for Flexible Transaction Calls16MTARTCondition for material typenvarchar40
93TMW00MRP Default Values per Material Type2MTARTMaterial Typenvarchar40
94U444BUser Settings for Flexible Transaction Calls19MTARTCondition for material typenvarchar40
TOPMaterial Categories
95/ISDFPS/CMATNRPName Prefix for Automatically Generated Material Masters2MTARTMaterial Typenvarchar40
96/ISDFPS/CMTARTMaterial Types That Are Not Loaded as Models for MPO2MTARTMaterial Typenvarchar40
97/ISDFPS/CNODMARTAssignment of iPPE Node Types to Material Types3MTARTMaterial Typenvarchar40
TOPMaterial Master
98MARAGeneral Material Data10MTARTMaterial Typenvarchar40
99MARA_TMPFile for Incorrect Data in Direct Input17MTARTMaterial Typenvarchar40
100MOFFOutstanding Material Master Records13MTARTMaterial Typenvarchar40
101MVRACross-version fields for MARA10MTARTMaterial Typenvarchar40
102T134Material Types2MTARTMaterial Typenvarchar40
103T134KConfigurable Material Types3MTARTMaterial Typenvarchar40
104T134TMaterial Type Descriptions3MTARTMaterial Typenvarchar40
105USRM3Material Master User Settings: Retail Organizational Levels4MTARTMaterial Typenvarchar40
106WRF_DISCONT_POSWorklist Items: Discontinuation for Seasonal Procurement10MTARTMaterial Typenvarchar40
TOPMaterials Management
107J_1GVL_WHB003Valid Materials2MTARTMaterial Typenvarchar40
108J_1GVL_WHB013Analytical ledger material postings after valuation5MTARTMaterial Typenvarchar40
TOPMedia Product
109TJPMATTYPLEVELIS-M: Assignment of Material Type to Hierarchy Level2MTARTMaterial Typenvarchar40
110TJPMATTYPSYNCHROIS-M: Material Type Relevant for Product Synchronization2MTARTMaterial Typenvarchar40
111TJP_VAL_DATAValuation Template for Unit Costs Transfer2MTARTMaterial Typenvarchar40
TOPMedia Product Sales and Distribution
112JVSDT134MIXIS-M: Cross-Plant Mix for Material Type2MTARTMaterial Typenvarchar40
113TJKSDSTATHORIZONIS-M: Horizon for Calculating Statistical Key Figures2MTARTMaterial Typenvarchar40
114TJVSD134WInitial Status of Batch3MTARTMaterial Typenvarchar40
TOPMerchandise and Assortment Planning
115TWISPC_MARARetail Planning: Materials for Provisional Planning24MTARTMaterial Typenvarchar40
TOPNetWeaver Enterprise Search
116ESH_TST_EMP2MARTES Test Object Employee to MTART Mapping4MTARTMaterial Typenvarchar40
117ESH_TST_MATES Test Object Material - Main Data5MTARTMaterial Typenvarchar40
118ESH_TST_T134Test Object Material Type and Authorization Group3MTARTMaterial Typenvarchar40
TOPPatient Accounting
119TNM04IS-H MM: Determine Materials for CO Reposting4MTARTMaterial Typenvarchar40
TOPPersonnel Administration
120T5H3GAssign material type and class to material group3MTARTMaterial typenvarchar40
TOPProduct Cost Planning
121KALMCosting Run: Costing Objects69MTARTMaterial Typenvarchar40
122KALOCosting Run: Costing Objects (KVMK)64MTARTMaterial Typenvarchar40
TOPProfit Center Accounting
123KE1_WU_MATPCA Where-Used List: Material8MTARTMaterial Typenvarchar40
124T8A00Account Determination for Profit Center Accounting3MTARTMaterial Typenvarchar40
TOPProfitability Analysis
125TKEVA03MCosting Key for Material Type6MTARTMaterial Typenvarchar40
TOPPurchasing
126EKPOPurchasing Document Item152MTARTMaterial Typenvarchar40
127T024W_CCPPlant/Supplying Plant Assignment for Extended Source Determ.5MTARTMaterial Typenvarchar40
TOPR2-R3 Link
128LDK05Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master10MTARTMaterial Typenvarchar40
TOPRecycling Administration Core Functions
129J_7LC05REA Data Filter: Material Types3MTARTMaterial Typenvarchar40
130J_7LC29REA Data Filter: Packaging Material Type3MTARTMaterial Typenvarchar40
131J_7LV1PREA Document: Item Data63MTARTMaterial Typenvarchar40
TOPRemaining Beverage - Obsolete Objects
132/BEV3/CHCIMATARTCI: Material Type CH3MTARTMaterial Typenvarchar40
TOPSales Plan
133RMCP8Archive Materials4MTARTMaterial Typenvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
134NWCHGALDATIS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat)4MTARTTipo di materialenvarchar40
TOPShipping
135DVM01R/2-R/3 Link: R/3 Input Data for Material Master12MTARTMaterial Typenvarchar40
136LIPSSD document: Delivery: Item data59MTARTMaterial Typenvarchar40
TOPSoftware Management
137KOTG402IS-SW Product List Exclusion4MTARTMaterial Typenvarchar40
138TPGACGG enhancement: Material types representing Product Groups2MTARTMaterial Typenvarchar40
TOPTariffs, Duties and Permits
139OIH40Excise Duty defaulting table GI/GR for production orders5MTARTMaterial Typenvarchar40
TOPTraders and Schedulers Workbench
140TOI0_REL_MMRelevance customizing for MM Documents17MTARTMaterial Typenvarchar40
141TOI0_REL_SDIS-OIL: Relevance customizing for SD Documents14MTARTMaterial Typenvarchar40
142TOI0_REL_TCTSW relevance table for trading contract18MTARTMaterial Typenvarchar40
TOPWaste Management
143EHSWAC_EAIMMCATWaste-Relevant Material Types2MTARTMaterial Typenvarchar40
144TEEWA_BULK_CUSTZBulk Refuse Order Types5MTARTMaterial Typenvarchar40
145TEWABEHGRPSDAllocation of Group Types to Material Types3MTARTMaterial Typenvarchar40
146TEWAIBASESDAllocation of IBASE Categories to Material Types3MTARTMaterial Typenvarchar40
147TEWA_EL_006Allocation: Material Types --> Waste2MTARTMaterial Typenvarchar40