datasource 3.x issue

[Former Member]

Hello Gurus

I am having the following issue please help..

I am executing an infopackage for 0bparter_attr  from CRM i get this issue

Record 566 :Contents 10101000000 99 from field VALID_FROM cannot be converted in type DEC

[former_member182470 · Accepted solution]

HI,

Please edit the record No:566 in PSA and save it.

Come back to monitor and right click on the red status of the datapackage-->Manual Processing

Then your load will continue from the struck stage..

[Former Member · Accepted solution]

Thanks for replying.

Actually the error package is not getting loaded to PSA to manually edit the record.

[RamanKorrapati · Accepted solution]

Hi,

At ecc side go to RSA3, enter the valid from value as 10101000000 at selection, execute it. you may find respective record details.thru that you will know 0BPARTNER, once you know 0bpartner, seek crm team help and ask them edit valid from value. once the correction was done, delete request at PSA and reload data from source team.

Thanks

[Former Member · Accepted solution]

Thank you for replying.

Actually we are pulling directly from CRM to BW.

In CRM at rsa3 tcode

i dont have any option to enter valid from value.

I am new to SAP,Correct me if i am missing something.

[RamanKorrapati · Accepted solution]

Hi venmani,

To find out the wrong record, at RSA3, execute and down load whole load data into Excel sheet(seems like you may medium size data), in that you may see Valid from and Valid date too. there you can find valid form - 10101000000, thru that you will find respective bpartner value. once you know partner value, take crm team help and do the correction. after the correct recheck at RSA3, if values are coming as expected way, then reload to bw too.

On excel use filters on column "valid from" you will find easily.

or ask CRM team check wrong "valid date from" was lied in base tables of 0BPARTNER_ATTR data source.

Thanks