DeliveriesStatus_PerSalesOrg
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - DeliveriesStatus_PerSalesOrg
Overview
This reporting view provides a comprehensive overview of delivery-related data from SAP systems. It combines information from multiple tables to offer a holistic view of deliveries, including their status, items, and associated organizational data.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.Deliveries |
Contains core delivery information such as delivery number, sales district, shipping point, and delivery type. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.SDStatus_Items |
Provides delivery status information for each delivery item. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.SalesOrganizationsMD |
Supplies details about sales organizations, including currency, name, country, and language. |
Key Use Cases
- Analyzing delivery performance and identifying bottlenecks.
- Monitoring delivery status and tracking progress.
- Performing data analysis on delivery-related metrics.
- Providing insights for optimizing delivery processes and customer satisfaction.
Query Logic
The query combines data from the Deliveries table with optional data from the SDStatus_Items and SalesOrganizationsMD tables. It uses LEFT OUTER JOINs to ensure that all delivery records are included, even if they do not have corresponding status or sales organization data.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VL03N | Display Delivery |
| VL02N | Change Delivery |
| VL01N | Create Delivery |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client number | |
| Delivery_VBELN | Delivery number | |
| SalesDistrict_BZIRK | Sales district | |
| ShippingPointreceivingPoint_VSTEL | Shipping point/receiving point | |
| SalesOrganization_VKORG | Sales organization | |
| DeliveryType_LFART | Delivery type | |
| CompleteDeliveryDefinedForEachSalesOrder_AUTLF | Complete delivery defined for each sales order | |
| ActualQuantityDeliveredInStockkeepingUnits_LGMNG | Actual quantity delivered in stockkeeping units | |
| BaseUnitOfMeasure_MEINS | Base unit of measure | |
| LoadingDate_LDDAT | Loading date | |
| TransportationPlanningDate_TDDAT | Transportation planning date | |
| DeliveryDate_LFDAT | Delivery date | |
| UnloadingPoint_ABLAD | Unloading point | |
| Incoterms__part1___INCO1 | Incoterms (part 1) | |
| Incoterms__part2___INCO2 | Incoterms (part 2) | |
| ExportIndicator_EXPKZ | Export indicator | |
| Route_ROUTE | Route | |
| BillingBlockInSdDocument_FAKSK | Billing block in SD document | |
| DeliveryBlock_documentHeader_LIFSK | Delivery block (document header) | |
| SdDocumentCategory_VBTYP | SD document category | |
| CustomerFactoryCalendar_KNFAK | Customer factory calendar | |
| ShippingConditions_VSBED | Shipping conditions | |
| ShipToParty_KUNNR | Ship-to party | |
| SoldToParty_KUNAG | Sold-to party | |
| CustomerGroup_KDGRP | Customer group | |
| TotalWeight_BTGEW | Total weight | |
| NetWeight_NTGEW | Net weight | |
| WeightUnit_GEWEI | Weight unit | |
| VolumeUnit_VOLEH | Volume unit | |
| TotalNumberOfPackagesInDelivery_ANZPK | Total number of packages in delivery | |
| PickedItemsLocation_BEROT | Picked items location | |
| TimeOfDelivery_LFUHR | Time of delivery | |
| LoadingPoint_LSTEL | Loading point | |
| SdDocumentCurrency_WAERK | SD document currency | |
| ShippingProcessingTimeForTheEntireDocument_VBEAK | Shipping processing time for the entire document | |
| DateOfLastChange_AEDAT | Date of last change | |
| DocumentDateInDocument_BLDAT | Document date in document | |
| ReferenceDocumentNumber_XBLNR | Reference document number | |
| Date__proofOfDelivery___PODAT | Date (proof of delivery) | |
| DeliveryItem_POSNR | Delivery item | |
| MaterialNumber_MATNR | Material number | |
| MaterialGroup_MATKL | Material group | |
| Plant_WERKS | Plant | |
| StorageLocation_LGORT | Storage location | |
| SalesOrgCurrency_WAERS | Sales organization currency | |
| SalesOrgName_VTEXT | Sales organization name | |
| Country_LAND1 | Country | |
| Language_SPRAS | Language | |
| DeliveryStatus_LFSTA | Delivery status | |
| is_return | Is return | |
| Delivery_StatusItm | Delivery status item |