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

41 columns | Print definition?ERP 6.0  | COMPTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_OBJTable for object types2COMPTYPEData element for comparision typenvarchar10
2CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information28COMPTYPEDD: Component Typenvarchar10
3DD03NDDD: Attributes of a Node of a Structured Object23COMPTYPEDD: Component Typenvarchar10
4DD10BDD: Parameters for Structured Objects, for ex. View Entities7COMPTYPEDD: Component Typenvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
5DD03LTable Fields25COMPTYPEDD: Component Typenvarchar10
TOPBusiness Consolidation
6UCF0030Layouts: Components14COMPTYPEType of Method Componentnvarchar10
TOPCompliance Check
7EHSBT_RC_EXPLSHMEHS: Table for Storing Explosion Result in Shared Memory7COMPTYPEID of Composition Typenvarchar100
TOPCross-Application Components
8/IXOS/DC_TAMAGeneral Doculink administraton data for data source44COMPTYPEDD: Component Typenvarchar10
TOPFinancials Basis
9UGR31008FIN Master Data: Dummy Field Names with Properties25COMPTYPEDD: Component Typenvarchar10
10UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures23COMPTYPEDD: Component Typenvarchar10
TOPGlobal Performance Analysis Transaction ST3
11AMSTANOGlobal Performance Analysis: Other Statistics Data3COMPTYPEN3 Workload: Type of Statistics Componentnvarchar100
TOPMaterial Master
12WGDS_FIELDS_LISTGDS storage: structures' fields info8COMPTYPEDD: Component Typenvarchar10
TOPMonitoring
13SGLWLSLISTSAP Workload: User-Specific System List for Global Analysis7COMPTYPEN3 Workload: Type of Statistics Componentnvarchar100
14SWLN3CMPIFNon-R/3 Statistic: Action Type and Service Type Information1COMPTYPEDSR Statistics: Type of Non-R/3 Componentnvarchar100
15SWLN3CMPITNon-R/3 Statistic: Action Type and Service Type Information2COMPTYPEDSR Statistics: Type of Non-R/3 Componentnvarchar100
16SWLN3MOIDXNon-R/3 Statistic: Index of Existing Aggregates2COMPTYPEDSR Statistics: Type of Non-R/3 Componentnvarchar100
17SWLN3WORKLNon-R/3 Statistic: Summarized Statistic Data (Aggregates)3COMPTYPEDSR Statistics: Type of Non-R/3 Componentnvarchar100
18SWNCCOLLPACKSIZESAP Workload NW Collector: Automatic Package Sizes2COMPTYPESAP Workload NW Collector: Component Typenvarchar200
19SWNCCOLLPERFPerformance Data of the Workload Collector2COMPTYPESAP Workload NW Collector: Component Typenvarchar200
20SWNCCOLLPERFTOTPerformance Data of the Workload Collector2COMPTYPESAP Workload NW Collector: Component Typenvarchar200
21SWNCMONISAP Workload NW Collector: Data Clusters3COMPTYPESAP Workload NW Collector: Component Typenvarchar200
22SWNCMONIINDEXSAP Workload NW Collector: Data Cluster Index Table2COMPTYPESAP Workload NW Collector: Component Typenvarchar200
TOPOLAP Technology
23RSRREPDIRDirectory of all reports5COMPTYPEType of a reporting componentnvarchar30
24RSUNIURLCOMPURL->IObj7COMPTYPEType of a reporting componentnvarchar30
TOPPersonalization Framework
25FPB_PERSAPPLFLDPersonalization: Characteristics of Application Hierarchy7COMPTYPEReference Data Elementnvarchar300
26FPB_PERSVARPersonalization: Variables2COMPTYPEReference Data Elementnvarchar300
TOPRecipe Development
27/PLMI/EXPL_CMPTYExplosion customizing: Assignment of component types3COMPTYPEComponent Typenvarchar100
28/PLMI/RFO_COMPCalculation-Relevant Component Types2COMPTYPEComponent Typenvarchar100
TOPRuntime WorkbenchMonitoring
29SXIPMIDESTPMI Component and Destination for XI Component6COMPTYPEComponent Type in SLDnvarchar2550
30SXMSPFCOMPONENTIntegration Engine: Component Information3COMPTYPEComponent Type in SLDnvarchar2550
TOPSolution Directory
31SDTSCOMPDTS: Components Referenced by Downtime Schedule3COMPTYPEDTS: Component Types in Downtime Planningnvarchar60
32SDTSCOMPSDTS: Components Referenced by Downtime Schedule2COMPTYPEDTS: Component Types in Downtime Planningnvarchar60
33SMDTSCOMPTPDTS: Supported Component Types1COMPTYPEDTS: Component Types in Downtime Planningnvarchar60
34SMDTSCOMPTP_TXTDTS: Supported Component Types2COMPTYPEDTS: Component Types in Downtime Planningnvarchar60
TOPTable Maintenance Tool
35SDMEDPCHDME: Dialog Pool Component Header2COMPTYPEDME: Dialog Pool Component Typenvarchar40
36SDMEDPCHTDME: Text Table for Dialog Pool Component Header3COMPTYPEDME: Dialog Pool Component Typenvarchar40
TOPTransaction Tax Engine
37TTEC_TAXCOMPTax Component2COMPTYPETax Component Typenvarchar10
TOPTreasury
38CML_MIG_BUFFERTable DDIC buffering (migration)45COMPTYPEDD: Component Typenvarchar10
TOPUser and Authorization Management
39AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary41COMPTYPEDD: Component Typenvarchar10
TOPWithout Description
40RSTT_ERRORError Archive21COMPTYPESubtype of Data Objectnvarchar10
TOPWorkbench Utilities
41SPAR_NTDBParameter Storage: Persistent Nametab Container48COMPTYPEDD: Component Typenvarchar10