Supply and Demand Inventory Situation for Snowflake

Name: Supply and Demand Inventory Situation for Snowflake
Brand: Onibex
SKU: onibex-streamingsolutions-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-streamingsolutions-supplyanddemand-snowflake Platform: Snowflake Created by: Onibex

TECHNICAL SPECIFICATIONS

Streaming Method	Snowflake
Streaming Time	Real time
Script Language	Dynamic 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

Purchase Order by Tables

x 1

Production Confirmation 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

Inventory Movement Stock 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	FOUNDATIONAL DATA PRODUCT
SALES AND DISTRIBUTION	SALES ORDER
SALES AND DISTRIBUTION	TRADING GOODS
SALES AND DISTRIBUTION	CUSTOMER MASTER
MATERIALS MANAGEMENT	INVENTORY MOVEMENT STOCK
MATERIALS MANAGEMENT	PURCHASE ORDER
PLANT TO PRODUCE	PRODUCTION CONFIRMATION
ORGANIZATIONAL STRUCTURE	PLANTS
ORGANIZATIONAL STRUCTURE	SALES DIVISION
ORGANIZATIONAL STRUCTURE	SALES ORGANIZATION
ORGANIZATIONAL STRUCTURE	SALES OFFICE
ORGANIZATIONAL STRUCTURE	DISTRIBUTION CHANNEL
ORGANIZATIONAL STRUCTURE	SHIPPING CONDITION