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

44 columns | Print definition?ERP 6.0  | DIMENSION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMSBW_NRDIMNumber range table for DIMID4DIMENSION30 Charactersnvarchar300
2GHO_MEAS_MEDIUMMeasurements mapped with mediums3DIMENSIONDimension keynvarchar60
3J_1I_PM_DOCDTLEXIM : Process Management Documents Detail Data55DIMENSIONDimensionnvarchar200
4MEP_ATTR_MAPPINGME Provider Attribute Mapping2DIMENSIONME Boost Dimensionnvarchar200
5MEP_BOOST_OINSTME Object Instance Boost3DIMENSIONME Boost Dimensionnvarchar200
6MEP_BOOST_OTYPEME Object Type Boost3DIMENSIONME Boost Dimensionnvarchar200
7MEP_PROV_REGME Provider Registry2DIMENSIONME Boost Dimensionnvarchar200
8MEP_PROV_UPDATEOBSOLETE: Use MEP_USR_DIM_STAT2DIMENSIONME Boost Dimensionnvarchar200
9MEP_USR_DIM_STATME Profile: Update status of dimension per user3DIMENSIONME Boost Dimensionnvarchar200
TOPAccounting Engine
10/EACC/DMB_DIMTable of Field Name and Dimensions for InfoCube4DIMENSIONDimension of a Star Schemanvarchar10
11/EACC/DMB_DIMTTexts of Dimensions Generated in an InfoCube3DIMENSIONDimension of a Star Schemanvarchar10
12/EACC/JRNL_TOTLSJournal Totals7DIMENSIONData Retention: Totals for Star Scheme in Totals Persistencenvarchar10
13/EACC/VIEW_TOT_AAll View Configurations8DIMENSIONData Retention: Totals for Star Scheme in Totals Persistencenvarchar10
14/EACC/V_TOTALS_FJournal Totals - Field List5DIMENSIONData Retention: Totals for Star Scheme in Totals Persistencenvarchar10
TOPAssetLiability Management
15JBAPLANPARALM Assignment of Planning Parameters to Planning Variant22DIMENSIONTime Unitnvarchar10
16JBASIMPARASAVEDBALM: Additional Information when Saving Sim. Transactions29DIMENSIONTime Unitnvarchar10
TOPBusiness Accounting
17/EACC/DMM_DICDimension Assignment of the Characteristics of Accntng Views5DIMENSIONDimension of a Star Schemanvarchar10
18/EACC/DMM_DIMDimensions of the Accounting Views4DIMENSIONDimension of a Star Schemanvarchar10
19/EACC/DMM_DIMTTest e for Dimensions of Accounting Views4DIMENSIONDimension of a Star Schemanvarchar10
TOPBusiness Objects, Common Components
20EHFNDC_AMN_CATAmount Categories3DIMENSIONPhysical Dimensionnvarchar60
TOPCollaboration Folders
21CFX_BOM_PDX_AFLDPDX IPC-2571: Additional Attributes w. CFX Field Assignment6DIMENSIONIPC-2571 Attribute "dimension": Unit of Measurementnvarchar400
TOPData Basis
22RSDDIMEDimensions directory3DIMENSIONDimensionnvarchar300
23RSDDIMEIOBJInfoObjects per dimension (where-used list)3DIMENSIONDimensionnvarchar300
24RSDDIMELOCDimensions system-local properties (not transport.)2DIMENSIONDimensionnvarchar300
25RSDDIMETDimension Texts4DIMENSIONDimensionnvarchar300
26RSMDUCMUKCUBEUT InfoCube: identifying attributes for MUKs4DIMENSIONDimensionnvarchar300
TOPFinancials Basis
27FINB_DMT_CHARData Retention: Characteristics5DIMENSIONData Retention: Totals for Star Scheme in Totals Persistencenvarchar10
28FINB_DMT_NRANGEData Retention: Number Range Intervals4DIMENSIONData Retention: Totals for Star Scheme in Totals Persistencenvarchar10
TOPFloorplan Manager Web Dynpro ABAP
29FPM_ADAPT_DIMAdaptation Dimensions2DIMENSIONAdaptation Dimensionnvarchar100
30FPM_ADAPT_RULEAdaptation Rule2DIMENSIONAdaptation Dimensionnvarchar100
TOPFunds Management
31FMIUROpen Interval Rules for updating FM3DIMENSIONValuenvarchar240
TOPIndustry-Specific Component Automotive
32RESKEYR3Resource Proxy ERP6DIMENSIONDimension of Available Capacity for Multi-Activity Resourcesnvarchar60
TOPMarket Risk Analyzer
33ATRFARTRisk factor type5DIMENSIONRisk factor dimensionnvarchar50
TOPOLAP Technology
34RSDDTREXNEWDID_RDIMIDs Required for BIA Recovery1DIMENSIONDimensionnvarchar300
35RSDDTREXNEWDIMIDNew DIMIDs for Dimensions in HPA Aggregates1DIMENSIONDimensionnvarchar300
TOPPerformance Assessment Workbench
36SLS_PUPAW - Performance Unit19DIMENSIONPAW - Dimensionnvarchar200
TOPPricing
37PRCC_CTYPE_ATTRAttributes of a Calculation Type3DIMENSIONSerial number of a dimension for a calculation typenvarchar20
TOPProduction Allocation
38GHO_ALLOC_UOM_IOBSOLETE - Table UOM rules Item3DIMENSIONDimension keynvarchar60
39GHO_RULE_LOG_IAllocation Rule Log Item18DIMENSIONDimension keynvarchar60
40GHO_SIMU_UOMRISimulation: Network UoM Rule Item4DIMENSIONDimension keynvarchar60
41GHO_UOM_RULE_INetwork UoM Rule Item4DIMENSIONDimension keynvarchar60
TOPSAP Business Partner
42T006ESystem for Units of Measurement (Components, Mapping)3DIMENSIONDimension keynvarchar60
TOPServices
43FINB_PR_TFIELDSFields of a Persistence Object10DIMENSIONData Retention: Totals for Star Scheme in Totals Persistencenvarchar10
TOPSupply Chain Management
44TCMC_QTTYTransportation Charge Management Quantity Type Code3DIMENSIONDimensionnvarchar60