From and where clause... combining Nested Query

[system]

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 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.

---

GBS74 (BOB member since 2007-01-23)

[system]

@GBS74

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 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.

---

GBS74 (BOB member since 2007-01-23)