Skip to Content
0
Former Member
Dec 26, 2007 at 05:30 AM

SELECT

36 Views

hi all

i have a select statement

SELECT * FROM BKPF

INTO CORRESPONDING FIELDS OF TABLE it_bkpf1

WHERE bukrs = p_bukrs AND gjahr = p_gjahr.

In the above statement i have bukrs and gjahr which is selected from the parameters statement as mentione below.

*PARAMETERS : P_BUKRS TYPE BKPF-BUKRS OBLIGATORY. "Company Code

PARAMETERS : P_GJAHR TYPE BKPF-GJAHR OBLIGATORY. "Fiscal Year*

Now i need to create a SELECT statement which along with the bukrs and gjhar also filters the BELNR field.The problem is the belnr field is SELECT-OPTIONS statement and it has two values low and high.

SELECT-OPTIONS : s_belnr FOR bkpf-belnr. "Document number.

Please help and tell me how to use the select statement along with the belnr field.

Vijay