topic Re: selecting all the fields using outerjoin in Application Development and Automation Discussions

selecting all the fields using outerjoin

deepthi_b — Tue, 31 Jul 2007 11:13:15 GMT

Hi All

I have a requirement to join two tables using outer join .I need to select all the fields from one of the table and few fields from other table.

Kindly let me know how to write the query using outerjoin by selecting all the fields from one of the table .

Regards

Deepthi

Re: selecting all the fields using outerjoin

Former Member — Tue, 31 Jul 2007 11:34:54 GMT

Hi,

Use the following code . Change table/fields anme accordingly.

PARAMETERS p_cityfr TYPE spfli-cityfrom. 

DATA: BEGIN OF wa, 
        carrid   TYPE scarr-carrid, 
        carrname TYPE scarr-carrname, 
        connid   TYPE spfli-connid, 
      END OF wa, 
      itab LIKE SORTED TABLE OF wa 
                WITH NON-UNIQUE KEY carrid. 

SELECT s~carrid s~carrname p~connid 
       INTO CORRESPONDING FIELDS OF TABLE itab 
       FROM scarr AS s 
       LEFT OUTER JOIN spfli AS p ON s~carrid   =  p~carrid 
                                  AND p~cityfrom = p_cityfr. 

LOOP AT itab INTO wa. 
  IF wa-connid = '0000'. 
    WRITE: / wa-carrid, wa-carrname. 
  ENDIF. 
ENDLOOP.

<i><b>regards

Debjani

Reward point for helpful answer</b></i>

Re: selecting all the fields using outerjoin

deepthi_b — Wed, 01 Aug 2007 05:29:21 GMT

Hi Debjani,

as per ur suggestion i will get selected fields from two tables.but my reqirement is to select AUFNR,POSNR,KDAUF,KDPOS fields from APFO table and all fields from VBEP table.

Regrads

Deepthi

Re: selecting all the fields using outerjoin

Former Member — Wed, 01 Aug 2007 05:39:24 GMT

Hi,

APFO TABLE does not exist .

debjani

Re: selecting all the fields using outerjoin

deepthi_b — Wed, 01 Aug 2007 06:54:33 GMT

its AFPO table not APFO.