on 04-24-2006 1:11 AM
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
num date
1 19870511
2 19870512
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.
Hi,
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
DO.
tab-date = tab-date + 1.
tab-nbr = sy-tabix.
APPEND tab.
IF tab-date = sy-datum.
EXIT.
ENDIF.
ENDDO.
/manfred
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Avinesh,
how r u ?
could u give some more sample data ? so i can get exactly what u need.
Best Regards....
Sankar Kumar
+91 98403 47141
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.