topic Re: get field calculation with LEFT OUTER JOIN in Application Development and Automation Discussions

get field calculation with LEFT OUTER JOIN

Former Member — Sat, 04 Apr 2009 15:09:27 GMT

Good morning

I would to know, if it is possibible get a filed calculation with LEFT OUTER JOIN'

I explain better

Select a_{vbeln a}posnr a_{etenr b}kwmeng a_{bmeng c}lfimg b~netpr

INTO CORRESPONDING FIELDS OF TABLE tab_in

FROM vbep AS a

LEFT OUTER JOIN lips AS c

ON a_{vbeln = c}vgbel

AND a_{posnr = c}vgpos

WHERE ecc ecc

I get a field that it is resul to ( b_{kwmeng - c}lfimg ) into table tab_in

How Can I do this?

Thanks a lot in advance for your replay.

Former Member — Sat, 04 Apr 2009 19:41:22 GMT

You might be ale to do this using native SQL. An easier way is to simply do it after the SELECT, in the ABAP code.

Rob

Former Member — Mon, 06 Apr 2009 06:46:45 GMT

Thanks a lot Rob for your replay.

I ddidn't use 'Native SQL'. Could you explain how to do it.

Thanks a lot

Former Member — Mon, 06 Apr 2009 06:50:26 GMT

Hi:

have a look

SELECT SCUSTOM_{NAME SCUSTOM}POSTCODE SCUSTOM~CITY

SBOOK_{FLDATE SBOOK}CARRID SBOOK_{CONNID SBOOK}BOOKID

INTO (CUSTOMER-NAME, CUSTOMER-POSTCODE, CUSTOMER-CITY,

BOOKING-FLDATE, BOOKING-CARRID, BOOKING-CONNID,

BOOKING-BOOKID)

FROM SCUSTOM LEFT OUTER JOIN SBOOK

ON SCUSTOM_{ID = SBOOK}CUSTOMID AND

SBOOK~FLDATE = '20081015'

ORDER BY SCUSTOM_{NAME SBOOK}FLDATE.

WRITE: / CUSTOMER-NAME, CUSTOMER-POSTCODE, CUSTOMER-CITY,

BOOKING-FLDATE, BOOKING-CARRID, BOOKING-CONNID,

BOOKING-BOOKID.

ENDSELECT.

Regards

Shashi

Former Member — Mon, 06 Apr 2009 07:53:30 GMT

Thanks shashi

but I get a error:

Incorrect nesting for the statement "EDSELECT, THERE IS NO OPEN STRUCTURE INTRODUCED BY "SELECT"