topic help in join in Application Development and Automation Discussions

help in join

Former Member — Thu, 15 Nov 2007 09:52:15 GMT

hi,

i do this select with join but i wont to change it to select <b>single</b>

without the line AND vbrp~posnr EQ '00010' how i can change that fits my requirement


SELECT  vbrk~vbeln vbrk~vbtyp vbrk~fkdat vbrk~netwr vbrk~waerk
        vbrp~kvgr3 vbrp~ps_psp_pnr tvv3t~bezei dd07v~ddtext
  FROM ( ( vbrk
  INNER JOIN vbrp ON vbrp~vbeln EQ vbrk~vbeln
      AND vbrp~posnr EQ '00010' "remove this
LEFT OUTER JOIN

    tvv3t ON tvv3t~kvgr3 EQ vbrp~kvgr3
    AND tvv3t~spras EQ sy-langu )

LEFT OUTER JOIN
    dd07v ON dd07v~domname EQ 'VBTYP'
    AND dd07v~ddlanguage EQ sy-langu
    AND dd07v~domvalue_l EQ vbrk~vbtyp )

INTO  CORRESPONDING FIELDS OF TABLE  sd_tab

      WHERE vbrk~rfbsk EQ 'C'
      AND vbrk~fksto EQ ''
      AND vbrk~sfakn EQ ''.

i reward

regards

Re: help in join

Former Member — Thu, 15 Nov 2007 09:54:36 GMT

Just remove the line. that will be fine in this case. It will work.

SELECT vbrk_{vbeln vbrk}vbtyp vbrk_{fkdat vbrk}netwr vbrk~waerk

vbrp_{kvgr3 vbrp}ps_psp_pnr tvv3t_{bezei dd07v}ddtext

FROM ( ( vbrk

INNER JOIN vbrp ON vbrp_{vbeln EQ vbrk}vbeln

LEFT OUTER JOIN

tvv3t ON tvv3t_{kvgr3 EQ vbrp}kvgr3

AND tvv3t~spras EQ sy-langu )

LEFT OUTER JOIN

dd07v ON dd07v~domname EQ 'VBTYP'

AND dd07v~ddlanguage EQ sy-langu

AND dd07v_{domvalue_l EQ vbrk}vbtyp )

INTO CORRESPONDING FIELDS OF TABLE sd_tab

WHERE vbrk~rfbsk EQ 'C'

AND vbrk~fksto EQ ''

AND vbrk~sfakn EQ ''.

Re: help in join

Former Member — Thu, 15 Nov 2007 10:00:27 GMT

hi jyothi

thanks

i now that, but the problem is that when i remove AND vbrp~posnr EQ '00010'

i get all posnr and i just wont to get just <b>one</b> for that i nned single

regards

Re: help in join

Former Member — Thu, 15 Nov 2007 10:05:04 GMT

HI,

try like this.

define sd_tab as a table with header line.then the selected contents will be moved to the header line of the internal table.

SELECT single vbrk_{vbeln vbrk}vbtyp vbrk_{fkdat vbrk}netwr vbrk~waerk

vbrp_{kvgr3 vbrp}ps_psp_pnr tvv3t_{bezei dd07v}ddtext

into corresponding fields of sd_tab

FROM ( ( vbrk

INNER JOIN vbrp ON vbrp_{vbeln EQ vbrk}vbeln

AND vbrp~posnr EQ '00010' "remove this

LEFT OUTER JOIN

tvv3t ON tvv3t_{kvgr3 EQ vbrp}kvgr3

AND tvv3t~spras EQ sy-langu )

LEFT OUTER JOIN

dd07v ON dd07v~domname EQ 'VBTYP'

AND dd07v~ddlanguage EQ sy-langu

AND dd07v_{domvalue_l EQ vbrk}vbtyp )

WHERE vbrk~rfbsk EQ 'C'

AND vbrk~fksto EQ ''

AND vbrk~sfakn EQ ''.

rgds,

bharat.