cancel
Showing results for 
Search instead for 
Did you mean: 

Deletion of Mobile / telephone numbers from customer master XD03

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

bsivasankarreddy_reddy
Active Contributor
0 Kudos

hi

adr2 table is not related with xd03 , it is related with vap1 or vae1 first you check the data,

xd01 tables only in KNA1-KNB1-KNVV Tables only , first you check the data , i think it wrong ADR2 TABLES IN XD03 PLEASE CHECK THE DATA ONCE

Former Member
0 Kudos

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

jpfriends079
Active Contributor
0 Kudos

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

bsivasankarreddy_reddy
Active Contributor
0 Kudos

hi

goto se16n you change the tables ,

bsivasankarreddy_reddy
Active Contributor
0 Kudos

This message was moderated.

jpfriends079
Active Contributor
0 Kudos

Use TCode MASS for Object Type-KNA1.

Or instead, you can use LSMW to update the same.

Regards

JP