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?