facing the error in activate data in DSO

[Former Member]

Hi Experts,

i am facing the error while activating the data in DSO. i am getting data in NEW DATA.

please let me know if you have concerns..

[Former Member · Accepted solution]

Hi,

For 0MATERIAL infoobejct.... select lower case allowed.

Delete data and relaod, activate. it will solve the issue,

Regards,

Gaurav

[Former Member · Accepted solution]

hi Gaurav,

thanks for your suggestions but i am using standard DSO how can i modify that,is it possible to modify infobject in DSO..

Best Regards,

sowjanya.

[mohd_abdullah · Accepted solution]

In the transfornation use the formula TOUPPER(0material) instead of direct mapping ... this will fix the issue .

[Former Member · Accepted solution]

you will have to modify the InfoObject and activate it. When you activate it, the changes get reflected in wherever the object has been used.

Thanks,

Sheen

[Former Member · Accepted solution]

Hi,

If this is dev. system and you can afford to loose data then delete data from DSO.

Then do the changes (select lowercase) in 0material, save and activate. Then reload in DSO.

If you do not want to loose data then you can use below characteristic routine:

TRANSLATE <result_field-0material> TO UPPER CASE.

or use formula

TOUPPER (0material).

Regards,

Gaurav

[Former Member · Accepted solution]

hi,

thank you so much..

your formula is working now..

Best Regards,

sowjanya.

[KodandaPani_KV]

Hi,

The problem with the 0MATERIAL - Coaching

in transformation level use the TOUPPER (Uppercase Letters) formula function. it will convert to lower case to upper case.

it will solve the problem.

Thanks,

Phani.

[RamanKorrapati]

Hi,

Delete failed request from DSO.

Go to your PSA, keep filter on material and find the value "Coaching".you can change Coaching to COACHING and save that record.

Later again load data to your DSO and activate it. it wil lwork.

Thanks

[srikanth_rapur2]

Hi

Go to PSA and filter on 0material info object with special char and with space search it with one by one,once you find it then go to the DSO delete the request and edit in PSA then save it and last run the dtp.

regards

sap

[Former Member]

Hiii,

The error in load might be because of 2 reasons,

1 Source data issue(i.e PSA has inconsistent records which don't match the infoobject 0material specifications)

2 Special characteristics issue (Make the necessary setting in RSKC ) or edit the data in PSA for particular record and reload.

Regards,

Akshay

[Former Member]

Hi,

Looking at the screenshot it is clear that there are no Invalid characters in the value "Coaching". So

Can you check the master data and give the screen shot of 0Material info object Properties(General Tab) from RSD1 or RSA1 so that we can come to a conclusion whether it is due to lowercase letters or not. If so, in Transformation of DSO, u can write a formula for CompanyCode (TOUPPER) to solve the issue.

Regards,

Banu

[Former Member]

hi Sowjanya,

Go to RSA1 -> 0MATERIAL (i think this is your characteristic, but please check, it is not very clear from screen shot).

Right click on 0MATERIAL -> maintian master data -> you'l get a selection screen. Enter value "Coaching" for material. It will most probably give you a pop-up saying that the value does not exist.

Now execute the selection screen without entering any value (the timer on the top). Create New record from the Create icon on top. Enter value Coaching for material. Rest fields should be left blank. Save and come back.

Now right click on 0MATERIAL -> Activate Master Data.

Once activation is done, you should go and activate your data.

____________

IF the above does not work, then the error is in data that you loaded to your DSO. For that you will have to delete the request from your DSO. Now go into RSA1-> PSA (2LIS_01_S262) -> right click -> manage. Edit data into PSA : turn the value Coaching to COACHING. Save and come back.

Re-execute the DTP which loads to DSO, repeat the activation.

Please share if this works / not.

Thanks,

Sheen

[Former Member]

Hi,

The error message is not clear from the screenshots. Can you try to get some more info on that by clicking on the log symbol next to the data load monitor from ur last screenshot or using SM37 so that we can analyse what the error.

[Former Member]

Hi Banu,

[former_member203104]

Hi,

Go to PSA and select the latest request and display data.

Check the data in the coaching filed, you can find the error record with special character in it.

delete the special character and load it again or add the special character in RSKC and repeat the process.

Thanks

[Former Member]

Hi Sowjanya,

Check the below:

1. Lower case to upper case.

2. Any special characteristics. if so then remove that in PSA and then load the data again using DTP.

3. Check whether Coaching is a valid material number.

If you want to correct the data in PSA, then delete the request in DSO and then correct the entry in PSA to push it again to DSO using DTP.

Regards

MM

[Former Member]

HI,

From the error message I understand that one(or more) records have an invalid value for 0MATERIAL. Go to PSA, select the data packet where erroneous record is present and click on erroneous records. it will display the records in error. Check the value in 0MATERIAL for those records. Correct them manually and then try again. It could be that some special character is coming for this field. you need to handle that and then reinitiate.

Regards,

Hemlata

[Former Member]

Hi,

Can you check the master data and give the screen shot of 0Material info object Properties from RSD1 or RSA1 so that we can come to a conclusion whether it is due to lowercase letters or not. If so, in Transformation of DSO, u can write a formula for CompanyCode (TOUPPER) to solve the issue.

Regards,

Banu

[mohd_abdullah]

Hi,

Please share the error message .

Regards .

[Former Member]

hi,

[Former Member]

Hi.. Check whether the Material value - Coaching is a valid material number (from your customer data front) and then take the necessary action.

Regards

MM

[Former Member]

Hi,

The Material info object's value 'Coachning' is valid or not please check. The issue could be the object cannot allow lowercase letters. Check the properties of the corresponding info object.

Regards,

Banu

[Former Member]

Hi.. Please check why the error has occured. Check the log of the request to see waht has made this to fail?

Mostly it might be SID issue or other invalid char issue. Please check the same and post the error message here?

Regards

MM