SalesOrderScheduleLine
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesOrderScheduleLine
Descripción general
Esta vista proporciona un conjunto de datos completo para informes de sistemas SAP, consolidando datos de la tabla vbep y enriqueciéndolos con dimensiones adicionales de la tabla calendar_date_dim.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| vbep | Tabla de ítems de documento de ventas que contiene información detallada sobre cada ítem en un documento de ventas, incluyendo líneas de programación, cantidades, fechas y otros datos relevantes. |
Casos de uso clave
- Analizar el rendimiento y las tendencias de ventas por ítem, línea de programación y otras dimensiones.
- Monitorizar los cronogramas de entrega e identificar posibles retrasos o problemas.
- Rastrear los niveles de inventario y la disponibilidad para una gestión eficaz de los materiales.
- Proporcionar información sobre la eficiencia del proceso de cumplimiento de pedidos.
Lógica de consulta
La consulta recupera todos los campos relevantes de la tabla vbep y la une con la tabla calendar_date_dim en el campo EDATU para enriquecer los datos con dimensiones adicionales relacionadas con la fecha.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| VA01 | Crear orden de venta |
| VA02 | Cambiar orden de venta |
| VL01N | Crear entrega |
| VL02N | Cambiar entrega |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| Client_MANDT | Client | |
| SalesDocument_VBELN | Sales Document | |
| SalesDocumentItem_POSNR | Sales Document Item | |
| ScheduleLineNumber_ETENR | Schedule Line Number | |
| ScheduleLineCategory_ETTYP | Schedule Line Category | |
| ItemRelevantforDelivery_LFREL | Item Relevant for Delivery | |
| ScheduleLineDate_EDATU | Schedule Line Date | |
| ArrivalTime_EZEIT | Arrival Time | |
| OrderQuantityInSalesUnits_WMENG | Order Quantity In Sales Units | |
| ConfirmedQuantity_BMENG | Confirmed Quantity | |
| SalesUnit_VRKME | Sales Unit | |
| RequiredQuantityForMatManagementInStockkeepingUnits_LMENG | Required Quantity For Mat Management In Stockkeeping Units | |
| BaseUnitOfMeasure_MEINS | Base Unit Of Measure | |
| RequirementDate_BDDAT | Requirement Date | |
| RequirementType_BDART | Requirement Type | |
| PlanningType_PLART | Planning Type | |
| BusinessDocumentNumber_VBELE | Business Document Number | |
| BusinessItemNumber_POSNE | Business Item Number | |
| ScheduleLine_ETENE | Schedule Line | |
| EarliestPossibleReservationDate_RSDAT | Earliest Possible Reservation Date | |
| MaintenanceRequest_IDNNR | Maintenance Request | |
| PurchaseRequisitionNumber_BANFN | Purchase Requisition Number | |
| OrderType_BSART | Order Type | |
| PurchasingDocumentCategory_BSTYP | Purchasing Document Category | |
| ConfirmationStatusOfScheduleLine_WEPOS | Confirmation Status Of Schedule Line | |
| InvoiceReceiptIndicator_REPOS | Invoice Receipt Indicator | |
| ReturnDateForReturnablePackaging_LRGDT | Return Date For Returnable Packaging | |
| DateType_PRGRS | Date Type | |
| TransportationPlanningDate_TDDAT | Transportation Planning Date | |
| MaterialAvailabilityDate_MBDAT | Material Availability Date | |
| LoadingDate_LDDAT | Loading Date | |
| GoodsIssueDate_WADAT | Goods Issue Date | |
| CorrectedQuantityInSalesUnit_CMENG | Corrected Quantity In Sales Unit | |
| ScheduleLineBlockedForDelivery_LIFSP | Schedule Line Blocked For Delivery | |
| GroupDefinitionOfStructureData_GRSTR | Group Definition Of Structure Data | |
| RelType_ABART | Rel Type | |
| ForecastDeliveryScheduleNumber_ABRUF | Forecast Delivery Schedule Number | |
| CommittedQuantity_ROMS1 | Committed Quantity | |
| Size2_ROMS2 | Size2 | |
| Size3_ROMS3 | Size3 | |
| UnitOfMeasureForSizes1to3_ROMEI | Unit Of Measure For Sizes1to3 | |
| FormulaKey_RFORM | Formula Key | |
| NumeratorForConversionOfSalesQuantityIntoSKU_UMVKZ | Numerator For Conversion Of Sales Quantity Into SKU | |
| DenominatorForConversionOfSalesQtyIntoSKU_UMVKN | Denominator For Conversion Of Sales Qty Into SKU | |
| AvailabilityConfirmedAutomatically_VERFP | Availability Confirmed Automatically | |
| MovementType_BWART | Movement Type | |
| ItemNumberOfPurchaseRequisition_BNFPO | Item Number Of Purchase Requisition | |
| ScheduleLineTypeEDI_ETART | Schedule Line Type EDI | |
| OrderNumber_AUFNR | Order Number | |
| PlannedOrderNumber_PLNUM | Planned Order Number | |
| BOMExplosionNumber_SERNR | BOM Explosion Number | |
| CustomerEngineeringChangeStatus_AESKD | Customer Engineering Change Status | |
| Guaranteed_ABGES | Guaranteed | |
| MaterialStagingTime_MBUHR | Material Staging Time | |
| TranspPlanningTime_TDUHR | Transp Planning Time | |
| LoadingTime_LDUHR | Loading Time | |
| TimeOfGoodsIssue_WAUHR | Time Of Goods Issue | |
| RouteSchedule_AULWE | Route Schedule | |
| HandoverDateAtTheHandoverLocation_HANDOVERDATE | Handover Date At The Handover Location | |
| HandoverTimeAtTheHandoverLocation_HANDOVERTIME | Handover Time At The Handover Location | |
| DeliveryDateRule_DELIVERY_DATE_TYPE_RULE | Delivery Date Rule | |
| DeliveredQuantity_DLVQTY_BU | Delivered Quantity | |
| DeliveredQuantity_DLVQTY_SU | Delivered Quantity | |
| OpenConfirmedDeliveryQuantity_OCDQTY_BU | Open Confirmed Delivery Quantity | |
| OpenConfirmedDeliveryQuantity_OCDQTY_SU | Open Confirmed Delivery Quantity | |
| OpenRequestedDeliveryQuantity_ORDQTY_BU | Open Requested Delivery Quantity | |
| OpenRequestedDeliveryQuantity_ORDQTY_SU | Open Requested Delivery Quantity | |
| DeliveryCreationDate_CREA_DLVDATE | Delivery Creation Date | |
| ScheduleLineDate_REQ_DLVDATE | Schedule Line Date | |
| RequirementsClass_BEDAR | Requirements Class | |
| DataFilterValueForDataAging_DATAAGING | Data Filter Value For Data Aging | |
| SDDocumentCurrency_WAERK | SD Document Currency | |
| OpenDeliveryNetAmount_ODN_AMOUNT | Open Delivery Net Amount | |
| GUIDInRAWFormat_HANDLE | GUID In RAW Format | |
| LegalControlCheckStatus_LCCST | Legal Control Check Status | |
| RequestedRequirementQuantityInBaseUnit_RRQQTY_BU | Requested Requirement Quantity In Base Unit | |
| ConfirmedRequirementQuantityInBaseUnit_CRQQTY_BU | Confirmed Requirement Quantity In Base Unit | |
| DummyFunctionInLength1_DUMMY_SLSDOCSCHEDL_INCL_EEW_PS | Dummy Function In Length1 | |
| ARunRequirementAllocatedQuantity_FSH_RALLOC_QTY | A Run Requirement Allocated Quantity | |
| OrderSchedulingGroupID_FSH_OS_ID | Order Scheduling Group ID | |
| RejectionCodeForPartialQuantityRejection_FSH_PQR_RC | Rejection Code For Partial Quantity Rejection | |
| MaterialAvailabilityDateThirdPartyOrderPlanning_MBDAT_DRS | Material Availability Date Third Party Order Planning | |
| YearOfChangeDate_EDATU | Year Of Change Date | |
| MonthOfChangeDate_EDATU | Month Of Change Date | |
| WeekOfChangeDate_EDATU | Week Of Change Date | |
| QuarterOfChangeDate_EDATU | Quarter Of Change Date |