SalesOrderScheduleLine
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesOrderScheduleLine
Descripción general
Esta vista de informes proporciona información detallada sobre líneas de programación en sistemas SAP. Combina datos de la tabla VBEP con dimensiones adicionales de la tabla calendar_date_dim.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| vbep | Tabla SAP que contiene datos de línea de programación |
Casos de uso clave
- Analizar datos de línea de programación para documentos de ventas
- Supervisar programas y cantidades de entrega
- Rastrear disponibilidad y requisitos de material
- Informar sobre estados y excepciones de línea de programación
Lógica de consulta
La consulta selecciona todos los campos relevantes de la tabla VBEP y la une a la tabla calendar_date_dim en el campo EDATU para agregar dimensiones adicionales relacionadas con la fecha.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| VA01 | Crear Pedido de Venta |
| VA02 | Cambiar Pedido 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 number | |
| SalesDocument_VBELN | Sales document number | |
| SalesDocumentItem_POSNR | Sales document item number | |
| 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 material 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 | Relationship type | |
| ForecastDeliveryScheduleNumber_ABRUF | Forecast delivery schedule number | |
| CommittedQuantity_ROMS1 | Committed quantity | |
| Size2_ROMS2 | Size 2 | |
| Size3_ROMS3 | Size 3 | |
| UnitOfMeasureForSizes1to3_ROMEI | Unit of measure for sizes 1 to 3 | |
| FormulaKey_RFORM | Formula key | |
| NumeratorForConversionOfSalesQuantityIntoSKU_UMVKZ | Numerator for conversion of sales quantity into SKU | |
| DenominatorForConversionOfSalesQtyIntoSKU_UMVKN | Denominator for conversion of sales quantity 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 | Transportation 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 | |
| DataFilterValueForDataAging_DATAAGING | Data filter value for data aging | |
| 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 |