topic Re: updating KNA1 table in Application Development and Automation Discussions

updating KNA1 table

Former Member — Wed, 06 Dec 2006 10:42:36 GMT

Hi Experts,

i need to update kna1 table with only one field stcd2.

My requitement

select customer records for range of customers

copy kna1-sortl to kna1-stcd2 and update kna1 table.

Following is the code which i have used

IF NOT it_cdhdr[] IS INITIAL.

SELECT * FROM kna1

INTO TABLE it_kna1

WHERE kunnr EQ ls_cdhdr-objectid.

ENDIF.

LOOP AT it_kna1.

it_kna1-stcd2 = it_kna1-sortl.

MODIFY it_kna1.

CLEAR it_kna1.

ENDLOOP.

ENDIF.

after getting this records how should i update this records so that it should not

affect performance.

1. UPDATE kna1 FROM it_kna1.

COMMIT WORK.

(OR)

LOOP AT it_kna1.

UPDATE kna1

SET stcd2 = it_kna1-stcd2

WHERE kunnr EQ it_kna1-kunnr..

ENDLOOP.

COMMIT WORK.

Please Advice

Re: updating KNA1 table

Former Member — Wed, 06 Dec 2006 10:44:43 GMT

Firstly it is potentially fatal to update the standard tables.

but still for your information,

UPDATE kna1 FROM table it_kna1.

COMMIT WORK.

would be faster.

Regards,

Ravi

Re: updating KNA1 table

Former Member — Wed, 06 Dec 2006 10:44:44 GMT

Please do not update Standard TAbles using modify or direct update statements

Please use std FM or BAPIs

Re: updating KNA1 table

Former Member — Wed, 06 Dec 2006 11:24:43 GMT

Here i need to update standard Table KNA1. its required

Can you please tell me the Fun Mods or BAPIs for updating this table.

Re: updating KNA1 table

Former Member — Wed, 06 Dec 2006 11:28:30 GMT

Try Using: BAPI_CUSTOMER_CREATEFROMDATA1 OR BAPI_CUSTOMER_CREATEFROMDATA

Re: updating KNA1 table

Former Member — Wed, 06 Dec 2006 11:31:12 GMT

Hi,

Recomendation is always use SAP standard transaction(XD01, in your case) to Update the standard table, but according to your requirement, it seems it is one time requirement because from the second time you can always tell the users to update that particular field in the transaction itself(XD01), so any method you use will not make much difference.

Cheers...

Santosh.

Mark All Usefull Answers...

Re: updating KNA1 table

Former Member — Wed, 06 Dec 2006 11:32:54 GMT

You could use Standard Program RFBIDE00

or the BAPI - BAPI_CUSTOMER_CREATEFROMDATA1

Re: updating KNA1 table

Former Member — Thu, 07 Dec 2006 23:59:35 GMT

Hi Praveen

use BAPI_CUSTOMER_CHANGEFROMDATA1 to update an existing customer.

Thanks

Gareth

Re: updating KNA1 table

Former Member — Wed, 13 Dec 2006 11:18:37 GMT

Hi Praveen,

There is one BAPI 'sd_customer_maintain_all' which I used to Update any of Cusotmer related tables such as KNA1, KNB5. Please let me know if this is available in the system you are working. I will tell you the process.

Regards,

Vijay

Re: updating KNA1 table

Former Member — Wed, 09 Apr 2008 10:50:31 GMT

Hi Praveen i am facing the same situation where i need to update a single field in KNA1,KNB1 and KNVV.... can you please let me know the procedure...

I have BAPI 'sd_customer_maintain_all' in my system...

Please let me know how to use that BAPI....

Thanx in advance n will reward points..