Skip to Content
Apr 09, 2009 at 10:17 AM

How to link GL Account with Cost element category



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?