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

[appel_solar_dk]

Hi Chaitanya

It could have to do with if SIDs has been generated or not. You need to add a bit more details about how you DSO is set up eg when are SIDs created and if you have a composite provider between the DSO and the query (you should) and if you have flagged user confirmed referential integrity in the composite provider.

Regards Kristian