topic Re: modify in Application Development and Automation Discussions

modify

Former Member — Tue, 24 Jul 2007 19:46:48 GMT

Hi Folks,

SORT IT_EKPO BY KUNNR.

LOOP AT IT_EKPO INTO WA_EKPO.

READ TABLE IT_KNA1 INTO WA_KNA1 WITH KEY KUNNR = WA_EKPO-KUNNR BINARY SEARCH.

IF SY-SUBRC = 0.

WA_KNA1-KUNNR = WA_EKPO-KUNNR.

ENDIF.

modify it_kna1 from wa_kna1.

ENDLOOP.

thing is i am having 1,2,3 materials shipped to a single customer .

so i have to get the corresponding kunnr for that material.

when i am using this statement its giving me a dump.

thing is i have to modify it_kna1 based upon it_ekpo-kunnr.

if any alternative method do let me know.

regards

jana

Re: modify

former_member194669 — Tue, 24 Jul 2007 19:49:19 GMT

Hi,

Check this



SORT IT_EKPO BY KUNNR.
LOOP AT IT_EKPO INTO WA_EKPO.

READ TABLE IT_KNA1 INTO WA_KNA1 WITH KEY KUNNR = WA_EKPO-KUNNR BINARY SEARCH.
IF SY-SUBRC = 0.
WA_KNA1-KUNNR = WA_EKPO-KUNNR.
modify it_kna1 from wa_kna1.  " PUT INSIDE IF
ENDIF.
ENDLOOP.

aRs

Re: modify

Former Member — Tue, 24 Jul 2007 19:50:58 GMT

Hi,

try doing this

SORT IT_EKPO BY KUNNR.
LOOP AT IT_EKPO INTO WA_EKPO.

<b> w_sytabix = sy-tabix.</b>
READ TABLE IT_KNA1 INTO WA_KNA1 WITH KEY KUNNR = WA_EKPO-KUNNR BINARY SEARCH.
IF SY-SUBRC = 0.
WA_KNA1-KUNNR = WA_EKPO-KUNNR.
ENDIF.
<b>modify it_kna1 from wa_kna1 index w_sytabix</b>.
ENDLOOP.

Cheers

Re: modify

Former Member — Tue, 24 Jul 2007 19:58:52 GMT

Are you sure you want to do:

modify it_kna1 from wa_kna1.

outside of the if - statement?

Chris

Re: modify

Former Member — Tue, 24 Jul 2007 20:16:00 GMT

Hi Ars,

i got a dump we cant use modify inside a loop.

regards

jana

Re: modify

Former Member — Tue, 24 Jul 2007 20:21:00 GMT

Change the modify statement to

MODIFY it_kna1 FROM wa_kna1 WHERE kunnr = wa_kna1-kunnr.

Re: modify

Former Member — Tue, 24 Jul 2007 20:21:24 GMT

hi VJ,

its working but its not modifying it_kna1 and i am not getting the next customer number.

i mean bfore it_kna1 is having 2 entries and after modify it shud be 3 but its skipping out the last entry

regards

jana.

Re: modify

former_member194669 — Tue, 24 Jul 2007 20:22:36 GMT

Hi,

Use with modify inside the IF and ENDIF statement and also use index option. Why it is giving dump is it is not find proper index to modify the I_KNA1 table


modify it_kna1 from wa_kna1 index sy-tabix.

aRs

Re: modify

Former Member — Tue, 24 Jul 2007 20:25:51 GMT

IF SY-SUBRC = 0.

WA_KNA1-KUNNR = WA_EKPO-KUNNR.

modify TABLE it_kna1 from wa_kna1.

ENDIF.

You have to use MODIFY TABLE it_kna1 from wa_kna1 statement... then it wont give the dump..

One suggestion .. you should put MODIFY statement should be inside IF... ENDIF.

Reward if useful

Regards

Prax

Re: modify

Former Member — Tue, 24 Jul 2007 20:33:11 GMT

