Dear All,
I have a query which is taking long time to execute. It would be great if someone please help me to optimize this without changing the result.
TIA
SELECT H.MANDT CLIENT,
H.OPBEL DOC_NUMBER,
P.OPUPK ITEM_NO,
P.OPUPZ SUB_ITEM_NO,
H.HERKF BILL_DESCRIPTIN_CODE,
P.AUGST CLEARING_STATUS,
P.FBNUM FORM_NUMBER,
P.GPART PARTNER,
P.VTREF BILL_NO,
P.VTRE2 SADAD_BILL_NO,
P.VKONT ACCOUNT_NUMBER,
P.ABRZU BILL_FROM_DATE,
P.ABRZO BILL_TO_DATE,
P.FAEDN PAYMENT_DUE_DATE,
P.ABWBL SUBST_DOC_NO,
P.ABWTP SUBST_DOC_TYPE,
P.BETRH * -1 AMOUNT_LCY,
P.AUGBL CLEARING_DOC_NO,
P.OPBEL ORGINAL_CLEARED_DOC_NO,
P.AUGDT CLEARING_DATE,
P.AUGBD CLEARING_POST_DATE,
P.AUGRD CLEARING_REASON,
P.AUGWA CLEARING_CURRENCY,
P.AUGBT * -1 CLEARING_AMT,
P.AUGVD CLEARING_VALUE_DATE,
P.APPLK APP_AREA,
P.HVORG MAIN_TRANSACTION_ITEM,
P.TVORG SUB_TRANSACTION_ITEM,
H.BLART DOC_TYPE,
P.PSOBTYP ACCOUNT_TYPE,
P.VKTYP_PS ACCOUNT_CATEGORY,
P.ABTYP_PS REVENUE_TYPE,
P.DUMMY DUMMY_FLG,
K.HKONT GL_ACCOUNT,
P.XANZA DOWN_PAYMENT_FLG,
P.STAKZ STATISTICAL_ITEM_TYPE,
H.BLDAT DOC_DATE,
H.BUDAT DOC_POST_DATE,
P.OPTXT DOC_TEXT,
P.PRCTR PROFIT_CENTER,
P.FAEDS CASH_DISCOUNT_DUE_DATE,
P.VERKZ ONLY_CLEARED_FLG,
P.STUDT DEFERRAL_TO_DATE,
P.SKTPZ CASH_DISCOUNT_RATE,
P.XMANL EXCLUDE_DUNNING_RUN_FLG,
P.WAERS CURRENCY,
P.KURSF EXCHANGE_RATE,
P.BETRW * -1 AMOUNT_ACY,
P.SKFBT * -1 ELIGIBLE_DISCOUNT_AMT,
P.PYMET PAYMENT_METHOD,
P.PERNR PERSONAL_NO,
P.GRKEY GROUPING_KEY,
P.PERSL PERIOD_KEY,
P.AUGOB ITEM_CANCEL_FLG,
P.WHANG REPETITION_ITEM_NO,
P.WHGRP REPETITION_GROUP,
P.XEIPH CREATE_LINE_GL_FLG,
P.XTAUS ITEM_SPLIT_FLG,
P.AUGRS CLEARING_RESTRICTION,
P.OPSTA DUNNING_INDICATOR,
P.EMGPA ALT_PARTNER,
P.EMBVT BANK_DETAIL_ID,
P.IKEY INTEREST_KEY,
P.XRAGL CLEARING_POSTING_REVERSE_FLG,
P.ASTKZ Statistic_Key_Initiating_Item,
P.ASBLG TRIGGING_DOC_NO,
H.XBLNR REFERENCE_DOC_NO,
P.INTBU AUTO_POSTING_CREATION_REASON,
P.ORUPZ SUBITEM_BEFORE_SPLIT_NO,
P.NEGBU NEGATIVE_POST_CONTROL_FLD,
P.PSWSL GL_UPDATE_CURRENCY,
P.PSWBT GL_UPDATE_AMOUNT,
P.PSWTX GL_UPDATE_TAX_AMT,
P.PSGRP DOC_ITEM_GROUP_KEY,
P.REFDOC_GUID,
P.KOFIZ ACCOUNT_DETERMINATION_ID,
P.PYEAR,
P.ZREF_DOCNO REFERENCE_FORM_NO,
P.ZLEG_FBNUM LEGACY_FORM_NUMBER,
P.ZZAPRV_CR_FB LATEST_UNPAID_FORM_NUMBER,
H.ERNAM CREATED_BY,
H.CPUDT ,
H.CPUTM
FROM SAPSR3.DFKKKO H
JOIN SAPSR3.DFKKOP P
ON (H.OPBEL = P.AUGBL AND H.MANDT = P.MANDT)
LEFT OUTER JOIN SAPSR3.DFKKOPK K
ON ( H.MANDT = K.MANDT
AND H.OPBEL = K.OPBEL
AND (P.OPUPK = K.OPUPK OR P.STAKZ <> ' ')
)
WHERE NOT EXISTS
(SELECT 0
FROM SAPSR3.DFKKOP OP
WHERE H.OPBEL = OP.OPBEL
AND H.MANDT = OP.MANDT
AND P.VKONT = OP.VKONT)
AND EXISTS (SELECT 0 FROM SAPSR3.DFKKOPK K WHERE H.MANDT = K.MANDT
AND H.OPBEL = K.OPBEL)