Skip to Content
0
Mar 01, 2016 at 12:02 PM

Formatted search low performance on marketing documents - SBO 9.1 PL10 HANA

161 Views

Hello,

I have this scenario:

1. Add 4 UDF - as Price type on marketing document lines.

2. Create formatted search like this:

IF $[$38.1] != '' THEN

IF $[$38.43] = '-1' THEN

SELECT 1 FROM DUMMY;

ELSE

SELECT 2 FROM DUMMY;

END IF;

END IF;

3. Using AR Invoice setup formatted search on 4 fields created in 1 step with auto refresh on Item No.

4. Reopen Document

5. Choose Item from list

On step 4 i 5 a have strange behavior.

Document just open 2-3 times slower than normal.

Populating values when Item No. is choosen also is slower 2-3 times.

This behavior was tested on 2 diferent SBO 9.1 PL 10 HANA enviroments.

Anyone have discovered similar behavior?

Generally even if i create query like SELECT 1 FROM DUMMY; document just open slow and choose Items also slows.

Regards

Przemek