Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Flat file Extraction

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.

Not what you were looking for? View more on this topic or Ask a question