How to import master data of Chart of Accounts into public dimension in SAP Analytics Cloud?

[former_member734596]

Dear colleagues,

I`m trying to understand how to use Business Content by SAP Analytics Cloud, some FI content in particular (Finance, model SAP__FI_GEN_IM_GENERALLEDGER). It was said in SAP Help that I can change master data in SAP_FI_GEN_GLACCOUNT (this is account dimension in the mentioned model) if needed. For that I can use "API_GLACCOUNTINCHARTOFACCOUNTS_SRV" OData service but I don`t really understand how I can retrieve data from S/4HANA using it. I know how to consume CDS views but it seems to be something different. All I found on that is A_GLAccountInChartOfAccounts (which was transformed by me into consumption CDS with mistakes), it is somehow connected with the mentioned OData service.

The question is how to use API_GLACCOUNTINCHARTOFACCOUNTS_SRV to retrieve master data of CAO and update public account dimension SAP_FI_GEN_GLACCOUNT? Is there any other way of retrieving master data of CAO from S/4HANA?

[MKreitlein · Accepted solution]

Hello Mikhail,

check t-code /IWFND/MAINT_SERVICE if the APIs are visible of if you need to activate them:

If they are visible here and active then you should find these in your SAC system connection to S4.

BR, Martin

[former_member734596 · Accepted solution]

Hello Martin,

Thanks a lot for your advice. The problem was that I didn`t make an OData service for "API_GLACCOUNTINCHARTOFACCOUNTS_SRV".

One needs to add an OData service for this API. For that one should use /n/IWFND/MAINT_SERVICE T-code sent by you, press "Add services", choose Sytsem alias and press "Get services", find API in Backend services and press on it.

Best Regards,

Mikhail

[MKreitlein]

Hello Mikhail,

this SAP Help Page explains all the details... more or less extensively:

https://help.sap.com/viewer/14010130de914754a17a040ad65614c5/1809.002/en-US/d049240bc02d4b2abca6632b...

You should go through all and then come back an ask again, what in detail you don't unterstand yet or where problems occur.

BR, Martin

[former_member734596]

Hello Martin,

Thanks a lot for your response. I`ve read SAP Help page sent by you.

I tried to make a query (I need to use API_GLACCOUNTINCHARTOFACCOUNTS_SRV) in SAC using S/4HANA on-premise connection but I didn`t find any APIs or A_* CDS views in the repository at all. Then I copied A_GLAccountInChartOfAccounts that is prebuilt by SAP, made my own Z_* CDS view on the top of it and granted myself an authorization. It didn`t work so I made an API state released and changed VDM.view type from BASIC to CONSUMPTION. But that didn`t solve the problem. I also tried to release my Z_* CDS view with an OData service but that didn`t help.

How can I use APIs or make them visible in repository? In the video "https://www.youtube.com/watch?v=gIA6qRJ90S4" a colleague is using A_GLAccountInChartOfAccounts for retrieving master data but he didn`t explain how he made it visible in repository. And as I see he uses A_* which is not C_* CDS view type.

Best regards,
Mikhail