DeliveryBlockingReasonsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - DeliveryBlockingReasonsMD
Overview
This reporting view provides a list of delivery blocks and their corresponding reason texts from the SAP system.
Data Sources
| Source Table/View | Description |
|---|---|
| TVLST | Delivery Block Table |
Key Use Cases
- Retrieve delivery block information for specific clients and languages.
- Analyze delivery block usage and reasons.
Query Logic
The view selects the client (Client_MANDT), language key (LanguageKey_SPRAS), default delivery block (DefaultDeliveryBlock_LIFSP), and delivery block reason (DeliveryBlockReason_VTEXT) from the TVLST table.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VL02N | Create 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 |