topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Thu, 21 Dec 2006 19:23:52 GMT

Hello friends,

I have 2 fields in my selection screen.

GL account and

Fiscal Year.

when i enter data in both the fields i get the results but when i enter only GL accound it comes without any results.

I am using select options for GL account and Parameters for Year.

In select statement i am using in for select options and eq for parameters.

I looked into debug mode and when i have a blank year it automates it to "0000" and i dont have any thing as "0000" in the table i am pulling my data from.

I know this can be done using select options but can this problem be solved using parameters.

Thanks,

Madhu.

Re: Select statement

Former Member — Thu, 21 Dec 2006 19:26:15 GMT

Hi,

For fiscal year..if it is not mandatory..use select-options no-extension no intervals option..

And use IN in the select statement..

If the fiscal year is not mandatory..It will always have 0000...If you want to have parameters for the fiscal year..make it mandatory in the selection screen...

Exam

tables: bkpf.

select-options so_year for bkpf-gjahr no-extension no intervals.

select single * from bkpf where gjahr <b>IN SO_YEAR</b>.

Thanks,

Naren

Re: Select statement

Former Member — Thu, 21 Dec 2006 19:31:08 GMT

Thanks Naren.

Madhu.