topic select problem... in Application Development and Automation Discussions

select problem...

Former Member — Fri, 01 Feb 2008 05:07:39 GMT

I need to retrieve some data from the database table. Selection parameter is P_FISCAI_YEAR, and the select option is S_PERIOD. But in the table I have three fields fiscalyear, Period from and Period to. I don’t know how to write select on this. Please suggest me how to write.

Thanks in Adv,

Raghu

Re: select problem...

Former Member — Fri, 01 Feb 2008 05:11:55 GMT

SEE ITS SIMPLE

take a single field as parameter for PERIOD.

now write select as

select <field> from dbtab into <wa>

where <from period field> LT <parameter> and

<to period field> GT <parameter>.

HOPE U GOT IT

REWARD IF USEFUL

KEEP ROCKIN

'VIVEK

Re: select problem...

Former Member — Fri, 01 Feb 2008 05:13:21 GMT

select <fields> from <database>

into table <itab>

where <Fiscal year field> = p_fiscal_year and

<period> in s_period.

rewards point if useful.

Madhavi

Re: select problem...

Former Member — Fri, 01 Feb 2008 05:14:30 GMT

Hello Raghu,

An example:

Select belnr into table itab_belnr where gjahr = p_year

and monat in s_period.

Thanks,

Venu

Re: select problem...

Former Member — Fri, 01 Feb 2008 05:14:51 GMT

select fiscalyear, Period from,Period to into <ur ITAB> from DBTAB

where fiscal year = P_FISCAI_YEAR and period in S_PERIOD.

i think ur query will be resolved by this

regards,

kushagra

Re: select problem...

Former Member — Fri, 01 Feb 2008 05:18:39 GMT

Raghu,

SELECT required fields

FROM your databasetable

into table internal table

where fiscalyear eq P_FISCAI_YEAR and

Period from IN S_PERIOD and

Period to IN S_PERIOD.

Note : internal table should have the same fields

like your extraction fields .

Don't forget to reward if useful.