SAP Knowledge Base Article - Preview

3620521 - Performance issue when executing PIQ_CALCULATE with empty IT_ITEM

Symptom

Performance issue occurs when function module PIQ_CALCULATE is doing full table scan in method PREFILL_ITEM (class CL_PIQ_PREPARE) with empty IT_ITEM.

Method PREFILL_ITEM (class CL_PIQ_PREPARE):
...
      select (lr_source_type_db->projection) from (lr_source_type_db->table_name)
        into table <lt_mara> for all entries in it_item
        where (lc_mara_where). 
...

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP S/4HANA
  • SAP S/4HANA Cloud Private Edition

Product

SAP S/4HANA Cloud Private Edition all versions ; SAP S/4HANA all versions

Keywords

PIQ_API, Long time, Running, Slow, Slowness, Blank, Without , KBA , SD-BF-PR , Pricing , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.