topic Re: Inner join giving error message in Application Development and Automation Discussions

Inner join giving error message

Nirojan — Wed, 23 Nov 2022 10:19:08 GMT

Hi Team,

I try to join 3 tables I'm getting this type of error "The field 'Addrcomm' does not have a corresponding field in the work area"

TYPES: BEGIN OF FINAL,
       partner TYPE but000-partner,
       add_number TYPE bu-addrcomm,
       remark TYPE ad_remark2,
       email TYPE ad_smtpadr,
       END OF final.

data: it_final type standard table of final.

select bu~partner, bu~addrcomm, at~remark, a6~smtp_addr
from but000 as bu 
inner join adrt as at on at~addrnumber = bu~addrcomm
inner join addr6 as a6 on a6~addrnumber = at~addrnumber
into corresponding fields of table @it_final.

I referred SELECT - JOIN - ABAP Keyword Documentation (sap.com) I couldn't find out

Please help me where I'm doing mistake.

Thanks,

Nirojan.

Re: Inner join giving error message

abo — Wed, 23 Nov 2022 10:23:56 GMT

Either use:

bu~addrcomm as add_number

or rename the field in the structure

Re: Inner join giving error message

FredericGirod — Wed, 23 Nov 2022 10:29:00 GMT

or remove CORRESPONDING FIELDS OF

Re: Inner join giving error message

anujawani242683 — Wed, 23 Nov 2022 10:33:18 GMT

Hi,

In structure, instead of add_number as field name use addrcomm.

TYPES: BEGIN OF FINAL,
       partner TYPE but000-partner,
       addrcomm TYPE bu-addrcomm,
       remark TYPE ad_remark2,
       smtp_addr TYPE ad_smtpadr,
       END OF final.

Re: Inner join giving error message

Nirojan — Wed, 23 Nov 2022 11:12:30 GMT

Thanks c5e08e0478aa4727abc4482f5be390b2

Hi frdric.girod removing corresponding is its good practice? Use of Into corresponding fields. | SAP Blogs

Thanks all for your quick response.

Re: Inner join giving error message

Nirojan — Wed, 23 Nov 2022 11:13:08 GMT

Thank you anujawani2426.

Re: Inner join giving error message

FredericGirod — Wed, 23 Nov 2022 12:07:56 GMT

corresponding is time consuming, I will not say using CORRESPONDING is a good practice.

I think people ask about this option, just to avoid error. But is it better to have error message or to be sure you are doing right ?

Re: Inner join giving error message

matt — Wed, 23 Nov 2022 12:20:15 GMT

frdric.girod

According to this blog https://blogs.sap.com/2012/12/10/why-into-corresponding-is-much-better-than-its-reputation/ that's an urban myth.

Re: Inner join giving error message

FredericGirod — Wed, 23 Nov 2022 13:41:46 GMT

matthew.billingham I am surprised he used SQL trace to mesure the time consuming of INTO CORRESPONDING. For me it is not at database level.

And the argument about dynamic programing is against Clean Code & Security.

I prefer to use it only when the number selected field is different than the internal table.

Re: Inner join giving error message

matt — Wed, 23 Nov 2022 14:03:58 GMT

frdric.girod

I must agree concerning clean code and security. It's why I don't like using it with *. But, it isn't less performant. It seems that there's some clever stuff done during compiling so that at runtime, everything is sorted out and the two forms of select end up being pretty much the same.

Re: Inner join giving error message

FredericGirod — Wed, 23 Nov 2022 14:18:19 GMT

I just finished to make a simple test :

(made with SAT)

*TYPES : BEGIN OF ts_structure,
*          matnr TYPE matnr,
*          matkl TYPE matkl,
*          meins TYPE meins,
*          labor TYPE labor,
*        END   OF ts_structure,
*        tt_table TYPE STANDARD TABLE OF ts_structure WITH NON-UNIQUE DEFAULT KEY.
*DATA my_table TYPE tt_table.
data my_table type standard table of mara with NON-UNIQUE default key.
START-OF-SELECTION.

  DO 100 TIMES.
    SELECT matnr, meins, labor, matkl
           INTO CORRESPONDING FIELDS OF TABLE @my_table
*           INTO TABLE @my_table
           FROM mara
           WHERE ersda LT '20210101'.
  ENDDO.

15:08 and 15:12 were with structure + INTO CORRESPONDING

15:09 and 15:11 were with structure + no INTO CORRESPONDING

15:13 was with no structure (MARA) + INTO CORRESPONDING

so, there is a little difference between INTO CORRESPONDING or not, but a big difference if you use the full MARA internal table.

Re: Inner join giving error message

roberto_forti — Wed, 23 Nov 2022 20:22:45 GMT

Hi,

SAP best practices (OpenSQL): do not implement "corresponding fields".

Select ... INTO CORRESPONDING FIELDS OF TABLE @my_table

Re: Inner join giving error message

sandeep_suggu — Fri, 25 Nov 2022 05:55:23 GMT

Hi nirojan

Hope you are doing great 🙂

Once Check Out the link in below similar to your question will get more clarity on 3 Table Inner Join:

https://answers.sap.com/questions/13708178/select-query-between-an-internal-table-and-3-joine.html?childToView=13710376

Thanks,

Suggu Sandeep.