Skip to Content
avatar image
Former Member

hi friends

hi i have 2 tables

one is cdhdr table another is eban how to extract the data b/n two tables .in that table there is no common fields,i want code of that.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 04:37 AM

    Hi Viswanath,

    Please read the [Rules of Engagement|Moving to Strict Rules to improve Quality and Control] before Posting...

    1) Give a meaningful subject line...

    2) clearly explain your requirement...

    Regards

    Karthik D

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 04:09 AM

    Hi,

    In CDHDR there is field OBJECTID which is a combination of BANFN and other fields.So you can use this to extract data from CDHDR and EBAN.

    THnaks,

    Rakesh.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 04:43 AM

    hi,

    u can do this:

    make an internal table having fileds of both the tables., then use a select statement with JOIN to fill the data

    SAMPLE CODE:

    DATA: BEGIN OF wa,

    fldate TYPE sflight-fldate,

    carrname TYPE scarr-carrname,

    connid TYPE spfli-connid,

    END OF wa.

    DATA itab LIKE SORTED TABLE OF wa

    WITH UNIQUE KEY fldate carrname connid.

    SELECT ccarrname pconnid f~fldate

    INTO CORRESPONDING FIELDS OF TABLE itab

    FROM ( ( scarr AS c

    INNER JOIN spfli AS p ON pcarrid = ccarrid

    AND p~cityfrom = p_cityfr

    AND p~cityto = p_cityto )

    INNER JOIN sflight AS f ON fcarrid = pcarrid

    AND fconnid = pconnid ).

    Hope it will help you

    regards

    Rahul sharma

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 09:08 AM

    Hi.

    You can increase the number of people reading your question by using a better subject. Describe your issue and more people get interested in reading your posting. Please have a look into our community guidelines which will explain some other things you should know as a member of SDN.

    Best regards,

    Jan Stallkamp

    Add comment
    10|10000 characters needed characters exceeded