Asset Register for Income Tax

Im developing report for Asset register. I have to include following fields:

1 Asset no

2 Asset description

3 Posting date

4 Gross value

5 Excise value

6 VAT

7 Net value

I got first 3 fields from ANLA, ANEK tables

also i got link between asset no and Purchase order no through table EKKN

Input for above report :

1. company code

2. Plant

3. Posting period

4. Asset class

<b>Q: From where i do fetch field 4 to 7 and how i link tables?</b>

Helpful Answer