Deliveries
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - Deliveries
Overview
This view provides reporting data for SAP systems. It combines data from the LIKP and LIPS tables to provide a comprehensive view of delivery-related information.
Data Sources
| Source Table/View | Description |
|---|---|
| LIKP | Header data for deliveries |
| LIPS | Item data for deliveries |
Key Use Cases
- Can be used to analyze delivery patterns and trends
- Can be used to identify potential areas for improvement in the delivery process
- Can be used to track the status of individual deliveries
Query Logic
The view is created using a join between the LIKP and LIPS tables. The join is performed on the VBELN field, which is the delivery number. This ensures that all of the data for a given delivery is included in the view.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VL01N | Create Delivery |
| VL02N | Change Delivery |
| VL03N | Display Delivery |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| LanguageKey_SPRAS | Language key | |
| DefaultDeliveryBlock_LIFSP | Default delivery block | |
| DeliveryBlockReason_VTEXT | Delivery block reason |