Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SELECT QUERY

Former Member
0 Kudos

following select query giving me error that vbeln has two meaning helpful answer will definatly rewarded

SELECT P~VKORG

P~KALSM

P~KNUMV

P~BUKRS

S~VBELN

S~WRBTR

S~ZFBDT

S~ZBD1T

S~ZBD2T

INTO CORRESPONDING FIELDS OF ITAB

FROM

VBRK AS P INNER JOIN BSID AS S

ON SBUKRS = PBUKRS

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

AND VBELN = BSID-VBELN.

6 REPLIES 6

Former Member
0 Kudos

Hi,

Remove S~VBELN

given in the select query and then execute.

Reward if helpful.

Regards.

Former Member
0 Kudos

Give like this:

SELECT P~VKORG

P~KALSM

P~KNUMV

P~BUKRS

S~VBELN

S~WRBTR

S~ZFBDT

S~ZBD1T

S~ZBD2T

INTO CORRESPONDING FIELDS OF ITAB

FROM

VBRK AS P INNER JOIN BSID AS S

ON SBUKRS = PBUKRS

and svbeln = pvbeln

WHERE p~KALSM = 'ZDEPO2'

OR p~KALSM = 'ZNET01'.

Thanks

Anon

Former Member
0 Kudos

Hi,

Give s~VBELN = BSID-VBELN. in ur where clause.

reward if helpful.

regards,

Ramya

Former Member
0 Kudos

Hi,

Correct your code as mentioned below.

SELECT p~vkorg

p~kalsm

p~knumv

p~bukrs

s~vbeln

s~wrbtr

*S~ZFBDT

*S~ZBD1T

*S~ZBD2T

INTO CORRESPONDING FIELDS OF TABLE

itab

FROM

vbrk AS p INNER JOIN bsid AS s

ON sbukrs = pbukrs and

pvbeln = svbeln

WHERE kalsm = 'ZDEPO2' OR kalsm = 'ZNET01'.

Reward points if useful.

Regards,

Sowmya.

0 Kudos

Hi,

select-options : vbeln for bsid-vbeln.


SELECT P~VKORG
P~KALSM
P~KNUMV
P~BUKRS
S~VBELN
S~WRBTR
S~ZFBDT
S~ZBD1T
S~ZBD2T
INTO CORRESPONDING FIELDS OF ITAB
FROM
VBRK AS P INNER JOIN BSID AS S
ON S~BUKRS = P~BUKRS
WHERE KALSM in ('ZDEPO2','ZNET01') 
AND VBELN in VBELN.

Regards,

Balakumar.G.

Reward Points if helpful.

Edited by: BALAKUMAR GANESAN on Mar 18, 2008 7:26 AM

Former Member
0 Kudos

Hi ,

Please correct your code as below:

SELECT P~VKORG

P~KALSM

P~KNUMV

P~BUKRS

S~VBELN

S~WRBTR

S~ZFBDT

S~ZBD1T

S~ZBD2T

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM

VBRK AS P INNER JOIN BSID AS S

ON Svbeln = Pvbeln and SBUKRS = PBUKRS

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

Regards

Sikha