Skip to Content
author's profile photo Former Member
Former Member

incoming data with more than 60 chars

Hai,

I have a incoming field with more than 60 chars mapped to an object with type char and length 60. Actually the incoming values are alpha numeric. I want to know if the bw system truncates and takes only first 60 chars or does the load fail?

Also is the behavior same for all kind of loading? I mean flat file, DB connect and SAP extraction?

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2006 at 08:08 PM

    Hi,

    Only the 60 chars would be loaded and there would not be any poblems with the load.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello BI user,

      If the field contains more than 60 chars, load should not fail. It will simply take first 60 chars. If your load is failing, there could be some other reason. Please check the log, some common problems while loading through file are special characters and alpha conversion erros.

      Hope it helps.

      Regards,

      Praveen

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2006 at 09:24 PM

    Hi,

    Probably you need to use an ABAP routine in the transfer rules to accept only the first 60 chars.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2006 at 09:26 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2006 at 09:27 PM

    Hi Dinesh,

    In general how would the load succeed if the source field has more than 60 chars? (just a doubt) As you said if one needs to write an ABAP rooutine, it should be done at Infopakage level right?

    Well, in suhc a case I agree that the load should not fail.

    Message was edited by: AVR - IGA

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello 😊 Guys,

      how ya all doin ?

      I got the same problem while extracting data from MS SQL, we had varchar(200), 500 like that. If you really want to have the whole data the best way is to split the data into parts by creating more infoobjects and store seperately.

      i.e. if u have char with length 100 then create 2 InfoObjects and spilit the data using a start routine and save in 2 IOs.

      Best Regards....

      Sankar Kumar

      +91 98403 47141

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2006 at 08:07 PM

    Hi,

    The load will fail but will not truncate.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 05, 2008 at 03:50 PM

    1what is relation to sap bw to apo

    2.tell me step by step

    3.how to connet to sap bw to apo

    4.how many parts in apo

    5.what is use to apo in sap bw

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.