The below tables are very useful in SAP BI
RSTS -- Transfer Structure
RSTSFIELD -- Transfer Structure fields
RSTSRULES-- Transfer Structure rules
RSAROUTT-- Text name of Transfer Routine
DD03T-- Text for R/3 Transfer structure Objects Update Rules
RSUPDROUT Update rules
RSUPDDAT-- Update rules with routines
RSUPDKEY-- Update rule key fields
RSUPDINFO-- InfoProvider to Infosource correlation Embedded ABAP coding for Transfer / Update Rules
RSAABAP-- ABAP source code per object routine InfoPackage
RSLDPIO-- Links datasource to infopackages
RSLDPIOT-- InfoPackage Text Description RSLDPRULE-- ABAP source code for InfoPackages
RSLDPSEL-- Hardcoded selections in InfoPackages
RSMONICDP-- Contains the request-id number by data target
RSPAKPOS-- List of InfoPackage Groups / InfoPackages ProcessChain
RSEVENTCHAIN-- Event Chain Processing Event Table
RSEVENTHEAD-- Header for the event chain
RSEVENTHEADT-- Header for the event chain
RSPCCHAIN-- Process chain
RSPCCHAINATTR-- Attributes for a Process Chain
RSPCCHAINEVENTS-- Multiple Events with Process Chains
RSPCCHAINT-- Texts for Chain
RSPCCOMMANDLOG-- System Command Execution Logs (Process Chains)
RSPCLOGCHAIN-- Cross-Table Log ID / Chain ID
RSPCLOGS-- Application Logs for the Process Chains
RSPCPROCESSLOG-- Logs for the Chain Runs
RSPCRUNVARIABLES-- Variables for Process Chains for Runtime
RSPC_MONITOR-- Monitor individual process chains Queries
RSZELTDIR-- Directory of the reporting component elements
RSZELTTXT-- Texts of reporting component elements
RSZELTXREF-- Directory of query element references
RSRREPDIR-- Directory of all reports (Query GENUNIID)
RSZCOMPDIR-- Directory of reporting components Workbooks
RSRWBINDEX-- List of binary large objects (Excel workbooks)
RSRWBINDEXT-- Titles of binary objects (Excel workbooks)
RSRWBSTORE-- Storage for binary large objects (Excel workbooks)
RSRWBTEMPLATE-- Assignment of Excel workbooks as personal templates
RSRWORKBOOK-- Where-used list for reports in workbooks Web templates
RSZWOBJ-- Storage of the Web Objects
RSZWOBJTXT-- Texts for Templates/Items/Views
RSZWOBJXREF-- Structure of the BW Objects in a Template
RSZWTEMPLATE-- Header Table for BW HTML Templates InfoObject
RSDIOBJ-- Directory of all InfoObjects
RSDIOBJT-- Texts of InfoObjects
RSDATRNAV-- Navigation Attributes
RSDATRNAVT-- Navigation Attributes
RSDBCHATR-- Master Data Attributes
RSDCHABAS-- Basic Characteristics (for Characteristics, Time Characteristics, and Units)
RSDCHA-- Characteristics Catalog
RSDDPA-- Data Package Characteristic
RSDIOBJCMP-- Dependencies of InfoObjects
RSKYF-- Key Figures
RSDTIM-- Time Characteristics
RSDUNI-- Units InfoCube
RSDCUBE-- Directory of InfoCubes
RSDCUBET-- Texts on InfoCubes
RSDCUBEIOBJ-- Objects per InfoCube (where-used list)
RSDDIME-- Directory of Dimensions
RSDDIMET-- Texts on Dimensions
RSDDIMEIOBJ-- InfoObjects for each Dimension (Where-Used List)
RSDCUBEMULTI-- InfoCubes involved in a MultiCube--
RSDICMULTIIOBJ-- MultiProvider--: Selection/Identification of InfoObjects
RSDICHAPRO-- Characteristic Properties Specific to an InfoCube
RSDIKYFPRO-- Flag Properties Specific to an InfoCube
RSDICVALIOBJ-- InfoObjects of the Stock Validity Table for the InfoCube Aggregates
RSDDAGGRDIR-- Directory of Aggregates
RSDDAGGRCOMP-- Description of Aggregates
RSDDAGGRT-- Text on Aggregates ODS Object
RSDODSO-- Directory of all ODS Objects
RSDODSOT-- Texts of all ODS Objects
RSDODSOIOBJ-- InfoObjects of ODS Objects
RSDODSOATRNAV-- Navigation Attributes for ODS Object
RSDODSOTABL-- Directory of all ODS Object Tables PSA
RSTSODS-- Directory of all PSA Tables DataSource (= OLTP Source)
ROOSOURCE-- Header Table for SAP BW DataSources (SAP Source System/BW System)
RODELTAM-- BW Delta Procedure (SAP Source System)
RSOLTPSOURCE-- Replication Table for DataSources in BW InfoSource
RSIS-- Directory of InfoSources with Flexible Update
RSIST-- Texts on InfoSources with Flexible Update
RSISFIELD-- InfoObjects of an InfoSource Communications Structure
RSKS-- Communications Structure for InfoSources with Flexible Update
RSKS-- Communications Structure (View) for Attributes for an InfoSource with Direct Update
RSKSFIELD-- Texts on InfoSources with Flexible Update
RSISFIELD-- InfoObjects of an InfoSource with Flexible Update Transfer Structure
RSTS-- Transfer Structure in SAP BW
ROOSGEN-- Generated Objects for a DataSource (Transfer Structure, for example in SAP Source System) Mapping
RSISOSMAP-- Mapping Between InfoSources and DataSources (=OLTP Sources)
RSOSFIELDMAP-- Mapping Between DataSource Fields and InfoObjects InfoSpoke
RSBSPOKESELSET-- InfoSpoke-- Directory and Selection Options
RSBSPOKEVSELSET-- InfoSpoke-- Directory with Selection Options and Versioning SAP BW Statistics
RSDDSTAT-- Basic Table for InfoCubes/Queries
RSDDSTATAGGR-- Detail Table for Aggregate Setup
RSDDSTATAGGRDEF-- Detail Table of Navigation for each InfoCube/Query Misc
RSSELDONE-- InfoPackage selection and job program
RSPSADEL-- PSA Table deletion
TBTCP-- Job Schedule Definition
TBTCO-- Job Schedule Result
RSMONMESS-- Monitor Messages
RSERRORLOG-- Check loading errors in table
V_RSZGLOBV-- Report Variables view table
DEVACCESS Developer Keys table
TSTC All Transactions in the system
RSDDAGGRDIR-- Directory of the aggregates
ROIDOCPRMS Control parameters for data transfer from the source system
SMEN_BUFFC-- Objects in User's Favorites U have to Authorisation above one
Is there any table for mapping between DSO fields and Datasource fields and table for mappng between dso fields and infocube fields.
ReplyDeletePlease suggest.
In the transformation between sources goto Extras > Table View then Export or copy.
ReplyDelete