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

117 columns | Print definition?ERP 6.0  | INFOPROV

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/PINFOPROVMaster Data (Time-Ind.): Characteristic InfoProvider1INFOPROVInfoProvidernvarchar300
2/BI0/SINFOPROVMaster Data IDs: InfoObject InfoProvider1INFOPROVInfoProvidernvarchar300
3RSBPCA_APPL_IPRVBPC information about infoproviders in model4INFOPROVInfoProvidernvarchar300
4RSBPCE_DAP_DIMBPC: DAP Dimension & Hierarchy6INFOPROVInfoProvidernvarchar300
5RSCRMC_TIME_IPROCustomizing table to enable multi time for infoprovider2INFOPROVInfoProvidernvarchar300
6RSCRMC_TIME_TGTCustomizing target time characteristics by infoprovider2INFOPROVInfoProvidernvarchar300
7RSDB2NLS_CHKRSLTDB2-z/OS HiPe NLS: Check results6INFOPROVInfoProvidernvarchar300
8RSDDSTATDTASIZESize of tables associated to a dta1INFOPROVInfoProvidernvarchar300
9RSDDSTATSLICECUSCustumizing of data slice statisitcs1INFOPROVInfoProvidernvarchar300
10RSDDSTATSLICEEXExtracted values3INFOPROVInfoProvidernvarchar300
11RSDIPRONCUMVIOBJInfoProvider: InfoObjects for NCUM Validity Table1INFOPROVInfoProvidernvarchar300
12RSDIPROV_MAPPINGMapping of InfoProvider fields to HANA View / ODP fields1INFOPROVInfoProvidernvarchar300
13RSDRI_HDB_ABORTStorage for Aborts / Breakpoints1INFOPROVInfoProvidernvarchar300
14RSDRS_HDB_ENGSELmaintain for which InfoProvider HDB-JOIN-enigine to use1INFOPROVInfoProvidernvarchar300
15RSIPRORANGESemantic Partitioning: Data Distribution2INFOPROVInfoProvidernvarchar300
16RSLUIKFMAPPINGKeyfigures copied to a CompositeProvider4INFOPROVInfoProvidernvarchar300
17RSPLS_SELDR_LOGStores SELDR1INFOPROVInfoProvidernvarchar300
18RSZCOMPTREEHierarchical Display of Reusable Query Components1INFOPROVInfoProvidernvarchar300
19RSZCOMPTREETXTHierarchical Display of Reusable Query Components (texts)1INFOPROVInfoProvidernvarchar300
TOPBusiness Consolidation
20UCS01A9Measures: Query9INFOPROVInfoProvidernvarchar300
21UCT9310Signoff Query4INFOPROVInfoProvidernvarchar300
TOPData Basis
22RSDIPROHIERInfoProvider: Hierarchies (InfoObjects)1INFOPROVInfoProvidernvarchar300
23RSDIPROHNODEInfoProvider: Hierarchy Nodes1INFOPROVInfoProvidernvarchar300
24RSDIPROHNODEIOBJInfoProvider: InfoObjects in Hierarchy Nodes1INFOPROVInfoProvidernvarchar300
25RSDIPROHNODETInfoProvider: Hierarchy Nodes, Descriptions2INFOPROVInfoProvidernvarchar300
26RSDIPROIOBJRANGEPartitioning Areas: InfoProvider1INFOPROVInfoProvidernvarchar300
27RSDIPROIOBJTTexts for InfoObjects in InfoProvider2INFOPROVInfoProvidernvarchar300
28RSSEM_RFCPACKTemporary Storage of Selected InfoProvider Data6INFOPROVInfoProvidernvarchar300
29RSSEM_UCR0_IPDSEM BCS Destination Registration For an InfoProvider1INFOPROVInfoProvidernvarchar300
TOPData Staging
30RSARCHIPROBW Archiving: General Archiving Properties1INFOPROVInfoProvidernvarchar300
31RSARCHIPROIOBJBW Archiving: General Archiving Properties1INFOPROVInfoProvidernvarchar300
32RSARCHIPROLOCBW ARchiving: General Local Properties1INFOPROVInfoProvidernvarchar300
33RSARCHIPROLOCSELBW Archiving: Archived Data Area1INFOPROVInfoProvidernvarchar300
34RSARCHIPROPIDBW Archiving: Program References of InfoProvider1INFOPROVInfoProvidernvarchar300
35RSCRT_RDA_IBCInformation Broadcasting Triggered by RDA2INFOPROVInfoProvidernvarchar300
36RSDAARCHREQCREFAssignment of Archiving Request to Source Request1INFOPROVInfoProvidernvarchar300
37RSDANLSEGBW Archiving: Segment of a Nearline Object9INFOPROVInfoProvidernvarchar300
38RSMREALTIMESTATECurrent Real-Time Request1INFOPROVnvarchar300
39RSODPOperational Data Provider: Header2INFOPROVInfoProvidernvarchar300
40RSODPACTIVEVERSOperational Data Provider: Active Versions of Indexes2INFOPROVInfoProvidernvarchar300
41RSODPLOADOperational Data Provider: Loading3INFOPROVInfoProvidernvarchar300
42RSODPQUERYSELOperational Data Provider: Query Selections3INFOPROVInfoProvidernvarchar300
43RSODPSELOperational Data Provider: Query and Load Selections2INFOPROVInfoProvidernvarchar300
44RSODPSELHASHOperational Data Provider: Hashed Query Selections2INFOPROVInfoProvidernvarchar300
45RSODPSTATOperational Data Provider: Status2INFOPROVInfoProvidernvarchar300
TOPInteractive Drilldown Reporting
46TRSTHV_VPBRST Repository of Hierarchies - Virtual InfoProvider11INFOPROVInfoSourcenvarchar300
TOPMDG for Financials
47USMDZ5104Virtual InfoProvider2INFOPROVInfoProvidernvarchar300
48USMDZ5105Selection rules2INFOPROVInfoProvidernvarchar300
49USMDZ5106Relationships of Entity Types2INFOPROVInfoProvidernvarchar300
TOPMetadata Repository
50RSDCOBPROTSTMPLTime Stamp for Buffer Management Class CL_RSD_DTA1INFOPROVInfoProvidernvarchar300
51RSDDTALOCLocal directory of all InfoProviders1INFOPROVInfoProvidernvarchar300
52RSDINFOPROVDATATime of Last Data Change in an InfoProvider1INFOPROVInfoProvidernvarchar300
TOPOLAP Technology
53RRAMBIADIRAnalytical Model: Directory for InfoProvider and BIA Index1INFOPROVInfoProvidernvarchar300
54RRAMBIAIOBJAnalytical Model: Mapping of InfoObject to TREX Attributes1INFOPROVInfoProvidernvarchar300
55RRAMDIRDirectory of Generated Analytic Models1INFOPROVInfoProvidernvarchar300
56RRAMFIEFields of Model1INFOPROVInfoProvidernvarchar300
57RSDDSTATBIAUSECounter for BIA Usage per InfoProvider1INFOPROVInfoProvidernvarchar300
58RSDDSTATDMData Manager Query Statistic Records6INFOPROVInfoCubenvarchar300
59RSDDSTATDU_IOQuery Filter Statistics: Monitored InfoObjects1INFOPROVInfoProvidernvarchar300
60RSDDSTATDU_IPInfoProvider for Query Filter Statistics1INFOPROVInfoProvidernvarchar300
61RSDDSTATHEADERBW Statistics (OLAP), Information by Runtime Object5INFOPROVInfoProvidernvarchar300
62RSDDTPSFMLSelected CKFs/RKFs for Providers1INFOPROVInfoProvidernvarchar300
63RSDDTPSFMLVARVariables for CKF/RKF1INFOPROVInfoProvidernvarchar300
64RSDDTPS_AUTHAuthorized Users for Polestar1INFOPROVInfoProvidernvarchar300
65RSDDTPS_CONVConversion Indices in Polestar1INFOPROVInfoProvidernvarchar300
66RSDDTPS_HIER_HNMHierarchies for Use in Polestar1INFOPROVInfoProvidernvarchar300
67RSDDTPS_HIER_IPAssignment of Hiers to InfoProvider/InfoObject Combination1INFOPROVInfoProvidernvarchar300
68RSDDTPS_IOBJDependency of InfoProvider to Chabasnm1INFOPROVInfoProvidernvarchar300
69RSDDTPS_IPROInfoProvider in Polestar and Batch Job1INFOPROVInfoProvidernvarchar300
70RSDDTPS_KYFHidden Key Figures per Provider1INFOPROVInfoProvidernvarchar300
71RSDDTREXBVIPVirtual InfoProviders with BIA Cache and Class Name1INFOPROVInfoProvidernvarchar300
72RSDRATCOSTRuntime Estimation Check3INFOPROVInfoProvidernvarchar300
73RSDRCRM_SEG_EXSTExecution Plan: Recording Additional Data for Step Calls5INFOPROVInfoProvidernvarchar300
74RSDRC_DS_BASE_TCTest Data for RSDRC DS Test2INFOPROVInfoProvidernvarchar300
75RSDRC_PART_TCTest Data for RSDRC Partitioning1INFOPROVInfoProvidernvarchar300
76RSDRC_TCTest Data RSDRI (External Read Interface)9INFOPROVInfoProvidernvarchar300
77RSDRC_TC_BACKTest Data RSDRI (External Read Interface)9INFOPROVInfoProvidernvarchar300
78RSDRI_TCTest Data RSDRI (External Read Interface)9INFOPROVInfoProvidernvarchar300
79RSDRI_TC_BACKTest Data RSDRI (External Read Interface)9INFOPROVInfoProvidernvarchar300
80RSDRT_TRACETraces Generated with RSDRT_INFOPROV_RANDOM_QUERIES1INFOPROVInfoProvidernvarchar300
81RSDRV_ODS_TCDataStore Test Data Without BEXFL1INFOPROVInfoProvidernvarchar300
82RSDRV_TCTest Data RSDRV (Virtual Cubes)8INFOPROVInfoProvidernvarchar300
83RSDRV_TC_BACKTest Data RSDRV (Virtual Cubes)8INFOPROVInfoProvidernvarchar300
84RSECAUTHGENERATDBI AS Authorization Reporting: Generated Authorizations2INFOPROVInfoProvidernvarchar300
85RSECLOPDIPLOPD: InfoProviders with Personal Data1INFOPROVInfoProvidernvarchar300
86RSECLOPDLOGFLOPD Protocol: Filter2INFOPROVInfoProvidernvarchar300
87RSECLOPDLOGHLOPD Logs: Control Data2INFOPROVInfoProvidernvarchar300
88RSECLOPDLOGILOPD Log: Details2INFOPROVInfoProvidernvarchar300
89RSECLOPDQFILTERFilter within Queries1INFOPROVInfoProvidernvarchar300
90RSECLOPDQIOBJLOPD-Relevant Objects Within Queries1INFOPROVInfoProvidernvarchar300
91RSECLOPDQSTATLOPD-Relevant Objects Within Queries1INFOPROVInfoProvidernvarchar300
92RSSBAUTHGENBW Reporting Authorizations: Generating Authorizations1INFOPROVInfoProvidernvarchar300
93RSSBAUTHGENERATDBW Reporting Authorizations: Generated Authorizations2INFOPROVInfoProvidernvarchar300
TOPPlanning
94RSPLF_SRVPlanning Service12INFOPROVInfoProvidernvarchar300
95RSPLS_ALVLPlanning: Primary Table for Aggregation Levels3INFOPROVInfoProvidernvarchar300
96RSPLS_ALVL_IOBJPlanning: Aggregation Levels for InfoObjects4INFOPROVInvolved InfoProvider (for MultiProvider)nvarchar300
97RSPLS_AUDITIn-Memory Planning - License Check3INFOPROVInfoProvidernvarchar300
98RSPLS_CHAS_LOCKPlanning: Lock-Relevant Characteristics per InfoProvider1INFOPROVInfoProvidernvarchar300
99RSPLS_CR_HEADCharacteristic Relationships: Header Table1INFOPROVInfoProvidernvarchar300
100RSPLS_CR_PROPCharacteristic Relationships: Settings1INFOPROVInfoProvidernvarchar300
101RSPLS_CR_RANGEChar.Relationship: Range (for example, for DataStore Object)1INFOPROVInfoProvidernvarchar300
102RSPLS_CR_ROLECharacteristic Relationships: Roles of the Characteristics1INFOPROVInfoProvidernvarchar300
103RSPLS_CR_STEPSRelationships Between Characteristics in Basic InfoProvider1INFOPROVInfoProvidernvarchar300
104RSPLS_DSData Slices1INFOPROVInfoProvidernvarchar300
105RSPLS_DSTText Table: Data Slices2INFOPROVInfoProvidernvarchar300
106RSPLS_DS_FIELDData Slices: InfoObejcts with Restrictions1INFOPROVInfoProvidernvarchar300
107RSPLS_DS_HEADData Slices: Header Table1INFOPROVInfoProvidernvarchar300
108RSPLS_DS_RANGEData Slices: Selection1INFOPROVInfoProvidernvarchar300
109RSPLS_ENQ_MASTERTable of Master Locks1INFOPROVInfoProvidernvarchar300
110RSPLS_HDB_ACT_IPBW-IP: Activation of Deep HANA Integration for Providers1INFOPROVInfoProvidernvarchar300
TOPRetention Warehouse
111IWP_WP_IPRVInfoProviders of an Audit Package3INFOPROVInfoProvidernvarchar300
112IWP_WP_IPRVTText Table: InfoProviders of an Audit Package3INFOPROVInfoProvidernvarchar300
TOPWithout Description
113RSBAIPROVTemporary Storage of Selected InfoProvider Data6INFOPROVInfoProvidernvarchar300
114RSINPCONFIGData Entry Configuration Store2INFOPROVInfoProvidernvarchar300
115RSQIMPACTLog for Impact-Analysis2INFOPROVInfoProvidernvarchar300
116RSTT_REPTable of Existing BI Reports for RSTT Reporting5INFOPROVInfoProvidernvarchar300
TOPXBRL Reporting
117UGX0010Queries of a Data Basis4INFOPROVInfoProvidernvarchar300