on 01-24-2012 9:21 AM
Hi Gurus,
I need to delete all the mobile numbers from various customers (more than 500) in customer master XD03.
I tried deleting the telephone number entries directly from ADR2 table, but it showing inconsistancy.
Can anyone guide me how can i mass delete the mobile / telephone numbers from XD03.
Hello,
when i am trying to directly delete entry from ADR2 table it is showing inconsistancy and the same customer is showing dump error in XD03
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I mainly want to delete all the mobile phone numbers from ADR2 table (i.e TEL_NUMBER with R3_USER = 2 or 3)
In MASS T-code i am not able to selec the ADR2 table but there is a KNA1 table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use SE16N to get desired list of customer for your parameter - TEL_NUMBER with R3_USER = 2 or 3
You can modify the list downloaded & make necessary change.
Then use LSMW to upload change data to the system.
I don't think its neither recommendable idea or fair practice to use &sap_edit to make direct changes to Database.
Regards
JP
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use TCode MASS for Object Type-KNA1.
Or instead, you can use LSMW to update the same.
Regards
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.