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

39 columns | Print definition?ERP 6.0  | VOLUME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAssetLiability Management
1JBAPLANPARLZBALM Assignment of Planning Parameters to Planning Variant15VOLUMETransaction Volumedecimal172
2JBASIMLZBSAVEALM: Maturity-Band-Dependent Parameters14VOLUMETransaction Volumedecimal172
TOPBilling in Contract Accounts Receivable and Payable
3DFKKBIEDRRJZ01Test Data: Provisionally Rejected EDRs fr. Cat. ZTCSERVICE13VOLUMEFuel Quantity in Litersdecimal52
4DFKKBIEDRWOZ01Test Data: Permanently Rejected EDRs fr. Category ZTCSERVICE13VOLUMEFuel Quantity in Litersdecimal52
5DFKKBIEDRZ01Test Data: EDRs with Additional Services for Toll Billing15VOLUMEFuel Quantity in Litersdecimal52
TOPCCMS Database Monitors for Oracle
6DBABDInformation About the Data Files (Oracle)18VOLUMEName of backup volumenvarchar100
7DBABLInformation About Archive Log Files (Oracle)17VOLUMEName of backup volumenvarchar100
TOPCentral Part of Product Master
8COMM_PR_UNITProduct Unit of Measurement10VOLUMEVolume Occupied by the Product per Volume Unitdecimal133
9COMM_PR_UNITHProduct Unit of Measurement History11VOLUMEVolume Occupied by the Product per Volume Unitdecimal133
TOPClinical System
10TN1MEUNITIS-H*MED: Medication - Units for Orders7VOLUMEMedication: Volume Unit Indicatornvarchar10
TOPDB2 for OS39
11DB2CCDL_OUTTSDSNACCDL: History of output table4VOLUMESerial number of the volumenvarchar60
TOPDSD Connector
12/DSD/ME_MAT_HDDSD CN: Material Data for Downloading to HH15VOLUMEDSD Connector: Volumedecimal133
TOPElectronic Data Interchange
13PRICAT_K004PRICAT:Cat. item units of measure, dimensions, weights,EANs39VOLUMEVolumedecimal133
14PRICAT_K004_PROIndication of Data to be Adopted from PRICAT_K00428VOLUMEIndicator for copying catalog datanvarchar10
TOPGlobal Trade Services
15/SAPSLL/PRLegal & Logistics Services: Product Master11VOLUMEDimension as Floating Point Fieldfloat1516
16/SAPSLL/PRUOMLegal & Logistics Services: Product Master - Units16VOLUMEDimension as Floating Point Fieldfloat1516
TOPIndustrial Hygiene and Safety
17CCIHT_MJEHS: Measurement57VOLUMETotal Volume in Litersfloat1516
18CCIHT_MJIMPORTEHS: Pooled Table for Imported Measurements57VOLUMETotal Volume in Litersfloat1516
TOPJoint Venture und Production Sharing Accounting
19T8PSA_ADJUST_VOLAdjustment Volumes9VOLUMEPSA Production Volumedecimal153
20T8PSA_LIFT_TERMLifting Volumes by terminal11VOLUMEPSA Production Volumedecimal153
21T8PSA_LIFT_VOLLifting Volumes17VOLUMEPSA Production Volumedecimal153
22T8PSA_PROD_VOLProduction Volumes9VOLUMEPSA Production Volumedecimal153
23T8PSC_ADJUSTPSC Adjustment Data9VOLUMEPSC Production Volumedecimal153
24T8PSC_LIFTPSC Lifting Data15VOLUMEPSC Production Volumedecimal153
25T8PSC_PRODPSC Production Data9VOLUMEPSC Production Volumedecimal153
TOPNetWeaver Enterprise Search
26ESH_QL_AREGXFollow-Up Action Cluster4VOLUMEFollow-Up Action Content Volumeint100
27ESH_QL_QLOGQQuery Log: Query Contents4VOLUMEQuery Log Content Volumeint100
TOPOwnership
28GHO_OWNRES_IOwnership results items8VOLUMEQnty Measured/Planned Against Node: Vol,Mass,Energy-FLTPfloat1516
TOPProduction Allocation
29GHO_ALLOCRES_IAllocation results Item9VOLUMEQnty Measured/Planned Against Node: Vol,Mass,Energy-FLTPfloat1516
30GHO_ALLOCRES_IFAllocation results Item with Final Indicator9VOLUMEQnty Measured/Planned Against Node: Vol,Mass,Energy-FLTPfloat1516
31GHO_ALLOC_FIN_IOBSOLETE - Table to store final itemized allocation results7VOLUMEQnty Measured/Planned Against Node: Vol,Mass,Energy-FLTPfloat1516
32GHO_ALLOC_FIN_PPTable to hold PP related final allocation results10VOLUMEQnty Measured/Planned Against Node: Vol,Mass,Energy-FLTPfloat1516
33GHO_ALLOC_RES_IOBSOLETE - Table to store the itemized allocation results7VOLUMEQnty Measured/Planned Against Node: Vol,Mass,Energy-FLTPfloat1516
34GHO_ALLOC_RES_PPTable to hold PP related allocation results10VOLUMEQnty Measured/Planned Against Node: Vol,Mass,Energy-FLTPfloat1516
TOPReal Estate
35CMS_RE_OBJ_SPCSpace Details to describe a real estate object14VOLUMEVolume of Real Estate Objectdecimal133
TOPShip
36CMS_SHPDescription of a Ship - Master Table37VOLUMEVolume of Shipdecimal133
TOPWaste Management
37EWA_ORDER_WEIGHWeighing Data for Waste Disposal Order24VOLUMEWaste volumedecimal133
38EWA_WA_WEIGHOFFLOffline Weighing46VOLUMEWaste volumedecimal133
39EWA_WA_WEIGHPROCWeighing Transaction25VOLUMEWaste volumedecimal133