on 03-24-2015 10:53 AM
Experts,
We have huge number of duplicate specifications (upto a lakh) created by SPRC. Though we have prevented further creation of duplicates we are unable to delete the existing duplicate specifications as they have been used in the composition of other specifications. As mentioned the number is huge. Is there any standard tool available in SAP for this? BDC will not work for this.
Please suggest.
Regards,
Balu
Dear Balu
As Andreas mentioned. there is no option available by standard. But there is a kind of "work around" possible.
These are the steps:
as mentioned by you: you can only delete a spec if it is not used; therefore first you need to check the "where used" option; this is SAP standard; then I would expect that you have a kind of "mapping" table (as we talk about duplicates). Now you know the specs there a specific spec is used and you now can try to "exchange" them by mass. May be you could try to use "DataEditor" (we do not use this tool´) to exchange spec A by spec B. This tool is providing to you a kind of "mass" option (can can maintain data by mass) If this is no option then you need to prepare e.g. an "user exit" there you can start from "hit list" and the try to use some "own" coding so that spec A get spec B; then you can delete spec A. Step by step you will get those specs identified which you then get exchanged and later deleted
Clearly You can generate a customer specific report as well to do the you; I depends a little bit on future approach; if there is the chance/risk that you will create once again duplicates may be the use of an "Userexit" in CG02/Cg02BD is a good option
Especially the use of specs in "composition and sepc listing" can be a nightmare if you would get rid of duplicates; reference and inheritance is here easier.
Conclusion: if you would do it "fast and dirty" then create an own ABAP report which is doing the "where used list" and then by mapping A to B you can exchange A by B and then you could delete A. If you have the risk/chance that furthere duplicates will come up an userexit (in GC02, CG02BD) is better as here the user can do the reasearch and exhange later by her/hisself
C.B.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Balu,
Unfortunately there is no standard tool available to achieve this task.
Kind regards,
Andreas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.