Query execution time taking too long in OIBT Table

[rmpal]

Experts,

When we are using "Select Top 10" in OIBT table, Its take more than 3 mins to execute the query. How to overcome this issue. Kindly guide us with the solution ASAP. Enclosed image FYR.

[ManishPant]

Hi @rmpal ,

Could you check your available memory when running this query?

At one of our clients, we found that the issue was caused by the SAP HANA Engine License Peak Memory reaching its limit. After increasing the memory to 128GB, the OIBT view ran without any issues.

Since the OIBT view can be slow, I usually prefer using the OITL, ITL1, and OBTN tables.

Depending on the requirements, I join these with transaction tables like OINV, OIGN, OPCH, etc.

What specifically are you planning to use the OIBT view for?

Thanks.

Manish