cancel
Showing results for 
Search instead for 
Did you mean: 

SELECT_OPTIONS AND PARAMETER

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (9)

Answers (9)

Former Member
0 Kudos

YES THERE IS NO PROBLEM WITH THAT ,

JUST YOUR DEFINING THAT FEILDS AS DIFFERENT OPTIONS

sastry_gunturi
Active Participant
0 Kudos

Yes you can....

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

HI Pratik,

You can definitely use both in the same select statement.

Kiran

Former Member
0 Kudos

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
0 Kudos

Hello,

Yes, U can use as u Wrote.

Regards,

Deepu.K

Former Member
0 Kudos

Yes.......

Former Member
0 Kudos

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.