BW4HANA Query field value showing #

[former_member746094]

I have build a query, but I found some of the value is showing #/ . e.g Profit Center, Cost Center, G/L Account

[rathy_moorthy2]

yes, those fields are compounded fields. The compounded values are # and hence showing so. you can refer the backend master data for these columns to get more clarity

Regards,

Rathy

[former_member746094]

Hi Rathy,

I loaded the master data text to these columns e.g G/L Account, but the compounded values still showing #...

Regards,

Jacky

[DotEiserman]

Hi Jacky,

Typically you would load the Chart Of Accounts column for GL Account (the two are compounded meaning that it requires the Chart of Accounts value to uniquely identify the GL Account), and Cost Center and Profit Center require Controlling Area. I don't see these compounded columns in your screenshots. Can you check?

Thanks

Dot