SAC Import Model | Data Filter during Data Import

[SAC_Newbie]

Dear all,

I am creating an import model in SAC which is based on S/4 Public Cloud. I am trying to create a model for cost center planning. During the data load the data should be restricted on "Debit" and "PLCHANGING" only. For this reason I have set the model import filter to "D" (Dimension DEBITCREDITCODE) and "PLCHANGING" for (Dimension GLACCOUNTFLOWTYPE). The "D" can be filtered, but all flow types are loaded. I have tried different constellations of the filter. E.g. only filter the flow type, checking by a single period but the Flow Type Filter does not get applied. Is there any thing I am not doing correctly?

I do not need all the data for other flow types and it would be to tedious to set the filter on report level.

Best

[hartmut_koerner]

I assume you are using OData service UI_FINS_GLACCOUNFLOW with Entity GLAccountBalanceFlow. For me the filtering works. Which S/4HANA backend release are you using?

[SAC_Newbie · Accepted solution]

Dear @hartmut_koerner ,

you are correct. This is the source we are using. Unforunately I do not have the information about the backend as this was developed by an external which is not working with us anymore. Thus I do not even have access to the backend.

I have came to the following : If reduce the volume of the data by just adding a monthly slice to the filter, it will properly apply the filter "PLCHANGING". If I filter the data for one whole year, the "PLCHANGING" will not work anymore. Is there any issue with data volume and filtering, when importing data?

Best

[hartmut_koerner · Accepted solution]

Hi, now I can reproduce the problem. E.g. When I filter for "PLCHANGING" I also get "BSCHANGING", but not other types. Seems to be a bug and you may open a ticket.

[hartmut_koerner · Accepted solution]

Hi, I got confirmation from the responsible developer that this is a bug. But there is a workaround: Use instead filter on GLAccountFlowType and IsBalanceSheetAccount.