Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Data gettng Truncated

Former Member
0 Likes
1,024

hi all,

I am using LSMW to upload data.

I am trying to insert the following record.

OTYPE SHORT STEXT

O WATER QUALITY WATER QUALITY & REGULATORY ASSURANCE

For STEXT Data type is C and length is 40.

I am loading into HRP1000 table{Objects Table}.

My problem is 'stext' is getting truncated and in the step Display read data in LSMW I am seeing the value "WATER QUALITY & A"

It's less than 40 characters. I don't understand why it's getting truncated. I have checked the domain and data element for it. I dont see any issues there.

Please provide any iputs.

Regards,

Hari Kiran

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
873

Hi,

Problems perhaps come for the fact that total length of your source definition is lower than extract (take a look on the way the read program is generated in LSMW).

In step 3 add a field NOTUSED type C 888 for example, and read data again to see if it solves your truncation problem.

David

hi all,

I am using LSMW to upload data.

I am trying to insert the following record.

OTYPE SHORT STEXT

O WATER QUALITY WATER QUALITY & REGULATORY ASSURANCE

For STEXT Data type is C and length is 40.

I am loading into HRP1000 table{Objects Table}.

My problem is 'stext' is getting truncated and in the step Display read data in LSMW I am seeing the value "WATER QUALITY & A"

It's less than 40 characters. I don't understand why it's getting truncated. I have checked the domain and data element for it. I dont see any issues there.

Please provide any iputs.

Regards,

Hari Kiran

3 REPLIES 3
Read only

Former Member
0 Likes
874

Hi,

Problems perhaps come for the fact that total length of your source definition is lower than extract (take a look on the way the read program is generated in LSMW).

In step 3 add a field NOTUSED type C 888 for example, and read data again to see if it solves your truncation problem.

David

Read only

0 Likes
873

Thank you David for the suggestion.

I will try it out and let you know the results.

Warm regards,

Hari Kiran

Read only

Former Member
0 Likes
873

The issue didn't repeat itself.

Data migration was done successfully.

Regards,

Hari