topic Re: Inner Join Error in Application Development and Automation Discussions

Inner Join Error

Former Member — Thu, 19 Jul 2018 16:57:14 GMT

Please People help

Error:- You cannot use an internal table as a work area.

PERFORM de top

TABLES: EKKO, EKPO

Data: BEGIN OF es_tabla_inner,

a_EBELN TYPE EKKO-EBELN,

b_EBELP TYPE EKPO-EBELP,

b_MATNR TYPE EKPO-MATNR,

b_WERKS TYPE EKPO-WERKS,

b_MENGE TYPE EKPO-MENGE,

b_MEINS TYPE EKPO-MEINS,

b_LOEKZ TYPE EKPO-LOEKZ,

END OF es_tabla_inner.

DATA: ti_tabla_inner LIKE TABLE OF es_tabla_inner.

Perform de rutina

FORM obtener_datos_alv TABLES p_it_zsdtt_alv.

SELECT a~EBELN b~EBELP b~MATNR b~MENGE b~WERKS b~MEINS b~LOEKZ

FROM EKKO AS a INNER JOIN ekpo as b ON a~ebeln = b~ebeln INTO ti_tabla_inner.

SKIP.

IF sy-subrc EQ 0.

WRITE: 'Tabla del Inner Join'.

uline.

LOOP AT ti_tabla_inner INTO es_tabla_inner.

es_tabla_inner-b_MENGE,'|',es_tabla_inner-b_MATNR,'|' ,es_tabla_inner-b_MEINS,'|',es_tabla_inner-b_LOEKZ,'|'.

uline.

ENDLOOP.

ENDIF.

ENDFORM.

retired_member — Thu, 19 Jul 2018 17:02:23 GMT

More than trivial!

Use SELECT ... INTO TABLE ...

And what the heck are the TABLES statements for? Seems that they are superfluous.

pokrakam — Fri, 20 Jul 2018 06:15:21 GMT

Please use code formatting when posting code, it makes it much easier to read.

matt — Fri, 20 Jul 2018 10:25:07 GMT

I.e. use the button marked "code" in the editor.

matt — Fri, 20 Jul 2018 10:26:03 GMT

And FORMs as well. *shudder*. 😉