tables for parked invoice

[former_member623831]

Dear Gurus,

May I know the tables for the print preview related to taxes for parked Invoices

[sanilbhandari]

Hi patt2019

The tax is not calculated unless the invoice is posted. You will only find one single line item for vendor created and the same would be available in VBEGK. Once the MIR7 information is parked, you can check the follow up document in MIR4. The document no of the follow document would be available in BKPF and VBSEGK tables. This is a standard SAP behaviour for LIV, which are parked.

Thanks & Regards

Sanil Bhandari

[former_member623831]

Dear Sir,

Thank you for your response but the client requirement is that he is going to check all the taxes calculated and then he is going to post the document.

So can this made possible in print preview , if the taxes go wrong before posting, wrong postings will be done.

[sanilbhandari]

Hi patt2019

There is no data in the underlying tables that you can take a print out with tax amounts.

If the concern is on wrong posting, why don't you consider implementing workflow, so that one user parks the document and other verifies and posts it. This is pretty much what would be done with the print out as well. Why not control it through the system? It will enable better monitoring and system based controls. It will also be environment friendly, since you will save paper 🙂

You will find lot of posts on SAP Community to enable workflow for MIRO/MIR7. One of the link is below:

https://answers.sap.com/questions/2941993/workflow-for-miro.html

Hope this helps.

Thanks & Regards

Sanil Bhandari

[former_member623831]

Dear Sanil,

Thank you very much for your wonderful guidance.

[former_member623831]

Dear Sanil,

May I know where the data is stored as in which table when the document is parked for the print preview which calculates the taxes.

Please help ASAP.

[sanilbhandari]

Hello patt2019

I have already informed you that that the parked document of MIR7 is updated in data base table with a vendor line item in tables BKPF and VBESGK with a single line item for Vendor only. This is how standard SAP transaction works. The data of tax in simulation is called through a function module and tax is calculated only, but not updated in the database. So I cannot give you the table name.

This also why i suggested to look at the possibility of implementing workflow in LIV

Thanks & Regards

Sanil Bhandari

[former_member623831]

Dear Sanil,

It is called through which function module , the data for the taxes ?

[sanilbhandari]

Hi patt2019

I am not sure of the exact FM. You might want to debug and check. As far as I know one of the below FM is used.

CALCULATE_TAXES_GROSS

CALCULATE_TAXES_NET

CALCULATE_TAX_DOCUMENT

CALCULATE_TAX_DOCUMENT_START

CALCULATE_TAX_FROM_GROSSAMOUNT

CALCULATE_TAX_FROM_NET_AMOUNT

CALCULATE_TAX_ITEM

Thanks & Regards

Sanil Bhandari

[former_member623831]

Dear Sanil,

Highly obliged with your wonderful guidance

Going through each functional module will be cumbersome.

Please let us know which functional module according to you will have which will have the gst tax amount and its parameters as we have a project deadline.

[sanilbhandari]

Hello patt2019

I do not know what is the code written behind in MIRO/MIR7. I know some of the FM that i am aware of. The same has been shared already.

You need to debug and check the same !

Thanks & regards

Sanil Bhandari