SalesOrderHeaderStatus
Arquivo SQL de origem - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesOrderHeaderStatus
Visão geral
Esta visão fornece uma visão geral abrangente do status dos documentos de vendas nos sistemas SAP. Inclui informações sobre o documento de referência, confirmação, entrega, faturamento e outros status de processamento, bem como status de verificação de crédito e bloqueio.
Fontes de Dados
| Tabela/Visão | Descrição |
|---|---|
| vbuk | Tabela de Cabeçalho do Documento de Vendas |
Casos de Uso
- Analisar o status dos documentos de vendas em tempo real.
- Identificar documentos que requerem atenção ou acompanhamento.
- Monitorar o progresso dos pedidos de venda nos vários estágios de processamento.
- Executar verificações de crédito e gerenciar limites de crédito.
- Identificar e resolver quaisquer bloqueios ou problemas que possam estar impedindo a conclusão dos documentos de vendas.
Lógica da Query
A visão é uma instrução SELECT simples que recupera todas as colunas da tabela vbuk.
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 |
| VA03 | Exibir Pedido de Venda |
| FBL1N | Exibir Itens de Linha: Visão Geral do Documento |
| FD32 | Manter Área de Controle de Crédito |
| OV09 | Manter Controle de 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 |