Account Receivable Visibility for Flink

Name: Account Receivable Visibility for Flink
Brand: Onibex
SKU: onibex-streamingsolutions-accountreceivablevisibility-confluent

by Onibex

Invoicing visibility system that enables analysis of historical and real-time performance by plant, area, and division.

Reference: onibex-streamingsolutions-accountreceivablevisibility-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 Billing by Tables

x 1

Sales Order by Tables

x 1

Trading Goods by Tables

x 1

Journal Entries by Tables

x 1

Taxes Region Text by Tables

x 1

Groups Material by Tables

x 1

Nielsen Indicator by Tables

x 1

Sales Group Text by Tables

x 1

Customer Group Description by Tables

x 1

Distribution Channel by Tables

x 1

Sales Division by Tables

x 1

Personnel by Tables

x 1

Sales Organization by Tables

x 1

Material Pricing Group by Tables

x 1

DESCRIPTION

An invoicing visibility system that enables the analysis of historical and real-time performance by plant, area, and division. It identifies consumption patterns and financial deviations to optimize commercial performance and strategic decision-making.

Dependencies:

One Connect for SAP +
One Connect Stream +
Databricks and Snowflake Dynamic Tables

STREAMING SOLUTION ASSET DETAILS

FLINK SCRIPTS INCLUDED:

onibex-dp-finance-s4h-accountreceivablevisibility-currency-silver.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-customermaster-silver.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-journalentries-silver.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-materialmaster-silver.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-personnel-silver.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-salesbilling-silver.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-salesorder-silver.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-accountreceivablejournalentries-gold.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-accountreceivablesalesdocumentconsolidation-gold.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-journalentriessalesbillingconsolidation-gold.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-journalentriessummary-gold.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-journalentriesuom-gold.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-salesdocumentsummary-gold.flinkcloud.sql
onibex-dp-finance-s4h-accountreceivablevisibility-salesdocumentuom-gold.flinkcloud.sql

STREAMING SOLUTION SOURCE DATA PRODUCTS

CATEGORY	FUNDATIONAL DATA PRODUCT
SALES AND DISTRIBUTION	SALES ORDER
SALES AND DISTRIBUTION	SALES BILLING
SALES AND DISTRIBUTION	TRADING GOOD
SALES AND DISTRIBUTION	CUSTOMER MASTER
FINANCE	JOURNAL ENTRIES
FINANCE	CURRENCY
HUMAN RESOURSES	PERSONNEL
ORGANIZATIONAL STRUCTURE	SALES ORGANIZATION
ORGANIZATIONAL STRUCTURE	DISTRIBUTION CHANNEL
ORGANIZATIONAL STRUCTURE	SALES DIVISION
ORGANIZATIONAL STRUCTURE	GROUPS MATERIALS
ORGANIZATIONAL STRUCTURE	NIELSEN INDICATOR
ORGANIZATIONAL STRUCTURE	SALES GROUP TEXT
ORGANIZATIONAL STRUCTURE	MATERIAL PRICING GROUP
ORGANIZATIONAL STRUCTURE	CUSTOMER GROUP DESCRIPTION
ORGANIZATIONAL STRUCTURE	TAXES REGION TEXT