Question:
Hi everbody,
I have created two infospokes for extracting master data from the infoobjects Plant Material and Material . I specify the same destination and the destination is a flat file. So i give the same flat file name for both the infospokes.
Each time i execute the infospoke, the output in the flat file gets overwritten with the data from the infoobjects. I would like to append the data coming from the two infospokes into the same destination.
Can anyone please let me know the way to just use one flat file and extract data from multiple infospokes without overwriting the data . I would really appreciate it if you could help me out with this problem.
Thanking you,
ysk
Answer:
I am affraid that is not a goal of infospoke. The same file will be overwritten every time, you have to handle that yourself.
Sorry for this non feature of SAP BW.
_________________
Laurent THIBERT
Business Connection Amerique
Answer:
Hi Laurent ,
Thank you very much for responding so quickly. I really appreciate it.
I have another question laurent. Can one specify the destination as a data base table and still send it to an application server.
Thanking you,
ysk
Answer:
I don't think it is possible, but what you can do, is to fill that table with infospoke. Then, you schedule an Abap executed right after the infospoke that will create your CSV file, extracting the table content.
That Abap programm will be able to detect if the file yet exists, and if so, file can be appended.
Hope it helps.
_________________
Laurent THIBERT
Business Connection Amerique
Answer:
Hi Laurent,
Once i thank you for giving me some valuable information regarding infospokes.
Unfortunately i am still not able to solve the problem. I would really appreciate it if you could give me some more tips on how to solve my problem. The problem is mentioned below
I have to create a file (CSV) which contains the following fields Plant ID, Material Number, Material Description, Material Type, Material Group, Old Material Number , Issue Unit, Basic unit of measure, Update data.
These fields belong to two different infoobjects names 0plant and 0material. So i am creating four different infospokes for the attributes of the infojbects as well as for the texts of the respective infoobjects.
Due to this i will having four different CSV files outputing from the infospoke . What i would like to know is whether there is any method by which i can extract the infospoke data into only one CSV file. Once extracted can you please let me know how do i schedule the infospokes for daily loading.
Waiting for your reply..
Thanking you,
ysk