topic Re: selection screen doubt in Application Development and Automation Discussions

selection screen doubt

Former Member — Wed, 19 Oct 2005 04:33:11 GMT

can anyone help on this:-

i hav tables pa0000, pa0001, pa2001.

my selection screen:-

parameters : S_BTRTL LIKE PA0001-BTRTL,

s_month like ?

how should i get month in the selection screen?

i am callig fun module:-REAL_ESTATE_F4_MONTH to get the month .

so i taken like this

s_month like VVIS_SOPTI-SMONTH.

when i am retriving data from select queries based on selection screen...

eg: - select .... from .. where btrtl eq s_btrtl

smonth eq s_month.

it's showing errror smonth is unknown?

Am I called the right function module?

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:41:47 GMT

which table are you writing the select on?

does it have a column named smonth?

when u say select ....where smonth = s_month, smonth needs to be a field in the concerned table

check it...

rgds,

Re: selection screen doubt

jayanthi_jayaraman — Wed, 19 Oct 2005 04:42:25 GMT

Hi,

Just try this.It won't show error.

tables vvis_sopti.

parameters s_month like VVIS_SOPTI-SMONTH.

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:42:37 GMT

Whats ur complete select query.

I think u r using PA0001 table..

If yes then there is no field of name 'smonth' in it.

Therefore you are getting this error

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:44:23 GMT

Hi Hari,

Could you post ur code here so we could take a look on it?

Regards,

Ville

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:44:41 GMT

hi,

the problem not with parameter

check your from ..table has smonth or not

>>smonth eq s_month.

cheers,

sasi

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:47:29 GMT

Hi,

Pop a Date in ABAP Report Selection Screens

REPORT ZPOPDATE.

DATA: V_CODE LIKE SY-SUBRC.

PARAMETER: V_MONTH LIKE ISELLIST-MONTH.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR V_MONTH.

CALL FUNCTION 'POPUP_TO_SELECT_MONTH'

EXPORTING

ACTUAL_MONTH = '200205'

LANGUAGE = SY-LANGU

START_COLUMN = 8

START_ROW = 5

IMPORTING

SELECTED_MONTH = V_MONTH

RETURN_CODE = V_CODE

EXCEPTIONS

FACTORY_CALENDAR_NOT_FOUND = 1

HOLIDAY_CALENDAR_NOT_FOUND = 2

MONTH_NOT_FOUND = 3

OTHERS = 4.

Hope it helps u.

Thanks,

Ruthra

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:52:46 GMT

tables are pa0000, pa0001, pa2001.

in this tables there is no month field.

my requirement is to get month in the selection screen..so i called func module.

but when i am using select queries...ther is no particular field like smonth.

i used REAL_ESTATE_F4_MONTH.

Is ther any alternative to get month in selc sceen.

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:53:16 GMT

Hi Hari,

I think if any change is required thats in your select query. the selecton screen is ok, can you send the code.

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:53:45 GMT

i used the same.

tables vvis_sopti.

parameters s_month like VVIS_SOPTI-SMONTH.

but there is no field in the concerned table.

how should i approach

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:55:58 GMT

Hai Ruthra,

thank u for your reply.

but this function module retrieves both month and year.

but i need only month in the seletion screen.

i already tried this fm.

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 04:57:42 GMT

hi,

>>parameters s_month like VVIS_SOPTI-SMONTH.

no probs with the above statement

in the query you don't have month field (smonth is not available in PA0001) how you want to fillter the data as per month

only BEGDA,ENDDA are the date fields in the PA0001

cheers,

sasi

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 05:04:18 GMT

Hi Anid. H R U.

here i am sending :-

PARAMETERS : S_MONTH LIKE VVIS_SOPTI-SMONTH,

S_BTRTL LIKE PA0001-BTRTL.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR S_MONTH.

CALL FUNCTION 'REAL_ESTATE_F4_MONTH'

EXPORTING

I_MONTH = 00

I_POPUP_TITLE = 'Choose Month'

IMPORTING

E_MONTH = P_MONTH

E_SEL_OK =

S_MONTH = P_MONTH.

I wnt to disply these fields in the report output.

personal sub area text, no. of workers, no.of work days lost based on sel. screen.

no. of workers can be calculated by:-

SELECT COUNT(*) INTO ITAB FROM PA0000

WHERE ENDDA = '99991231' AND STAT2 = '3'.

no. of work days can be calc by:-

SELECT COUNT(*) INTO ITAB FROM PA2001.

if i select btrtl in selection screen...the corresponding text should be displayed in the rep output

please send me how to declare as an internal table and also the code.

your help is appreciated.

Re: selection screen doubt

jayanthi_jayaraman — Wed, 19 Oct 2005 05:04:43 GMT

Hi Hari,

IN PA0002 table,there is a field GBMON.

tables vvis_sopti.

data itab type standard table of pa0002.

parameters s_month like VVIS_SOPTI-SMONTH.

select * from pa0002 into table itab where gbmon = s_month.

Kindly reward points if it helps.

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 05:05:24 GMT

hi ville ,

i posted the code. plz hav a look.

thank u

your help would be appreciated.

Re: selection screen doubt

jayanthi_jayaraman — Wed, 19 Oct 2005 05:11:04 GMT

Hi,

If you need personal sub area text,you can get it from T001P.

types : begin of ty,

btext type t001p-btext,

end of ty.

data itab type standard table of ty.

select BTEXT into table itab from t001p where btrtl = p_btrtl.

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 05:13:57 GMT

HI Hari,

i need one more clarification. The month , that you r accepting from user in selection screen, r u going to display the report for records r created

1.only for that month or

2.upto that month or

3.after that months.

please clarify this from your functional team, then we can send the code

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 05:20:44 GMT

i wnt to display for that month.

and also there is one more column in the output saying that 12month rolling period(means if i select october..it should roll back 12 months. ie., nov2004 to oct2005.

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 06:09:03 GMT

Anid..Can we take GBMON as month field in the sel screen which is in the PA0002?

and can we proceed. bcoz it is not showing error.if we select this.

Please send me the code for the above prg. I wait for u.

Thanks again for your valuable time.

your help is appreciated.

Re: selection screen doubt

Former Member — Wed, 19 Oct 2005 06:13:58 GMT

ya hari, just hang on, i am trying ..i am not fully aware of infotyps of HR thats why, its taking time