SalesOrderScheduleLine
Arquivo SQL de origem - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesOrderScheduleLine
Visão geral
Esta visão de relatório fornece informações detalhadas sobre linhas de programação em sistemas SAP. Ele combina dados da tabela VBEP com dimensões adicionais da tabela calendar_date_dim.
Fontes de Dados
| Tabela/Visão | Descrição |
|---|---|
| vbep | Tabela SAP contendo dados da linha de programação |
Casos de Uso
- Analisar dados da linha de programação para documentos de vendas
- Monitorar cronogramas e quantidades de entrega
- Rastrear disponibilidade e requisitos de material
- Relatar sobre status e exceções da linha de programação
Lógica da Query
A consulta seleciona todos os campos relevantes da tabela VBEP e a une à tabela calendar_date_dim no campo EDATU para adicionar 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 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 |