Supply and Demand Inventory Situation for Snowflake

Name: Supply and Demand Inventory Situation for Snowflake
Brand: Onibex
SKU: onibex-stemingsolutions-supplyanddemand-snowflake

by Onibex

Provides real-time visibility into supply and demand, as well as the current and projected inventory status by material and plant.

Integrates stock data, open orders, and pending movements.

Reference: onibex-stemingsolutions-supplyanddemand-snowflake Platform: Snowflake Created by: Onibex

TECHNICAL SPECIFICATIONS

Streaming Method	Snowflake
Streaming Time	Real time
Script Language	Dymanic tables-SQL
Implementation Time	15 hours
Tech Layers	Data Engineering / AI Data Foundation

THIS SOLUTION CONTAINS

Customer Master by Tables

x 1

Sales Order by Tables

x 1

Trading Goods by Tables

x 1

Inventory Movement by Tables

x 1

Purchase Order by Tables

x 1

Production Order by Tables

x 1

Shipping Condition by Tables

x 1

Distribution Channel by Tables

x 1

Plants by Tables

x 1

Sales Office by Tables

x 1

Sales Division by Tables

x 1

Sales Organization by Tables

x 1

DESCRIPTION

Ensures real-time visibility into supply and demand, along with current and projected inventory status by material and plant. Integrates stock data, open orders, and pending movements. Designed to provide a unified, holistic view for supply-demand planning, optimize inventory levels, and streamline inventory control for swift decision-making and delivery planning.

Dependencies:

One Connect for SAP +
One Connect Stream +

STREAMING SOLUTION ASSET DETAILS

SCRIPTS INCLUDED:

onibex-dp-inventorysituation-s4h-silversdsalesorder-snowflake.sql
onibex-dp-inventorysituation-s4h-silvermminventorymovement-snowflake.sql
onibex-dp-inventorysituation-s4h-silverppproductionorder-snowflake.sql
onibex-dp-inventorysituation-s4h-silvermmpurchaseorder-snowflake.sql
onibex-dp-inventorysituation-s4h-goldsdopenordertracker-snowflake.sql
onibex-dp-inventorysituation-s4h-goldopertrackingreception-snowflake.sql
onibex-dp-inventorysituation-s4h-goldinventorysituation-snowflake.sql

STREAMING SOLUTION SOURCE DATA PRODUCTS

CATEGORY	FUNDATIONAL DATA PRODUCT
SALES AND DISTRIBUTION	SALES ORDER
SALES AND DISTRIBUTION	TRADING GOODS
SALES AND DISTRIBUTION	CUSTOMER MASTER
MATERIAL MANAGEMENT	INVENTORY MOVEMENT
MATERIAL MANAGEMENT	PURCHASE ORDER
PLANT TO PRODUCE	PRODUCTION ORDER
ORGANIZATIONAL STRUCTURE	PLANTS
ORGANIZATIONAL STRUCTURE	SALES DIVISION
ORGANIZATIONAL STRUCTURE	SALES ORGANIZATION
ORGANIZATIONAL STRUCTURE	SALES OFFICE
ORGANIZATIONAL STRUCTURE	DISTRIBUTION CHANNEL
ORGANIZATIONAL STRUCTURE	SHIPPING CONDITION