BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

From and where clause... combining Nested Query


 
Search this topic... | Search DI: SAP-specific ERP/BW... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Author Message
GBS74
Principal Member
Principal Member



Joined: 23 Jan 2007

Posts: 255



PostPosted: Tue Feb 12, 2019 10:44 am 
Post subject: From and where clause... combining Nested Query

There are two query
One for Header info and other with nested Item level details.
Need to combine and load to BAPI/ABAP function. I have used condition in from clause in third query based on common field (in order to avoid Cartesian product). But I am getting following error :
“…column <MTNR> does not occur in the FROM clause. For a top-level query, all columns must belong to some table in the FROM clause.”
Any clue how to handle Cartesian or in other word how to join nested data coming from one query with other query at header level

thanks in advance.
Back to top
GBS74
Principal Member
Principal Member



Joined: 23 Jan 2007

Posts: 255



PostPosted: Tue Feb 12, 2019 11:09 am 
Post subject: Re: where clause... combining Nested Query..join..NRDM funct

GBS74 wrote:
There are two query
One for Header info and other with nested Item level details.
Need to combine and load to NRDM BAPI/ABAP function. I have used condition in from clause in third query based on common field (in order to avoid Cartesian product). But I am getting following error :
“…column <MTNR> does not occur in the FROM clause. For a top-level query, all columns must belong to some table in the FROM clause.”
Any clue how to handle Cartesian or in other word how to join nested data coming from one query with other query at header level

thanks in advance.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0292 seconds using 17 queries. (SQL 0.0030 Parse 0.0009 Other 0.0253)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo