Hi Gurus,
I am facing a weird issue when comparing BW Prod and with BW QA. I have a composite provider which is built on open ODS views. And on the top of composite provider there is a bex query.
Now, when I run the BEX query in RSRT and do F4 on selection - "LOGSYS" below SQL statements are generated in Quality and Prod.
QA:
SELECT "VT_ATL_CV_MDP_MARM_N"."LOGSYS" FROM "_SYS_BIC"."ZMDP/CV_MDP_MARM_N" "VT_ATL_CV_MDP_MARM_N" [Local Compensation] abap_alphanum
Production:
SELECT TO_VARCHAR(TO_ALPHANUM("VT_WST_CV_MDP_MARM_N"."LOGSYS", 000010)) FROM (SELECT "__numoffacttablerows", "LOGSYS" FROM "_SYS_BIC"."ZMDP/CV_MDP_MARM_N") "VT_WST_CV_MDP_MARM_N" GROUP BY TO_VARCHAR(TO_ALPHANUM("VT_WST_CV_MDP_MARM_N"."LOGSYS", 000010))
I checked the query in both environments and nothing changed. Then how come the SQL statements created are different. Why in prod I have "__numoffacttablerows" but it is not there in QA.
Why BW is generating two different statements although both everything same in backend?
Thanks,
Ravi Rawat