|
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.
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.
Get help for your SAP APO problems
SAP Books
SAP APO Tips
Best regards,
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|