Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to update the table contents in std table KNA1

Former Member
0 Kudos

hi ALL,

I need to change the telephone number TELF1 in table KNA1.

say I need to change customer telephone value to 001233222.

how can i handle a standard table contents.

rpoints will be rewarded

thanks in advance

1 ACCEPTED SOLUTION

Sougata
Active Contributor
0 Kudos

Hi Jai,

Avoid directly updating SAP standard table(s)...use a BAPI or screen logic for the update so that all standard checks can be executed by the system before the update.

Cheers,

Sougata.

3 REPLIES 3

Former Member
0 Kudos

Either change the Contents using a standard BAPI or use

UPDATE 

statement.

A

Sougata
Active Contributor
0 Kudos

Hi Jai,

Avoid directly updating SAP standard table(s)...use a BAPI or screen logic for the update so that all standard checks can be executed by the system before the update.

Cheers,

Sougata.

tamas_hoznek
Product and Topic Expert
Product and Topic Expert
0 Kudos

Strangely enough, there doesn't seem to be a BAPI to change a customer (or a vendor, for that matter). There is one for create, delete, read etc. but not for change. The ones for EDIT call the dialog transaction... doesn't make much sense.

Your best bet appears to be to do some BDC-like processing (like CALL TRANSACTION 'XD02' USING...). In case of just the phone number, this is easy enough.