incoming data with more than 60 chars

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

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

Bye

Dinesh

[Former Member · Accepted solution]

I am sorry. I am totally confused. have two different replies here.

I tried loading from a flat file and the load was failing for fields with more 60 chars.

I guess AVR - IGA and Dinesh are talking about 2 different scenarios. Can somebody clarify me?

Thank you very much.

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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

[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

[Former Member]

Hi,

Check these links:

Bye

Dinesh

[Former Member]

Hi,

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

Bye

Dinesh

[Former Member]

Hi,

The load will fail but will not truncate.