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?

[N1kh1l]

@SAC_Newbie 

The filters looks fine to me. Do you mean to say with the Debit/Credit code set to "D" and Gl Account Flow Type set to "CHANGING", its still loading other Flow Type Data. Could you show how the next screen of the query looks like. You can also filter on the query screen transformation but this should have worked fine.

Nikhil

[SAC_Newbie]

Correct! It is loading other data as well. How can I do the filtering in the transformation screen? I cannot provide it as we have company restrictions