Importing Actuals from ACDOCA table into SAC using API

[phadke_manas]

Hello Experts,

We have a requirement to fetch Actuals data for certain expenses from the ACDOCA table in S/4 HANA into SAC. Preferred approach is to use any existing API's to import the required transaction data at Company code, Cost Center, G/L account level. We found the OData service API_JOURNALENTRYITEMBASIC_SRV (Journal Entry Item - Read (A2X)) in the help documentation. However this API is not available for the S/4HANA Private Cloud Edition version 1909 in the Business Accelerator Hub.
Is there any other OData service that we can use to import the Actual transaction data from ACDOCA into SAC?
If not an API, what other options are available for meeting our requirement considering there's no SAP BW or Datasphere in the client IT landscape?

Regards,

Manas

[Susanne_Helbig · Accepted solution]

Dear @phadke_manas,

it looks like the documentation in the Business Accelerator Hub is not available before 2020 FSP2, but actually the API is available in S/4HANA Private Cloud Edition version 1909.
To activate and integrate the service, please follow the instructions in the SAP Help portal 

Once the service is active you can set up a connection in the SAP Analytics Cloud, for details see Maintaining the SAP S/4HANA Connection Within SAP Analytics Cloud and import your master and transaction data.

Best regards
Susanne

[phadke_manas · Accepted solution]

Thanks @Susanne_Helbig , we'll activate the API in S/4 and test if we're able to extract the required data

Just to confirm, the query A_JournalEntryItemBasic extracts Actuals data from ACDOCA table in S/4? Reason I want to confirm is because I'm unable to select certain GL accounts in the query filter even though there is data on those GL accounts in the ACDOCA table.

[Susanne_Helbig · Accepted solution]

Hi @phadke_manas,

yes A_JournalEntryItemBasic extracts data from ACDOCA. The selection of filter values is independent of data records in the table, means you should be able to select accounts even if there is no data available in ACDOCA.
Maybe the following documentation helps you Importing Actual Data and Predictive Accounting Data to SAP Analytics Cloud

One reason why the account might not appear could be, that the account is in a different chart of account.

Best regards
Susanne

[phadke_manas · Accepted solution]

@Susanne_Helbig The issue with the G/L Account filters is a strange one, I had to manually type in the accounts with a ; separator since the required accounts were not showing up when searching in the filter. Many thanks for your inputs, I was able to import the Actuals data successfully using the query.