Select statement

[Former Member]

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.

[Former Member]

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

[Former Member]

Thanks Naren.

Madhu.