CDHDR and CDPOS table's performance issue?

752 Views

hi abapers,

In MR21 recently updated price i need to bring in output depends on date entered in input,

with out entering material in input selection criteria.

I am takeing MBEW table STPRS field for the old price and for the new price i am takeing CDPOS table VALUE_NEW field for

for newly updated price in MR21.

I am using CDHDR and CDPOS tables in this report to fetch the recent updated data. These tables are Cluster tables so we cant use joins conditions. I know that some performance draw back is there for this tables, to over come that i have used key word PACAKAGE SIZE . when i am using this option i am able to over come performance issue, but report is not fetching

some records.

one more thing i came to know some updates will not be available in these tables.

Thank you and regards.