topic Re: INNER JOIN in Application Development and Automation Discussions

INNER JOIN

Former Member — Fri, 21 Mar 2008 10:34:15 GMT

Hi All

following inner joing giving me errror pl suggest me to connect three tables

SELECT P~VKORG

P~KALSM

P~KNUMV

P~BUKRS

S~VBELN

S~WRBTR

S~ZFBDT

S~ZBD1T

S~ZBD2T

T~VKBUR

T~VKGR

T~VKORG

INTO CORRESPONDING FIELDS OF table ITAB

FROM VBRK AS P INNER JOIN BSID AS S

INNER JOIN KNVV AS T

ON S_{BUKRS = P}BUKRS

AND S_{VBELN = P}VBELN

AND P_{VKORG = T}VKORG

WHERE KALSM = 'ZDEPO2' OR KALSM = 'ZNET01' .

Re: INNER JOIN

Former Member — Fri, 21 Mar 2008 10:38:17 GMT

Please rewrite like this

SELECT P~VKORG

P~KALSM

P~KNUMV

P~BUKRS

S~VBELN

S~WRBTR

S~ZFBDT

S~ZBD1T

S~ZBD2T

T~VKBUR

T~VKGR

T~VKORG

INTO CORRESPONDING FIELDS OF table ITAB

FROM VBRK AS P INNER JOIN BSID AS S

ON S_{BUKRS = P}BUKRS

INNER JOIN KNVV AS T

ON P_{VKORG = T}VKORG

AND S_{VBELN = P}VBELN

WHERE KALSM = 'ZDEPO2' OR KALSM = 'ZNET01' .

thanks Arjun

Re: INNER JOIN

Former Member — Fri, 21 Mar 2008 10:45:30 GMT

Hi,

Try add in where condition proper statement for select criteria (eg. s~ or t_{or p})

Re: INNER JOIN

Former Member — Fri, 21 Mar 2008 10:49:33 GMT

hi ,

change this..

WHERE p_{KALSM = 'ZDEPO2' OR p}KALSM = 'ZNET01' .

regards,

venkat.

Re: INNER JOIN

Former Member — Fri, 21 Mar 2008 10:53:19 GMT

Hi.

Check this out.

SELECT P~VKORG

P~KALSM

P~KNUMV

P~BUKRS

S~VBELN

S~WRBTR

S~ZFBDT

S~ZBD1T

S~ZBD2T

T~VKBUR

*T~VKGR

T~VKORG

INTO CORRESPONDING FIELDS OF table ITAB

FROM VBRK AS P INNER JOIN BSID AS S

ON S_{BUKRS = P}BUKRS

AND S_{VBELN = P}VBELN

INNER JOIN KNVV AS T

ON P_{VKORG = T}VKORG

WHERE KALSM = 'ZDEPO2' OR KALSM = 'ZNET01' .

Hope it helps.

SayC.

Re: INNER JOIN

Former Member — Fri, 21 Mar 2008 10:55:19 GMT

hi,

try this



SELECT P~VKORG
P~KALSM
P~KNUMV
P~BUKRS
S~VBELN
S~WRBTR
S~ZFBDT
S~ZBD1T
S~ZBD2T
T~VKBUR
T~VKGR
T~VKORG
INTO CORRESPONDING FIELDS OF table ITAB
FROM VBRK AS P INNER JOIN BSID AS S ON S~BUKRS = P~BUKRS 
INNER JOIN KNVV AS T
AND S~VBELN = P~VBELN
AND P~VKORG = T~VKORG
WHERE p~KALSM = 'ZDEPO2' OR p~KALSM = 'ZNET01'

*if helpful give reward points*

regards,

pankajvashista

Re: INNER JOIN

Former Member — Fri, 21 Mar 2008 10:55:50 GMT

Hi,

Please modify the Select statement as under:

SELECT

P~VKORG

P~KALSM

P~KNUMV

P~BUKRS

S~VBELN

S~WRBTR

S~ZFBDT

S~ZBD1T

S~ZBD2T

T~VKBUR

T~VKGR

T~VKORG

FROM ( ( VBRK AS P INNER JOIN BSID AS S

ON S_{BUKRS = P}BUKRS and

S_{VBELN = P}VBELN )

INNER JOIN KNVV AS T ON

P_{VKORG = T}VKORG )

INTO CORRESPONDING FIELDS OF table ITAB

WHERE

KALSM = 'ZDEPO2'

KALSM = 'ZNET01' .

Please check this query and let me know how it worked for you.

Thanks,

Vishnu.

Re: INNER JOIN

Former Member — Fri, 21 Mar 2008 10:59:21 GMT

WHERE p~KALSM = 'ZDEPO2' OR

p~KALSM = 'ZNET01' .