Retrival of Data to database after running preprocessing for crm_serord

[Former Member]

HI,

    i used a custom program to close the open service orders,which meet some custom criteria.,i.e, in crmd_order_h and crm_jest tables i manually modified the archiving_flag and status fields for service orders.and submitted those to sara for write ,store and delete.now i have some service orders which has gone through my custom program and having archive_flag=X.but not deleted by sara.now i want to get back those orders to database ,as they are required by business activities.so,i unflagged the fields to space in the crmd_order_h and crm_jest tables.but now i cant able to edit these orders.the change/display is not active.how to make it active or enable editing for these orders.kindly help.

thankq,

phaneendra.

[Former Member · Accepted solution]

Its not that simple to uncheck the archive flag by ur custom program.

In sap all the status updates is done in many tables even if u uncheck only

one table it will not allow you to edit the document.

I have no experience in CRM but i recommend you to check with ur function guys

they will help you.

[Former Member · Accepted solution]

thanks for your reply tony,

                                         i compared all tables in the spool log of a delete job with the normal service order which is not archived .as per my observation all table entries are same for both orders except the crmd_orderadm_h and crm_jest table entries.those entries i manually changed removed the flag.

but,the service order is still read-only.