DeliveryBlockingReasonsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - DeliveryBlockingReasonsMD
Overview
This reporting view provides information about delivery blocks in SAP systems. It combines data from the TVLST table to display the client, language key, default delivery block, and delivery block reason.
Data Sources
| Source Table/View | Description |
|---|---|
| TVLST | Table containing delivery block information in SAP systems. |
Key Use Cases
- Analyzing delivery block settings across different clients and languages.
- Identifying reasons for delivery blocks and taking appropriate actions.
- Reporting on the status of delivery blocks for compliance or auditing purposes.
Query Logic
The query selects the following fields from the TVLST table: Client_MANDT (client), LanguageKey_SPRAS (language key), DefaultDeliveryBlock_LIFSP (default delivery block), and DeliveryBlockReason_VTEXT (delivery block reason).
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VL02N | Create Delivery |
| VL03N | Display Delivery |
| VL06N | Change Delivery |
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 |