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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

43 columns | Print definition?ERP 6.0  | RC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_20308_DFDATALog for Deviations9RCCause of the differencenvarchar10
2DDREPLICATORDD: Information on Metadata Transfer17RCReturn Codeint100
3DDREPLICATORVIDD: Information on Metadata Transfer10RCReturn Codeint100
4FDT_TRANS_Q_0011FDT: Transport Activation Queue - Merge Transport6RCReturn Codeint100
5T803DReport Writer: Key Figure Blocks (Row/Column Texts)6RCRow/columnnvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
6DBDCGENTBDD: Persisting Activating Ojects in Mass Activation9RCReturn Codeint100
TOPBRFplus - ABAP-Based Business Rules
7FDT_EMEX_0001BRFplus: Protocol table for emergency transports6RCReturn Codeint100
8FDT_TRANS_Q_0001FDT: Transport Activation Queue - Merge Transport5RCReturn Codeint100
TOPCCMS Database Monitors for Oracle
9DBAERRLook-Up Table for Database Operation Errors4RCReturn code for DBA actionnvarchar40
10DBAMLJob / Job Step Utility View15RCSub-operation return codenvarchar40
11DBAOBJLObject Status19RCReturn code for DBA actionnvarchar40
12DBAPHALObject Status16RCReturn code for DBA actionnvarchar40
13DBARCLSub-operations14RCSub-operation return codenvarchar40
14DBATLCentral Task / Job Information10RCReturn code for DBA actionnvarchar40
15SDBAHHeader Table for DBA Logs5RCReturn code for DBA actionnvarchar40
TOPClaims Management
16ICLITEMEVClaim Item Evaluation29RCOriginal Cash Valuedecimal152
17ICLITEMEVAClaim Item: Actual Cash Value Valuation12RCOriginal Cash Valuedecimal152
18ICSITEMEVClaim Item Evaluation29RCOriginal Cash Valuedecimal152
19ICSITEMEVAClaim Item: Actual Cash Value Valuation12RCOriginal Cash Valuedecimal152
TOPCollectionsDisbursements
20VVKKIHISTDeposit Acct Interest Calc: History (Detail)15RCReturn Value (Return Code)nvarchar20
21VVKKIHISTIOBSec. Acct Int. Calc. Acc. to Ins. Obj.: History (Detail)23RCReturn Value (Return Code)nvarchar20
TOPData Basis
22RSR_PE_LOGLog for Planning Engine10RCint100
TOPDatabase Interface, Database Platforms
23DBA_DBH_COLL_RUNDBA-DBH: Collector Runtime Statistics nad Return Codes7RCint100
TOPDB2 for AS4
24DB4BACKUPStore DB4 Backup Data4RCnvarchar40
TOPEnd User Technology
25RSR_PREC_QUEUEPersistant Precalculation Queue9RCCount parametersnvarchar40
TOPGeneric Contract Accounts Receivable and Payable
26DFSCIHISTIOBBalance Int. Calculation at Contract Account Level: History22RCReturn Value (Return Code)nvarchar20
TOPGovernance, Risk and Compliance
27GRFNDMRCDataMart: Rule Criteria4RCRule Criterianvarchar300
TOPInformation System
28T801DReport Writer: Row/Column Characteristics4RCRow/columnnvarchar10
29T801FReport Writer: Rest Blocks (Rows, Columns)4RCRow/columnnvarchar10
30T801MReport Writer: Rows/Columns4RCRow/columnnvarchar10
31T803GReport Writer: Key Figure Blocks (Cells in Formulas)5RCRow/columnnvarchar10
TOPliveCache
32LCINIT_LOGLog Entries: Start/Stop/Init of Prep./Postprocessing Reports10RCReturn code for DBA actionnvarchar40
TOPMaxDB
33SDBADSDBDBA calendar: planning- vs. R/3 exec.vs. DB exec. times12RCReturn codenvarchar40
34SDBAHSDBSAP DB: DBA History5RCReturn code for DBA actionnvarchar40
TOPMonitoring
35SCMC_NODE_MSCAdditional Attributes for Message Container Nodes40RCAlert: Return Codeint100
36SCMC_NODE_PERFAdditional Attributes for Performance Nodes54RCAlert: Return Codeint100
37SCMC_NODE_SMESAdditional Attributes for Log Nodes18RCAlert: Return Codeint100
TOPOracle Database Monitors
38ORA_ISQ_DETAILIndex Storage Quality - Objects of a Workingset12RCReturncodeint100
TOPSAP Business Workflow
39SWFRPCSTARWorkflow: Process Step in Status of a Process Unit II8RCException for methodnvarchar40
TOPService Data Download
40/SDF/CMO_T_PBACKTEA self-service: Production Backlog9RCNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
41/SDF/SDBAHHeader Table for dba Log5RCnvarchar40
TOPTransport Organizer
42GUPDLAYOUTList of Table Layouts that Need to Be Updated6RCReturn Codeint100
TOPUser and Authorization Management
43USR07Object/values of last authorization check that failed32RCNatural Numberint100