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

F4 Help at selection screen

Dear Experts

I have a selection screen parameter named 'Project Name'. I need to display the list of project in the help.

But the issue i am facing is that my project names are stored in 2 different tables.

table 1 : PROJ which is through WBS element.

table 2 : a Custom field is created in VBAK which stores the project names if it is based on a sales order.

Is it possible to display the project names from both those tables in the F4 Help at selection screen.

Thanks in advance.

Zamir Parkar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Posted on Aug 21, 2011 at 09:28 AM

    Hi,

    if these 2 fields are both the same length/definition, then you may assign (PARAMETER ... MATCHCODE ID ...) a collective search help (I think it's the cleanest solution) in which there are both a standard project search help, and the other one will be a new custom search help on VBAK-ZZ... field.

    Otherwise, you'll have to handle it manually, using the POV (AT SELECTION-SCREEN ON VALUE-REQUEST FOR, and inside, you'll code whatever you want)

    BR

    Sandra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2011 at 11:21 AM

    Please use the matchcode object 'PRS'

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 21, 2011 at 02:37 PM

    Hello Zamir,

    But the issue i am facing is that my project names are stored in 2 different tables.

    table 1 : PROJ which is through WBS element.

    table 2 : a Custom field is created in VBAK which stores the project names if it is based on a sales order.

    In order to maintain the data consistency w.r.t the project names, i'll suggest you maintain a check table for the custom field in VBAK. If you've done that, then you need not bother about this scenario.

    If you've not maintained a check table against this custom field, i'll like to know why?

    BR,

    Suhas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2011 at 06:24 AM

    Dear Sandra Rossi & chinmay kulkarni

    Thanks for the suggestions will try it out and get back.

    Regards

    Zamir Parkar

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 24, 2011 at 06:34 AM

    - First create an elementary search help based on VBAK using your customer field. If the field length is not the same than PS_PSPID (24) use a search help exit to map the database field to an actual project name field (data element) (*) if the field has the same type/length just change the data element to PS_PSPID.

    - Add this search help to project search help PRSM via Customizing (Project System, Structures, Operative Structures, Work Breakdown Structure (WBS), Matchcodes for Work Breakdown Structures (WBS), Matchcode for Project Definition)

    - Use the search help PRSM in your report

    Regards,

    Raymond

    (*) Create the search from VBAK, add a field PSPID (data element PS_PSPID) to parameters, create a FM for search help exit and in step callcontrol-step = 'DISP' use a F4UT_PARAMETER_VALUE_GET to get value of your customer field, and fill PSPID parameter via F4UT_PARAMETER_RESULTS_PUT

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 24, 2011 at 09:16 AM

    HI

    In VBAP you have PS_PSP_PNR and in PROJ table you have PSPID

    you use conversion exit (INPUT) function module and pass it to VBAP table to get the Sales orders against them

    I observed VBAP is taking too long time so create an Index on PS_PSP_PNR field

    If you want to display the WBS elements against the Sales orders then pass VBELN to VBAP table then you can fetch the WBS elements from it and no need to create the Index here

    Hope this serve your purpose

    Cheerz

    Ramchander Rao.K

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2011 at 05:44 AM

    AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_NUM.

    REFRESH IT[].

    SELECT f1 f2 f3 FROM <table> INTO TABLE IT.

    CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

    EXPORTING

    • DDIC_STRUCTURE = ' '

    RETFIELD = 'F1' " above select query field which is going to be displays values in the selection screen

    • PVALKEY = ' '

    DYNPPROG = SY-REPID

    DYNPNR = SY-DYNNR

    DYNPROFIELD = 'P_NUM' " selection screen parameter

    • STEPL = 0

    • WINDOW_TITLE =

    • VALUE = ' '

    VALUE_ORG = 'S'

    • MULTIPLE_CHOICE = ' '

    • DISPLAY = ' '

    • CALLBACK_PROGRAM = ' '

    • CALLBACK_FORM = ' '

    • MARK_TAB =

    • IMPORTING

    • USER_RESET =

    TABLES

    VALUE_TAB = IT

    • FIELD_TAB =

    • RETURN_TAB =

    • DYNPFLD_MAPPING =

    • EXCEPTIONS

    • PARAMETER_ERROR = 1

    • NO_VALUES_FOUND = 2

    • OTHERS = 3

    .

    *IF SY-SUBRC <> 0.

    • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

    • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

    *ENDIF.

    hope helpful..

    regards,

    anil

    Edited by: anil.neegineni on Aug 26, 2011 7:45 AM

    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.