03-18-2008 6:02 AM
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.
03-18-2008 6:10 AM
Hi,
Remove S~VBELN
given in the select query and then execute.
Reward if helpful.
Regards.
03-18-2008 6:11 AM
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
03-18-2008 6:13 AM
Hi,
Give s~VBELN = BSID-VBELN. in ur where clause.
reward if helpful.
regards,
Ramya
03-18-2008 6:20 AM
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.
03-18-2008 6:25 AM
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
03-18-2008 6:34 AM
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