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

126 columns | Print definition?ERP 6.0  | INFOCUBE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMSBW_AGGRActive aggregates of Infocubes in receiver system4INFOCUBEInfoCubenvarchar300
2CNVTDMSBW_NRDIMNumber range table for DIMID3INFOCUBE30 Charactersnvarchar300
3RSCDS_SP_CONFIGConfiguration of stored procedure7INFOCUBEInfoCubenvarchar300
4RSCNVCRITSelections for RSCURRCONV1INFOCUBEInfoCubenvarchar300
5RSCNVFIXCUKYConversion Table for Fixed Currencies4INFOCUBEInfoCubenvarchar300
6RSCNVPROVConversion Table for Currency Translation1INFOCUBEInfoCubenvarchar300
7RSRT_BOOKMARKBookmark for RSRT BICS12INFOCUBEInfoCubenvarchar300
8RSSFMSSREPMSS-relevant reports2INFOCUBEInfoCubenvarchar300
TOPAccounting Engine
9/EACC/DMB_DIMTable of Field Name and Dimensions for InfoCube2INFOCUBEInfoCube Namenvarchar90
10/EACC/DMB_DIMTTexts of Dimensions Generated in an InfoCube2INFOCUBEInfoCube Namenvarchar90
11/EACC/DMB_QUEUEDataSource/InfoSource Link to InfoCube3INFOCUBEInfoCubenvarchar300
12/EACC/DMB_TARGETInfoCube Information3INFOCUBEInfoCubenvarchar300
TOPBI Content Analyzer
13RSCONTACTStatus Overview of All BW TLOGO Content Objects4INFOCUBEInfoCubenvarchar300
14RSCONTACT_CUBEStatus Overview for All Objects That Belong to a Cube1INFOCUBEObject Name in Object Directorynvarchar400
TOPBusiness Accounting
15/EACC/DMM_QUEUEBW Objects in the Extraction Lines10INFOCUBEInfoCubenvarchar300
TOPBusiness Analytics
16UABWTDEXTBW Objects for Transaction Data Extraction6INFOCUBEInfoCubenvarchar300
TOPBusiness Consolidation
17UCI1102Data Stream, BW-specific Definition4INFOCUBEInfoCubenvarchar300
TOPBusiness Planning and Simulation
18UPC_BW_AREAPlanning Areas of the BW Application3INFOCUBEInfoCubenvarchar300
TOPBusiness Warehouse Proxies
19UGBW1002FI/BW Interface: Generated Classes (Dest. & InfoCube-Dep.)2INFOCUBEInfoCubenvarchar300
TOPBW MaxDB
20RSDUADACUBESInfoCubes read according to system type1INFOCUBEInfoCubenvarchar300
TOPConsolidation
21TFBW0Destination and Target InfoCube for Data Transfer into BW3INFOCUBETarget info cubenvarchar300
22TFBW1Data streams into BW3INFOCUBETarget info cubenvarchar300
23TFBW2Mapping InfoObjects -> Field Names3INFOCUBEInfoCubenvarchar300
24TFBW3Data streams from BW3INFOCUBEInfoCubenvarchar300
25TFBW4Additional selections3INFOCUBEInfoCubenvarchar300
TOPData Basis
26RSAPOADMManagement Table for Transactional Requests1INFOCUBEInfoCubenvarchar300
27RSAPOREQUESTTable for Defining Lock Object1INFOCUBEInfoCubenvarchar300
28RSDCUBEDirectory of InfoCubes / InfoProvider1INFOCUBEInfoCubenvarchar300
29RSDCUBEIOBJObjects per InfoCube (where-used list)1INFOCUBEInfoCubenvarchar300
30RSDCUBELOCLocal Characteristics: InfoCubes (InfoProvider)1INFOCUBEInfoCubenvarchar300
31RSDCUBEMULTIInfoCubes concerned with MultiCube1INFOCUBEInfoProvidernvarchar300
32RSDCUBETTexts for the InfoCubes2INFOCUBEInfoCubenvarchar300
33RSDDIMEDimensions directory1INFOCUBEInfoCubenvarchar300
34RSDDIMEIOBJInfoObjects per dimension (where-used list)1INFOCUBEInfoCubenvarchar300
35RSDDIMELOCDimensions system-local properties (not transport.)1INFOCUBEInfoCubenvarchar300
36RSDDIMETDimension Texts2INFOCUBEInfoCubenvarchar300
37RSDD_DELTA_PKGDelta Package Management for InfoCube Delta Write1INFOCUBEInfoCubenvarchar300
38RSDD_PKG_IDUnique Delta Package ID for Each InfoCube1INFOCUBEInfoCubenvarchar300
39RSDICHAPROInfoCube-specific characteristic properties1INFOCUBEInfoCubenvarchar300
40RSDICMULTIIOBJMultiProvider: Selection/Identification of InfoObjects1INFOCUBEInfoProvidernvarchar300
41RSDICVALIOBJInfoObjects in NC-value validity table for the InfoCube1INFOCUBEInfoCubenvarchar300
42RSDIKYFPROInfoCube-specific key figure properties1INFOCUBEInfoCubenvarchar300
43RSDRI_HDB_CNVStatus Table for InfoCube Conversion1INFOCUBEInfoCubenvarchar300
44RSEUROConversion Table for Euro Conversion1INFOCUBEInfoCubenvarchar300
45RSICRESETReset Cube Administration1INFOCUBEInfoCubenvarchar300
46RSMDUCMUKAGGRUT Aggregates: Identifying attributes for MUKs3INFOCUBEInfoCubenvarchar300
47RSMDUCMUKCUBEUT InfoCube: identifying attributes for MUKs3INFOCUBEInfoCubenvarchar300
48RSSEM1000Generated Classes by InfoCube1INFOCUBEInfoCubenvarchar300
TOPData Staging
49RSAREACUBECube InfoAreas1INFOCUBEInfoCubenvarchar300
50RSERRORHEADIncorrect Records (Header Table)3INFOCUBEInfoCubenvarchar300
51RSERRORLOGLogs for Incorrect Records (Header RSERRORHEAD)3INFOCUBEInfoCubenvarchar300
52RSICENQEnqueue table for InfoCubes1INFOCUBEInfoCubenvarchar300
53RSICPROTLogs for Processed Jobs1INFOCUBEInfoCubenvarchar300
54RSICSETTINGSSettings for an InfoCube1INFOCUBEInfoCubenvarchar300
55RSMDATASTATELOGSStatus of the Data in the Infocubes1INFOCUBEInfoCubenvarchar300
56RSMONICTABMonitor IC table6INFOCUBEInfoCubenvarchar300
57RSOACUBEBW OLTP Direct Access: List of Virtual InfoCubes1INFOCUBEInfoCubenvarchar300
58RSOACUBE_DSOURCEBW OLTP Direct Access: Not Assigned DataSources1INFOCUBEInfoCubenvarchar300
59RSOACUBE_DTPBW: OLTP Direct Access: Directory of Assigned Remote DTPs1INFOCUBEInfoCubenvarchar300
60RSOACUBE_LOGSYSBW OLTP Direct Access: List of Assigned Source Systems1INFOCUBEInfoCubenvarchar300
61RSOACUBE_SSYSTBW OLTP Direct Access: List of Assigned Source Systems1INFOCUBEInfoCubenvarchar300
62RSODSACTActivation of ODS M Records1INFOCUBEInfoCubenvarchar300
63RSODSACTSELActivation of ODS M Records3INFOCUBEInfoCubenvarchar300
64RSODSSETTINGSSettings for an ODS1INFOCUBEInfoCubenvarchar300
65RSUPDENQRemoval of locks in the update rules1INFOCUBEInfoCubenvarchar300
66RSUPDINFOUpdate info (status and program)3INFOCUBEInfoCubenvarchar300
67RSUPDSIMULHTable for saving simulation data header information8INFOCUBEInfoCubenvarchar300
TOPEnd User Technology
68RRX_USRMENUUser-defined menu entries1INFOCUBEInfoCubenvarchar300
69RRX_USRMENUTTexts for user-defined menu entries1INFOCUBEInfoCubenvarchar300
70RSRA_ER_LOGNLog Table for Batch Runs of Exception Reporting7INFOCUBEInfoCubenvarchar300
71RSRA_SETTINGSettings for the Report Agent13INFOCUBEInfoCubenvarchar300
72RSZCOMPICAssignment reuseable component <-> InfoCube3INFOCUBEInfoCubenvarchar300
73RSZELTXREFDirectory of query element references6INFOCUBEInfoCubenvarchar300
74RSZGLOBVGlobal Variables in Reporting20INFOCUBEInfoCubenvarchar300
75RSZWOBJXREFStructure of the BW Objects in a Template10INFOCUBEInfoCubenvarchar300
76RSZWVIEWHeader Table for BW Views7INFOCUBEInfoCubenvarchar300
TOPFinancials Basis
77/EACC/TIOBJ_CUBEObsolete3INFOCUBEInfoCubenvarchar300
TOPMetadata Repository
78RSDCUBETMPTemporary Properties: InfoCubes (InfoProviders)1INFOCUBEInfoCubenvarchar300
TOPOLAP Technology
79RSBBSCUBEBW: InfoCube Receiver1INFOCUBEInfoCubenvarchar300
80RSBBSCUBEDIRBW: Directory of the InfoCube Sender1INFOCUBEInfoCubenvarchar300
81RSBBSCUBEMAPPINGFixed Mapping for BW-R/RI1INFOCUBEInfoCubenvarchar300
82RSBBSCUBETBW: Texts for InfoCube Receiver1INFOCUBEInfoCubenvarchar300
83RSBBSQRYMAPPINGFixed Mapping for BW-R/RI3INFOCUBEInfoCubenvarchar300
84RSBBSQUERYBW: Query Receiver3INFOCUBEInfoCubenvarchar300
85RSBBSQUERYDIRBW: Directory of the Query Sender3INFOCUBEInfoCubenvarchar300
86RSBBSQUERYTBW: Texts for Query Receiver4INFOCUBEInfoCubenvarchar300
87RSCDSMVREFORAControl Table for Conversion of ICs with ncumtim = parttim1INFOCUBEnvarchar300
88RSCDSREQDELTABAdministration of Requests to be Deleted When Compressing1INFOCUBEInfoCubenvarchar300
89RSCURRConversion Table for Euro Conversion1INFOCUBEInfoCubenvarchar300
90RSDDAGGRStatus of the active aggregates in the InfoCube1INFOCUBEInfoCubenvarchar300
91RSDDAGGRCHECKDIRManagement Table for the Aggregate Check2INFOCUBEInfoCubenvarchar300
92RSDDAGGRCHECKSELSelection Options for the Aggregate Check2INFOCUBEInfoCubenvarchar300
93RSDDAGGRCHECKTText Table for the Aggregate Check3INFOCUBEInfoCubenvarchar300
94RSDDAGGRDIRDirectory of the aggregates3INFOCUBEInfoCubenvarchar300
95RSDDAGGRENQUEQUETable to define lock argument1INFOCUBEInfoCubenvarchar300
96RSDDCHNGPROTTable with InfoObject whose master table has been changed4INFOCUBEInfoCubenvarchar300
97RSDDSTATAGGRStatistics data BW for aggregate selection and accounting4INFOCUBEInfoCubenvarchar300
98RSDDSTATCONDBW Statistics: Data on Condensing Run InfoCube2INFOCUBEInfoCubenvarchar300
99RSDDSTATDELEBW Statistics: Data on Deletion of Data in InfoCube2INFOCUBEInfoCubenvarchar300
100RSDDSTATWHMStatistics Data: BW for Warehouse Management4INFOCUBEInfoCubenvarchar300
101RSDDSTAT_WRITEStatistics for InfoCube Write2INFOCUBEInfoCubenvarchar300
102RSDDTREXCHECKIDHeader for BIA Checks for Data Consistency2INFOCUBEInfoCubenvarchar300
103RSDDTREXDIRTABLNo longer used as of BI 7.10; now for lock object only1INFOCUBEInfoCubenvarchar300
104RSDDTREXPSInfoProvider BIA Index also for Polestar1INFOCUBEInfoProvidernvarchar300
105RSDDTREX_BICSTATGet status (RNSID) of a BIA index during backup2INFOCUBEInfoCubenvarchar300
106RSDRDREQDELTABManagement of Requests to be Deleted with Request Deletion1INFOCUBEInfoCubenvarchar300
107RSDRHSEQNRTable for Calculating Unique Sequence Numbers1INFOCUBEInfoCubenvarchar300
108RSRA_ER_LOGLog Information for an RA Setting5INFOCUBEInfoCubenvarchar300
109RSRREPDIRDirectory of all reports3INFOCUBEInfoCubenvarchar300
110RSSTOBJDIRManagement Table for Authorization Objects1INFOCUBEInfoProvidernvarchar300
111RSUNIURLCOMPURL->IObj5INFOCUBEInfoCubenvarchar300
TOPPlanning
112RSPLS_LOG_REQMapping save ID and InfoCube to corresponding request2INFOCUBEInfoProvidernvarchar300
113RSPLS_RECOVERYBW-IP Blobs for Recovery7INFOCUBEInfoCubenvarchar300
TOPTools
114TKEBWLREQuery Data Transfer: Administration6INFOCUBEInfoCubenvarchar700
115TKEBWLRTTransfer: BW-Query-CO-PA6INFOCUBEInfoCubenvarchar700
116TKEBWLRTR2Transfer: BW-Query-CO-PA6INFOCUBEInfoCubenvarchar700
117TKEBWLRTR3Transfer: BW-Query-CO-PA11INFOCUBEInfoCubenvarchar700
118TKEBWLRTRTTransfer: BW-Query-CO-PA Text6INFOCUBEInfoCubenvarchar700
119TKEBWLTNTransfer: BW-Query-CO-PA6INFOCUBEInfoCubenvarchar700
TOPWithout Description
120RSDDCVERTESTSChecking InfoCubes: Description of the tests5INFOCUBEInfoCubenvarchar300
121RSDDSTATStatistics data BW for aggregate selection and accounting4INFOCUBEInfoCubenvarchar300
122RSDVENQUEUETable for Lock Management of RSDV1INFOCUBEInfoCubenvarchar300
123RSMDATASTATEStatus of the data in the Infocubes1INFOCUBEInfoCubenvarchar300
124RSRBPRINTPROPGlobal print settings for printing4INFOCUBEInfoCubenvarchar300
125RSRPRVARIANTSVariants to variant groups (batch printing)7INFOCUBEInfoCubenvarchar300
126RSSBAUTHTRACEAuthorization Trace BW Reporting2INFOCUBEInfoCubenvarchar300