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
one more thing i came to know some updates will not be available in these tables.
Thank you and regards.