Sap Psa Table
2021年1月24日Download here: http://gg.gg/nzjk5
In this article, we will list the most Important SAP BW Tables (Business Intelligence Warehouse Tables).
Table Space analysis through DB02 for PSA and Change log deletion strategies.Previous. Screen will give you details of the each process table spaced occupied and values are in MB so you can check and do analysis for particular by clicking double click to check which are the tables and size of the table.
For more information, see Customizing for Extended Warehouse Management under Master Data Production Supply Maintain Product Group Type for PSA Assignment. Assign a product group to the products. On the SAP Easy Access screen, choose Extended Warehouse Management Master Data Product Maintain Product Properties 2. /BIC/B is a standard SAP Table which is used to store PSA for /CPD/PFPDSWBS T90CLNT090 DataSource for WBS data and is available within R/3 SAP systems depending on the version and release level. Below is the standard documentation available and a few details of the fields which make up this Table. . Run ABAP ‘SAPPSAZEROCORRECT’ to correct PSA table with partition number 0. Sometimes, a correction can be made, so the data is still available. If this correction cannot be made, the content is deleted. Clean-up unreferenced PSA metadata objects by using ABAP ‘RSARPSACLEANUPDEFINITION’.
In order to simplify this list, we will divide the list into SAP BW Tables by topics such us: Transfer Structure Tables, Update Rules, InfoPackage, Queries, Workbooks, InfoObject, InfoCube Tables, DataSource, InfoSource tables …SAP BW TablesSAP BW Tables for Transfer Structure
The most important SAP BW Tables for Transfer Structure are SAP Tables DescriptionRSTSTransfer Structure ListRSTSFIELDTransfer Structure fieldsRSTSRULESTransfer Structure rulesRSAROUTTText name of Transfer RoutineDD03TText for R/3 Transfer structure ObjectsSAP BW Tables for Update Rules
The most important SAP BW Tables for Update Rules are SAP Tables DescriptionRSUPDROUTUpdate rules ListRSUPDDATUpdate rules with routinesRSUPDKEYUpdate rule key fieldsRSUPDINFOInfoProvider to Infosource correlation
Read also SAP Info Record Table, Info Record Tcodes and SAP Info Record Report.Embedded ABAP coding for Transfer / Update Rules
The most important Embedded ABAP coding for Transfer / Update Rules are SAP Tables DescriptionRSAABAPABAP source code per object routineInfoPackage Tables in SAP BW
The most important InfoPackage Tables in SAP BW are SAP Tables DescriptionRSLDPIOLinks datasource to infopackagesRSLDPIOTInfoPackage Text DescriptionRSLDPRULEABAP source code for InfoPackagesRSLDPSELHardcoded selections in InfoPackagesRSMONICDPContains the request-id number by data targetRSPAKPOSList of InfoPackage Groups / InfoPackagesSAP Process Chain Tables
The most important Process Chain Tables in SAP BW are SAP Tables DescriptionRSEVENTCHAINEvent Chain Processing Event TableRSEVENTHEADHeader for the event chainRSEVENTHEADTHeader for the event chainRSPCCHAINProcess chain detailsRSPCCHAINATTRAttributes for a Process ChainRSPCCHAINEVENTSMultiple Events with Process ChainsRSPCCHAINTTexts for ChainRSPCCOMMANDLOGSystem Command Execution Logs (Process Chains)RSPCLOGCHAINCross-Table Log ID / Chain IDRSPCLOGSApplication Logs for the Process ChainsRSPCPROCESSLOGLogs for the Chain RunsRSPCRUNVARIABLESVariables for Process Chains for RuntimeRSPC_MONITORMonitor individual process chainsQuery Tables in SAP BW
The most important Queries Tables in SAP BW areSap Pa Psa Table SAP Tables DescriptionRSZELTDIRDirectory of the reporting component elementsRSZELTTXTTexts of reporting component elementsRSZELTXREFDirectory of query element referencesRSRREPDIRDirectory of all reports (Query GENUNIID)RSZCOMPDIRDirectory of reporting componentsRSZRANGESelection specification for an elementRSZSELECTSelection properties of an elementRSZELTDIRDirectory of the reporting component elementsRSZCOMPICAssignment reuseable component < -> InfoCubeRSZELTPRIOPrioritifes with element collisionsRSZELTPROPElement properties (settings)RSZELTATTRAttribute selection per dimension elementRSZCALCDefinition of a formula elementRSZCELQuery Designer: Directory of CellsRSZGLOBVGlobal Variables in ReportingRSZCHANGESChange history of reporting componentsWorkbooks SAP Tables DescriptionRSRWBINDEXList of binary large objects (Excel workbooks)RSRWBINDEXTTitles of binary objects (Excel workbooks)RSRWBSTOREStorage for binary large objects (Excel workbooks)RSRWBTEMPLATEAssignment of Excel workbooks as personal templatesRSRWORKBOOKWhere-used list for reports in workbooksWeb templates SAP Tables DescriptionRSZWOBJStorage of the Web ObjectsRSZWOBJTXTTexts for Templates/Items/ViewsRSZWOBJXREFStructure of the BW Objects in a TemplateRSZWTEMPLATEHeader Table for BW HTML TemplatesInfoObject SAP Tables DescriptionRSDIOBJDirectory of all InfoObjectsRSDIOBJTTexts of InfoObjectsRSDIOBJDirectory of all InfoObjectsRSDIOBJTTexts of InfoObjectsRSDATRNAVNavigation AttributesRSDATRNAVTNavigation AttributesRSDBCHATRMaster Data AttributesRSDCHABASBasic CharacteristicsRSDCHACharacteristics CatalogRSDDPAData Package CharacteristicRSDIOBJCMPDependencies of InfoObjectsRSKYFKey FiguresRSDTIMTime CharacteristicsRSDUNIUnitsInfoCube Tables in SAP BW SAP Tables DescriptionRSDCUBEDirectory of InfoCubesRSDCUBETTexts on InfoCubesRSDCUBEIOBJObjects per InfoCube (where-used list)RSDDIMEDirectory of DimensionsRSDDIMETTexts on DimensionsRSDDIMEIOBJInfoObjects for each Dimension (Where-Used List)RSDCUBEMULTIInfoCubes involved in a MultiCubeRSDICMULTIIOBJMultiProvider: Selection/Identification of InfoObjectsRSDICHAPROCharacteristic Properties Specific to an InfoCubeRSDIKYFPROFlag Properties Specific to an InfoCubeRSDICVALIOBJInfoObjects of the Stock Validity Table for the InfoCubeAggregate Tables in SAP BW SAP Tables DescriptionRSDDAGGRDIRDirectory of AggregatesRSDDAGGRCOMPDescription of AggregatesRSDDAGGRTText on AggregatesRSDDAGGLTDirectory of the aggregates and textsODS Object SAP Tables DescriptionRSDODSODirectory of all ODS ObjectsRSDODSOTTexts of all ODS ObjectsRSDODSOIOBJInfoObjects of ODS ObjectsRSDODSOATRNAVNavigation Attributes for ODS ObjectRSDODSOTABLDirectory of all ODS Object TablesPSA Tables in SAP BW SAP Tables DescriptionRSTSODSDirectory of all PSA TablesDataSource (= OLTP Source) SAP Tables DescriptionROOSOURCEHeader Table for SAP BW DataSources (SAP Source System/BW System)RODELTAMBW Delta Procedure (SAP Source System)RSOLTPSOURCEReplication Table for DataSources in BWInfoSource SAP Tables DescriptionRSISDirectory of InfoSources with Flexible UpdateRSISTTexts on InfoSources with Flexible UpdateRSISFIELDInfoObjects of an InfoSourceCommunications Structure SAP Tables DescriptionRSKSCommunications Structure for InfoSources with Flexible UpdateRSKSCommunications Structure (View) for Attributes for an InfoSource with Direct UpdateRSKSFIELDTexts on InfoSources with Flexible UpdateRSISFIELDInfoObjects of an InfoSource with Flexible UpdateTransfer StructureSap Psa Table Ideas
The main Transfer Structure Tables in SAP Business Warehouse are SAP Tables DescriptionRSTSTransfer Structure in SAP BWROOSGENGenerated Objects for a DataSourceMapping
The main Mapping Tables in SAP Business Warehouse are SAP Tables DescriptionRSISOSMAPMapping Between InfoSources and DataSources (=OLTP Sources)RSOSFIELDMAPMapping Between DataSource Fields and InfoObjectsInfoSpoke
The main InfoSpoke Tables in SAP Business Warehouse are SAP Tables DescriptionRSBSPOKESELSETInfoSpoke Directory and Selection OptionsRSBSPOKEVSELSETInfoSpoke Directory with Selection Options and VersioningRSBSPOKEList of all InfoSpokes with attributes maintainedRSBSPOKETList of all InfoSpokes with the ShortRSBSTEPIDMESSContains all the messages that have been recorded during the execution of an InfoSpokeSap Se16n Table ListSap Bw Psa TableSAP BW Statistics SAP Tables DescriptionRSDDSTATBasic Table for InfoCubes/QueriesRSDDSTATAGGRDetail Table for Aggregate SetupRSDDSTATAGGRDEFDetail Table of Navigation for each InfoCube/QueryRSDDSTATCONDInfoCube CompressionRSDDSTATDELEInfoCube DeletionsRSDDSTATWHMWarehouse ManagementOther useful SAP BW Tables
In this part, you will find a list of interesting and useful SAP Tables in BW.Sap Bw Psa Table Size SAP Tables DescriptionRSFECBW Frontend Check. Useful for checking the installed SAP GUI versions on user machines.RSSELDONEInfoPackage selection and job programRSPSADELPSA Table deletionTBTCPJob Schedule DefinitionTBTCOJob Schedule ResultRSMONMESSMonitor MessagesRSERRORLOGCheck loading errors in tableV_RSZGLOBVReport Variables view tableDEVACCESSDeveloper Keys tableTSTCAll Transactions in the systemRSDDAGGRDIRDirectory of the aggregatesROIDOCPRMSControl parameters for data transfer from the source systemSMEN_BUFFCObjects in User’s FavoritesTSTCTTransaction Codes with TextDD03Lfield names and corresponding data element namesDD03LTDescription of each data elementDD02LAll SAP Defined Table NamesDD02LTDescription of All SAP Defined Table NamesSAP BW Tables for Web Item SAP Tables DescriptionRSZWITEMHeader Table for BW Web ItemsRSZWMDITEMBW Web Metadata: Template Item Dataprovider& ItemRSZWITEMXREFCross Reference of Web ItemsRSZWMIMEIOBUFFERBuffer for Translation MIME Rep. to IORSZWOBJStorage of the Web ObjectsRSZWOBJTXTTexts of Templates/Items/ViewsRSZWOBJXREFStructure of the BW Objects in a TemplateRSZWTEMPLATEHeader Table for BW HTML TemplatesArchiving Tables in SAP BW
The main Archiving Tables in SAP Business Warehouse are SAP Tables DescriptionRSARCHIPROBW Archiving: General Archiving PropertiesRSARCHIPROIOBJBW Archiving: General Archiving PropertiesRSARCHIPROLOCBW ARchiving: General Local PropertiesRSARCHIPROLOCSELBW Archiving: Archived Data AreaRSARCHIPROPIDBW Archiving: Program References of InfoProviderRSARCHREQBW Archiving: Archiving RequestRSARCHREQFILESBW Archiving: Verfified Archive FilesRSARCHREQSELBW Archiving: Request-SelectionsOpen Hub Destination SAP Tables DescriptionRSBOHSERVICETPOpen Hub: Service TypesRSBREQUESTDELTAOpen Hub: Cross Reference Outbound/InboundRSBREQUESTMESSOpen Hub: Log for a RequestRSBREQUIDOpen Hub: RequestsRSBREQUID3RDOpen Hub: Status of 3rd Party RequestsRSBREQUIDRUNOpen Hub: Table with Status for a RequestRSBSTRUCTUREOpen Hub: Generated Structures and Tables
All the credit go the writer of this article on scn.
Download here: http://gg.gg/nzjk5
https://diarynote-jp.indered.space
In this article, we will list the most Important SAP BW Tables (Business Intelligence Warehouse Tables).
Table Space analysis through DB02 for PSA and Change log deletion strategies.Previous. Screen will give you details of the each process table spaced occupied and values are in MB so you can check and do analysis for particular by clicking double click to check which are the tables and size of the table.
For more information, see Customizing for Extended Warehouse Management under Master Data Production Supply Maintain Product Group Type for PSA Assignment. Assign a product group to the products. On the SAP Easy Access screen, choose Extended Warehouse Management Master Data Product Maintain Product Properties 2. /BIC/B is a standard SAP Table which is used to store PSA for /CPD/PFPDSWBS T90CLNT090 DataSource for WBS data and is available within R/3 SAP systems depending on the version and release level. Below is the standard documentation available and a few details of the fields which make up this Table. . Run ABAP ‘SAPPSAZEROCORRECT’ to correct PSA table with partition number 0. Sometimes, a correction can be made, so the data is still available. If this correction cannot be made, the content is deleted. Clean-up unreferenced PSA metadata objects by using ABAP ‘RSARPSACLEANUPDEFINITION’.
In order to simplify this list, we will divide the list into SAP BW Tables by topics such us: Transfer Structure Tables, Update Rules, InfoPackage, Queries, Workbooks, InfoObject, InfoCube Tables, DataSource, InfoSource tables …SAP BW TablesSAP BW Tables for Transfer Structure
The most important SAP BW Tables for Transfer Structure are SAP Tables DescriptionRSTSTransfer Structure ListRSTSFIELDTransfer Structure fieldsRSTSRULESTransfer Structure rulesRSAROUTTText name of Transfer RoutineDD03TText for R/3 Transfer structure ObjectsSAP BW Tables for Update Rules
The most important SAP BW Tables for Update Rules are SAP Tables DescriptionRSUPDROUTUpdate rules ListRSUPDDATUpdate rules with routinesRSUPDKEYUpdate rule key fieldsRSUPDINFOInfoProvider to Infosource correlation
Read also SAP Info Record Table, Info Record Tcodes and SAP Info Record Report.Embedded ABAP coding for Transfer / Update Rules
The most important Embedded ABAP coding for Transfer / Update Rules are SAP Tables DescriptionRSAABAPABAP source code per object routineInfoPackage Tables in SAP BW
The most important InfoPackage Tables in SAP BW are SAP Tables DescriptionRSLDPIOLinks datasource to infopackagesRSLDPIOTInfoPackage Text DescriptionRSLDPRULEABAP source code for InfoPackagesRSLDPSELHardcoded selections in InfoPackagesRSMONICDPContains the request-id number by data targetRSPAKPOSList of InfoPackage Groups / InfoPackagesSAP Process Chain Tables
The most important Process Chain Tables in SAP BW are SAP Tables DescriptionRSEVENTCHAINEvent Chain Processing Event TableRSEVENTHEADHeader for the event chainRSEVENTHEADTHeader for the event chainRSPCCHAINProcess chain detailsRSPCCHAINATTRAttributes for a Process ChainRSPCCHAINEVENTSMultiple Events with Process ChainsRSPCCHAINTTexts for ChainRSPCCOMMANDLOGSystem Command Execution Logs (Process Chains)RSPCLOGCHAINCross-Table Log ID / Chain IDRSPCLOGSApplication Logs for the Process ChainsRSPCPROCESSLOGLogs for the Chain RunsRSPCRUNVARIABLESVariables for Process Chains for RuntimeRSPC_MONITORMonitor individual process chainsQuery Tables in SAP BW
The most important Queries Tables in SAP BW areSap Pa Psa Table SAP Tables DescriptionRSZELTDIRDirectory of the reporting component elementsRSZELTTXTTexts of reporting component elementsRSZELTXREFDirectory of query element referencesRSRREPDIRDirectory of all reports (Query GENUNIID)RSZCOMPDIRDirectory of reporting componentsRSZRANGESelection specification for an elementRSZSELECTSelection properties of an elementRSZELTDIRDirectory of the reporting component elementsRSZCOMPICAssignment reuseable component < -> InfoCubeRSZELTPRIOPrioritifes with element collisionsRSZELTPROPElement properties (settings)RSZELTATTRAttribute selection per dimension elementRSZCALCDefinition of a formula elementRSZCELQuery Designer: Directory of CellsRSZGLOBVGlobal Variables in ReportingRSZCHANGESChange history of reporting componentsWorkbooks SAP Tables DescriptionRSRWBINDEXList of binary large objects (Excel workbooks)RSRWBINDEXTTitles of binary objects (Excel workbooks)RSRWBSTOREStorage for binary large objects (Excel workbooks)RSRWBTEMPLATEAssignment of Excel workbooks as personal templatesRSRWORKBOOKWhere-used list for reports in workbooksWeb templates SAP Tables DescriptionRSZWOBJStorage of the Web ObjectsRSZWOBJTXTTexts for Templates/Items/ViewsRSZWOBJXREFStructure of the BW Objects in a TemplateRSZWTEMPLATEHeader Table for BW HTML TemplatesInfoObject SAP Tables DescriptionRSDIOBJDirectory of all InfoObjectsRSDIOBJTTexts of InfoObjectsRSDIOBJDirectory of all InfoObjectsRSDIOBJTTexts of InfoObjectsRSDATRNAVNavigation AttributesRSDATRNAVTNavigation AttributesRSDBCHATRMaster Data AttributesRSDCHABASBasic CharacteristicsRSDCHACharacteristics CatalogRSDDPAData Package CharacteristicRSDIOBJCMPDependencies of InfoObjectsRSKYFKey FiguresRSDTIMTime CharacteristicsRSDUNIUnitsInfoCube Tables in SAP BW SAP Tables DescriptionRSDCUBEDirectory of InfoCubesRSDCUBETTexts on InfoCubesRSDCUBEIOBJObjects per InfoCube (where-used list)RSDDIMEDirectory of DimensionsRSDDIMETTexts on DimensionsRSDDIMEIOBJInfoObjects for each Dimension (Where-Used List)RSDCUBEMULTIInfoCubes involved in a MultiCubeRSDICMULTIIOBJMultiProvider: Selection/Identification of InfoObjectsRSDICHAPROCharacteristic Properties Specific to an InfoCubeRSDIKYFPROFlag Properties Specific to an InfoCubeRSDICVALIOBJInfoObjects of the Stock Validity Table for the InfoCubeAggregate Tables in SAP BW SAP Tables DescriptionRSDDAGGRDIRDirectory of AggregatesRSDDAGGRCOMPDescription of AggregatesRSDDAGGRTText on AggregatesRSDDAGGLTDirectory of the aggregates and textsODS Object SAP Tables DescriptionRSDODSODirectory of all ODS ObjectsRSDODSOTTexts of all ODS ObjectsRSDODSOIOBJInfoObjects of ODS ObjectsRSDODSOATRNAVNavigation Attributes for ODS ObjectRSDODSOTABLDirectory of all ODS Object TablesPSA Tables in SAP BW SAP Tables DescriptionRSTSODSDirectory of all PSA TablesDataSource (= OLTP Source) SAP Tables DescriptionROOSOURCEHeader Table for SAP BW DataSources (SAP Source System/BW System)RODELTAMBW Delta Procedure (SAP Source System)RSOLTPSOURCEReplication Table for DataSources in BWInfoSource SAP Tables DescriptionRSISDirectory of InfoSources with Flexible UpdateRSISTTexts on InfoSources with Flexible UpdateRSISFIELDInfoObjects of an InfoSourceCommunications Structure SAP Tables DescriptionRSKSCommunications Structure for InfoSources with Flexible UpdateRSKSCommunications Structure (View) for Attributes for an InfoSource with Direct UpdateRSKSFIELDTexts on InfoSources with Flexible UpdateRSISFIELDInfoObjects of an InfoSource with Flexible UpdateTransfer StructureSap Psa Table Ideas
The main Transfer Structure Tables in SAP Business Warehouse are SAP Tables DescriptionRSTSTransfer Structure in SAP BWROOSGENGenerated Objects for a DataSourceMapping
The main Mapping Tables in SAP Business Warehouse are SAP Tables DescriptionRSISOSMAPMapping Between InfoSources and DataSources (=OLTP Sources)RSOSFIELDMAPMapping Between DataSource Fields and InfoObjectsInfoSpoke
The main InfoSpoke Tables in SAP Business Warehouse are SAP Tables DescriptionRSBSPOKESELSETInfoSpoke Directory and Selection OptionsRSBSPOKEVSELSETInfoSpoke Directory with Selection Options and VersioningRSBSPOKEList of all InfoSpokes with attributes maintainedRSBSPOKETList of all InfoSpokes with the ShortRSBSTEPIDMESSContains all the messages that have been recorded during the execution of an InfoSpokeSap Se16n Table ListSap Bw Psa TableSAP BW Statistics SAP Tables DescriptionRSDDSTATBasic Table for InfoCubes/QueriesRSDDSTATAGGRDetail Table for Aggregate SetupRSDDSTATAGGRDEFDetail Table of Navigation for each InfoCube/QueryRSDDSTATCONDInfoCube CompressionRSDDSTATDELEInfoCube DeletionsRSDDSTATWHMWarehouse ManagementOther useful SAP BW Tables
In this part, you will find a list of interesting and useful SAP Tables in BW.Sap Bw Psa Table Size SAP Tables DescriptionRSFECBW Frontend Check. Useful for checking the installed SAP GUI versions on user machines.RSSELDONEInfoPackage selection and job programRSPSADELPSA Table deletionTBTCPJob Schedule DefinitionTBTCOJob Schedule ResultRSMONMESSMonitor MessagesRSERRORLOGCheck loading errors in tableV_RSZGLOBVReport Variables view tableDEVACCESSDeveloper Keys tableTSTCAll Transactions in the systemRSDDAGGRDIRDirectory of the aggregatesROIDOCPRMSControl parameters for data transfer from the source systemSMEN_BUFFCObjects in User’s FavoritesTSTCTTransaction Codes with TextDD03Lfield names and corresponding data element namesDD03LTDescription of each data elementDD02LAll SAP Defined Table NamesDD02LTDescription of All SAP Defined Table NamesSAP BW Tables for Web Item SAP Tables DescriptionRSZWITEMHeader Table for BW Web ItemsRSZWMDITEMBW Web Metadata: Template Item Dataprovider& ItemRSZWITEMXREFCross Reference of Web ItemsRSZWMIMEIOBUFFERBuffer for Translation MIME Rep. to IORSZWOBJStorage of the Web ObjectsRSZWOBJTXTTexts of Templates/Items/ViewsRSZWOBJXREFStructure of the BW Objects in a TemplateRSZWTEMPLATEHeader Table for BW HTML TemplatesArchiving Tables in SAP BW
The main Archiving Tables in SAP Business Warehouse are SAP Tables DescriptionRSARCHIPROBW Archiving: General Archiving PropertiesRSARCHIPROIOBJBW Archiving: General Archiving PropertiesRSARCHIPROLOCBW ARchiving: General Local PropertiesRSARCHIPROLOCSELBW Archiving: Archived Data AreaRSARCHIPROPIDBW Archiving: Program References of InfoProviderRSARCHREQBW Archiving: Archiving RequestRSARCHREQFILESBW Archiving: Verfified Archive FilesRSARCHREQSELBW Archiving: Request-SelectionsOpen Hub Destination SAP Tables DescriptionRSBOHSERVICETPOpen Hub: Service TypesRSBREQUESTDELTAOpen Hub: Cross Reference Outbound/InboundRSBREQUESTMESSOpen Hub: Log for a RequestRSBREQUIDOpen Hub: RequestsRSBREQUID3RDOpen Hub: Status of 3rd Party RequestsRSBREQUIDRUNOpen Hub: Table with Status for a RequestRSBSTRUCTUREOpen Hub: Generated Structures and Tables
All the credit go the writer of this article on scn.
Download here: http://gg.gg/nzjk5
https://diarynote-jp.indered.space
コメント