Text of InfoObject not transferred from PSA with DTP

[Former Member]

Good morning

BI 7

I have a problem where master data text is loaded to the PSA correctly, but it is not transferred to the IO Infoprovider when the DTP is requested. What could cause this?

Thanks in advance.

CJ

[Former Member · Accepted solution]

Thanks Vishal...

Yes, I see that the length of the text field in the source is 80 and the length in the target field is 60 (0TXTLG).

I am using DB connect to an Oracle db. The db says his field length is correct (80). How do I handle this in BW?

Your assistance is appreciated.

Cj

[former_member205352 · Accepted solution]

You cant bring text greater than 60 characters to BI unless you split the data.

[Former Member · Accepted solution]

Hi,

there is only one way to bring it in BW.

in tranformation you will have to put ABAP routine for offset and put first 60 characters in first infoobject and rest 20 in another new created infoobject and this should be done in tranformation through simple ABAP routine.

Once populated you can combine these text in the report for display together.

There is no other way to put it in the Tables as BW doesnt allow more then 60 charaters.

Thanks

Ajeet

[Former Member]

Hi,

There can be a couple of things,

1. The length of the text field in the source might be bigger than that defined in the target field.

2. There might be some problem in the mapping of the field from source to target in the Transformation.

Pls verify these, it might help.