topic Re: query about where condition . in Application Development and Automation Discussions

query about where condition .

Former Member — Fri, 11 May 2007 06:05:24 GMT

Hello to all ,

i have a quest about the where condition in select statement .

SELECT * FROM /xyz/abc_V

INTO TABLE VIT_abc

WHERE ( FUNCTION = 'ab12' or FUNCTION = 'cd34' )

AND TYPECODE = 'VKORG'

if vit_vbrk[] is not initial.

SELECT * FROM VBRP INTO TABLE VIT_VBRP for all entries in vit_vbrk

WHERE

VBELN = VIT_VBRK-VBELN .

VBRP-MATNR <> the materials selected from /GIL/ZGTYPCODE_V for function WICFREIGHT.

can u please help me to write the code for the (* VBRP-MATNR <> the materials selected from /xyz/abc_V for function WICFREIGHT).

Thanks in advance.

Re: query about where condition .

former_member632991 — Fri, 11 May 2007 06:12:34 GMT

Hi,

try like this

SELECT * FROM /xyz/abc_V

INTO TABLE VIT_abc

WHERE ( FUNCTION = 'ab12' or FUNCTION = 'cd34' )

AND TYPECODE = 'VKORG'

SELECT * FROM VBRP INTO TABLE VIT_VBRP for all entries in vit_vbrk

WHERE

VBELN = VIT_VBRK-VBELN .

<b>and matnr <> vit_vbrk-matnr.</b>

VBRP-MATNR <> the materials selected from /GIL/ZGTYPCODE_V for function WICFREIGHT.

Regards,

Sonika

Re: query about where condition .

Former Member — Fri, 11 May 2007 06:17:41 GMT

Hello to all ,

the select statement should be like this

SELECT * FROM VBRP INTO TABLE VIT_VBRP for all entries in vit_vbrk

WHERE

VBELN = VIT_VBRK-VBELN .

VBRP-MATNR <> the materials selected from /xyz/abc_V for function WICFREIGHT.

can u please help me to write the code for the (* VBRP-MATNR <> the materials selected from /xyz/abc_V for function WICFREIGHT).

Thanks in advance.

Re: query about where condition .

dev_parbutteea — Fri, 11 May 2007 06:28:34 GMT

SELECT * FROM /xyz/abc_V

INTO TABLE VIT_abc

WHERE ( FUNCTION = 'ab12' or FUNCTION = 'cd34' )

AND TYPECODE = 'VKORG'

if vit_vbrk[] is not initial.

SELECT * FROM VBRP INTO TABLE VIT_VBRP for all entries in vit_vbrk

WHERE

VBELN = VIT_VBRK-VBELN .

if sy-subrc = 0.

SELECT * FROM VIT_VBRP INTO TABLE VIT_VBRP2 for all entries in

/GIL/ZGTYPCODE_V for function WICFREIGHT

where VIT_VBRP-MATNR <> the materials selected from /GIL/ZGTYPCODE_V for function WICFREIGHT