Moving fields to final internal table

[Former Member]

hi all,

after i select

elect aufk~aufnr

aufk~objnr

aufk~ktext

vbap~vbeln

vbap~posnr

from

inner join aufk

on vbap_{aufnr = aufk}aufnr

into table t_contracts

where aufk~aufnr in s_proj

and vbap~vbeln in s_vbeln

and vbap~matnr in s_matnr

and vbap~abgru = c_abgru.

sort t_contracts by aufnr vbeln posnr.

i select status from jest like below

if t_contracts[] is not initial.

t_contracts_temp = t_contracts.

delete ADJACENT DUPLICATES FROM t_contracts_temp COMPARING aufnr objnr.

select stat

objnr

from jest

into table it_jest

for all entries in t_contracts_temp

where objnr = t_contracts_temp-objnr

and inact <> c_inact.

Now i want for every objnr the value of jest-stat should move to my final internal table it_contracts.

can you suggest the best way to do it?

[andreas_mann3]

try:

SELECT aufk~aufnr

aufk~objnr

aufk~ktext

vbap~vbeln

vbap~posnr

jest~stat

FROM ( vbap JOIN aufk

ON vbap_{aufnr = aufk}aufnr )

JOIN jest ON jest_{objnr = aufk}objnr

INTO TABLE t_contracts

WHERE aufk~aufnr IN s_proj.

A.

[Former Member]

hi all,

Its done