[9656] in SAPr3-news
BAPI -- how to get master-detail
daemon@ATHENA.MIT.EDU (Vadim Tropasko)
Fri Jan 22 22:27:16 1999
To: sapr3-news@MIT.EDU
Date: Fri, 22 Jan 1999 19:12:57 -0800
From: Vadim Tropasko <vtropash@us.oracle.com>
The examples of data extraction for master-detail related tables like
customer/sales order looks like this in BAPI:
loop by the customers
loop via each customer orders
On implementation level this translates into multiple remote calls
(roundtrips) to SAP server.
This can be contrasted to the relational technology, where
customer/sales order data could
be fetched in two or even one roundtrip to data server, where server is
able to filter all the data
satisfying a query.
Please correct me if extracting data via BAPI could be done better than
in example above. For example,
could all the purchase orders for the customer in 'Berlin' be fetched in
one roundtrip (CITY is not
an attribute in SalesOrder)?
