Skip to main content

Hello Community,

I have the following “problem,” or am I misunderstanding something here?

SAP Example 

I have an Sales Order (Table VBAK) with 6 items (Table VBAP). On Item has the Category “TAX” (Field VBAP.PSTYV)

Within the Knowledge Model I have set an global filter FILTER VBAP.PSTYV NOT IN (‘TAX’)

This works as expected and I only see only 5 items when I display the data in flat table or using the count function e.g. COUNT(VBAP.POSNR)

But when I use the PU_COUNT Function PU_COUNT(VBAK, VBAP.POSNR) I get 6 items as result.

My question here: Is this expected behaviour and does PU_FUNCTION ignore global knowledge model filters? Or is this a bug?

Best, Thomas

 

 

 

Hello Thomas,

 

PU-Functions indeed ignore filtering in this way, as stated here:

Pull Up Aggregation 

In contrast to that the Pull-Up-functions ignore the global filter state and are calculated only once.

 

To achieve, what you want to do, you need to include the same filter in the filter-statement of the PU_COUNT-Funtion:

PU_COUNT(VBAK, VBAP.POSNR, VBAP.PSTYV NOT IN (‘TAX’) )

 

Best regards,

Fabian

 

Hello Thomas,

 

PU-Functions indeed ignore filtering in this way, as stated here:

Pull Up Aggregation 

In contrast to that the Pull-Up-functions ignore the global filter state and are calculated only once.

 

To achieve, what you want to do, you need to include the same filter in the filter-statement of the PU_COUNT-Funtion:

PU_COUNT(VBAK, VBAP.POSNR, VBAP.PSTYV NOT IN (‘TAX’) )

 

Best regards,

Fabian

 



Or use the FILTER_TO_NULL statement to apply current Filters to the PU-outcomes: https://docs.celonis.com/en/filter_to_null.html. This is quite memory consuming, so might slow down your calculations at certain points.

Community Code of ConductAccessibility statement