SAP Knowledge Base Article - Public

3330317 - Mexico DIOT Report Displays Information Message: “No items to report;Query DOC_SEL did not return any data” With the Supplier Summary File Size 0 Byte

Symptom

Upon executing the Mexico DIOT Report, the system does not return any data. Mexico DIOT Report Displays the below information message and further, the Supplier summary file is of size 0 Byte

No items to report;Query DOC_SEL did not return any data

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  1. Go to the app Run Statutory Reports
  2. Choose the Filters
  3. Report Name: MX_VAT_DCL – Mexico DIOT Report
  4. Reporting Year: XXXX
  5. Click the required entry for Reporting Period: YYYYY
  6. In the Current Phases tab, click the Mexico Monthly VAT Report With Reported Item Log Information
  7. At the top right corner, click the button New Run
  8. In the Selection Criteria for Mexico Monthly VAT Report With Reported Item Log Information, select as below:
  9. Company Code: XYZ
  10. Reporting Date: DD.MM.YYYY – DD1.MM1.YYYY1
  11. Run Options: Start a Short Run Now (Less than 3 Minutes)
  12. Click on Run
  13. The Run is Generated Successfully
  14. Click open the Report Run Status
  15. In the Legal Reporting section, the Document: Supplier summary file is of size 0 Byte
  16. At the bottom of the screen, in the Log, you see the Information message

where XXXX represents the Reporting Year
YYYYY represents the Reporting Period

Cause

The field Type of Business is not maintained in the Vendor: Tax Data of the Business Partner. 

  1. Go to the app Maintain Business Partner
  2. Find the Supplier ID
  3. Display in BP role: FLVN00 Supplier (Fin.Accounting)
  4. Go to the tab Vendor: Tax Data
  5. In the section Tax Calculation Korea, the field Type of Business is empty

Resolution

Type of Business field informs the business type you have configured for your supplier in the Define Transaction Types for Vendors (SSCUI ID - 105629) customizing activity. 
You may define the Types of Business in the SSCUI ID – 103052

Once you have defined the Type of Business for your vendor that is applicable for DIOT report, you will be able to generate a file with entries.

Note:
Business type is used to determine two important information for the vendor in the DIOT report: vendor transaction types and VAT group version (tax box) to be considered. One business type is used to derive one or multiple transaction types - (each transaction type is then assigned to a VAT group version)

Single transaction type means that the vendor only provides me one type of service / product, for instance: 3 - Professional Services
On other hand, multiple transaction types means that the vendor provides me more than one type of service / product, for instance: 3 - Professional Services and 6 - Real Estate Lease.

You must enter the Type of Business with numbers 11, 12, 13, 14, 15, 21, 22, 23 and 24.

Go to the BP transaction and assign the business type to your vendor according to the following rule: 

  1. Use a business type with numbers from 11 to 15 when you want to maintain a single transaction type for each one of your vendors.
  2. Use a business type with numbers from 21 to 24 when you want to maintain multiple transaction types for each one of your vendors. 

You can assign a grouping version for each transaction type according to your monthly VAT returns.
You can use the following values as a template to group your transaction types: 

Transaction Type

Number of Grouping Version

Professional Services

N03

Real Estate Lease

N06

Others

N85

Acquisition of Other Intangible Goods

F29

  

Example

Here's an example of mapping that you can use as a template for your configuration:

Define Transaction Types for Vendors - (SSCUI ID - 105629)

Transaction Type

Number of Grouping Version

Ord. (Business Type)

85 Others

N85

11

85 Others

N85

12

03 Professional Services

N03

13

06 Real Estate Lease

N06

14

29 Acquisition of Other Intangible Goods

F29

15

03 Professional Services

N03

21

85 Others

N85

21

06 Real Estate Lease

N06

22

85 Others

N85

22

03 Professional Services

N03

23

06 Real Estate Lease

N06

23

29 Acquisition of Other Intangible Goods

N29

24

85 Others

F85

24

 

See Also

Mexico DIOT Report

Configuration for DIOT Report

Keywords

Type of Business, MXTVO, Business Partner, BUSTYPE, Supplier, FIMXV_MXTVO, Maintain Business Partner, Tax Data, Vendor, 105629, Tax Calculation Korea, DIOT Report, Mexico, 103052, No items to report, DOC_SEL, Supplier Summary File, Size, 0 Byte, Zero Byte, Mexico Monthly VAT Report, MX_VAT_DCL, Professional Services, Real Estate Lease, Acquisition of Other Intangible Goods, Others , KBA , LO-MD-BP-VM , Vendor Master , Problem

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions