Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Matching 2 non Key fields

0 Likes
1,444

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

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

6 REPLIES 6
Read only

loyd_enochs3
Participant
1,310

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

Read only

Jelena_Perfiljeva
Active Contributor
1,310

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

Read only

0 Likes
1,310

Hallo Jelena,

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

Thanks

Madhu

Read only

0 Likes
1,310

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"

Read only

0 Likes
1,310

Please close the question if it's solved.

Read only

former_member1716
Active Contributor
0 Likes
1,310

Hello Madhu,

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