Delete the whole receipt

Question

Hello everybody,I have the following problem. I hope you can help.I would like to use the component filter to hide the documents that have a clearing document.I have no idea for the formula.When I FILTER BSEG. AUGBL = then it only deletes the line for me, but not the entire receipt.Was a formula turned into a formula?Do I have to take GJAHR into account with the formula? Because the document in 2021 does not yet have a clearing document and should not be deleted.image779124 2.89 KBGREETINGS

david.beche12 · Answer

Hi Steven,you can use a PU_COUNT to count the number of clearing documents for each document. If this number of larger than 0, then you have a clearing document. Since you only want to show those documents which do not have a clearing document, you need to filter on those where the PU_COUNT result is 0:FILTER PU_COUNT( "BKPF" , "BSEG"."AUGBL", "BSEG"."AUGBL" != '') = 0;Since usually, BKPF and BSEG are joined also via GJAHR, the year is taken into account here as well.BestDavid

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN