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

62 columns | Print definition?ERP 6.0  | OBJ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1SRT_CDTC_CF_DETCentral Design Time Cache: Consumer Factory Details2OBJCentral Design Time Cache: Objectnvarchar300
2SRT_CDTC_CI_DETCentral Design Time Cache: Contract Implementation Details2OBJCentral Design Time Cache: Objectnvarchar300
3SRT_CDTC_CO_DETCentral Design Time Cache: Contract Details2OBJCentral Design Time Cache: Objectnvarchar300
4SRT_CDTC_EP_DETCentral Design Time Cache: Event Provider Proxy Details2OBJCentral Design Time Cache: Objectnvarchar300
5SRT_CDTC_IS_DETCentral Design Time Cache: Integration Scenario Def. Details2OBJCentral Design Time Cache: Objectnvarchar300
6SRT_CDTC_SC_DETCentral Design Time Cache: Semantic Contract Details2OBJCentral Design Time Cache: Objectnvarchar300
TOPAccounting Engine
7/EACC/TAR_OBJArchiving Objects4OBJArchiving Objectnvarchar100
TOPBalanced Scorecard
8UMB_BC_OB100Strategy Elements: Header Table (Business Content)2OBJObjectivenvarchar100
9UMB_BC_OB101Strategy Elements: Texts (Business Content)3OBJObjectivenvarchar100
10UMB_BC_SM102Strategy Map: Objective Assignment3OBJObjectivenvarchar100
11UMB_BC_SM103Strategy Map: Measure Assignment2OBJObjectivenvarchar100
12UMB_OB100Objectives: Header Table2OBJObjectivenvarchar100
13UMB_OB101Objectives: Texts3OBJObjectivenvarchar100
14UMB_SC105Scorecard: Objective Assignment3OBJObjectivenvarchar100
15UMB_SC140Scorecard: Objective Assignment (Time-Dependent)4OBJObjectivenvarchar100
16UMB_SC150Scorecard: Objective Assignment (Time-Dependent)3OBJObjectivenvarchar100
17UMB_SC151Scorecard: Objective Score, A&C, DBS, Doc Id3OBJObjectivenvarchar100
18UMB_SC152Scorecard: Objective: BIC Selections3OBJObjectivenvarchar100
19UMB_SC153Scorecard: Objective: Assigned BW Queries3OBJObjectivenvarchar100
20UMB_SC162Objective: Measure Assignment (Time-Dependent)3OBJObjectivenvarchar100
21UMB_SC182Objectives: Initiative Assignment (Time-Dependent)3OBJObjectivenvarchar100
22UMB_SC183Scorecard: Assignment of General Initiatives to Objectives3OBJObjectivenvarchar100
TOPBusiness Package for Manager Self-Service FI
23FPB_SNI_HIEROBJObjects in the Hierarchy3OBJObject Type for Communicationnvarchar40
24FPB_SNI_SEARCHOObject-specific Search Criteria in Hierarchy4OBJObject Type for Communicationnvarchar40
25FPB_SNI_SUBOBJSubnode Relationships in Hierarchy3OBJObject Type for Communicationnvarchar40
26FPB_SNI_SUBOBJCActivation of Subnode Relationships5OBJObject Type for Communicationnvarchar40
TOPCCMS Database Monitors for Oracle
27DBAOPTLDB Optimization - Table Statistics9OBJObject of DB operationnvarchar300
28DBAREOLReorganization9OBJObject namenvarchar300
29DBASPALMemory Allocation9OBJObject of DB operationnvarchar300
30SDBAHHeader Table for DBA Logs4OBJObject of DB operationnvarchar160
TOPControl Plan
31QPCPC_OBJCustomizing Table for the Objects5OBJData Element for Objectnvarchar30
32QPCPC_SELFIELDCustomizing Table for Selection Fields5OBJData Element for Objectnvarchar30
33QPCPC_SELRANGECustomizing Table for Selection Area5OBJData Element for Objectnvarchar30
TOPData Basis
34RSCNVTSTDATARemodeling test data2OBJTable Namenvarchar300
35RSDUPARTTCTest Data for Automatic Tests3OBJnvarchar300
TOPFunds Management
36TBP1CBudget/Plan Profile48OBJDefault Object Currency for Planning in Trans. Currencynvarchar10
TOPIncentive and Commission Management ICM
37CACS00_STAT_CASStatistics for Memory Requirement of Commission Cases (DB)11OBJMemory Requirement in Bytesint100
TOPMaxDB
38SDBAHSDBSAP DB: DBA History4OBJObject of DB operationnvarchar160
TOPMonitoring
39EWRELStatistics, relations in hierarchy3OBJStatistics, type of object of elementnvarchar40
TOPOLAP Technology
40RSCDSTCContains Test Scenarios for Program RSDR_ARCH_CHECK3OBJnvarchar300
41RSDRDTCTest Scenario for Archiving Check3OBJnvarchar300
TOPProvisioning
42SPCIPCSNLocations18OBJObject for Status Managementnvarchar200
43SPCIPEFFEffectivity Range8OBJObject for Status Managementnvarchar200
44SPCIPHDRStores header information for IP data11OBJObject for Status Managementnvarchar200
45SPCIPOCHOther Charges - Code & Amount9OBJObject for Status Managementnvarchar200
46SPCIPOSDSOptional Suppliers and Distributors9OBJObject for Status Managementnvarchar200
47SPCIPPARTSOther parts that can be used11OBJObject for Status Managementnvarchar200
48SPCIPPDRSpare parts / End items27OBJObject for Status Managementnvarchar200
49SPCIPPDSSPEC2000: Procurement Data Segment30OBJObject for Status Managementnvarchar200
50SPCIPPQAPrice Break - Quantity & Amount9OBJObject for Status Managementnvarchar200
51SPCIPRPDEReplacing Parts / Replaced Parts15OBJObject for Status Managementnvarchar200
52SPCIPUOAUsed On Assemblies11OBJObject for Status Managementnvarchar200
TOPReceivablesPayment Management
53TZB23Assign clerk4OBJObject for user assignmentnvarchar130
TOPReport Selection for Product Costing
54TKKB1Costing Reports13OBJAnalysis Objectnvarchar10
55TKKB3KKB: General Reports7OBJAnalysis Objectnvarchar10
56TKKBXUser Groups for Costing Reports5OBJAnalysis Objectnvarchar10
TOPService Data Download
57/SDF/SDBAHHeader Table for dba Log4OBJnvarchar160
TOPWeb Service and SOAP - ABAP
58SRT_CDTCCentral Design Time Cache3OBJCentral Design Time Cache: Objectnvarchar300
59SRT_CDTC_C_DETCentral Design Time Cache: Consumer Proxy Details2OBJCentral Design Time Cache: Objectnvarchar300
60SRT_CDTC_DESCR_TCentral Design Time Cache3OBJCentral Design Time Cache: Objectnvarchar300
61SRT_CDTC_G_DETCentral Design Time Cache: Service Group Details2OBJCentral Design Time Cache: Objectnvarchar300
62SRT_CDTC_S_DETCentral Design Time Cache: Service Definition Details2OBJCentral Design Time Cache: Objectnvarchar300