Create flat file from Infoobject data

[Former Member]

Hi Experts,

I am using SAP BW 7.3 version.

Qeustion1.:

I have created info objects to store certain data for materials. I want to create flat file from this data, on UNIX path.

This feature has to be scheduled to run in background automatically. This file I am going to access in other SAP systems like APO system.

Kindly guide me on how to create such a flat file from infoobject.

Question 2 :

I want to create download function on infoobjects and the download should open in excel (like a BI query) and then user modifies the values in excel and uploads it back. This upload should load data to infoobject directly.

Thanks,

Krutika

Message was edited by: KRUTIKA SAVE

[former_member190104 · Accepted solution]

Hi Krutika,

You can use the Analysis Process Designer (APD) to achive this

1. Goto T-Code RSANWB

2. Create New Analysis Process

3. drag and drop data source (Info Provider)

4. give name of info provider  and select the fields you want to export.

5. drag and drop data targets - flat file

6 . give the data target Application server/Client Server. and CSV properties.

7 . drag and drop routine and configure routine along with the code. with source and target.

8.  save, activate and execute.

for more details follow the document

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f06353dd-1fe3-2c10-7197-dd1a2ed38...

Regards,

AK

[Former Member · Accepted solution]

Thank you Arun!!

Can you tell if the Analysis Process can be included in Process chain?

Regs, Krutika

[Loed · Accepted solution]

Hi,

Yes you can..Check the docs below..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/609faa7e-b453-2e10-9b9f-b1dec521d...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c03d110c-15ca-2d10-e485-99c2728b3...

Regards,

Loed

[Former Member]

Arun & Loed, Thank you for your response!! I could design with these document's help.

Krutika

[Loed]

Hi,

Good to know that it helped you..

Regards,

Loed

[former_member190104]

Hi Loed,

Process chain inclusion was a learning to me too. Thank you!

Regards,

AK

[Former Member]

Thanks Michael, but I need more specific solution to this. I check Help.SAP, but no luck there.

Krutika

[michael_devine]

Hi,

You can find this information in the BW administration guides in help.sap.com. Then use a process chain to run your load in the background.

Regards,

Michael Devine