Deletion of CVCs Records

Got a requirement for deletion. 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.
 
Answer:
 
Method 1:
 
It’s 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 achieve 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 - let’s say in your case this is Product or whatever it is.
 
5. Copy the entire column 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. Execute.
 
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 at least this should delete only the required ones. 
 
or
 
Method 2
 
You can write an 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.
 
Notes:
 
The method 1 is a standard one and has the danger to pull other values than intended. So you have test and consider this option.

SAP Books
SAP APO Books  - Certification, Interview Questions and Configuration

SAP APO Tips
SAP APO Tips and SAP Advanced Planner/Optimizer Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.