Skip to main content

Team,

We have to write a code for threshold which can be read as -

--Any transaction with an amount (the total of debit line items in a transaction) if less than 1000 then threshold would be <1000, if the amount is less than 5000 then it would be <5000 else >5000.

 

-- We code it with PU_SUM but the concern is that the threshold is getting applied on the total absolute amount (i:e total of debit and credit of a transaction) and then the threshold is getting applied which is not correct.

 

INSTEAD IT SHOULD SAY IF THE FIELD IN BSEG.SHKZG IS "H" THEN TOTAL OF AMOUNT FIELD CORRESPONDING TO "H" FIELD IN BSEG.SHKZG AND THEN THE THRESHOLD CODE SHOULD BE APPLIED IN CONJUNCTION WITH "H" FIELD .

 

ANY HELP WOULD BE REALLY GREAT.

 

THANKS.

ANKUR

 

Hello Ankur,

 

Do you have a filter argument in your PU_SUM? For example, the PQL below sums up WRBTR to BKPF, but only if SHKZG = H. If ZHKZG is not H, then that specific BSEG record is not factored. Does this resolve your inquiry?

 

PU_SUM(BKPF,BSEG.WRBTR,BSEG.SHKZG = 'H')


Reply