Skip to Content
Former Member
Nov 24, 2011 at 02:10 PM

Query does not display the code.


Hi Experts,

I created a query joining SKA1 and SKB1 with the following requirements:

Query of the chart of accounts total for each company code with the following additional information:

- reconciliation list: yes or no / for which sub-ledger (cutomer, accounts payable, assets or others)

- binding on interim transaction: yes or no.

I have successfully created a query but instead of displaying the code (for example AA01-company code) the name of the company was displayed.(example: ABS Company) this is also the same with other fields like the GL account, instead of displaying the numerical value, the text description was displayed even if I have selected the correct field assignment (SKB1-BUKRS).

Your inputs are very much appreciated. thanks in advance!