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

79 columns | Print definition?ERP 6.0  | LFMON

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table393LFMONCurrent period (posting period)nvarchar20
2/SMERP/STG_MM002Data staging - Material storage location view complex table204LFMONCurrent period (posting period)nvarchar20
TOPBatches
3WBEWActive Ingredient Valuation31LFMONCurrent period (posting period)nvarchar20
TOPCross-Application Components
4MMARCPlant Data for Material197LFMONCurrent period (posting period)nvarchar20
TOPHydrocarbon Product Management
5MARCHO1MARCH: Additional quantities appendix5LFMONCurrent period (posting period)nvarchar20
6MARDHO1MARDH: Aditional quantities appendix6LFMONCurrent period (posting period)nvarchar20
7MCHBHO1MCHBH: Additional quantities appendix7LFMONCurrent period (posting period)nvarchar20
8MKOLHO1MKOLH: Additional quantities appendix9LFMONCurrent period (posting period)nvarchar20
9MSKAHO1MSKAH: Additional quantities appendix10LFMONCurrent period (posting period)nvarchar20
10MSKUHO1MSKUH: Additional quantities appendix8LFMONCurrent period (posting period)nvarchar20
11MSLBHO1MSLB: Additional quantities appendix8LFMONCurrent period (posting period)nvarchar20
12MSPRHO1MSPRH: Additional quantities appendix9LFMONCurrent period (posting period)nvarchar20
13MSPRO1Project Stock additional quantities10LFMONCurrent period (posting period)nvarchar20
TOPInventory Management
14MMINKON_UPCorrections due to Technical Problems with Stock19LFMONCurrent period (posting period)nvarchar20
15MSTBStock in Transit8LFMONCurrent period (posting period)nvarchar20
16MSTBHStock in Transit - History8LFMONCurrent period (posting period)nvarchar20
17MSTEStock in Transit to Sales and Distribution Document10LFMONCurrent period (posting period)nvarchar20
18MSTEHSiT to Sales and Distribution Document - History10LFMONCurrent period (posting period)nvarchar20
19MSTQStock in Transit for Project9LFMONCurrent period (posting period)nvarchar20
20MSTQHStock in Transit for Project - History9LFMONCurrent period (posting period)nvarchar20
21MWXVM07MFields: Update Control of Module Pool SAPMM07M30LFMONCurrent period (posting period)nvarchar20
22MWZVM07MFields: Update Control of Module Pool SAPMM07M30LFMONCurrent period (posting period)nvarchar20
TOPMaterial Master
23EBEWSales Order Stock Valuation33LFMONCurrent period (posting period)nvarchar20
24EBEWHValuation of Sales Order Stock: History9LFMONCurrent period (posting period)nvarchar20
25MARCPlant Data for Material197LFMONCurrent period (posting period)nvarchar20
26MARCHMaterial Master C Segment: History5LFMONCurrent period (posting period)nvarchar20
27MARC_TMPFile for Incorrect Data in Direct Input200LFMONCurrent period (posting period)nvarchar20
28MARDStorage Location Data for Material8LFMONCurrent period (posting period)nvarchar20
29MARDHMaterial Master Storage Location Segment: History6LFMONCurrent period (posting period)nvarchar20
30MARD_TMPFile for Incorrect Data in Direct Input11LFMONCurrent period (posting period)nvarchar20
31MARVMaterial Control Record4LFMONCurrent period (posting period)nvarchar20
32MARVCDChange Document: Period Initialization when System in Op.10LFMONCurrent period (posting period)nvarchar20
33MBEWMaterial Valuation31LFMONCurrent period (posting period)nvarchar20
34MBEWHMaterial Valuation: History6LFMONCurrent period (posting period)nvarchar20
35MBEW_TMPFile for Incorrect Data in Direct Input34LFMONCurrent period (posting period)nvarchar20
36MCHBBatch Stocks12LFMONCurrent period (posting period)nvarchar20
37MCHBHBatch Stocks: History7LFMONCurrent period (posting period)nvarchar20
38MKOLSpecial Stocks from Vendor14LFMONCurrent period (posting period)nvarchar20
39MKOLHSpecial Stocks from Vendor: History9LFMONCurrent period (posting period)nvarchar20
40MSCASales Orders on Hand with Vendor10LFMONCurrent period (posting period)nvarchar20
41MSCAHSales Order Stock at Vendor: History10LFMONCurrent period (posting period)nvarchar20
42MSKASales Order Stock10LFMONCurrent period (posting period)nvarchar20
43MSKAHSales Order Stock: History10LFMONCurrent period (posting period)nvarchar20
44MSKUSpecial Stocks with Customer8LFMONCurrent period (posting period)nvarchar20
45MSKUHSpecial Stocks at Customer: History8LFMONCurrent period (posting period)nvarchar20
46MSLBSpecial Stocks with Vendor8LFMONCurrent period (posting period)nvarchar20
47MSLBHSpecial Stocks at Vendor: History8LFMONCurrent period (posting period)nvarchar20
48MSOATotal Sales Orders on Hand with Vendor9LFMONCurrent period (posting period)nvarchar20
49MSPRProject Stock9LFMONCurrent period (posting period)nvarchar20
50MSPRHProject Stock: History9LFMONCurrent period (posting period)nvarchar20
51MSSATotal Customer Orders on Hand8LFMONCurrent period (posting period)nvarchar20
52MSSAHTotal Sales Order Stocks: History8LFMONCurrent period (posting period)nvarchar20
53MSSLTotal Special Stocks with Vendor7LFMONCurrent period (posting period)nvarchar20
54MSSQProject Stock Total7LFMONCurrent period (posting period)nvarchar20
55MSSQHTotal Project Stocks: History7LFMONCurrent period (posting period)nvarchar20
56MVEWMaterial Valuation31LFMONCurrent period (posting period)nvarchar20
57MVEWHMaterial Valuation: History6LFMONCurrent period (posting period)nvarchar20
58MVRCCross-version fields for MARC197LFMONCurrent period (posting period)nvarchar20
59MVRDStorage Location Data for Material8LFMONCurrent period (posting period)nvarchar20
60OBEWValuated Stock with Subcontractor32LFMONCurrent period (posting period)nvarchar20
61OBEWHValuated Stock with Subcontractor: History8LFMONCurrent period (posting period)nvarchar20
62QBEWProject Stock Valuation32LFMONCurrent period (posting period)nvarchar20
63QBEWHValuation of Project Stock: History8LFMONCurrent period (posting period)nvarchar20
TOPSpare Part Sharing and Stock Providede by Customer
64MCSDCustomer Stock10LFMONCurrent period (posting period)nvarchar20
65MCSDHCustomer Stock: History9LFMONCurrent period (posting period)nvarchar20
66MCSSTotal Customer Stock8LFMONCurrent period (posting period)nvarchar20
67MCSSHKundenbeistellbestand - Historie - Summe7LFMONCurrent period (posting period)nvarchar20
68MSCDCustomer stock with vendor9LFMONCurrent period (posting period)nvarchar20
69MSCDHCustomer stock with vendor - History9LFMONCurrent period (posting period)nvarchar20
70MSCSCustomer stock with vendor - Total8LFMONCurrent period (posting period)nvarchar20
71MSFDSales Order Stock with Vendor10LFMONCurrent period (posting period)nvarchar20
72MSFDHSales Order Stock at Vendor: History10LFMONCurrent period (posting period)nvarchar20
73MSFSSales Order Stock with Vendor - Total9LFMONCurrent period (posting period)nvarchar20
74MSIDVendor Stock with Vendor9LFMONCurrent period (posting period)nvarchar20
75MSIDHVendor Stock with Vendor - History9LFMONCurrent period (posting period)nvarchar20
76MSISVendor Stock with Vendor - Total8LFMONCurrent period (posting period)nvarchar20
77MSRDProject Stock with Vendor9LFMONCurrent period (posting period)nvarchar20
78MSRDHProject Stock with Vendor - History9LFMONCurrent period (posting period)nvarchar20
79MSRSProject Stock with Vendor - Total8LFMONCurrent period (posting period)nvarchar20