This is taking a really long time. Any input in how to tune? DBA suggested a index on BSIS table using only one field HKONT.
And also possible creating index on BKPF using MANDT,GJAHR, BSTAT, BELNR.
Any thoughts would be appreciated.
SELECT F~BUKRS F~MONAT P~HKONT F~CPUDT F~BLDAT F~BLART X~TXT20 F~XBLNR
P~PRCTR Y~KTEXT P~KOSTL Z~KTEXT F~BELNR P~WRBTR P~SHKZG F~USNAM
F~PPNAM F~GJAHR J~BUTXT P~BUZEI F~WAERS
INTO TABLE ITAB_REC FROM BSIS AS P
INNER JOIN BKPF AS F ON P~BUKRS = F~BUKRS AND
P~GJAHR = F~GJAHR AND
P~BELNR = F~BELNR
INNER JOIN T001 AS J ON P~BUKRS = J~BUKRS
INNER JOIN SKAT AS X ON P~HKONT = X~SAKNR
LEFT OUTER JOIN CEPCT AS Y ON P~PRCTR = Y~PRCTR AND
Y~SPRAS = SY-LANGU AND
Y~KOKRS = P_KOKRS
LEFT OUTER JOIN CSKT AS Z ON P~KOSTL = Z~KOSTL AND
Z~SPRAS = SY-LANGU AND
Z~KOKRS = P_KOKRS
WHERE F~BUKRS IN S_CO_CD AND
F~BSTAT = ' ' AND
F~BUDAT IN S_PST_DT AND
F~BLART IN S_DOC_TY AND
F~BLDAT IN S_DOC_DT AND
F~CPUDT IN S_ENT_DT AND
F~GJAHR IN S_FIS_YR AND
F~MONAT IN S_FIS_PD AND
F~XBLNR IN S_REF_CD AND
F~BELNR IN S_DOC_NO AND
F~PPNAM IN S_PARKBY AND
P~HKONT IN S_AC_NO AND
P~PRCTR IN S_PRCTR AND
P~KOSTL IN S_CSTCTR AND
X~SPRAS = SY-LANGU AND
X~KTOPL = P_KTOPL.
Edited by: Thomas Zloch on Sep 3, 2010 5:31 PM - code tags added
Bluesky
