Populate records in a cds view with abap variable

[Victorcardona]

Hello SAP experts,

Currently I am working on a CDS 1, and the data preview is the following:

As you can see, I don't have records for every date. I want to join this CDS 1 with a calendar CDS to have records for all dates. however this join will return records with NULL values for the dates that doesnt exist in the CDS 1.

I would like to populate this NULL values with the closest last record which is not NULL, so the result would be something like this:

The yellow rows are the new records

Look that in my source CDS 1 I don't have records for the dates 202301, 202302, 202303 and 202304. what I would like to do is to carry on the values of the date 202212 for these new records.

Could you please explain me how to do this? I read in internet that this could be done with abap variables, but I am not abap expert. Thank you in advance for your help.

[Necla_Catakli]

Dear Victor,

Unfortunately, it seems to be taking longer than usual for your question to be answered. You might want to try an alternative route to speed things up.

Please check if a similar question has already been asked in the Community. We have found that sometimes questions that have been answered before are no longer receiving responses.

The easiest way to do this, is to visit the All Questions page and search for your specific topic.

You could also check the SAP Support Portal and search for SAP Notes, SAP Knowledge Base Articles and more.

If all of this doesn’t work, I would suggest that you create a support ticket. All you need to do is log onto the SAP Support Portal with your S-user ID and password: http://service.sap.com/message

Thank you,

Necla