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!