Skip to Content
0
Jun 29, 2020 at 02:56 PM

SAP BW - HANA SQL Generation "__numoffacttablerows"

85 Views

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