Supply and Demand Inventory Situation for Flink

Name: Supply and Demand Inventory Situation for Flink
Brand: Onibex
SKU: onibex-stemingsolutions-supplyanddemand-confluent

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-confluent Platform: Confluent Created by: Onibex

TECHNICAL SPECIFICATIONS

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

To ensure a seamless and efficient implementation, this streaming solution includes a Word document containing all the necessary technical documentation. Within this file, you will find detailed information regarding key metrics, architecture overflow, data flow, key transformations and installation, enabling you to fully leverage the resource's capabilities from day one.

SCRIPTS INCLUDED:

onibex-dp-inventory-s4h-inventorysituation-silversalesorder-flinkcloud.sql
onibex-dp-inventory-s4h-inventorysituation-silverinvetory-flinkcloud.sql
onibex-dp-inventory-s4h-inventorysituation-silverproductionorder-flinkcloud.sql
onibex-dp-inventory-s4h-inventorysituation-silverpurchaseorder-flinkcloud.sql
onibex-dp-inventory-s4h-inventorysituation-goldopenoerdertracker-flinkcloud.sql
onibex-dp-inventory-s4h-inventorysituation-goldordertrackingreception-flinkcloud.sql
onibex-dp-inventory-s4h-inventorysituation-goldinventory-flinkcloud.sql
onibex-dp-inventory-s4h-inventorysituation-goldinventory-flinkcloud.sql

STREAMING SOLUTION SOURCE DATA PRODUCTS

Gain immediate visibility into the specific SAP data products included in this streaming solution. This section outlines the core Supply and Demand Inventory Situation data products and their categories, helping you assess data availability upfront to streamline your customization and deployment strategy.

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