Hello All,
We are using SAP SDI 2.5.2, Oraclelogreader adapter to connect to Oracle. Product - SAP Commissions.
There is a table with more than 3 billion records. Table has a time field EXTRACT_DATE where filters can be applied to fetch data incr...
Hi,
I am facing issue while activating the data source.
Error : Field NODENAME : Fields with variable length (STRG, SSTR, RSTR) must not be key fields. Please help me to fix the issue. Thanks!!!
dump.pngHello,
We recently upgraded to BW 7.5. Now the issue is I am getting dump while opening the TCODE RSCRM_BAPI. Does it work in 7.5?
Details:
Category ABAP programming error
Runtime Errors GETWA_NOT_ASSIGNED
ABA...
Hello Sefan,
Thank you for a nice post. It helps.
I would like to have clarification on CAP_LIMIT. I added the capability at adapters.xml and can see the same at table level also.
However when I did SELECT TOP/LIMIT, filter push down is not happen...
Hello Yogananda,I tried with different combinations. For example SELECT * FROM "VT_TABLES" WHERE "EXTRACT_DATE" = '2020-09-24'; --Converting as TIMESTAMP '2020-09-24 00:00:00.0000000'But the performance is too bad when compared with no filter (no fil...
Thank you for your reply Yogananda, I watch out for your blogs on SAP Commissions, helps a lot.More Scenarios Tried:Working Oracle - SELECT * FROM TABLES where EXTRACT_DATE = TO_TIMESTAMP('2020-09-04 14:30:59','YYYY-MM-DD HH24:MI:SS')Working in SAP -...
Hello Sven,Did you find the workaround on this, if yes can you please provide solution?https://answers.sap.com/questions/13898178/sap-sdi-filter-push-down-from-virtual-table-to-ora.htmlThank you.