Bex report on ADSO, not showing null values records

[former_member219894]

Hi,

We have created an ADSO and created a bex query, when we run the query it is NOT returning the records which has blank values in them.

Example

Data in ADSO

Report before adding Contract field into Report layout (Rows)

After adding Contract field into report layout

here we are missing the records which has blank values in Contract, so the total report is showing the incorrect data.

Can someone please help

[falkste]

Hello Chaitanya,

check the query settings for the contract field, if there is the setting active to only show masterdata values only. Then you should switch to display posted values.

Regards Stephan