Skip to Content
0
Former Member
Nov 23, 2005 at 11:12 AM

I want to select a field from existing internal table

32 Views

FORM getinfo.

rp-provide-from-last p9012 space pnpbegda pnpendda.

IF pnp-sw-found EQ '1'. "record found

MOVE: p9012-begda TO it9012-begda,

p9012-zz_dept_c TO it9012-z_dept_c,

p9012-ZZ_CLIENT_C TO it9012-Z_CLIENT_C.

SORT IT9012 BY z_dept_c.

append it9012.

*country type selection FROM CHECK BOX.

if p1 = 'x' and p2 = ' ' .

Select * from ZSC_CONS_ORGN into table itemp where

Z_CLIENT_C = it9012-Z_CLIENT_c and Z_CLIENTSTS_C = '002'.

loop at it9012.

read table itemp with key Z_CLIENT_c = it9012-Z_CLIENT_C.

if sy-subrc EQ 0.

it1-z_dept_c = it9012-z_dept_c.

append it1. "FINAL INTERNAL TABLE

endif.

endloop.

endif.

NOTE;

1 HERE I AM GETTING DATA FROM PNP LDB AND PUTTING IT INTO IT9012(INTERNALTABLE).

2 IF CHECK BOX P1 CHECKED IT HAS TO RETRIVE DATA FROM ANOTHER TABLE AND IT WILL MATCH CLIENT CODE AND COUNTRY TYPE = 002

3 SOME FIELDS ARE THERE MEANS IT'LL CAPTURE and check it'll match with it9012.

4 matches means it'll send it to it1.

but this is not working.

Datas are there.

Thanks,

Regards,

Nandha..