SELECT_OPTIONS AND PARAMETER

[Former Member]

can i use select-options and parameter in same select statement.

ex:-

PARAMETERS : S_BUKRS LIKE AUFK-BUKRS,

S_GSBER LIKE AUFK-GSBER.

SELECT-OPTIONS : S_AUFNR FOR AUFK-AUFNR.

SELECT AUFNR BUKRS GSBER KTEXT USER4

FROM AUFK INTO TABLE IT_AUFK

WHERE AUFNR IN S_AUFNR

AND BUKRS = S_BUKRS

AND GSBER = S_GSBER.

[Former Member]

YES THERE IS NO PROBLEM WITH THAT ,

JUST YOUR DEFINING THAT FEILDS AS DIFFERENT OPTIONS

[SG141]

Yes you can....

[Former Member]

Also

SELECT ...

FROM

WHERE ... <b>IN</b> Select-options

.... <b>=</b> Parameter

This is because a parameter is a single value, select-options are a range of values.

[Former Member]

hi

tables aufk.

PARAMETERS : S_BUKRS LIKE AUFK-BUKRS,

S_GSBER LIKE AUFK-GSBER.

SELECT-OPTIONS : S_AUFNR FOR AUFK-AUFNR.

data : it_aufk type table of aufk ."occurs 0 with header line.

SELECT AUFNR BUKRS GSBER KTEXT USER4

FROM AUFK INTO TABLE IT_AUFK

WHERE AUFNR IN S_AUFNR

AND BUKRS = S_BUKRS

AND GSBER = S_GSBER.

it will work..

reward if useful.

[Former Member]

Hi

Yes, you have to give the parameter name in that particular field where class(=) and same as select options (but use IN).

[Former Member]

HI Pratik,

You can definitely use both in the same select statement.

Kiran

[Former Member]

We can write , but it is advisable to change the naming convention to P_... for parameters to be clear

PARAMETERS : P_BUKRS LIKE AUFK-BUKRS,
P_GSBER LIKE AUFK-GSBER.
SELECT-OPTIONS : S_AUFNR FOR AUFK-AUFNR.

SELECT AUFNR BUKRS GSBER KTEXT USER4
FROM AUFK INTO TABLE IT_AUFK
WHERE AUFNR IN S_AUFNR
AND BUKRS = P_BUKRS
AND GSBER = P_GSBER.

[Former Member]

Hello,

Yes, U can use as u Wrote.

Regards,

Deepu.K

[Former Member]

Yes.......

[Former Member]

Hi,

Sorry for earlier>>

U will have to use(written in bold):

PARAMETERS : P_BUKRS LIKE AUFK-BUKRS,

P_GSBER LIKE AUFK-GSBER.

SELECT-OPTIONS : S_AUFNR FOR AUFK-AUFNR.

SELECT AUFNR BUKRS GSBER KTEXT USER4

FROM AUFK INTO TABLE IT_AUFK

WHERE AUFNR IN S_AUFNR<b>-low</b>

AND BUKRS = P_BUKRS

AND GSBER = P_GSBER.

Regards,

Shashank.