ALV Report Year Field

[sumeyye_1634]

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

[FredericGirod]

Use transaction ST05 to make a SQL trace. You will see how the program access to your table, the number of entries retrieve ...

[sumeyye_1634]

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?

[FredericGirod]

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)

[sumeyye_1634]

Actually i have no experience with debugging so is it impossible to fix that issue without Debugging?

[FredericGirod]

Check the number of records for your SELECT :

https://blogs.sap.com/2007/09/05/the-sql-trace-st05-quick-and-easy/

[sveabecker]

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