topic Re: Problem in Updating KNA1 table fields. in Application Development and Automation Discussions

Problem in Updating KNA1 table fields.

naresh_kumar2 — Tue, 20 Jul 2010 08:39:26 GMT

Hi,

I have small issue , i need to block the customer while creating im using BADI(ADDRESS_UPDATE) to block the customer created.In the BADI im trying to update few fields of KNA1 table using UPDATE statement.

Like this...

WA_KNA1-SPERR = 'X'.

WA_KNA1-CASSD = 'X'.

WA_KNA1-AUFSD = '01'.

WA_KNA1-FAKSD = '01'.

WA_KNA1-LIFSD = '01'.

UPDATE KNA1 SET SPERR = WA_KNA1-SPERR

AUFSD = WA_KNA1-AUFSD

LIFSD = WA_KNA1-LIFSD

FAKSD = WA_KNA1-FAKSD

CASSD = WA_KNA1-CASSD

WHERE KUNNR = W_KUNNR.

when this statement excutes it is updating

1) SPERR

2) AUFSD this two field remaining 3 fields it is not updating

Can anyone pls let me know the reason .

thanks in Adv.

Re: Problem in Updating KNA1 table fields.

Former Member — Tue, 20 Jul 2010 08:45:03 GMT

see note 1469543

it is not possible to update kna1 directly, you must create a bim

oops sorry see that you're question is it inside a badi and not bapi

kind regards

arthur

Edited by: A. de Smidt on Jul 20, 2010 10:45 AM

Re: Problem in Updating KNA1 table fields.

naresh_kumar2 — Tue, 20 Jul 2010 08:49:15 GMT

im updating kna1 in BADi

Re: Problem in Updating KNA1 table fields.

anup_deshmukh4 — Tue, 20 Jul 2010 08:58:54 GMT

Hello ajju_bobby ,

If you are in a BADI,

write a wrapper Function module to update the fields in and Call it in update task

Have a commit at end of function module ,

Don't forget to lock the customer using FM ENQUEUE DEQUE WHILE updating as it is a change BADI

Re: Problem in Updating KNA1 table fields.

naresh_kumar2 — Tue, 20 Jul 2010 09:04:31 GMT

thanks for ur quick reply .

but which Function Module should for updation .

pls let me know Deque and Enqu for locking Customer.

pls let me know ..

Thanks in adv.

Re: Problem in Updating KNA1 table fields.

naresh_kumar2 — Thu, 04 Nov 2010 05:22:11 GMT