need badi to update crm_jest table values

[Former Member]

hi as i need to change massive record values in the crm_jest table

this need has occured as the status value codes are wrongly configured many old service ordres have distribution lock becaus eof this

though the correct values are update now we have to correct the old orders this can be done by chnaging the corresping order values in

crm_jest table using the object is as guid but i need a badi to do this or is there any other way to do this??

[samantak_chatterjee]

Hi,

To update a Table, it's better you need a SAP Update Function Module. You can do a Where-Used-List in CRM_JEST Table and then can look for the function module which will meet your requirement.

I got this list of function module which I feel might be useful, but you need to check it thoroughly as which one will solve your requirement.

CRM_STATUS_BUFFER_FILL_EXT

CRM_STATUS_CHANGE_EXTERN Set user status

CRM_STATUS_CHANGE_EXTERN_OW Set user status

CRM_STATUS_CHECK Check Whether Status is Active

CRM_STATUS_CHECK_EXTENDED_MLTI

CRM_STATUS_CHECK_MULTI Checks Several Objects, Whether Status is Active

CRM_STATUS_CHECK_NEW_OLD

CRM_STATUS_CHECK_OLD

CRM_STATUS_NUMBER_CONVERSION Status Number Conversion in Language-Dependent T

CRM_STATUS_OBJECT_CHECK_MULTI

CRM_STATUS_PRE_READ_DATA

CRM_STATUS_PROPERTIES_GET Determine Current State of a Status

CRM_STATUS_PUT_DB

CRM_STATUS_READ Read Object Status (JSTO and JEST)

CRM_STATUS_READ_ARCHIVE_OBJECT Read Status Objects from Archive

CRM_STATUS_READ_MULTI

CRM_STATUS_REARCH_OBJECT Archive Status Objects (for Conversion Program)

Also, how will you look for the Service Orders which are old or out dated?

Don't try to update the standard SAP Tables manually as this might cause a lot of problems.

Hope this helps.

Thanks,

Samantak.