Metadata Extraction from IBP HANA DB

[Former Member]

Hi Team,

We are trying to query the following tables to retrieve key figure metadata:

1. select * from"SAP_SFND"."sap.sop.sopfnd.catalogue::SOPDM_KEYFIGURE" where plarea = 'PA'orderby plarea, kfid
2. select * from"SAP_SFND"."sap.sop.sopfnd.catalogue::SOPCM_KEYFIGCALC" where plarea = 'PA'and kfid like'H%'

Can anyone guide us as to how we can achieve this through HCI?

Regards,

Aditya G

[parveen_kumar6]

Hello Aditya

The metadata/configuration data is specific to the application. How the configuration/metadata is stored in the database will not make sense to external systems.Hence, meta data/configuration tables are not exposed in HCI.

Although there is a database view which contains the tables to be exposed. I will not recommend changing that view to expose the key figure meta data tables. Instead, you can directly export the data out of these tables directly from HANA.

Thanks
Parveen Kumar

[Former Member]

Hi Parveen,

Thanks for your response.

Can you explain what you meant by "Instead, you can directly export the data out of these tables directly from HANA."

How can I export them from HANA? Do I get access to HANA?

Regards,

Aditya G

[parveen_kumar6]

Hello Aditya

I thought you are using an On-premise system as you know the database table names.Hence, I suggested the table export for HANA. You cannot export these tables for cloud based system.

Thanks

Parveen Kumar