Skip to Content
0

Add Flat File name as Data Field in entry DSO

Feb 18, 2017 at 04:54 PM

112

avatar image

Hello Experts,

We have massive Flat Files in Application Server. For Exsample:

AS_20160321_PCSW.csv

AS_20160421_PCSW.csv

....

All the flat files have the same columns. We use a ABAP Program to check if a Flat File is a new Flat File or not. IF a Flat File is a new Flat Flie, it will be loaded to a DSO. But some time we receive wrong Flat Flies from different local Systems. So we need to delete the corresponding Requests from DSO and from Infocube. This is very complicated for us.

We have a new idea that maybe it is possible to add the flat file Name as a Data Field in DSO, then we can use selective delection to delete the wrong data base on the File Name.

Is it a good idea ?

How is it possible to add the flat file Name as a Data Field in DSO?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Raf Boudewijns Feb 20, 2017 at 07:13 AM
0

I guess it's possible if your flat file names are not too long and you're on BW < 7.4 (as of then you could use the "long" characteristics, so the length of your filename is no longer an issue).

However, if you're loading flat files from different local systems, I would suggest to load them into separate (first-layer) DSOs (to make file handling easier).

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you very much.

you are right we will load the files from differen contries into separate first-layer DSOs.

But the files all are in al11. I would like to know if it possible to add the file Name in first layer DSO as a Data Field.

0
Raf Boudewijns Feb 20, 2017 at 11:58 AM
0

of course it's possible, however up until (and including) BW release 7.3 you're limited to 60 chars, as of BW release 7.4 (SP02) you can go up to 1333 chars

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks a lot, but I don't know how to add the file Name in Al11 to a Data Field in DSO.

Can you explain me how to do that ?

For exsample : Path in Al11

/exchange/ftp/400/AS_20160421_PCSW.csv

We would like add 'AS_20160421_PCSW ' as a Data Field in first layer DSO.

0
Raf Boudewijns Feb 20, 2017 at 03:20 PM
0

So you would like to have the filename automatically filled out in your DSO?

In that case I assume you'll have to work with the "p_r_request" attribute of your DTP (assuming your loading via DTPs) which is type-referenced to "if_rsbk_request_admintab_view". You have a couple of methods available there, one of them being GET_TH_RANGE (which should hold the selections of your DTP - not 100% sure that your flat file name is part of that, but that's something you'll need to check in debug mode I guess).

Share
10 |10000 characters needed characters left characters exceeded