Please find below SE38 ABAP program:- REPORT ZBW_HCPR_CLV.ĭata: l_t_hana_xref type standard table of l_s_objxref_hana,įield-symbols: like line of l_t_hana_xref. This above Stored procedure will be called into SE38 Program via AMDP class. Stored Procedure:- create procedure "_SYS_BIC"."user_space.shankpre::clv_tech_name" ( The below stored procedure will get the desired metadata information for all the calculation view present in the HANA system. The Metadata of Calculation view is present in the Schema “_SYS_BI” view name “BIMC_ALL_CUBES”. In this program we are calling the AMDP Class. ABAP Program (Main program) where user input the system generate calculation view name (2H*) and gets the actual Calculation View name.An AMDP Class (created in ABAP Perspective) with Method to call the stored procedure. A Stored Procedure to get the Meta data information of Calculation View.We end up creating a report in ABAP which inside looks in HANA database tables/views by calling a AMDP Script and HANA Stored Procedure.įor this solution a small set of development is required:. Hence, we are looking for a solution which combines both ABAP and HANA to find the required meaningful information. The generated name 2H* is in ABAP layer metadata and the Actual Calculation View Name is present in the HANA Metadata. This is not a meaningful Information for a BW Developer and to find out the actual name of the Calculation View leads to the below development The InfoProvider here is a calculation View and instead of its technical Name the report shows a system generated Name 2H*. Scenario:We had created a S/4HANA Report based on a Transient Provider and when checking for InfoProvider report gives a System Generated Tech name 2H*. Below is one Scenario we have faced in our Project. In Mixed modelling Scenario calling a Stored Procedure from SAP Application can also be a good approach. Stored Procedures allows to group the SQL statement into a single block and can return data in the form of output parameters. Stored Procedure are frequently used Objects in SAP HANA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |