Deliveries

Source SQL File - Google Cloud Cortex Data Foundation

Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - Deliveries

Overview

This view provides a comprehensive reporting dataset for SAP systems, combining data from the LIKP and LIPS tables. It offers insights into delivery-related information, including delivery header and item-level details, along with key performance indicators and financial metrics. The view is designed to support various reporting and analysis needs within the supply chain and logistics domains.

Data Sources

Source Table/View	Description
LIKP	Delivery Header Table
LIPS	Delivery Item Table

Key Use Cases

Analyzing delivery performance and identifying areas for improvement
Monitoring key delivery metrics such as delivery time, completeness, and accuracy
Evaluating customer satisfaction and identifying trends in delivery-related issues
Supporting financial reporting and analysis related to deliveries and sales orders
Providing a consolidated view of delivery-related data for comprehensive insights and decision-making

Query Logic

The view combines data from the LIKP and LIPS tables using an INNER JOIN on the VBELN and MANDT fields. It includes numerous calculated fields and metrics, such as delivery delay, net value in target currency, and weight and volume calculations. The view also incorporates data from the currency_decimal table for currency conversion and from the calendar_date_dim table for temporal dimensions.

Possible relation with SAP Transactions

Transaction Code	Transaction Description
VL03N	Display Delivery
VL02N	Change Delivery
VL01N	Create Delivery
VF03	Display Billing Document
VF02	Change Billing Document
VF01	Create Billing Document

Data Lineage

Under Development

Table/View Fields

Field	Field Description	Description in SAP Dictionary (Comming soon)
Client_MANDT	Client number
LanguageKey_SPRAS	Language key
DefaultDeliveryBlock_LIFSP	Default delivery block
DeliveryBlockReason_VTEXT	Delivery block reason