Data Object Definition
The Customer-Product Combination dataset contains data on all combinations of customer & product which appear in either the Sales History or the Sales Forecast. For these combinations, it stores attributes which are derived from multiple sources. It serves as a central source of derived master data for enrichment in various other datasets.
As of Oct 2023, this data is not yet available in the Pricing Data Lake. It is tentatively planned for Q1 2024.
Data Model
Additional Info & Comments
- The exact definition of customer-product combination can be different between different GBUs:
- For Novecare, the customer is managed at individual shipto level and products are specified including the material packaging format.
- For SpP, the customer is specified at the soldto level, and products are specified at the commercial product level (so valid across all different packaging types of the same chemistry).
- There can be additional nuances on whether or not incoterm, delivering plant, manufacturing plant are included - need to clarify during analysis & design.
- The customer-product dataset should specify for each CPC at least the following fields:
- GBU
- GBU Customer Segment
- End Use
- Market Cluster
- Product Hierarchy (inc. H4)
- Account Manager
- Primary shipping plant & manufacturing plant
- Primary Incoterm
- Primary Payment Term
- Contracted (Yes/No) and Latest Contract ID
- Last Invoice Price
- Forecast Price
Data Flow
- Extract Type(Snapshot/Delta/Transactional): Transactional data extracted through COPA03 and COCP07 queries (Refer Sales History and Sales Forecast tab for more details )
- Data Refresh Frequency: Jobs will be scheduled to run everyday at 8AM CET
- Data Mapping Document:
- Schedule and Dependent job details:
