SAP S/4 HANA - Account Import not filtered by LOGS_TABLE_FILTER

[VicyB]

Hello everybody,

in our dev-instance we sucessfully created the connection to the SAP S/4 HANA system.

In the first account import, we wanted to restrict the imported accounts by using the LOGS_TABLE_FILTER. Unfortunately, it showed no effect and the import job basically imported all accounts from the S/4 system including all their tcodes.

Are there any technical situations in which the LOGS_TABLE_FILTER is not applied at all?

Thank you for the information!

[sai_sp]

Hi,

Can you please share the filter you have used in the connector?

[VicyB]

Hi @sai_sp ,

of course! The filter we use is:

{
   "GENERALFILTERS": {
      "ACCOUNTTYPE": [
         "A"
      ],
      "ACCOUNTNAME": [
         "XXXXX",
         "XXXXX" ]
   }
}

- Instead of "XXXXX" we of course entered the account names we want to import - 

[sai_sp · Accepted solution]

Hi @VicyB 

Thank you for the information. This attribute is not to add a filter on importing accounts but is a filter to import logs when we import data from CDHDR and CDPOS tables in SAP. The documentation is misleading and we are working on correcting it. This attribute would not solve your use case to filter the accounts to import and we currently do not support filtering on account in the SAP connector.

[VicyB]

Hi @sai_sp ,

thank you a lot for the clarification! 👍