I'm not getting..why u r reading a record from KNA1 for EKPO-KUNNR... and then if record is read then u r assigning same value to KNA1-KUNNR.

So it will never get updated..

wa_ekpo-kunnr and wa_kna1-kunnr will always be same..

since u have read the data from KNA1 for wa_ekpo-kunnr..

Are u sure u have to update... IT_KNA1 from IT_EKPO..

I think it should be reverse...

Have a thought.. tell me if I'm wrong..

Regards

Prax

Re: modify

Former Member — Tue, 24 Jul 2007 20:36:15 GMT

hi folks,

Still not working folks,

thing is i have material 13 which is ordered by 2 customers like

material customer no.

13 a

13 b

but kna1 will have only 2 entries i have to modify as per the material .

and using modify i am not getting the 3rd entry.

please guide me.

regards

jana

Re: modify

former_member194669 — Tue, 24 Jul 2007 20:36:17 GMT

Hi,

I think you want to update the i_KNA1 ?


SORT IT_EKPO BY KUNNR.
LOOP AT IT_EKPO INTO WA_EKPO.
READ TABLE IT_KNA1 INTO WA_KNA1 WITH KEY KUNNR = WA_EKPO-KUNNR BINARY SEARCH.
IF SY-SUBRC NE 0.
WA_KNA1-KUNNR = WA_EKPO-KUNNR.
Append wa_kna1 to i_kna1.
ENDIF.
ENDLOOP.

aRs

Re: modify

Former Member — Tue, 24 Jul 2007 20:40:29 GMT

Check my last post....

I'm not getting..why u r reading a record from KNA1 for EKPO-KUNNR... and then if record is read then u r assigning same value to KNA1-KUNNR.

So it will never get updated..

wa_ekpo-kunnr and wa_kna1-kunnr will always be same..

since u have read the data from KNA1 for wa_ekpo-kunnr..

Are u sure u have to update... IT_KNA1 from IT_EKPO..

I think it should be reverse...

Have a thought.. tell me if I'm wrong..

Regards

Prax

Regards

Prax

Re: modify

Former Member — Tue, 24 Jul 2007 20:42:48 GMT

hi Prax,

The how wud i go forward of getting the customer numbers based on the materials ..

please guide me i am unable to get it.

regards'

jana

Re: modify

Former Member — Tue, 24 Jul 2007 20:55:56 GMT

Hi.. I'm not much aware of these tables.. since I'm working more on HR module..

but what I think I think..

u r not using correct tables..

In EKPO, EBELN and EBELP are primary key fields..

In KNA1, KUNNR is primary field.

so based on MATNR in EKPO, u want to update KUNNR in KNA1. procedure seems to be wrong.. consult ur functional person for more info or may be somebody else here can tell u..

I told u the wrong logic in ur code...

One more thing I found in ur logic is..

13 a

13 b

You will get only 2 entries in KNA1..

since there are only two customer numbers...

from where this 3rd one came ?

Regards

Prax

Re: modify

Former Member — Tue, 24 Jul 2007 21:02:07 GMT

hi folks,

let me put this way.

i have to group materials by customer .

material customer

13 a

13 b

i have to update kna1 as i will be getting address numbers based upon kunnr .

how wud i go fwd for this requirement

regards

jana

Re: modify

Former Member — Tue, 24 Jul 2007 21:13:00 GMT

Irrespective of how many material customer combinations you have, you need only one kna1 record per customer and from the same KNA1 record, you will get one ADRNR per customer and you can get the address from ADRC using ADRNR. Your logic should be

loop at it_ekpo.

read table it_kna1 with key kunnr = it_ekpo-customer.

if sy-subrc = 0.

select from ADRC where adrnr = it_kna1-adrnr.

endif.

endloop.

EKPO is for POs, how are you getting customers here? Are you taking EKPO-KUNNR? Sometimes, you can override the address in the PO itself and in such cases, EKPO-ADRNR will be filled in. So you may not even have to go to KNA1.