How to link GL Account with Cost element category

[former_member553808]

Hi,

I have to generate a report by querying tables SKA1,SKB1,SKAT and CSKB.

Step 1.Firstly I have queried SKA1,

step 2. for the obtained SAKNR(GL Accounts) from step 1,I have queried SKB1 table

step 3. For the obtained SAKNR from step2, I have queried SKAT table.

Now, I have to get KATYP(Cost element category) from CSKB based on the above steps.

Please can you let me know the procedure to fetch the Cost element category(KATYP) from CSKB based on the above 3 steps?

[Former Member]

Hi,

a cost element (primary cost element, thats what we are talkgin about as you want to join them to FI account numbers) is created per controlling area.

If your comp.codes to be reported use different controlling areas you have to identify which controlling area is used for which comp. code (tab. TKA02) and join the skb1 account number to cskb cost element number for reporting the KATYP.

BR Christian