on 02-23-2009 4:27 PM
Is there something like a RHOMATTRIBUTES_DELETE? I'd like to be able to clean up Webservice ID's from the CAT attribute for suppliers we no longer shop from.
Robin,
I am unable to get it to work conditionally. Sure, I can wipe out the attribute for all entries for CAT, but I want to be able to pick and choose which ones get wiped out.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We are looking to do it for 80,000 people.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It is quite easy to delete attributes. Use FM: BBP_UPDATE_ATTRIBUTES, replace the attribute you want with nothing. I saw you tried the FM with some dramatic results, but I think it is the way to go.
To achieve this:
Set parameter REPLACE_P to X (this will overwrite the attribute you specify even if it is empty)
Enter the attribute you want cleared but don't put any value on the structure other than the attribute ID, I tested with the CAT attribute and had no problem deleting it (SRM 5.0).
Another option would be to explore the RHINFTY function modules with infty 1222 (table where most attributes are maintained).
And the last option is to just write a custom program to delete the rows you need to have deleted, the 2 tables you will have to update are hrt1222 and hrp1222.
Regards,
Robin
When I first tried using BBP_UPDATE_ATTRIBUTES it replaced my whole list of CAT attributes.
Let's say I have the following for CAT:
GRAINGER_CAT
OFFICE_MAX_CAT
STAPLES_CAT
Now, we don't want anyone to access Staples any more, but don't want to touch the other two.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I do not think there is any for this requirement. But you can give this function module BBP_UPDATE_ATTRIBUTES a try. This should help.
Regards
Kathirvel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
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.