Question:
Hi,
We are loading information from a Z table in R/3 which has got date and time stamp. Since the records in the Z table in R/3 are always appended (not updated) it is easy to have delta's based on date and time stamp. We have both the date and time as selection criteria in our info package since we are loading 3 times a day.
On loading the data, however, I find that not all records within a given time frame(e.g. 09:00:00 to 17:00:00) come across. Checking the extraction via RSA3 in R/3(& using SQL trace) gave us different results when we used different formats for time as selection criteria i.e. 09:00:00(as in infopackage) vs 090000. This tells us that the extraction program is not doing the external to internal conversion(and vice versa) correctly.
Anybody has any clue why this is happening?..Thanks
Answer:
Checking the extraction via RSA3 in R/3(& using SQL trace) gave us different results when we used different formats for time as selection criteria i.e. 09:00:00(as in infopackage) vs 090000.
you are correct... however I believe this only applies to the extractor checker (RSA3). if you go into debugging you can see what happens... in a BW InfoPackage I believe the conversion does happen.
cheers,
El Belgio