hi friends

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi Viswanath,

Please read the [Rules of Engagement|] before Posting...

1) Give a meaningful subject line...

2) clearly explain your requirement...

Regards

Karthik D

[Former Member]

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 c_{carrname p}connid f~fldate

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( scarr AS c

INNER JOIN spfli AS p ON p_{carrid = c}carrid

AND p~cityfrom = p_cityfr

AND p~cityto = p_cityto )

INNER JOIN sflight AS f ON f_{carrid = p}carrid

AND f_{connid = p}connid ).

Hope it will help you

regards

Rahul sharma

[JanStallkamp]

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