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

HI

my third list should have the field i selected in second list with the customer id i selected in primary list.

suppose my 1st list has 1,2,3,4, customer id. i select 1 and 2.

the secondary list shows the fields like customer name address, city, phone num.... here i select name and address. then the third list should display the name and address of customer id 1, 2.

hope so i m clear with my requirement.

can u help me.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Dec 28, 2007 at 08:38 AM

    Hi ,

    You can try using HIDE statement.

    in the second list HIDE customer ID and based on this display the other attributes in third list .

    Hope this helps.

    Regards,

    Sandeep

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 28, 2007 at 08:59 AM

    Hi,

    At first level u have done Hide customer id

    At second level do Hide Customer id, name, address, city , phone num.

    At third level use these fields to extract data from DB.

    Regards

    Naveen Gupta

    PS: Reward Points if helpfull.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 28, 2007 at 09:11 AM

    Hi Ramya...

    do as shown below (underlined & Bold )

    TABLES: spfli, sbook.

    DATA: num TYPE i,

    dat TYPE d.

    START-OF-SELECTION.

    num = 0.

    SET PF-STATUS 'FLIGHT'.

    GET spfli.

    num = num + 1.

    WRITE: / spfli-carrid, spfli-connid,

    spfli-cityfrom, spfli-cityto.

    HIDE: spfli-carrid, spfli-connid, num.

    END-OF-SELECTION.

    CLEAR num.

    TOP-OF-PAGE.

    WRITE 'List of Flights'.

    ULINE.

    WRITE 'CA CONN FROM TO'.

    ULINE.

    TOP-OF-PAGE DURING LINE-SELECTION.

    CASE sy-pfkey.

    WHEN 'BOOKING'.

    WRITE sy-lisel.

    ULINE.

    WHEN 'WIND'.

    WRITE: 'Booking', sbook-bookid,

    / 'Date ', sbook-fldate.

    ULINE.

    ENDCASE.

    AT USER-COMMAND.

    CASE sy-ucomm.

    WHEN 'SELE'.

    IF num NE 0.

    SET PF-STATUS 'BOOKING'.

    CLEAR dat.

    SELECT * FROM sbook WHERE carrid = spfli-carrid

    AND connid = spfli-connid.

    IF sbook-fldate NE dat.

    dat = sbook-fldate.

    SKIP.

    WRITE / sbook-fldate.

    POSITION 16.

    ELSE.

    NEW-LINE.

    POSITION 16.

    ENDIF.

    WRITE sbook-bookid.

    HIDE: sbook-bookid, sbook-fldate, sbook-custtype,

    sbook-smoker, sbook-luggweight, sbook-class.

    ENDSELECT.

    IF sy-subrc NE 0.

    WRITE / 'No bookings for this flight'.

    ENDIF.

    num = 0.

    CLEAR sbook-bookid.

    ENDIF.

    WHEN 'INFO'.

    IF NOT sbook-bookid IS INITIAL.

    SET PF-STATUS 'WIND'.

    SET TITLEBAR 'BKI'.

    WINDOW STARTING AT 30 5 ENDING AT 60 10.

    WRITE: 'Customer type :', sbook-custtype,

    / 'Smoker :', sbook-smoker,

    / 'Luggage weight :', sbook-luggweight UNIT 'KG',

    / 'Class :', sbook-class.

    ENDIF.

    ENDCASE.

    Reward if helpful..

    Thnx

    Rohit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2007 at 06:21 AM

    Hi,

    first you have to select those values using hide statement for customer id.

    after displaying second list use hide statement for name field.

    write select statement based on that field whic is hide.

    it displays 3rd list.

    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.