loading flat file for budget value in SAP BI -need format

[Former Member]

Dear all,

we have a report in which we have a key figure Budget Price which we have to load from flat file for material.

we have pulled all required data from r/3 the layout of report is like this (except budget price which we have to upload from Flat file)

the report fields are like this

Material code

Vendor code Vendor name

Plant

Purchase Org

Purchase Order

Purchase order date

landed price

Budget price

Variance (budget price-landed price)

(we pulled all the fields data above ...except budget price above)

so please suggest me FLAT FILE structure , what all the fields i have to include in the flat file

and i am thinking to upload this flat file to a infocube and create a multiprovider over 0pur_c01 and this infocube (zinfocube)

Also help me with the step by step process of loading a flat file from application server

regards

[former_member1310099 · Accepted solution]

Hi

To load a flat file from application server follow the below link.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d076cc3e-f13d-2e10-aeb1-f48b4c34f...

Hope it helps.

Thank you.

Regards,

Sravan.

[Former Member · Accepted solution]

can you suggest the flat file format ..(which fields should be included )..

regards

[former_member1310099]

HI,

I just want to make sure about few points initially.

You already have the following fields in your cube 0pur_c01

1.Material code

2.Vendor code Vendor name

3.Plant

4.Purchase Org

5.Purchase Order

6.Purchase order date

7.landed price

8.Variance (budget price-landed price)

Is Variance = budget price-landed price ???

If variance data is already available in the cube. Then directly you can calculate Budget price in the query designer by creating a NEW FORMULA where Budget Price = Variance + landed price.

By doing this directly Budget Price will be calculated and will appear in the report.

But you have to load Budget Price from the flat file, follow the below steps.

Create a Flat file with Budget Price and any Characteristic(for example Material code) and save it as .CSV format.

On BW side create info Object for Budget price and take same info object for Material code. create a cube with these two fields. Create Datasource, Info Package, run the infopackage, create dtp and run it, Once the data comes in to the Zcube, create the multiprovider over the 0pur_c01 and this Zcube.

Hope it helps

Regards,

Sravan.

[Former Member]

variance is calculated based on budget price which has to be uploaded from flat file.

and also

if I Use only material code and budget price to create my IC and then multiprovider.

then in my report when i join multiprovider using only material...and my report has plant, purchorg,Purchase order number .PO Date and then these kf's if i join only using material ..in my report i cant see the kf's against other characeteristics right?

can you suggest me file format....based on the fields i have mentioned above..