-* select History summary data into a hold file TABLE FILE XXXXXXXX SUM COMPUTE SALES = SALES_ACTUAL; COMPUTE PLAN_TYPE/A5 = 'HIST'; BY PLANT_NAME BY PLANT_LEVEL_01 BY SALES_OFF_NAME BY SALES_OFFICE_LEVEL_01 BY SALES_GRP_NAME BY SALES_GROUP_LEVEL_01 BY CALMONTH_NAME BY REGPRO_NAME BY REGIONAL_PRODUCT_LEVEL_01 BY MATERIAL__0PROD_HIER_NAME BY MATERIAL_NAME BY VAL_TYPE_NAME WHERE ( VMONTH_YEAR__MMYYYY__N FROM '&HS_DATE' TO '&HE_DATE') AND VVERSION_N EQ '#' AND VPLAN_START_YEAR_N EQ '&YEAR'
ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE HOLD AS DATAHOLD FORMAT ALPHA END -RUN
APP HOLD -RUNThis message has been edited. Last edited by: Tamra,