SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

90 columns | Print definition?ERP 6.0  | LVORM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table201LVORMFlag Material for Deletion at Plant Levelnvarchar10
2/SMERP/STG_MM002Data staging - Material storage location view complex table202LVORMFlag Material for Deletion at Storage Location Levelnvarchar10
3/SMERP/STG_MM003Data staging - Material UoM view complex table200LVORMDeletion Indicatornvarchar10
4/SMERP/STG_MM004Data staging - Material warehouse view complex table200LVORMDeletion flag for all material data of a warehouse numbernvarchar10
5/SMERP/STG_MM005Data staging - Material batch view complex table201LVORMDeletion Indicatornvarchar10
6/SMERP/STG_PM001Data staging - Equipment complex table17LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
7/SMERP/STG_PM002Data staging - Functional Location complex table22LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
8/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab17LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
9/SMERP/STG_PM004Data staging - Equipment list set - Measuring Points23LVORMDeletion Flag for 2-Level Deletion Logicnvarchar10
10/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab22LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
11/SMERP/STG_PM009Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab23LVORMDeletion Flag for 2-Level Deletion Logicnvarchar10
12CNV_20551_MATNRMaterial numbers scheduled for deletion4LVORMDeletion Indicatornvarchar10
13SGT_MLGNSegmentation dependent Material Data for Each Warehouse no5LVORMDeletion flag for all material data of a warehouse numbernvarchar10
14SGT_MLGTSegmentation dependent Material Data for Each Storage Type6LVORMDeletion flag for all material data of a storage typenvarchar10
15ZEIMMARAUSING FOR STORING EIM MARA DATAS9LVORMFlag Material for Deletion at Client Levelnvarchar10
TOPAssortment Maintenance
16WSOFModule Assignment (SAP Retail) to Plants8LVORMDeletion indicator IS-R tablesnvarchar10
17WSOHAssortment Modules SAP Retail6LVORMDeletion indicator IS-R tablesnvarchar10
18WSOPModules SAP Retail / Item Data6LVORMDeletion indicator IS-R tablesnvarchar10
TOPCATT Computer Aided Test Tool
19CATACATT: General Test Procedure Data16LVORMCATT - Delete flagnvarchar10
TOPConstruction Equipment Management
20J_3GSTLKOPFHeader Data for Equipment BOMs13LVORMDeletion Indicatornvarchar10
TOPCross-Application Components
21CCRHDWork Center Header17LVORMDeletion flag for work centernvarchar10
22MMARAGeneral material data9LVORMFlag Material for Deletion at Client Levelnvarchar10
23MMARCPlant Data for Material5LVORMFlag Material for Deletion at Plant Levelnvarchar10
TOPEngineering Change Management
24AENRChange Master21LVORMDeletion Flag for Change Number (Reorganization)nvarchar10
25ECM_ORDChange Order7LVORMDeletion Indicatornvarchar10
26ECM_REQData for Engineering Change Request7LVORMDeletion Indicatornvarchar10
27ECM_TSKChange Task7LVORMDeletion Indicatornvarchar10
TOPEquipment
28EQUIEquipment master data11LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
29EQUZEquipment time segment14LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
30IEQT_WL_ITEMSInterim Statuses - Items32LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
31IEQT_WL_ITM_BACInterim Statuses - Items (Backup)33LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
TOPExchanges
32OIA02Exchange item data - sales side6LVORMDeletion Indicatornvarchar10
33OIA03Exchange item data - purchasing side7LVORMDeletion Indicatornvarchar10
34OIA05HQuantity schedule header table - sales side7LVORMDeletion Indicatornvarchar10
35OIA06HQuantity schedule header table - purchasing side7LVORMDeletion Indicatornvarchar10
TOPExternal Services
36ASMDService Master: Basic Data7LVORMDeletion Indicatornvarchar10
TOPFinancial Accounting
37ACCRBDAccruals/Deferrals Master Data - Basic Data9LVORMDeletion Indicatornvarchar10
TOPFunctional Locations
38IFLOTFunctional Location (Table)16LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
39IFLOT_VSFunctional Location (Version Table)17LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
40IRLOTReference Functional Location (Table)12LVORMSAP Development Reserve: Format CHAR, Length 1nvarchar10
TOPInventory Management
41SLGHElements of Stock Population11LVORMDeletion Indicatornvarchar10
TOPMaintenance Task Lists
42MPLAMaintenance plan16LVORMIndicator: maintenance plan locked against callsnvarchar10
TOPMaterial Master
43MARAGeneral Material Data9LVORMFlag Material for Deletion at Client Levelnvarchar10
44MARA_TMPFile for Incorrect Data in Direct Input16LVORMFlag Material for Deletion at Client Levelnvarchar10
45MARCPlant Data for Material5LVORMFlag Material for Deletion at Plant Levelnvarchar10
46MARC_TMPFile for Incorrect Data in Direct Input8LVORMFlag Material for Deletion at Plant Levelnvarchar10
47MARDStorage Location Data for Material6LVORMFlag Material for Deletion at Storage Location Levelnvarchar10
48MARD_TMPFile for Incorrect Data in Direct Input9LVORMFlag Material for Deletion at Storage Location Levelnvarchar10
49MBEWMaterial Valuation5LVORMDeletion flag for all material data of a valuation typenvarchar10
50MBEW_TMPFile for Incorrect Data in Direct Input8LVORMDeletion flag for all material data of a valuation typenvarchar10
51MBPRStock at Production Storage Bin6LVORMDeletion Indicatornvarchar10
52MCH1Batches (if Batch Management Cross-Plant)4LVORMDeletion Flag for All Data in a Batchnvarchar10
53MCHABatches5LVORMDeletion Flag for All Data on a Batch at a Plantnvarchar10
54MCHBBatch Stocks6LVORMDeletion Flag for All Data on a Batch Stocknvarchar10
55MEIKMake-to-Order Stock for Customer Order9LVORMDeletion Indicatornvarchar10
56MGVTYPETable of version categories9LVORMDeletion indicatornvarchar10
57MGVTYPE_WRKTable of version categories9LVORMDeletion indicatornvarchar10
58MKLKConsignment Stocks and Returnable Packaging with Customer7LVORMDeletion Indicatornvarchar10
59MKOLSpecial Stocks from Vendor8LVORMDeletion Flag for All Data on a Consignment Stocknvarchar10
60MKOPConsignment Price Segment5LVORMDeletion Flag for All Data on a Consignment Materialnvarchar10
61MKUBMaterial Provided by Customer7LVORMDeletion Indicatornvarchar10
62MLGNMaterial Data for Each Warehouse Number4LVORMDeletion flag for all material data of a warehouse numbernvarchar10
63MLGN_TMPFile for Incorrect Data in Direct Input7LVORMDeletion flag for all material data of a warehouse numbernvarchar10
64MLGTMaterial Data for Each Storage Type5LVORMDeletion flag for all material data of a storage typenvarchar10
65MLGT_TMPFile for Incorrect Data in Direct Input8LVORMDeletion flag for all material data of a storage typenvarchar10
66MLIBMaterial Provided to Vendor6LVORMDeletion Indicatornvarchar10
67MVEWMaterial Valuation5LVORMDeletion flag for all material data of a valuation typenvarchar10
68MVGNMaterial Data for Each Warehouse Number4LVORMDeletion flag for all material data of a warehouse numbernvarchar10
69MVGTMaterial Data for Each Storage Type5LVORMDeletion flag for all material data of a storage typenvarchar10
70MVKESales Data for Material5LVORMInd.: Flag material for deletion at distribution chain levelnvarchar10
71MVKE_TMPFile for Incorrect Data in Direct Input8LVORMInd.: Flag material for deletion at distribution chain levelnvarchar10
72MVRACross-version fields for MARA9LVORMFlag Material for Deletion at Client Levelnvarchar10
73MVRCCross-version fields for MARC5LVORMFlag Material for Deletion at Plant Levelnvarchar10
74MVRDStorage Location Data for Material6LVORMFlag Material for Deletion at Storage Location Levelnvarchar10
75MVVESales Data for Material5LVORMInd.: Flag material for deletion at distribution chain levelnvarchar10
76WRF_DISCONT_HDRWorklist for Discontinuation for Seasonal Procurement12LVORMSet Deletion Flagsnvarchar10
TOPMeasuring Points and Counters
77IMPTTMeasuring Point (Table)17LVORMDeletion Flag for 2-Level Deletion Logicnvarchar10
78IMRGMeasurement Document17LVORMDeletion Flag for 1-Level Deletion Logicnvarchar10
TOPNetwork Modeler
79GHO_SIM_INETObject Links for Network Simulation27LVORMDeletion Indicatornvarchar10
TOPObject Networking
80INETObject networking26LVORMDeletion Indicatornvarchar10
81T372INetwork identification5LVORMDeletion Indicatornvarchar10
TOPPermits
82IHSGObject-Related Permits in Plant Maintenance24LVORMDeletion Indicatornvarchar10
TOPProduction Allocation
83GHO_INET_LOGChange log table for INET - productive networks28LVORMDeletion Indicatornvarchar10
84GHO_SIMU_INETLOGLog table for simulation changes in production network28LVORMDeletion Indicatornvarchar10
TOPTechnical Objects
85EAML_D_EVTEAML: Events DB Table3LVORMDeletion Indicatornvarchar10
TOPWarranties
86BGMKMaster Warranty Header15LVORMDeletion Indicatornvarchar10
87BGMKOBJMaster Warranty - Object Assignment9LVORMDeletion Indicatornvarchar10
88BGMPMaster Warranty Item19LVORMDeletion Indicatornvarchar10
TOPWaste Management
89EWATDEVLOCProvisional Container/Container Location Allocation14LVORMDeletion Indicatornvarchar10
TOPWork Center
90CRHDWork Center Header17LVORMDeletion flag for work centernvarchar10