Skip to Content
author's profile photo
Former Member

doubt

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Posted on Aug 22, 2007 at 03: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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 03:45 PM

    select likpvbeln likpkunnr vttptknum from likp join vttp on likpvbeln = vttp~vbeln into table itab.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 03: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.

    Add comment
    10|10000 characters needed characters exceeded