POSchedule
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - POSchedule
Descripción general
Esta vista de informes proporciona información detallada sobre líneas de programación en documentos de compras SAP. Combina datos de la tabla EKET con dimensiones adicionales de la tabla calendar_date_dim, proporcionando información sobre el tiempo y el estado de las líneas de programación.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| eket | Tabla SAP que contiene datos de línea de programación para documentos de compra |
Casos de uso clave
- Analizar el programa de entrega de los documentos de compra
- Supervisar el progreso de las recepciones y entregas de mercancías
- Identificar posibles retrasos o problemas en la cadena de suministro
- Informar sobre el rendimiento y la eficiencia de las compras
Lógica de consulta
La consulta une la tabla EKET con la tabla calendar_date_dim en los campos EINDT y BEDAT para añadir dimensiones temporales a los datos de la línea de programación. También incluye campos adicionales para información presupuestaria, detalles de transferencia y mensajes de recordatorio.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| ME23N | Mostrar orden de compra |
| ME22N | Cambiar orden de compra |
| ME21N | Crear orden de compra |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| 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 |