SalesOrderScheduleLine
Arquivo SQL de origem - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesOrderScheduleLine
Visão geral
Esta visão fornece um conjunto de dados abrangente para relatórios de sistemas SAP, consolidando dados da tabela vbep e enriquecendo-os com dimensões adicionais da tabela calendar_date_dim.
Fontes de Dados
| Tabela/Visão | Descrição |
|---|---|
| vbep | Tabela de itens do documento de vendas contendo informações detalhadas sobre cada item em um documento de vendas, incluindo linhas de programação, quantidades, datas e outros dados relevantes. |
Casos de Uso
- Analisar o desempenho e as tendências de vendas por item, linha de programação e outras dimensões.
- Monitorar cronogramas de entrega e identificar possíveis atrasos ou problemas.
- Rastrear os níveis de estoque e a disponibilidade para uma gestão eficaz dos materiais.
- Fornecer insights sobre a eficiência do processo de atendimento de pedidos.
Lógica da Query
A consulta recupera todos os campos relevantes da tabela vbep e a une com a tabela calendar_date_dim no campo EDATU para enriquecer os dados com dimensões adicionais relacionadas à data.
Possível relação com transações SAP
| Código da Transação | Descrição da Transação |
|---|---|
| VA01 | Criar pedido de venda |
| VA02 | Alterar pedido de venda |
| VL01N | Criar entrega |
| VL02N | Alterar entrega |
Linhagem de dados
Em desenvolvimento
Campos da Tabela/Visão
| Campo | Descrição do Campo | Descrição no Dicionário 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 |