Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

help in join

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

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question