Query does not display the code.

[Former Member]

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!

[Former Member]

Hi, go to sq01, then put query name, and press InfoSet query, then select required field and choose eg Show Value

[Former Member]

Hi,

Are you creating this query under SQVI TCode?

Because when i am doing the same thing... its working. i can see he company code coming up as AA01.

SKB1-BUKRS is for Company code number... then how it can display Company code Description.

Best Regards

Guneetinder