You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »


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.


Deployment Status

PLANNED

As of Oct 2023, this data is not yet available in the Pricing Data Lake. It is tentatively planned for Q1 2024.


Data Model 

Customer data in the Data Lake is composed of below tables/views:

  1. V_DIM_cpc_master
  2. V_DIM_cpic_master

Project Space: gcp-sqo-data-pricing-d
See how this entity relates to the others in the pricing data model here.


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).
    • For CM, the customer is managed at individual slodto level and products are specified including the material packaging format.
    • 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


  • cpc_master table will be built by 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:




Tables & Attributes




  • No labels