SalesOrderHeaderStatus
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesOrderHeaderStatus
Descripción general
Esta vista proporciona una descripción general completa del estado de los documentos de ventas en los sistemas SAP. Incluye información sobre el documento de referencia, la confirmación, la entrega, la facturación y otros estados de procesamiento, así como los estados de verificación de crédito y bloqueo.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| vbuk | Tabla de Cabecera de Documento de Ventas |
Casos de uso clave
- Analizar el estado de los documentos de ventas en tiempo real.
- Identificar documentos que requieren atención o seguimiento.
- Supervisar el progreso de los pedidos de venta en las distintas etapas de procesamiento.
- Realizar verificaciones de crédito y gestionar los límites de crédito.
- Identificar y resolver cualquier bloqueo o problema que pueda estar impidiendo la finalización de los documentos de ventas.
Lógica de consulta
La vista es una simple sentencia SELECT que recupera todas las columnas de la tabla vbuk.
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 |
| FBL1N | Mostrar Partidas Individuales: Resumen del Documento |
| FD32 | Mantener Área de Control de Crédito |
| OV09 | Mantener Control de 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 |