I am running following code in ECC and Oracle 12c: PARAMETER : p_bupla TYPE bsis-bupla.
SELECT-OPTIONS: s_perio FOR bsis-bldat.SELECT bukrs hkont bldat gjahr belnr budat xblnr bupla gsber
FROM bsis INTO TABLE it_bsis
WHERE bukrs = '1000' AND...
We have one custom program which has been running fine. Now, we have added following code and program is taking 5-7 minutes compared to 8-10 seconds. SELECT ACCVOUCHERNO EWBNUMBER FROM ZDIGI_OOWARD_H
INTO TABLE gt_zdigi_ooward_h
FOR ALL E...
Hi Sandra,Thanks for your valuable input. Hints suggested by you was going for dump and I have never used hints, so did not try much. Just read a bit of documentation and moved to alternative.Join instead of FAE worked.
Hi Ptrck,I had tried with 5000 limit and now I tried without limit and not much difference observed. Without limit it took 2-3 seconds more (it could be server load or any other reason as well).
Hi Keremkoseoglu,We are on ECC 6.0 and Oracle 12c DB. It does not allow join with internal table.Used range for vbeln (from likp table - precondition) in where SELECT e~ACCVOUCHERNO e~EWBNUMBER v~fksto
FROM ZDIGI_OOWARD_H as e
INNER J...