Showing results for 
Search instead for 
Did you mean: 


0 Kudos

It has been a long time SAP release this program to cover MX DIOT report for Mexico.

However I not feel very confident it is working or fixed now. (2017)

Does someone have documentation for this old program?

There is no documentation on SAP Notes. (no clear documentation)


After some debugging we could find tables MXTVO and T007k should be filled in specific order that are not really clear.

We are pretty sure we have setup RFUMSV25 program correctly and our tax codes (origin and target) has been customized correctly (even the table BSET is working properly)

How to fill tables MXTVO and T007k tables?

It is another hide table to be filled?

Why the output list is so different from the txt file output?

(there are missing vendors)

After guessing we should made the following entries on MXTVO

3 - N03 (For Services)

85 - N85 (General Others)

And is specific order we supposed...

MX N03 S0 VST 15 (origyn)
MX N03 S1 VST 16 (origyn)

MX N03 SE VST 17 (origyn)

MX N03 T0 VST 18 (target)

MX N03 T1 VST 19 (target)

MX N03 TE VST 20 (target)

MX N85 V0 VST 21 (origyn)

MX N85 V1 VST 22 (origyn)

MX N85 VE VST 23 (origyn)

MX N85 W0 VST 24 (target)
MX N85 W1 VST 25 (target)
MX N85 WE VST 26 (target)

After some testing most of the documents (invoice with taxes already cleared) appear on the output report but not in the txt file!

Many thanks for your help

View Entire Topic
0 Kudos

Just updating the issue

SAP Notes relevant for DIOT 2014 were update on: 11.09.2017

2468616 - FAQ of Mexico's A29 DIOT report


There are some key features to take into account in this solution:

- MXTVO is a table were you define the business transaction (general, services, leassing)

- In table T007K you define the target tax code (the right column number should be taked from DIOT definition)

- Amounts are grouped by RFC in local currency (company code currency MXN); remember to post F.38 using the exchange rate currency from the payment

- Only the bases appear on the DIOT file

- The creation of new tax codes does not apply at all in the newest versio (old approach)

- Each vendor should be classify according the MXTVO (otherwise cannot be displayed in the DIOT); I could not update massively at least on S4 HANA version (business partner functions are not update at all; surprisingly say Corea business transaction)

After some testing the parameters are:

-> Enter the document type used for deferral tax (create a specific one is useful)

-> Enter the document type for invoices (accounts payable)

-> Enter the document type for credit notes (accounts payable)

There are some issues that I found in the standard solution but there not see solution by SAP in the future:

- You classify the vendor by business transaction (general, leassing, honorarios, etc.).

However in the practice, a vendor could issue invoices for two o more concepts; therefor there are a risk to classify incorrectly the ammounts in the DIOT

- The program is based on clearing (such as RFUMSV25 program); therefore the program cannot differenciate from a clearing against a bank from a manual clearing

For example if you post a MR8M, the DIOT program takes the amount as a "credit note" more than a reverse.

In fact if you post reverse these are not different from a credit note.

- I cannot display 0% base

- The program is focused in creating the file (not to provide a conciliation report; no payment document appears; so you cannot be enough confident the balance is from payed line items)

Let's stay tune whether new SAP notes corrections appear

It is not clear also if sometime in the future a DPIVA solution will be available in the future.

Best Regards