How to Display GL Accounts without Chart of Account Prefix

[former_member690380]

Hello,

I have a BW Query that has accounts in row axis. But it gets displayed with Chart of Accounts as a prefix in the excel workbook. How do I remove the prefix? In the example below, C001 is chart of accounts, 6010 is the account number. Thanks

[bhavinvyas · Accepted solution]

Hi Manish,

Place charts of account ablove GL Account in Rows section of Query and Hide Charts of account from propert.

You can refer this blog for steps,

https://blogs.sap.com/2013/10/22/how-to-hide-compounding-object-from-bex-display/

Thanks,

Bhavin

[former_member690380 · Accepted solution]

Thank you Bhavin for pointing me in the right direction.

[xiaofang_liu]

Hello

Please just use COA as static filters.

[former_member673162]

Hi Manish, Try to add the chart of accounts in-front of the account number but make sure you hide the chart of accounts.

Thanks