Flatfile data loads to BW

[#1]

Hi,

In BW System I have few data load that needs to be performed using flat files on daily basis, Currently the files are being saved on my desktop and loaded them manually. But I would like to include them in process chains and load them during overnight data loads.

But in order to load them from my desktop overnight my desktop should not be shutdown

Please advise.

Thanks

[RamanKorrapati · Accepted solution]

Hi,

From desktop, we can't load them thru process chains.

We need to keep flat files in application servers Tx - AL11.

Later thru process chains we can load them whenever you want.

From where your getting your flat file on desktop?

By using some custom program you can move desktop files to AL11.

From AL11 to taregts we can load flat files data thru process chains.

Please search on google by using search key as "Various ways for File Moving from one folder to other on application server". it migth be helpful.

Thanks

[ShailendarAnugu]

Hi SAP User,

I think by now you should have got the clarity, if yes, please mark the thread as answered and it will help others as well.

Thanks,

Shailu.

[Loed]

Hi,

As members above said, loading FLAT FILE via LOCAL WORKSTATION is not possible..You need to load data from your APPLICATION SERVER..

Ask your BASIS team to create a folder in AL11..

Regards,

Loed

[Former Member]

Thanks for all the updates...

Basis team created a folder in AL11,Question is how can I upload the file save in network drive to the folder in Al11

[ShailendarAnugu]

Please check with your administrator(basis guy), ask him to upload the file from network drive to the BW Application server(where the folder is created).

Thanks,

Shailu.

[Loed]

Hi,

Ask your BASIS team to provide you the PATH of the AL11 folder so that you can store your file on it..

Regards,

Loed

[swati_gawade]

you can use FM ARCHIVFILE_CLIENT_TO_SERVER to upload file to required destination on AL11.

-Swati

[Former Member]

Check if this link is useful- http://wiki.scn.sap.com/wiki/display/BI/How+to+write+routine+to+fetch+current+day

[KodandaPani_KV]

Hi,

you can place the file in the AL11 server.

while creating the data source select the application server in extractiont tab -> file form the application server.

but you need to get the file to application server use the abap custom program.

take the abaper help write the logic.

Thanks,

Phani.

[Former Member]

Hi SAP User,

In process chain, you can't load file from the local workstation. It will give the error.

Does file have daily updated records or you need to update flat file manually. If you have some kind of mechanism to upload the file at BW application server, then you can use that file and load to the data target.

You need to create one folder in AL11 t-code and place the file there.  Then you can create flat data source and source of the file should be application server path.

Thanks,

Chandresh

[ShailendarAnugu]

Hi,

Why you want to load them on daily basis? does the records gets updated in the flat files daily?

you can try to copy the files to the application server(/usr/sap/trans/ create a folder and copy the files into it.

you can list the directories in the AL11 transaction and check if the file is available.

Thanks,

Shailu.