I tried to implemente the first solution by creating :
a R/3 dataflow that contains
SAP table — query transform----Data Transport
then, accordind to the DI document i should do that if I need to use my first data transport
1rst Data transport ----Query transform ---- second data transform and so one.
At the end I could connect my data flow R/3 to my flat file to extract the data.
The thing is I don’t know how to put my fisrt data transport as Source.
**** The repeatable process********
I would like to extract the data in my sap table by year before creating my flat file at the end.