Get a substring from lon char source field

[Former Member]

Hi all,

I need to get only a few characters from a field of non-sap table. I don't want to get the text field which is 1100 chars. long,. i.e. how can i get the 3 chars. into my infoobject like SUBSTR(AFIM, 403, 3)

thanks and regards,

Yigit

[Former Member]

you can create a formula in transfer rules in which you specified (with substring function) substring offset and length .

[Former Member]

No. I'm using 2004s data source. At data source definition screen I get the error "An invalid data type was defined in Alan AFIM3 " So I can't store the data to PSA.