POScheduleLine
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - POScheduleLine
Overview
This reporting view provides insights into purchasing documents and their associated items, delivery schedules, and goods receipt information from SAP systems.
Data Sources
| Source Table/View | Description |
|---|---|
| eket | Delivery schedule table containing information about scheduled deliveries, quantities, and dates. |
| ekpo | Purchase order item table with details about individual items, quantities, and storage locations. |
| ekko | Purchase order header table with general information about the purchasing document, such as vendor, date, and type. |
Key Use Cases
- Analyzing purchasing patterns and trends.
- Monitoring the status of purchase orders and deliveries.
- Identifying potential delays or discrepancies in the supply chain.
- Reconciling goods received with purchase orders.
Query Logic
The view combines data from the eket, ekpo, and ekko tables using inner joins to ensure that only matching records are included. It calculates the OpenQuantity as the difference between the ScheduledQuantity and the QuantityOfGoodsReceived, considering the DeliveryCompleted_Indicator to handle completed purchase orders.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| ME21N | Create Purchase Order |
| ME22N | Change Purchase Order |
| ME23N | Display Purchase Order |
| 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 number | |
| PurchasingDocumentNumber_EBELN | Purchasing document number | |
| MaterialNumber_MATNR | Material number | |
| ItemNumberOfPurchasingDocument_EBELP | Item number of purchasing document | |
| DeliveryScheduleLineCounter_ETENR | Delivery schedule line counter | |
| Plant_WERKS | Plant | |
| StorageLocation_LGORT | Storage location | |
| ItemDeliveryDate_EINDT | Item delivery date | |
| StatisticsRelevantDeliveryDate_SLFDT | Statistics relevant delivery date | |
| ScheduledQuantity_MENGE | Scheduled quantity | |
| QuantityOfGoodsReceived_WEMNG | Quantity of goods received | |
| IssuedQuantity_WAMNG | Issued quantity | |
| PurchasingDocumentType_BSART | Purchasing document type | |
| DateOnWhichRecordWasCreated_AEDAT | Date on which record was created | |
| VendorAccountNumber_LIFNR | Vendor account number | |
| PurchasingOrganization_EKORG | Purchasing organization | |
| PurchasingGroup_EKGRP | Purchasing group | |
| PurchasingDocumentDate_BEDAT | Purchasing document date | |
| SupplyingPlantInCaseOfStockTransportOrder_RESWK | Supplying plant in case of stock transport order | |
| DeletionIndicatorInPurchasingDocument_LOEKZ | Deletion indicator in purchasing document | |
| DeliveryCompleted_Indicator_ELIKZ | Delivery completed indicator | |
| PurchasingDocumentCategory_BSTYP | Purchasing document category | |
| PurchaseRequisitionNumber_BANFN | Purchase requisition number | |
| ItemNumberOfPurchaseRequisition_BNFPO | Item number of purchase requisition | |
| ReturnsItem_RETPO | Returns item | |
| IssuingStorageLocationForStockTransportOrder_RESLO | Issuing storage location for stock transport order | |
| OpenQuantity | Open quantity | |
| InTransitQuantity | In transit quantity |