08-22-2007 4:40 PM
Hi
I need fetch value as follows.
table-filed
LIKP-VBELN
LIKP-KUNNR
VTTP-TKNUM
where condition LIKP-VBELN = VTTP-VBELN
pls give code for me.
To be rewarded all helpfull answers,
Regards,
jay
08-22-2007 4:46 PM
Something like this?
report zrich_0001 .
data: begin of ili occurs 0,
tknum type VTTP-TKNUM,
vbeln type LIKP-VBELN,
kunnr type LIKP-KUNNR,
end of ili.
select-options s_tknum for ili-tknum.
select vttp~tknum likp~vbeln likp~kunnr
into table ili
from vttp
inner join likp
on vttp~vbeln = likp~vbeln
where vttp~tknum in S_tknum.
Regards,
RIch Heilman
08-22-2007 4:45 PM
select likpvbeln likpkunnr vttptknum from likp join vttp on likpvbeln = vttp~vbeln into table itab.
08-22-2007 4:46 PM
Something like this?
report zrich_0001 .
data: begin of ili occurs 0,
tknum type VTTP-TKNUM,
vbeln type LIKP-VBELN,
kunnr type LIKP-KUNNR,
end of ili.
select-options s_tknum for ili-tknum.
select vttp~tknum likp~vbeln likp~kunnr
into table ili
from vttp
inner join likp
on vttp~vbeln = likp~vbeln
where vttp~tknum in S_tknum.
Regards,
RIch Heilman
08-22-2007 4:56 PM
HI.
pls refer my code.
DATA:BEGIN OF wa_deli_data1,
vbeln TYPE likp-vbeln,
kunnr TYPE likp-kunnr,
END OF wa_deli_data1.
DATA:BEGIN OF wa_deli_data2,
vbeln TYPE vttp-vbeln,
tknum TYPE vttp-tknum,
END OF wa_deli_data2.
DATA:BEGIN OF wa_deli_data,
vbeln TYPE likp-vbeln,
kunnr TYPE likp-kunnr,
tknum TYPE vttp-tknum,
END OF wa_deli_data.
DATA:it_deli_data LIKE TABLE OF wa_deli_data WITH HEADER LINE,
it_deli_data1 LIKE TABLE OF wa_deli_data1 WITH HEADER LINE,
it_deli_data2 LIKE TABLE OF wa_deli_data2 WITH HEADER LINE.
loop at it_deli_data1.
MOVE-CORRESPONDING it_deli_data1 TO it_deli_data.
APPEND it_deli_data.
endloop.
loop at it_deli_data.
read table it_deli_data2 with key field vbeln = it_deli_data-vbeln.
if sy-subrc = 0.
MOVE-CORRESPONDING it_deli_data2 TO it_deli_data.
modify it_deli_data.
endif.
endloop.
here vbeln is not a key field for table vttp.i think so its problem here
so it shown messge like VBELN is not expected.
pls help me.
Jay
08-22-2007 4:59 PM
It should be..
read table it_deli_data2 with key vbeln = it_deli_data-vbeln.
Without the field -:)
Greetings,
Blag.
08-22-2007 4:47 PM
SELECT LIKP~VBELN KUNNR TKNUM
INTO TABLE TB_TABLE
FROM (LIKP INNER JOIN VTTP
ON LIKP~VBELN EQ VTTP~VBELN)
WHERE LIKP~VBELN EQ GS_VBELN.
Greetings,
Blag.