Does anyone know why the following open SQL statement:
* Fetching data from faglflexa table
SELECT docnr
buzei
HSL
ryear
rldnr
rbukrs
docln
prctr
FROM faglflexa
INTO TABLE it_belnr_prctr
FOR ALL ENTRIES IN it_pos
WHERE rldnr = '0L' AND
rbukrs = it_pos-bukrs AND
ryear = it_pos-gjahr AND
poper = it_pos-poper AND
docnr = it_pos-belnr AND
buzei = it_pos-buzei AND
prctr IN s_prctr.
Would be translated to the following when looking at the statement from DBACOCKPIT?
SELECT "DOCNR" AS c,"BUZEI" AS c,"HSL" AS c,"RYEAR" AS c,"RLDNR" AS c,"RBUKRS"
AS c,"DOCLN" AS c,"PRCTR" AS c
FROM "FAGLFLEXA"
WHERE "RCLNT" = @P1
Where are the rest of the WHERE clause items? The reason I ask is because it seems to be really slow. Thanks!
Bluesky
