topic Issue in file interface in Application Development and Automation Discussions

Issue in file interface

Former Member — Wed, 27 Jun 2012 13:54:36 GMT

Hi,

I want to output a file in AL11 which contains differential data.

The differential data would be fetched by comparing the last update on the material data with the last run date of the interface program.

Please help how to read the date timestamp of last flat file created in AL11 using sap abap program.

Any function module for this and which parmaters needs to pass.

Thanks in Advance,

Nagendra

Re: Issue in file interface

Former Member — Wed, 27 Jun 2012 14:28:21 GMT

Hi Nagendra,

You can use this FM if you have the directory you are looking for. It has the date and time stamp. Look for some other FM's on the forum. Some of them have time stamps.

EPS2_GET_DIRECTORY_LISTING

Regards,

Shravan

Re: Issue in file interface

Former Member — Wed, 27 Jun 2012 15:41:45 GMT

much easier way to do this....what if somebody deletes your files?

why not create a row in a table, such as TVARVC, and store the time stamp of the last retrieval?

In you program, you would get the value, convert it to date and time, set you start values to that....

do get time. set your end values to current date, current time.

convert current date, current time to timestamp and store back in same row in TVARVC (or to other table)...

no need to rely upon files, and by putting an optional start / end date on the screen, you can override what is stored in the table is a re-execution is required.