Question from surenekr on Mar 29 at 7:34 AM Hi
I have made query in the abap program to get arbpl field from CHRD by joining AFRU with AFVC fields AUFPL and APLZL. and AFRU join with CRHD ARBID = OBJID WHERE ltxa1 = 'Confirmation Text' AND ktsch = Std text key and STOKZ eq space.
Even I tried the same join made as a view and fetching the details with the where condition in the abap program.
Both the cases the data correctly fetches. But it takes huge time to execute this query.
Any one has any suggestion to improve the performance of this query or view.
CREATE VIEW "ZVIEW_OPRN_DET" ("RUECK", "RMZHL", "BUDAT", "ARBID", "LTXA1", "AUFNR", "VORNR", "KTSCH", "OBJID", "ARBPL",
"WERKS", "STEUS", "AUFPL", "APLZL", "STOKZ", "STZHL") AS SELECT T1."RUECK", T1."RMZHL", T1."BUDAT", T1."ARBID", T1."LTXA1",
T1."AUFNR", T1."VORNR", T2."KTSCH", T3."OBJID", T3."ARBPL", T3."WERKS", T3."STEUS", T2."AUFPL", T2."APLZL", T1."STOKZ",
T1."STZHL" FROM "AFRU" T1, "AFVC" T2, "CRHD" T3 WHERE T1."MANDT" = T2."MANDT" AND T1."AUFPL" = T2."AUFPL" AND T1."APLZL" = T2."APLZL" AND T1."MANDT" = T3."MANDT" AND T1."ARBID" = T3."OBJID".
Regards,
Suren
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
