Skip to Content
0
Former Member
May 09, 2009 at 09:06 PM

Archiving CRM Service Contracts and Business Activities questions?

333 Views

Dear All,

The requirement is to Archive CRM Service Contracts and Business Activities. I am using standard object CRM_SRCONT and CRM_ACT_ON.

Am I using the right objects for the above requirements?

*CRMACT_ON*:_

When I execute the write program CRM_ARC_ACT_ON_SAVE for CRM_ACT_ON it does not archive the Object id reason being as below.

When debugged found that from the following statement there is no record in CRM_JEST table with GUID and status I1100.

SELECT guid

FROM crmd_orderadm_h

INTO TABLE object_guids

WHERE verify_date ne ''

AND object_id IN r_objid

AND process_type IN r_protp

AND changed_at IN r_date

AND EXISTS ( SELECT objnr

FROM crm_jest

WHERE stat = gc_status-archivable

AND inact = ' '

AND objnr = crmd_orderadm_h~guid ). "#EC CI_NOFIRST

where gc_status-archivable = I1100 ( meaning - can be archived)

Would like to know when is CRM_JEST gets updated with status 'I1100' for a business activity.

*CRMSRCONT*:_

Also it's the same case for Service Contract from the following statement in Write Program CRM_ORDER_ARCHIVE_SAVE.

SELECT guid

FROM crmd_orderadm_h

INTO TABLE object_guids

WHERE verify_date ne ''

AND object_id IN r_objid

AND process_type IN r_protp

AND changed_at IN r_date

AND EXISTS ( SELECT objnr

FROM crm_jest

WHERE stat = gc_status-archivable

AND inact = ' '

AND objnr = crmd_orderadm_h~guid ). "#EC CI_NOFIRST

Would like to know when or how will we update CRM_JEST with status 'I1100' for a Service Contract.

Please share all your views if someone has worked on these objects.

Thanks

MS