topic Re: SELECT QUERY in Application Development and Automation Discussions

SELECT QUERY

Former Member — Tue, 18 Mar 2008 06:02:15 GMT

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 S_{BUKRS = P}BUKRS

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

AND VBELN = BSID-VBELN.

Re: SELECT QUERY

Former Member — Tue, 18 Mar 2008 06:10:00 GMT

Hi,

Remove S~VBELN

given in the select query and then execute.

Reward if helpful.

Regards.

Re: SELECT QUERY

Former Member — Tue, 18 Mar 2008 06:11:47 GMT

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 S_{BUKRS = P}BUKRS

and s_{vbeln = p}vbeln

WHERE p~KALSM = 'ZDEPO2'

OR p~KALSM = 'ZNET01'.

Thanks

Anon

Re: SELECT QUERY

Former Member — Tue, 18 Mar 2008 06:13:49 GMT

Hi,

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

reward if helpful.

regards,

Ramya

Re: SELECT QUERY

Former Member — Tue, 18 Mar 2008 06:20:11 GMT

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 s_{bukrs = p}bukrs and

p_{vbeln = s}vbeln

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

Reward points if useful.

Regards,

Sowmya.

Re: SELECT QUERY

Former Member — Tue, 18 Mar 2008 06:25:09 GMT

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

Re: SELECT QUERY

Former Member — Tue, 18 Mar 2008 06:34:12 GMT

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 S_{vbeln = P}vbeln and S_{BUKRS = P}BUKRS

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

Regards

Sikha