SalesOrderHeaderStatus
Arquivo SQL de origem - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesOrderHeaderStatus
Visão geral
Esta visão de relatório fornece uma visão geral abrangente do status dos documentos de vendas nos sistemas SAP. Inclui informações sobre vários aspetos do processo de vendas, como confirmação de pedido, entrega, faturamento e verificações de crédito.
Fontes de Dados
| Tabela/Visão | Descrição |
|---|---|
| vbak | Cabeçalho do Documento de Vendas |
Casos de Uso
- Analisar o status dos documentos de vendas em tempo real.
- Identificar gargalos e atrasos no processo de vendas.
- Monitorar o progresso dos pedidos de vendas e entregas.
- Executar verificações de crédito e avaliar o risco associado aos clientes.
Lógica da Query
A visão une a tabela vbak para recuperar dados sobre informações do cabeçalho do documento de vendas. Inclui campos que fornecem insights sobre o status do documento, como status de confirmação, status de entrega, status de faturamento e status de verificação de crédito.
Possível relação com transações SAP
| Código da Transação | Descrição da Transação |
|---|---|
| VA01 | Criar Pedido de Vendas |
| VA02 | Alterar Pedido de Vendas |
| VA03 | Exibir Pedido de Vendas |
| VL01N | Criar Entrega |
| VL02N | Alterar Entrega |
| VL03N | Exibir Entrega |
| VF01 | Criar Fatura |
| VF02 | Alterar Fatura |
| VF03 | Exibir Fatura |
| FD32 | Verificação de Crédito |
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 | |
| ReferenceDocumentHeaderStatus_RFSTK | Reference Document Header Status | |
| OverallReferenceStatusAllItems_RFGSK | Overall Reference Status All Items | |
| ConfirmationStatus_BESTK | Confirmation Status | |
| DeliveryStatus_LFSTK | Delivery Status | |
| OverallDeliveryStatus_LFGSK | Overall Delivery Status | |
| TotalGoodsMovementStatus_WBSTK | Total Goods Movement Status | |
| BillingStatus_FKSTK | Billing Status | |
| OrderRelatedBillingStatusAllItems_FKSAK | Order Related Billing Status All Items | |
| PostingStatusOfBillingDocument_BUCHK | Posting Status Of Billing Document | |
| RejectionsStatus_ABSTK | Rejections Status | |
| OverallProcessingStatus_GBSTK | Overall Processing Status | |
| OverallPickingPutawayStatus_KOSTK | Overall Picking Putaway Status | |
| OverallStatusOfWarehouseManagementActivities_LVSTK | Overall Status Of Warehouse Management Activities | |
| IncompletionStatusAllItems_UVALS | Incompletion Status All Items | |
| DeliveryIncompletionStatusAllItems_UVVLS | Delivery Incompletion Status All Items | |
| BillingIncompletionStatusAllItems_UVFAS | Billing Incompletion Status All Items | |
| IncompletionStatusHeader_UVALL | Incompletion Status Header | |
| DeliveryIncompletionStatusHeader_UVVLK | Delivery Incompletion Status Header | |
| BillingIncompletionStatusHeader_UVFAK | Billing Incompletion Status Header | |
| PricingIncompletionStatusAllItems_UVPRS | Pricing Incompletion Status All Items | |
| DocumentCategory_VBTYP | Document Category | |
| SdDocumentObject_VBOBJ | Sd Document Object | |
| ChangedOn_AEDAT | Changed On | |
| BillingTotalsStatusForIntercompanyBilling_FKIVK | Billing Totals Status For Intercompany Billing | |
| InvoiceListStatusOfBillingDocument_RELIK | Invoice List Status Of Billing Document | |
| CustomerReserves1HeaderStatus_UVK01 | Customer Reserves 1 Header Status | |
| CustomerReserves2HeaderStatus_UVK02 | Customer Reserves 2 Header Status | |
| CustomerReserves3HeaderStatus_UVK03 | Customer Reserves 3 Header Status | |
| CustmerReserves4HeaderStatus_UVK04 | Custmer Reserves 4 Header Status | |
| CustomerReserves5HeaderStatus_UVK05 | Customer Reserves 5 Header Status | |
| CustomerReserves1SumOfAllItems_UVS01 | Customer Reserves 1 Sum Of All Items | |
| CustomerReserves2SumOfAllItems_UVS02 | Customer Reserves 2 Sum Of All Items | |
| CustomerReserves3SumOfAllItems_UVS03 | Customer Reserves 3 Sum Of All Items | |
| CustomerReserves4SumOfAllItems_UVS04 | Customer Reserves 4 Sum Of All Items | |
| CustomerReserves5SumOfAllItems_UVS05 | Customer Reserves 5 Sum Of All Items | |
| OverallPackingStatusOfAllItems_PKSTK | Overall Packing Status Of All Items | |
| StatusOfStaticCreditLimitCheck_CMPSA | Status Of Static Credit Limit Check | |
| StatusOfDynamicCreditLimitCheckInTheCreditHorizon_CMPSB | Status Of Dynamic Credit Limit Check In The Credit Horizon | |
| StatusOfCreditCheckAgainstMaximumDocumentValue_CMPSC | Status Of Credit Check Against Maximum Document Value | |
| StatusOfCreditCheckAgainstTermsOfPayment_CMPSD | Status Of Credit Check Against Terms Of Payment | |
| StatusOfCreditCheckAgainstCustomerReviewDate_CMPSE | Status Of Credit Check Against Customer Review Date | |
| StatusOfCreditCheckAgainstOpenItemsDue_CMPSF | Status Of Credit Check Against Open Items Due | |
| StatusOfCreditCheckAgainstOldestOpenItems_CMPSG | Status Of Credit Check Against Oldest Open Items | |
| StatusOfCreditCheckAgainstHighestDunningLevel_CMPSH | Status Of Credit Check Against Highest Dunning Level | |
| StatusOfCreditCheckAgainstFinancialDocument_CMPSI | Status Of Credit Check Against Financial Document | |
| StatusOfCreditCheckAgainstExportCreditInsurance_CMPSJ | Status Of Credit Check Against Export Credit Insurance | |
| StatusOfCreditCheckAgainstPaymentCardAuthorization_CMPSK | Status Of Credit Check Against Payment Card Authorization | |
| StatusOfCreditCheckOfReserves4_CMPSL | Status Of Credit Check Of Reserves 4 | |
| StatusOfCreditCheckForCustomerReserve1_CMPS0 | Status Of Credit Check For Customer Reserve 1 | |
| StatusOfCreditCheckForCustomerReserve2_CMPS1 | Status Of Credit Check For Customer Reserve 2 | |
| StatusOfCreditCheckForCustomerReserve3_CMPS2 | Status Of Credit Check For Customer Reserve 3 | |
| OverallStatusOfCreditChecks_CMGST | Overall Status Of Credit Checks | |
| TransportationPlanningStatusHeader_TRSTA | Transportation Planning Status Header | |
| StatusOfPickConfirmation_KOQUK | Status Of Pick Confirmation | |
| ConfirmationStatusForAle_COSTA | Confirmation Status For Ale | |
| SapRelease_SAPRL | Sap Release | |
| TotalsIncompleteStatusForAllItemsPackaging_UVPAS | Totals Incomplete Status For All Items Packaging | |
| TotalsIncompleteStatusForAllItemsPicking_UVPIS | Totals Incomplete Status For All Items Picking | |
| TotalIncompleteStatusOfAllItemsPostGoodsMovement_UVWAS | Total Incomplete Status Of All Items Post Goods Movement | |
| HeaderIncompleteStatusForPackaging_UVPAK | Header Incomplete Status For Packaging | |
| HeaderIncompleteStatusForPickingPutaway_UVPIK | Header Incomplete Status For Picking Putaway | |
| PostHeaderIncompleteStatusForGoodsMovement_UVWAK | Post Header Incomplete Status For Goods Movement | |
| Unused_UVGEK | Unused | |
| CreditCheckDataIsObsolete_CMPSM | Credit Check Data Is Obsolete | |
| DelayStatus_DCSTK | Delay Status | |
| HandlingUnitPlacedInStock_VESTK | Handling Unit Placed In Stock | |
| DistributionStatusDecentralizedWarehouseProcessing_VLSTK | Distribution Status Decentralized Warehouse Processing | |
| RevenueDeterminationStatus_RRSTA | Revenue Determination Status | |
| IndicatorDocumentPreselectedForArchiving_BLOCK | Indicator Document Preselected For Archiving | |
| BillingBlockStatus_FSSTK | Billing Block Status | |
| OverallDeliveryBlockStatusAllItems_LSSTK | Overall Delivery Block Status All Items | |
| OverallBlockStatusHeader_SPSTG | Overall Block Status Header | |
| PodStatusOnHeaderLevel_PDSTK | Pod Status On Header Level | |
| StatusFundsManagement_FMSTK | Status Funds Management | |
| ManualCompletionOfContract_MANEK | Manual Completion Of Contract | |
| TemporaryInboundDelivery_SPE_TMPID | Temporary Inbound Delivery | |
| InboundDeliveryHeaderNotYetCompleteOnHold_HDALL | Inbound Delivery Header Not Yet Complete On Hold | |
| AtLeastOneOfIdItemsNotYetCompleteOnHold_HDALS | At Least One Of Id Items Not Yet Complete On Hold | |
| StatusOfCreditCheckSapCreditManagement_CMPS_CM | Status Of Credit Check Sap Credit Management | |
| StatusOfTechnicalErrorSapCreditManagement_CMPS_TE | Status Of Technical Error Sap Credit Management | |
| ExtensionOfSdDocumentCategory_VBTYP_EXT | Extension Of Sd Document Category | |
| OverallAllocationStatusSalesDocumentHeader_FSH_AR_STAT_HDR | Overall Allocation Status Sales Document Header |