Symptom
- Error message SRF_GENERATION019 - "No items to report; Query DOC_SEL did not return any data" occurs when executing TH_WHT_50BIS report via Run Statutory Report App.
- No data is retrieved in TH_WHT_50BIS report.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the app Run Statutory Reports.
- Select report name TH_WHT_50BIS and the relevant reporting year.
- Open the desired period (for example, a specific month).
- Choose New Run.
- Enter company code, posting date range, business place, and address language.
- Under Run Options, choose Start a Short Run Now (Less than 3 Minutes).
- Choose Run and observe that the run is generated with errors and shows: "No items to report; Query DOC_SEL did not return any data."
- Verify in Manage Supplier Line Items that withholding tax records exist for the same company code and period.
Cause
The error happens due to some possible reasons as below:
- The WHT type input in the invoice document is maintained for payment posting.
- The income type maintained for the corresponding WHT codes in configuration activity 104227 - Define Withholding Tax Codes does not belong to the supported list as outlined in Income Types to Report in Pre-Printed Legal Forms | SAP Help Portal.
Resolution
- In case the WHT type is maintained for payment posting, only the payments for the corresponding invoice document is retrieved in the TH_WHT_50BIS report. This is a standard system behavior.
- Maintain the income types included in Income Types to Report in Pre-Printed Legal Forms | SAP Help Portal for the corresponding WHT codes. Any other income types are excluded from the TH_WHT_50BIS report.
See Also
Refer to SAP Help Portal: Income Types to Report in Pre-Printed Legal Forms | SAP Help Portal
Keywords
TH_WHT_50BIS, statutory report empty, SRF_GENERATION019, no items to report, query DOC_SEL did not return any data, generated with errors, run statutory reports, SSCUI 104227, payment posting. , KBA , FI-AP-AP-Q1 , Withholding Tax (Reporting) , Problem
Product
SAP S/4HANA Cloud Public Edition all versions
SAP Knowledge Base Article - Public