Question

  Asked: May 2 2008   4:34 PM GMT
  Asked by: SAPFAQ1 6249


Trouble loading flat file when we need to skip some fields


SAP BI, Data load, Data Transfer Process (DTP), SAP errors, Persistent Staging Area (PSA)

Hello

This is the first time that I have tried to create transformations and a DTP. I have a flat file that has three text fields in the file that I do not want to import. When I try to load to the PSA I get the following message; "

"Error 'The argument 'PO QTY' cannot be interpreted as a number' on assignment field /BIC/ZQUANTITY record 1 value PO QTY" Message no. RSDS013. I have double checked the DataSource, flat file and DTP layouts.

I know that this means that it is trying to read the first text field into the quantity field. How do I preview this? Have I missed a step in the process?

Any help at all is greatly appreciated.

Renee

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


Start this Answer and Earn your Knowledge Points!

By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.

Browse more Questions and Answers on SAP.

Looking for relevant SAP Whitepapers? Visit the SearchSAP.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register