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

SELECT

32 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