Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Issues in SAP Query

Former Member

‎2013 Jul 08 5:58 AM

0 Likes
865

Hi All.

I have issues in SAP query table joint, I am facing this problem after added new table(ADR6) in joint. It is partially pulling the records now.Guide me for   table inner joint, Please check attached tables and help me to resolve this issue.

Preview file
47 KB
Preview file
24 KB

Hi All.

I have issues in SAP query table joint, I am facing this problem after added new table(ADR6) in joint. It is partially pulling the records now.Guide me for   table inner joint, Please check attached tables and help me to resolve this issue.

Reply
3 REPLIES 3
Read only

jogeswararao_kavala
Active Contributor

‎2013 Jul 08 6:01 AM

0 Likes
827

Choose 'LEFT OUTER JOIN' by right-clicking on the link line in the table join view.

And see.

Jogeswara Rao K

Preview file
133 KB
Read only

Former Member

‎2013 Jul 08 6:25 AM

0 Likes
827

Hi Nagaraj,

You could also try and split the records into 2 internal tables at Customer Master and Person/Address details.

So based on KUNNR value, fetch from ADCP, ADRP and ADR6 tables using INNER JOIN.

Hope it helps.

Regards,

Adithi

Read only

krishna_k19
Contributor

‎2013 Jul 08 6:51 AM

0 Likes
827

Hi ,

  If you want to link two or more tables , if your unable to find the link , then goto SQVI t.code and give view name--> title and select 1) DataSource as Table Join --> press Shift+F1 give table names it will give the relation between theose tables.

Regards,

Krishna