SELECT

[Former Member]

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

[Kanagaraja_L]

SELECT * FROM BKPF

INTO CORRESPONDING FIELDS OF TABLE it_bkpf1

WHERE bukrs = p_bukrs AND gjahr = p_gjahr and belnr in s_belnr.

Kanagaraja L

[kesavadas_thekkillath]

Just pass IN s_belnr into your select query

[Former Member]

Hi evryone

i got it but the real problem is when am giving entries it is giving me all the unncessary data.But if am saving the input as a variant its coming exactly right.Please help

Vijay

[former_member188827]

SELECT * FROM BKPF

INTO CORRESPONDING FIELDS OF TABLE it_bkpf1

WHERE bukrs = p_bukrs AND gjahr = p_gjahr

and belnr in s_blenr.

[Former Member]

hi

SELECT * FROM BKPF

INTO CORRESPONDING FIELDS OF TABLE it_bkpf1

WHERE bukrs = p_bukrs AND gjahr = p_gjahr

and belnr in s_belnr.

regards,

pavan

[Former Member]

h

[Former Member]

Hi Vijay,

Decalre the parameters as

tables: bkpf.

SELECT-OPTIONS: P_BUKRS FOR BKPF-BUKRS NO INTERVALS OBLIGATORY. "Company Code

SELECT-OPTIONS: P_GJAHR FOR BKPF-GJAHR NO INTERVALS OBLIGATORY. "Fiscal Year*

And use the following select statement

SELECT * FROM BKPF

INTO CORRESPONDING FIELDS OF TABLE it_bkpf1

WHERE bukrs IN p_bukrs AND gjahr IN p_gjahr AND belnr IN s_belnr

[Former Member]

Hi Vijay Krishna

please use this:-

SELECT * FROM BKPF

INTO CORRESPONDING FIELDS OF TABLE it_bkpf1

WHERE bukrs = p_bukrs AND gjahr = p_gjahr

and belnr in s_belnr.

hope it will resolve your issue

Regards

Deepanker