Navigation attributes can be provided by the external HANA view in case the column view 0BW:BIA:<HCPR> includes the navigation attribute.
preconditions are provided in SAP Note 2211315
Case 1: The navigation attribute is not part of a PartProvider of the CompositeProvider and the PartProvider is not an advanced Datastore Object. Case 2 and 3 do not apply.
Case 2: The CompositeProvider characteristic of the navigation attibute is mapped to a navigation attribute of a PartProvider.
Case 3: The CompositeProvider characteristic of the navigation attibute is mapped to a characteristic of a PartProvider with a different basic characteristic than the basic characteristic of the CompositeProvider characteristic
The external HANA view does not provide those navigation attribute which are mentioned in the different warning as the 0BW:BIA:<HCPR> Column view also does not provide those information. For queries executed directly on the HCPR e.g. via RSRT the system creates 'ON the FLY' a calulation scenario and provide the needed information.
e.g. with example of scenario 3 and HCPR: JK_HCPR_1
Transaction RSRT: JK_HCPR_1/!!aJK_HCPR_1
Execute in debugging and set flag:
switch on the technical information, by pressing two times
Drill down navigation attribute JK_PLANT__0COUNTRY
a join calulation view with source '/BIC/PJKPLANT' and calulation scenario "0BW:BIA:JK_HCPR_1 will be created
- field based aDSO is included in HCPR and the fields are mapped to an infoobject and for that infoobject navigation attributes are switched on
- HANA calculation view is included in HCPR and the fields are mapped to an infoobject and for that infoobject navigation attributes are switched on
Reasons why a join is necessary:
1) column view of the HCPR does not provide the information:
As those navigation attributes are not available in 0BW:BIA_JK_HCPR_1 those navigation attributes are not available in the BW external HANA view as a calculation view 'On the Fly' is not possible.
2) only partial support of the navigation attribute
It is possible that some part providers in the HCPR can supply the navigation attribute. Hence there will be partial support for the navigation attributes which may not require on the fly joins. However the BW external HANA view requires full support of navigation attributes or it cannot add the navigation attribute to the output view.
Inner join to the infoobject in the HCPR level,
Defining a query
The external HANA view
The following error will occur
Technical limitation of the BW external HANA view.