Deletion of CVCs

[Former Member]

Hi

I have a requirement. I have CVCs by specific product, specific customer, location. My std CVC has total 10 chars. Now I want to delete based on these 3 chars. From my prepared excel sheet, i have 500 CVCs to delete, but in system, if i enter these values, i get some 3000 CVCs. Means the said products with other customers also shows up. and my user does not want to compare these 2 lists for deletion as this takes lot of time.

So they want some kind of upload the list from excel, and delete only those CVCs from pool of CVCs. like as in creation of CVCs.

Is there any ABAP method to do this, I know in std way, there is none. I am on SCM 5.0

Appreciate any help..

thanks

Venkat

[Former Member]

Hello Hari,

That method is a standard one, and has danger to pull other values than intended. So we have ruled out this option.

Anjali, Thanks for your help. I need to talk to my ABAPer and see how much is the work estimate.

Before that, i wanted to know if anybody did differently/ easily to deal this issue. I will close this thread.

Thanks for your help..

Venkat

[Former Member]

Hello Venkat,

You may like to explore/use the Realignment functionality to "realign" the 500 odd CVCs you want to delete.

In the realignment table entries put the Target characteristic values as say "DUMMY" with Delete Source CVC option ticked.

This will result in a single CVC in your Planning Area with CVC Value as DUMMY-DUMMY-DUMMY-DUMMY.....

The advantage of this method is -

a) Its possible to mass upload entries in Realignment Table, refer the excel file which you are planning to prepare for those 500 CVCS.

b) Realignment job can be kicked off in background.

c) You have record of the CVCs "deleted" in the Realignment table.

Hope this helps and let know if any questions/doubts.

Satish Waghmare

[Former Member]

Hi Satish

This is definitely a clever way to tackle this issue. Really appreciate this idea.

Thanks a lot, giving you the points..

Venkat

[Former Member]

Venkat,

Its possible that you are seeing 3000 CVCs, If you want to delete exactly those 500 CVCS.

The can try this, though this is not as simple as uploading a excel file, but much better than writing an ABAP program to achive this.

1. Got to MC62

2. Click on Delete from a Combination List

3. Click on Selection Condition,

4. IN the pop up menu, click on Multiple selection for the first Char - lets say in your case this is Product or whatever it is

5. Copy the entire coloum from your excel that has the 500 CVCS and past it into the Pop up field for that Char

6. Continue doing this for all the 10 Chars one by one.

7. Excecute

8. Execute once again and see if you get the 500 CVCs only

9. If so, then select all and delete them.

Copying and pasting 10 times is cumbersome, but atleast this should delete only the required ones.

Hope this helps.

Hari Vomkarey

[Former Member]

You can right the ABAP Program by which you can upload the excel sheet of the CVCs to be deleted and delete those CVCs.

Explain your requirement to the ABAper, I am sure they will write ABAP program as per the requirement.