BEX Query - records are disappearing when i pull cost center field into report

[joseph_reddy88]

Hi,

I have Bex query on composite provider (which is left join between two ADSO'S - Invoice and PO Data). i have cost center, PO number, invoice number,material, material group,vendor,purchase group and Cost center etc in free characteristics. Query is running fine getting the required output .But when i pull the Cost center into the rows, all the output records in the report getting disappearing. cost center and controlling area is mapped from left ADSO (Invoice) . Screenshot- costcenter-issue.png

Any one faced same issue? is there any reason? solution will be helpful.

we are on BW7.4 SPS10.

Thanks,

Joseph

[joseph_reddy88 · Accepted solution]

This got solved. When i assigned dummy value(DUMMY) for all the Nulls/blank records in cost center field routine.