Data Object Definition
...
BOM (Bill of Material), is is a cost-focused recipe of everything required to build a material, including energy and logistic related costs.
Deployment Status
...
...
This data is available in the Data Ocean as of Q4 2024.
...
Data will be refreshed from SAP-BW into data ocean on a daily basis
Will extract forecast data from CPCOPC04 data latest month of transactions on a daily basis and refresh into data ocean. This will include next 24 months of data
- Will extract last 27months data from MVCOPA06 SAP-BW query
- Stage table will be partitioned on meta_stg_Insert_date
- ODS table will be partitioned on meta_ods_Insert_date
- FACT_bom_raw, FACT_bom_flc_raw and FACT_bom_enriched tables will be partitioned on running_month
- Refer below data flow diagram for in-detailed low level design of the flow.
https://docs.google.com/drawings/d/1sC8p4J9RtrwRuKXOvgM3a-r4R4Bj5Hs0IJIVqEI9eYY/edit
https://docs.google.com/drawings/d/1y1-_4IROiqBsFIJ_SMRCW-1pgoiREAZC--ceOIZojwU/edit
Refer below data flow diagram for low level data flow design:
...