- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- ALV Report Year Field
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ALV Report Year Field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2022 Feb 24 5:38 AM
- SAP Managed Tags:
- ABAP Development,
- ABAP Testing and Analysis
Hello,
We have a custom report. That report has 2 time fields those are:
The vehicle's entry date to the scale and The vehicle's leaving date to the scale .Within the code the date field extracts from a SE16N Table however has no year restriction. Yet the report doesnt show any data from 2019 and 2020. How can i find what is wrong as there is no restriction about years.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2022 Feb 24 6:30 AM
- SAP Managed Tags:
- ABAP Development,
- ABAP Testing and Analysis
Use transaction ST05 to make a SQL trace. You will see how the program access to your table, the number of entries retrieve ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2022 Feb 24 7:03 AM
- SAP Managed Tags:
- ABAP Development,
- ABAP Testing and Analysis
When i traced it i found this stamement:
SELECT <FDA READ> <JOIN> WHERE "M" . "MANDT" = '100' AND "M" . "LEAVE_DATE" BETWEEN '20190101' AND '20201030' AND "M" . "SUREC
It seems 2019 and and forward years are defined yet why the report doesnt show the results from 2019 and 2020?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2022 Feb 24 7:05 AM
- SAP Managed Tags:
- ABAP Development,
- ABAP Testing and Analysis
in the trace, you could see how many entries are retrieved
You could also, see the corresponding abap code, and put a break point in the abap editor. (and rerun the program & debug it)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2022 Feb 24 7:09 AM
- SAP Managed Tags:
- ABAP Development,
- ABAP Testing and Analysis
Actually i have no experience with debugging so is it impossible to fix that issue without Debugging?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2022 Feb 24 7:49 AM
- SAP Managed Tags:
- ABAP Development,
- ABAP Testing and Analysis
Check the number of records for your SELECT :
https://blogs.sap.com/2007/09/05/the-sql-trace-st05-quick-and-easy/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2022 Feb 24 7:47 AM
- SAP Managed Tags:
- ABAP Development,
- ABAP Testing and Analysis
Welcome and Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html
The more details you provide, the more likely it is that members will be able to assist you. Especially, when it comes to the tags - for your questions, I have removed the SAP HANA tag as it is not related to SAP HANA.
Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.
Regards, Svea
SAP Community Global Moderator
