Skip to Content
author's profile photo Former Member
Former Member

selection screen doubt

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

<b>smonth eq s_month</b>.

it's showing errror smonth is unknown?

Am I called the right function module?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

9 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 10:13 AM

    Hi hari,

    i can change the code , but let me explain something.

    PA0000 , from where we r selectiong the no of worker, contains two fields , begda and endda.

    begda = join date of employee

    endda =99991231 by default, that means the employee is still working and has no left the company yet.once he retire or resign the endda for that worker is set to that perticular date.

    the present code shows you the employee who are active ie, endda = 99993112, and stat2 = 3.

    so it is coming constant for any month selection, since month selection is not oing alter that.

    if you craete a new info type and or change the stat2 of any infotype to 3, then you will find diffeent output.

    By the way what stat2 =3 stands in your company?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 19, 2005 at 04:42 AM

    Hi,

    Just try this.It won't show error.

    tables vvis_sopti.

    parameters s_month like VVIS_SOPTI-SMONTH.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 04:53 AM

    Hi Hari,

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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      for diff entry..it displaying the same .it's nt taking from sel. screen.

      no. of workers : 636.

      no. of work days lost : 0

      i wntt in a table form.

      Ok..Anid. Let try by taking begda and enda in the sel. screen as parameters as u said earlier that for each infotype it should hav begda and enda.

      forget abt the month in sel. screen.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 04:41 AM

    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,

    PJ

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 04:42 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 04:44 AM

    Hi Hari,

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

    Regards,

    Ville

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 04:44 AM

    hi,

    the problem not with parameter

    check your from ..table has smonth or not

    >>smonth eq s_month.

    cheers,

    sasi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 04:47 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 12:18 PM

    Hi Hari,

    Regarding displaying the Text of the field pa0001-btrtl, you can select that from T001P-BTEXT.

    You can select this field and display the same based on the input in the Selection Screen.

    tell me if this works....

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.