POScheduleLine
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - POScheduleLine
Overview
This reporting view provides a comprehensive overview of purchasing documents and their associated items in SAP systems. It combines data from the EKKO, EKET, and EKPO tables to offer insights into the status, quantities, and delivery schedules of purchase orders.
Data Sources
| Source Table/View | Description |
|---|---|
| EKKO | Header data for purchasing documents, including document type, date, vendor, and purchasing organization. |
| EKET | Schedule line data for purchasing documents, containing information about delivery schedules, quantities, and dates. |
| EKPO | Item data for purchasing documents, providing details about materials, plants, storage locations, and purchasing document categories. |
Key Use Cases
- Monitoring the status of purchase orders and their items.
- Tracking the delivery progress of goods and services.
- Analyzing purchasing patterns and identifying potential cost savings.
- Providing data for reporting and analysis purposes.
Query Logic
The view joins the EKKO, EKET, and EKPO tables on the EBELN (Purchasing Document Number) and MANDT (Client) fields. It includes fields from all three tables to provide a comprehensive view of purchasing documents and their items. Additionally, it calculates the OpenQuantity and InTransitQuantity fields based on the scheduled quantity, goods received quantity, and issued quantity.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| ME23N | Display Purchase Order |
| ME22N | Change Purchase Order |
| ME21N | Create Purchase Order |
| VL02N | Display Delivery |
| VL01N | Create 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 |