Hi BW experts!
Is it possible to create an abap code to be used in data loads
for example -
create an internal table where data is generated
so the table creates a number which corresponds to a date.
then we find the current date - 1 (yesterday) and find the corresponding number to it.
Then we only select the data for that number from the external system.
This will give a selection of records for delta loads using udconnect in our infopackage as dates are controlled by number in the external system.
What I am looking for is some sample code as I am not good at ABAP.
here is the code for an internal table which starts in the past and always is filled from the startno until today.
DATA: BEGIN OF tab OCCURS 0,
nbr TYPE i,
date TYPE d,
END OF tab.
tab-date = '19870510'. "Startdate minus 1
tab-date = tab-date + 1.
tab-nbr = sy-tabix.
IF tab-date = sy-datum.