topic Re: doubt in Application Development and Automation Discussions

doubt

Former Member — Wed, 22 Aug 2007 15:40:13 GMT

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

Re: doubt

Former Member — Wed, 22 Aug 2007 15:45:27 GMT

select likp_{vbeln likp}kunnr vttp_{tknum from likp join vttp on likp}vbeln = vttp~vbeln into table itab.

Re: doubt

RichHeilman — Wed, 22 Aug 2007 15:46:23 GMT

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

Re: doubt

Former Member — Wed, 22 Aug 2007 15:47:11 GMT


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.

Re: doubt

Former Member — Wed, 22 Aug 2007 15:56:37 GMT

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

Re: doubt

Former Member — Wed, 22 Aug 2007 15:59:27 GMT

It should be..


read table it_deli_data2 with key vbeln = it_deli_data-vbeln.

Without the field -:)

Greetings,

Blag.