Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Suppress zero-net records from reports

Hello experts,

I need to suppress zero netting records with matching key (contract, LOB, Type) from my BEx report (running from an ODS). As an example the following records in the ODS net to zero, so they need to be suppressed from showing in my report.

Contract LOB Type Amount

12345 1234 3456 1000.00

12345 1234 3456 -500.00

12345 1234 3456 -500.00

How can these records be suppressed in BEx? (I have tried using a condition, but it looks at single records and does not compare records.)

If this needs to be done in a user exit, please show the ABAP code and explain how the exit can be linked to the BEx report.

Highest regards,

Tom

Former Member replied

It does not matter what they are, it will still use zero suppression. With key figures and characteristic type structures, you must make sure to check the allow zero suppression box in the properties of the structure(s).

Thanks,

Jeff

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question