POSchedule
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - POSchedule
Overview
This reporting view provides detailed information about schedule lines in SAP purchasing documents. It combines data from the EKET table with additional dimensions from the calendar_date_dim table, providing insights into the timing and status of schedule lines.
Data Sources
| Source Table/View | Description |
|---|---|
| eket | SAP table containing schedule line data for purchasing documents |
Key Use Cases
- Analyzing the delivery schedule of purchasing documents
- Monitoring the progress of goods receipts and deliveries
- Identifying potential delays or issues in the supply chain
- Reporting on purchasing performance and efficiency
Query Logic
The query joins the EKET table with the calendar_date_dim table on the EINDT and BEDAT fields to add temporal dimensions to the schedule line data. It also includes additional fields for budget information, handover details, and reminder messages.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| ME23N | Display Purchase Order |
| ME22N | Change Purchase Order |
| ME21N | Create Purchase Order |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| PurchasingDocumentNumber_EBELN | Purchasing Document Number | |
| ItemNumberOfPurchasingDocument_EBELP | Item Number Of Purchasing Document | |
| DeliveryScheduleLineCounter_ETENR | Delivery Schedule Line Counter | |
| ItemDeliveryDate_EINDT | Item Delivery Date | |
| StatisticsRelevantDeliveryDate_SLFDT | Statistics Relevant Delivery Date | |
| CategoryOfDeliveryDate_LPEIN | Category Of Delivery Date | |
| ScheduledQuantity_MENGE | Scheduled Quantity | |
| PreviousQuantity__deliveryScheduleLines___AMENG | Previous Quantity (delivery Schedule Lines) | |
| QuantityOfGoodsReceived_WEMNG | Quantity Of Goods Received | |
| IssuedQuantity_WAMNG | Issued Quantity | |
| DeliveryDateTimeSpot_UZEIT | Delivery Date Time Spot | |
| PurchaseRequisitionNumber_BANFN | Purchase Requisition Number | |
| ItemNumberOfPurchaseRequisition_BNFPO | Item Number Of Purchase Requisition | |
| CreationIndicator__purchaseRequisitionscheduleLines___ESTKZ | Creation Indicator (purchase Requisition schedule Lines) | |
| NumberOfQuotaArrangement_QUNUM | Number Of Quota Arrangement | |
| QuotaArrangementItem_QUPOS | Quota Arrangement Item | |
| NoOfRemindersexpeditersForScheduleLine_MAHNZ | No Of Reminders/expediters For Schedule Line | |
| OrderDateOfScheduleLine_BEDAT | Order Date Of Schedule Line | |
| NumberOfReservationdependentRequirements_RSNUM | Number Of Reservation-dependent Requirements | |
| BomExplosionNumber_SERNR | Bom Explosion Number | |
| ScheduleLineIsfixed_FIXKZ | Schedule Line Isfixed | |
| QuantityDelivered__stockTransfer___GLMNG | Quantity Delivered (stock Transfer) | |
| QuantityReduced__mrp___DABMG | Quantity Reduced (mrp) | |
| BatchNumber_CHARG | Batch Number | |
| VendorBatchNumber_LICHA | Vendor Batch Number | |
| Components_CHKOM | Components | |
| ProductionVersion_VERID | Production Version | |
| SchedulingAgreementReleaseType_ABART | Scheduling Agreement Release Type | |
| CommittedQuantity_MNG02 | Committed Quantity | |
| CommittedDate_DAT01 | Committed Date | |
| PreviousDeliveryDate_ALTDT | Previous Delivery Date | |
| RouteSchedule_AULWE | Route Schedule | |
| MaterialAvailabilityDate_MBDAT | Material Availability Date | |
| MaterialStagingTime_MBUHR | Material Staging Time | |
| LoadingDate_LDDAT | Loading Date | |
| LoadingTime__localTimeRelatingToAShippingPoint___LDUHR | Loading Time (local Time Relating To A Shipping Point) | |
| TransportationPlanningDate_TDDAT | Transportation Planning Date | |
| TranspPlanningTime__local_TDUHR | Transp Planning Time (local) | |
| GoodsIssueDate_WADAT | Goods Issue Date | |
| TimeOfGoodsIssue__local_RelatingToAPlant___WAUHR | Time Of Goods Issue (local Relating To A Plant) | |
| GoodsReceiptEndDate_ELDAT | Goods Receipt End Date | |
| GoodsReceiptEndTime__local__ELUHR | Goods Receipt End Time (local) | |
| NumberOfSerialNumbers_ANZSN | Number Of Serial Numbers | |
| Ind_ReservNotApplicableToMrpPurcReqNotCreated_NODISP | Ind Reserv Not Applicable To Mrp Purc Req Not Created | |
| DescriptionOfAGeographicalRoute_GEO_ROUTE | Description Of A Geographical Route | |
| RouteCodeForSapGlobalTradeServices_ROUTE_GTS | Route Code For Sap Global Trade Services | |
| GoodsTrafficType_GTS_IND | Goods Traffic Type | |
| ForwardingAgent_TSP | Forwarding Agent | |
| LocationNumberInApo_CD_LOCNO | Location Number In Apo | |
| ApoLocationType_CD_LOCTYPE | Apo Location Type | |
| HandoverDateAtTheHandoverLocation_HANDOVERDATE | Handover Date At The Handover Location | |
| HandoverTimeAtTheHandoverLocation_HANDOVERTIME | Handover Time At The Handover Location | |
| ArunRequirementAllocatedQuantity_FSH_RALLOC_QTY | Arun Requirement Allocated Quantity | |
| AllocatedStockQuantity_FSH_SALLOC_QTY | Allocated Stock Quantity | |
| OrderSchedulingGroupId_FSH_OS_ID | Order Scheduling Group Id | |
| UniqueNumberOfBudget_KEY_ID | Unique Number Of Budget | |
| RequiredBudget_OTB_VALUE | Required Budget | |
| OtbCurrency_OTB_CURR | Otb Currency | |
| ReservedBudgetForOtbRelevantPurchasingDocument_OTB_RES_VALUE | Reserved Budget For Otb Relevant Purchasing Document | |
| SpecialReleaseBudget_OTB_SPEC_VALUE | Special Release Budget | |
| ReasonProfileForOtbSpecialRelease_SPR_RSN_PROFILE | Reason Profile For Otb Special Release | |
| BudgetType_BUDG_TYPE | BudgetType | |
| OtbCheckStatus_OTB_STATUS | Otb Check Status | |
| ReasonIndicatorForOtbCheckStatus_OTB_REASON | Reason Indicator For Otb Check Status | |
| TypeOfOtbCheck_CHECK_TYPE | Type Of Otb Check | |
| DatelineId__guid___DL_ID | Dateline Id (guid) | |
| TransferDate_HANDOVER_DATE | Transfer Date | |
| PurchaseOrderNotTransferredToScem_NO_SCEM | Purchase Order Not Transferred To Scem | |
| CreationDateOfReminderMessageRecord_DNG_DATE | Creation Date Of Reminder Message Record | |
| CreationTimeOfReminderMessageRecord_DNG_TIME | Creation Time Of Reminder Message Record | |
| CancellationThreatMade_CNCL_ANCMNT_DONE | Cancellation Threat Made | |
| NumberOfCurrentDateShifts_DATESHIFT_NUMBER | Number Of Current Date Shifts | |
| YearOfItemDeliveryDate_EINDT | Year Of Item Delivery Date | |
| MonthOfItemDeliveryDate_EINDT | Month Of Item Delivery Date | |
| WeekOfItemDeliveryDate_EINDT | Week Of Item Delivery Date | |
| QuarterOfItemDeliveryDate_EINDT | Quarter Of Item Delivery Date | |
| YearOfOrderDateOfScheduleLine_BEDAT | Year Of Order Date Of Schedule Line | |
| MonthOfOrderDateOfScheduleLine_BEDAT | Month Of Order Date Of Schedule Line | |
| WeekOfOrderDateOfScheduleLine_BEDAT | Week Of Order Date Of Schedule Line | |
| QuarterOfOrderDateOfScheduleLine_BEDAT | Quarter Of Order Date Of Schedule Line |