Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Tax conditions in purchase register report

pradeep_reddy17
Participant
0 Kudos

Hi all,

I am developing a Purchase Register Report, I have a small doubt regarding Tax conditions.

From which tables we will get the Tax Conditions like CST, SERVICE TAX, VAT etc.

Previously I have developed Purchase Requisition Report,in that I have used the FM    'CALCULATE_TAX_ITEM' to get the Tax Condition Values. But in this purchase register report I am getting wrong values for the same FM.

Please suggest me.

Regards,

Pradeep.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Pradeep,

First of all let me clarify that you are generating report for Purchase orders generated or for MIRO posted documents

If you are generating for purchase orders

  • First use FM 'REFRESH_TAX_TABLES' for updating tax tables with latest changes
  • Next use FM 'FIND_TAX_SPREADSHEET' to find out tax procedure or schema
  • Then use FM 'CALCULATE_TAX_ITEM' to get taxes

If you are generating report for MIRO documents

  • Use BSET table for accounting document generated against MIRO

Regards

Krishna

4 REPLIES 4

k_k33
Explorer
0 Kudos

Check

KONV

KONP

KOMV

T007*

Excise Duty - Table J_1IMATEXP ,J_1IMTCHID

for Tax - Table BSET

Tax table

Former Member
0 Kudos

Hi Pradeep,

First of all let me clarify that you are generating report for Purchase orders generated or for MIRO posted documents

If you are generating for purchase orders

  • First use FM 'REFRESH_TAX_TABLES' for updating tax tables with latest changes
  • Next use FM 'FIND_TAX_SPREADSHEET' to find out tax procedure or schema
  • Then use FM 'CALCULATE_TAX_ITEM' to get taxes

If you are generating report for MIRO documents

  • Use BSET table for accounting document generated against MIRO

Regards

Krishna

former_member183425
Participant
0 Kudos

Hi Pradeep,

According to Krishna, get the fields like VAT, CST, SERVICE TAX  from BSET Table.

And get FRIGHT from RSEG Table.

Regards,

G S Ramanjaneyulu.

pradeep_reddy17
Participant
0 Kudos

Thank you all,

I have solved this issue..

Regards,

Pradeep.