Dear All,
Can some explain how the sales order intake process work and when data is sored in the table IFSINFO.SALES_SUMMARY_PCKCOMP_V2_TAB?
We've made a customer report based on a view called: IFSINFO.SALES_SUMMARY_PCKCOMP_V2
The view contains this:
CREATE OR REPLACE VIEW IFSINFO.SALES_SUMMARY_PCKCOMP_V2 AS
SELECT "LINE_TYPE","ORDER_NO","STATE","LINE_NO","REL_NO","LINE_ITEM_NO","LINE_STATE","CONTRACT","ORDER_TYPE","CUSTOMER_NO","CUSTOMER_NAME","CATALOG_NO","CATALOG_DESC","COUNTRY_CODE","REGION_CODE","ADDRESS_STATE","SALESMAN_CODE","S_GROUP","T_SALES_QTY","TOTAL_SALES","TOTAL_COSTS","GROSS_PROFIT","REPORT_DATE"
FROM IFSINFO.SALES_SUMMARY_PCKCOMP_V2_TAB;
When we use this view we only see data till a certain date
When we look in the table we also see no data with a report date later than that certain date.
So my question is how is the table IFSINFO.SALES_SUMMARY_PCKCOMP_V2_TAB normaly filled?
What proces or processes must be run to dow that?
Kind regards
Raymond