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

Compare with Current View Page History

« Previous Version 7 Next »

Data Object Definition

Material represents all information regarding goods that are relevant for production, sales, purchasing or inventory management. This can include finished products, but also raw materials, intermediates, packaging, and other material types.

Data Model

Material data in the Data Lake is composed of 6 table views:

  1. DIM_material
  2. DIM_material_type
  3. DIM_product_line
  4. DIM_material_group
  5. DIM_package_type
  6. DIM_product hierarchy

Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.

Additional Info & Comments

  • The terms Material and Product tend to be used interchangeably although there are important differences as explained below.
  • In daily business usage, the term Material tends to refer to a specific SKU including a specified packaging format, while the term Product tends to refer to a certain chemistry without specifying the packaging format (so one level higher in the product hierarchy).
  • In context of the SAP data model, SAP refers to Material in the generic sense as anything which can be held in inventory or sold. This includes finished goods, but also trading goods, raw materials and intermediates, and can even include spare parts or services. SAP distinguishes these different types based on the Material Type, where Material Type "FERT" is referred to as Finished Products.
  • In context of the Salesforce data model, Salesforce uses the term Product to refer to all saleable finished goods, while using a separate Raw Material object for raw materials. Salesforce also stores higher levels of the product hierarchy as non-saleable Products.

Data Flow

(to be added)

Tables & Attributes


View ID: prj-data-pricing-dev.DataOcean.V_DIM_material

fullnamemodetypedescription
material_key
STRING
material_id
STRING
source_system_id
STRING
material_name
STRING
arch_type
STRING
material_type_key
STRING
material_type_id
STRING
material_type_name
STRING
base_unit_of_measure
STRING
product_line_e2e
STRING
commercial_material_group_id
STRING
commercial_material_group_name
STRING
product_line_01_key
STRING
product_line_01_id
STRING
product_line_01_name
STRING
product_line_02_key
STRING
product_line_02_id
STRING
product_line_02_name
STRING
product_line_03_key
STRING
product_line_03_id
STRING
product_line_03_name
STRING
product_line_04_key
STRING
product_line_04_id
STRING
product_line_04_name
STRING
product_line_05_key
STRING
product_line_05_id
STRING
product_line_05_name
STRING
product_line_06_key
STRING
product_line_06_id
STRING
product_line_06_name
STRING
product_family_code
STRING
material_group_key
STRING
material_group_id
STRING
material_group_name
STRING
material_group_package_type_id
STRING
material_group_package_type_name
STRING
hierarchy4
STRING
product_hierarchy_key
STRING
product_hierarchy_id
STRING
product_hierarchy_name
STRING
package_type_key
STRING
package_type_id
STRING
package_type_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag

BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_material_type

fullnamemodetypedescription
material_type_key
STRING
material_type_id
STRING
source_system_id
STRING
material_type_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_package_type

fullnamemodetypedescription
package_type_key
STRING
package_type_id
STRING
source_system_id
STRING
package_type_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_product_line

fullnamemodetypedescription
product_line_key
STRING
product_line_id
STRING
product_line_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_material_group

fullnamemodetypedescription
material_group_key
STRING
material_group_id
STRING
source_system_id
STRING
material_group_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_product_hierarchy

fullnamemodetypedescription
product_hierarchy_key
STRING
product_hierarchy_id
STRING
source_system_id
STRING
product_hierarchy_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


Other Info & Comments  

-

  • No labels