SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Timeslices not getting deleted in CRMD_ISUEXTA4

devashish_bhattacharya
Active Participant

‎2015 May 11 4:54 PM

0 Kudos
224

Hello Experts,

I have to create a data fix program in which if I update EVERH, the same should replicate in CRMD_ISUEXTA4.

Now suppose I have 3 entries in EVERH, I updated one and deleted other two. ( so I got left with one entry only, i.e only 1 timeslice)

This needs to be reflected in CRMD_ISUEXTA4 as well for the respective contract.

Any idea how to achieve it? I have tried with ECRM_CONTRACT_RESEND, but it just updates the timeslice ( which we have updated) but doesn't delete the timeslices ( which we have deleted from EVERH).

Please advice. ( I have tried a request load for the same, but even that didn't deleted the timeslices, though it isn't present in EVERH, as we deleted it)

Regards,

Devashish


2 REPLIES 2

devashish_bhattacharya
Active Participant

‎2015 May 12 5:39 AM

0 Kudos
128

This message was moderated.

ceedee666
Active Contributor

‎2015 May 12 8:27 PM

0 Kudos
128

Hi Devashish,

I'm afraid there is no simple solution for your problem.

The table CRMD_ISUEXTA4 contains data related to each CRM contract position. If you, for example, perform a product change in CRM a new contract position is created. In this case there will be two entries in CRMD_ISUEXTA4 while there still will be only one entry in EVER and EVERH in IS-U. So it is in general not possible to rebuild CRMD_ISUEXTA4 correctly after you have update EVERH by an custom report.

However, there is one option. But this involves deleting data in CRM. So you should handle it with great care. If you use this approach you'll, for example, loose all change history in CRM. Having said this you could use the report CRM_ORDER_DELETE to delete the contracts to which the CRMD_ISUEXTA4 entries belong. This will also remove the entries in CRMD_ISUEXTA4. After you delete the contract using the report you can perform a request load for the deleted contracts. This should recreate them with CRMD_ISUEXTA4 corresponding to EVERH.

Christian