Flat file Extraction

[Former Member]

Hi BW Experts,

Can you please answer to this requirement to load flatfile data to Existing ODS

We have to add two key figures to the existing ODS. I added two keyfigures to ODS and communication structure and these two key figures are related to revenue, so is reffering to currency field.

The format in the flatfile is:

0000000790|0000000790|000000000070004128|200547|100|0|0|0|0|USD|EA|20071|DETAIL|0.00000000000000e00|0.00000000000000e001

0000000790|0000000790|000000000070004128|200547|100|3|0|0|66000|USD|EA|20062|DETAIL|6.40200000000000e01|0.00000000000000e001

But when i trigger the Load the data is showing as:

0000000790|000000079000|00000000|700041282|005471|000|0|0|0U|SD|EA|20071|DETAIL0|.000000|00000000e000.0000|0000000000e001

0000000790|000000079000|00000000|700041282|005471|0|3|0|0|66000|USD|EA|20062|DETAIL|6.40200|000000000e01|0.00000000000000e001

If you see the output the Data Seperator | (pipeline) is appearing in between the field data. Can you please check whether we have to adjust any thing in Infopackage in External data Tab.

Present settings iam using is

File Type - ASCII

Character used for decimal point - .

Can you please answer to my que asap.

Thanks & Regards,

UReddy.

[edwin_harpino]

hi UReddy,

ascii is for fixed length without separator,

for flat file with separator, you can use 'csv',

and set separator for '|', and your flat file has extension .csv

you can try 'preview' in infopackage.

http://help.sap.com/saphelp_bw33/helpdata/en/57/e537373aedaf43e10000009b38f839/frameset.htm

hope this helps.

[Former Member]

Hi xys,

in InfoSource --> Transfer Roules --> Tab DataSource count the cdigit for every field of you flat file. You probably make an error of lenght in the 4 field, it has to be of 8 digit and not 9.

This problem doesn't happen if you upload a CSV file, but happens with flat file.

Ciao.

Riccardo.