SalesOrderHeaderStatus
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesOrderHeaderStatus
Descripción general
Esta vista de informes proporciona una descripción general completa del estado de los documentos de ventas en los sistemas SAP. Incluye información sobre varios aspectos del proceso de ventas, como la confirmación del pedido, la entrega, la facturación y las verificaciones de crédito.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| vbak | Cabecera de Documento de Venta |
Casos de uso clave
- Analizar el estado de los documentos de ventas en tiempo real.
- Identificar cuellos de botella y retrasos en el proceso de ventas.
- Supervisar el progreso de los pedidos de venta y las entregas.
- Realizar verificaciones de crédito y evaluar el riesgo asociado con los clientes.
Lógica de consulta
La vista une la tabla vbak para recuperar datos sobre la información del encabezado del documento de ventas. Incluye campos que proporcionan información sobre el estado del documento, como el estado de confirmación, el estado de entrega, el estado de facturación y el estado de verificación de crédito.
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 |
| VA03 | Mostrar Pedido de Venta |
| VL01N | Crear Entrega |
| VL02N | Cambiar Entrega |
| VL03N | Mostrar Entrega |
| VF01 | Crear Factura |
| VF02 | Cambiar Factura |
| VF03 | Mostrar Factura |
| FD32 | Verificación de Crédito |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario 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 |