topic Re: Error in Left Outer join in Application Development and Automation Discussions

Error in Left Outer join

former_member656987 — Sat, 17 Jul 2021 07:26:34 GMT

Hello Experts,

I'm new to abap. Trying to add "Left outer join" in the program. However getting below syntax error:

Pls help. Points will be awarded for right answer.

REPORT ZMARA_LEFTOUTERJOIN.

Types : BEGIN OF Ty_mat,
matnr type matnr,
ERNAME TYPE ERNAM,
werks type werks,
LABST TYPE LABST,
END OF TY_MAT.

DATA : it_MAT TYPE TABLE OF ty_MAT,
WA_MAT TYPE TY_MAT.

PARAMETERS : p_MATNR TYPE MATNR.

SELECT MARA-MATNR MARA-ERNAM MARD-WERKS MARD-LABST INTO TABLE it_mat
FROM MARA AS MARA LEFT OUTER JOIN MARD AS MARD
ON MARA-MATNR = MARD-MATNR
where mara-matnr = P_matnr.

Regards

ganesan

Re: Error in Left Outer join

former_member656987 — Sat, 17 Jul 2021 07:57:51 GMT

Error

Line 23 Program ZMARA_LEFTOUTERJOIN

Field "MARD-MATNR" is unknown.

Re: Error in Left Outer join

Sandra_Rossi — Sat, 17 Jul 2021 08:24:45 GMT

Please edit your question, select your code and press the "CODE" button to make it correctly colorized/indented, so that it's easier for us to analyze it. Thank you.

Re: Error in Left Outer join

Sandra_Rossi — Sat, 17 Jul 2021 08:24:57 GMT

Please use the COMMENT button for comments, questions, adding details, replying to a comment or a proposed solution or to the OP question, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

Re: Error in Left Outer join

Sandra_Rossi — Sat, 17 Jul 2021 08:30:49 GMT

In ABAP SQL, use tilde, not dash (and also alias is not needed if it's same as table name

SELECT MARA~MATNR MARA~ERNAM MARD~WERKS MARD~LABST 
  INTO TABLE it_mat
  FROM MARA
  LEFT OUTER JOIN MARD
  ON MARA~MATNR = MARD~MATNR.

Re: Error in Left Outer join

former_member656987 — Sat, 17 Jul 2021 08:56:48 GMT

Wonderful. It worked. one quick question, while using write statement, I'm using dash like "mara-matnr" which is working, why not dash is not working while using join statement.

Thanks!!

Re: Error in Left Outer join

Sandra_Rossi — Sat, 17 Jul 2021 09:44:17 GMT

Because you don't deal with same nature of object - table/alias column versus component of a structured variable, type or constant:

Re: Error in Left Outer join

VXLozano — Mon, 19 Jul 2021 06:40:58 GMT

And remove the "points" phrase. It's offensive for people who try to help "for free"