Reply from janee on Mar 29 at 10:44 AM The path for getting from AFRU to CRHD should be:
afru to afvc on aufpl and aplzl
afvc to crhd on
objty = '8' (check the table to confirm)
afvc~ARBID = crhd~OBJID
It's important to limit the number of AFRU records. For example, you might use posting date. See if there is a secondary index on it. If not, you can add one.
| | | ---------------Original Message---------------
From: suren m
Sent: Saturday, March 29, 2014 7:35 AM
Subject: Join AFRU AFVC CRHD to get ARBPL from CHRD
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.   _.____.__ |
