Inner Join

Former Member — Tue, 28 Jun 2011 12:00:09 GMT

Hello Experts,

Im trying to make a Inner Join, but the next failure rising up:

'' wrong table name'' in the marked line (plese look under)

what am I doing wrong???

thank you !

*********************************************************************

DATA: gs_marc TYPE marc.

DATA: gt_marc TYPE STANDARD TABLE OF marc.

DATA: gs_mara TYPE mara.

DATA: gt_mara TYPE STANDARD TABLE OF mara.

TYPES: BEGIN OF ts_ABCDE,

matnr TYPE matnr,

werks TYPE werks_d,

ekgrp TYPE ekgrp,

minbe TYPE minbe,

basmg TYPE basmg,

END OF ts_ABCDE.

DATA: gs_ABCDE TYPE ts_ABCDE.

DATA: gt_ABCDE TYPE STANDARD TABLE OF ts_ABCDE.

SELECT-OPTIONS: pr_matnr FOR gs_marc-matnr,

pr_werks FOR gs_marc-werks.

START-OF-SELECTION.

SELECT a_{matnr a}werks a_{minbe a}basmg b~mtart FROM marc

INTO CORRESPONDING FIELDS OF TABLE gt_ABCDE

FROM marc AS a *************************************************************** "* in this line the problem is!!!!!*

INNER JOIN mara AS b

ON b_{matnr = a}matnr

WHERE mtart = 'HALB'.

LOOP AT gt_marc INTO gs_marc.

READ TABLE gt_mara INTO gs_mara WITH KEY matnr = gs_marc-matnr.

IF sy-subrc = 0.

MOVE: gs_marc-matnr TO gs_ABCDE-matnr,

gs_marc-werks TO gs_ABCDE-werks,

gs_marc-ekgrp TO gs_ABCDE-ekgrp,

gs_marc-minbe TO gs_ABCDE-minbe,

gs_marc-basmg TO gs_ABCDE-basmg.

WRITE: / gs_marc-matnr, gs_marc-werks, gs_marc-ekgrp, gs_marc-minbe, gs_marc-basmg.

APPEND gs_ABCDE TO gt_ABCDE.

ENDIF.

ENDLOOP.

LOOP AT gt_ABCDE INTO gs_ABCDE.

WRITE: / sy-vline, gs_ABCDE-matnr,

sy-vline, gs_ABCDE-werks,

sy-vline, gs_ABCDE-ekgrp,

sy-vline, gs_ABCDE-minbe,

sy-vline, gs_ABCDE-basmg.

ULINE.

Edited by: Do3Times on Jun 28, 2011 2:00 PM

Edited by: Do3Times on Jun 28, 2011 2:02 PM

Re: Inner Join

Former Member — Tue, 28 Jun 2011 12:11:19 GMT

Hi,

SELECT a_{matnr a}werks a_{minbe a}basmg b~mtart FROM marc <=====There is the problem

INTO CORRESPONDING FIELDS OF TABLE gt_ABCDE

FROM marc AS a *************************************************************** "* in this line the problem is!!!!!*

Regards,

Klaus

Re: Inner Join

Former Member — Tue, 28 Jun 2011 12:17:04 GMT

Dankeschön Klaus!

topic Inner Join in Application Development and Automation Discussions

Inner Join

Re: Inner Join

Re: Inner Join