topic Re: SELECT in Application Development and Automation Discussions

SELECT

Former Member — Wed, 26 Dec 2007 05:30:16 GMT

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

Re: SELECT

Kanagaraja_L — Wed, 26 Dec 2007 05:42:10 GMT

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

Re: SELECT

kesavadas_thekkillath — Wed, 26 Dec 2007 05:42:40 GMT

Just pass IN s_belnr into your select query

Re: SELECT

former_member188827 — Wed, 26 Dec 2007 05:44:07 GMT

SELECT * FROM BKPF

INTO CORRESPONDING FIELDS OF TABLE it_bkpf1

WHERE bukrs = p_bukrs AND gjahr = p_gjahr

and belnr in s_blenr.

Re: SELECT

Former Member — Wed, 26 Dec 2007 05:44:28 GMT

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

Re: SELECT

Former Member — Wed, 26 Dec 2007 05:45:45 GMT

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

Re: SELECT

Former Member — Wed, 26 Dec 2007 05:53:10 GMT

Re: SELECT

Former Member — Wed, 26 Dec 2007 06:32:01 GMT

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

Re: SELECT

Former Member — Wed, 26 Dec 2007 06:39:34 GMT

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