If you are using a Hana database, you can use the setting Master Data Access = 'SAP Hana View' to create virtual master data. This means that the master data is not stored in the classic P/Q/X/Y tables but in a Hana View which is assigned to the InfoObject.
Transaction RSD1 → tab Master Data/Texts
SAP Hana Studio:
In principle you can use Hana attribute views, analysis views and calculation views, but it is rather recommended to use calculation views of the type Dimension.
As explained in note 2479940, with regard to their flexibility, convenience and BW query runtime, InfoObjects based on an SAP HANA view are not comparable with InfoObjects with generic master data access, since the master data is not controlled by BW. Due to this restrictions, it is recommended that you use InfoObjects based on an SAP HANA model rather in execptional cases.
Important to know
- Review note 2479940 - Restrictions for InfoObjects based on SAP HANA model
- If master data based on a HanaView is used, you need to assure that the data stored in the Hana tables complies with the standard which exists for master data in BW. E.g. uniqueness has to be guaranteed in order to avoid incorrect/confusing query results! See Example IV. Note 2772010 provides an RSADMIN parameter with which you can check the existence of duplicates during query runtime(in order to avoid the display of incorrect query results).
- In case of time-dependent attributes please check Example V:
- You need to ensure a consistent state between the master data available in the HANA View and the values booked in BW providers, see note 2538757 for details.
- In order to create SIDs for new master data values (not yet known by BW) use report RSPLS_CREATE_MISSING_SIDS, see also 2538757
- If master data based on a HanaView is used, the data stored in the Hana tables should comply with the data type of the InfoObject. See 2192217. If conversion routine is set on the InfoObject, all data stored in the Hana tables should complie with it. For example, if Alpha routine is set for the InfoObject, all values need to be padded with leading 0s. Otherwise report RSPLS_CREATE_MISSING_SIDS will fail.
- F4 Help
- Example I: Missing values in the F4 help
- Example II: Characteristic with Texts
- Example III: Missing values for navigation attributes
- Example IV: Incorrect query result due to inconsistent data records in the Hana View
- Example V: Time-Dependent Master Data
- Example VI: Characteristic with Language Dependent Texts
SAP Online Documentation
SAP Consulting Notes
- 2538757 - Virtual Master Data based on SAP HANA View - Frequent Issues and Questions
- 2479940 - Restrictions for InfoObjects based on SAP HANA model
- 2772010 - Master data access SAP HANA View: Duplicates
- 2192217 - BRAIN019 when Activate Hierarchy on a NUMC/DATS/TIMS Characteristic with Master Data Access using SAP HANA View
- 2035645 - How to map description of attribute in HANA View
- 2718912 - Input help and maintainability SQL statement for SAP HANA views is not displayed