
V_CARRID = 'SQ'.
V_CONNID = '0325'.
V_DATUM = '20100707'.
CALL FUNCTION 'BAPI_SBOOK_GETLIST'
EXPORTING
AIRLINECARRIER = V_CARRID
CONNECTIONNUMBER = V_CONNID
DATEOFFLIGHT = V_DATUM
CUSTOMERNUMBER = V_CUSTOMID
ORDERDATE = V_ORDERDATE
TABLES
BOOKINGLIST = LT_BOOKINGLIST.
SELECT *
FROM SBOOK
INTO TABLE @DATA(LT_SBOOK)
FOR ALL ENTRIES IN @LT_BOOKINGLIST
WHERE CARRID = @LT_BOOKINGLIST-CARRID
AND CONNID = @LT_BOOKINGLIST-CONNID
AND FLDATE = @LT_BOOKINGLIST-FLDATE
AND BOOKID = @LT_BOOKINGLIST-BOOKID.

SELECT *
FROM SBOOK
INTO TABLE @DATA(LT_SBOOK)
FOR ALL ENTRIES IN @LT_BOOKINGLIST
WHERE CARRID = @LT_BOOKINGLIST-CARRID
AND CONNID = @LT_BOOKINGLIST-CONNID
AND FLDATE = @LT_BOOKINGLIST-FLDATE
AND BOOKID = @LT_BOOKINGLIST-BOOKID
%_HINTS HDB '&prefer_join_with_fda 0&'.



ZCL_MY_FIRST_AMDP=>READ_SBOOK(
EXPORTING IT_BOOKS = LT_BOOKINGLIST
IMPORTING ET_SBOOK = DATA(LT_SBOOK) ).METHOD READ_SBOOK BY DATABASE PROCEDURE
FOR HDB
LANGUAGE SQLSCRIPT
OPTIONS READ-ONLY
USING SBOOK.
ET_SBOOK = SELECT DISTINCT K.MANDT, K.CARRID, K.CONNID, K.FLDATE,
K.BOOKID, K.CUSTOMID, K.CUSTTYPE, K.SMOKER,
K.LUGGWEIGHT, K.WUNIT, K.INVOICE, K.CLASS,
K.FORCURAM, K.FORCURKEY, K.LOCCURAM, K.LOCCURKEY,
K.ORDER_DATE, K.COUNTER, K.AGENCYNUM, K.CANCELLED,
K.RESERVED, K.PASSNAME, K.PASSFORM, K.PASSBIRTH
FROM SBOOK K INNER JOIN :IT_BOOKS
ON K.MANDT = SESSION_CONTEXT('CLIENT')
AND K.CARRID = :IT_BOOKS.CARRID
AND K.CONNID = :IT_BOOKS.CONNID
AND K.FLDATE = :IT_BOOKS.FLDATE
AND K.BOOKID = :IT_BOOKS.BOOKID;
ENDMETHOD.
SQL trace shows the ADMP takes about 24.6ms including two TRUNCATE statements and an INSERT statement to a temporary data object. It seems INSERT statement is used to send the rows in the internal table to the database.

SELECT DISTINCT SK~CARRID, SK~CONNID, SK~FLDATE, SK~BOOKID, SK~CUSTOMID,
SK~CUSTTYPE, SK~SMOKER,SK~LUGGWEIGHT, SK~WUNIT, SK~INVOICE,
SK~CLASS, SK~FORCURAM, SK~FORCURKEY, SK~LOCCURAM, SK~LOCCURKEY,
SK~ORDER_DATE, SK~COUNTER, SK~AGENCYNUM, SK~CANCELLED,
SK~RESERVED, SK~PASSNAME, SK~PASSFORM,SK~PASSBIRTH
FROM SBOOK AS SK INNER JOIN @LT_BOOKINGLIST AS BLIST
ON SK~CARRID = BLIST~CARRID
AND SK~CONNID = BLIST~CONNID
AND SK~FLDATE = BLIST~FLDATE
AND SK~BOOKID = BLIST~BOOKID
INTO TABLE @DATA(LT_SBOOK).





You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 4246 | |
| 3357 | |
| 2603 | |
| 2153 | |
| 1983 | |
| 1255 | |
| 1164 | |
| 1122 | |
| 1100 |