INNER JOIN

[Former Member]

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' .

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

hi ,

change this..

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

regards,

venkat.

[Former Member]

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.

[Former Member]

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

[Former Member]

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'

OR

KALSM = 'ZNET01' .

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

Thanks,

Vishnu.

[Former Member]

WHERE p~KALSM = 'ZDEPO2' OR

p~KALSM = 'ZNET01' .