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

Exchange Rate by Tables

x 1

Taxes Region Text 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

Payment Terms by Tables

x 1

Account Receivable S4HANA by Tables

x 1

Account Receivable Clear Items 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	FOUNDATIONAL DATA PRODUCT
SALES AND DISTRIBUTION	SALES ORDER
SALES AND DISTRIBUTION	SALES BILLING
SALES AND DISTRIBUTION	TRADING GOODS
SALES AND DISTRIBUTION	CUSTOMER MASTER
FINANCE	ACCOUNT RECEIVABLE S4HANA
FINANCE	ACCOUNT RECEIVABLE CLEAR ITEMS
FINANCE	EXCHANGE RATE
HUMAN RESOURCES	PERSONNEL
ORGANIZATIONAL STRUCTURE	SALES ORGANIZATION
ORGANIZATIONAL STRUCTURE	DISTRIBUTION CHANNEL
ORGANIZATIONAL STRUCTURE	SALES DIVISION
ORGANIZATIONAL STRUCTURE	TAXES REGION TEXT
ORGANIZATIONAL STRUCTURE	PAYMENT TERMS
ORGANIZATIONAL STRUCTURE	NIELSEN INDICATOR
ORGANIZATIONAL STRUCTURE	SALES GROUP TEXT
ORGANIZATIONAL STRUCTURE	CUSTOMER GROUP DESCRIPTION