Skip to main content

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

Be the first to reply!

Reply