topic Re: Matching 2 non Key fields in Application Development and Automation Discussions

Matching 2 non Key fields

Former Member — Fri, 06 Sep 2019 21:30:37 GMT

Hallo Experts,

I have 2 fields from 2 different tables and these 2 fields are non Key fields.My requirement is to get matching data for these 2 fields.

Any Suggesions how to achieve this.

Thanks

Madhu

Re: Matching 2 non Key fields

loyd_enochs3 — Mon, 09 Sep 2019 14:58:48 GMT

Are you trying to match up two tables based on non-key fields? (Table1-field_x = Table2-field_x)

Use a JOIN

Or are you trying to get all data from each table which have same value in the same non-key field?

Build two internal tables and merge them.

But either way, these are basic ABAP concepts covered in transaction ABAPDOCU

Re: Matching 2 non Key fields

Jelena_Perfiljeva — Mon, 09 Sep 2019 17:43:19 GMT

What have you tried so far and what specific challenge are you facing?

Re: Matching 2 non Key fields

Former Member — Tue, 17 Sep 2019 22:24:18 GMT

Hallo Jelena,

Thanks for responding. I tried triming the leading spaces and it work

Thanks

Madhu

Re: Matching 2 non Key fields

former_member1716 — Wed, 18 Sep 2019 03:28:13 GMT

Hello Madhu,

Can you please let us know the challenge you are facing?

Re: Matching 2 non Key fields

Sandra_Rossi — Wed, 18 Sep 2019 06:50:55 GMT

Please use the COMMENT button for comments, questions, adding details, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area: "Before answering You should only submit an answer when you are proposing a solution to the poster's problem"

Re: Matching 2 non Key fields

Sandra_Rossi — Wed, 18 Sep 2019 06:51:33 GMT

Please close the question if it's solved.