SalesOrderHeaderStatus
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesOrderHeaderStatus
Overview
This reporting view provides a comprehensive overview of the status of sales documents in SAP systems. It includes information on various aspects of the sales process, such as order confirmation, delivery, billing, and credit checks.
Data Sources
| Source Table/View | Description |
|---|---|
| vbak | Sales Document Header |
Key Use Cases
- Analyzing the status of sales documents in real-time.
- Identifying bottlenecks and delays in the sales process.
- Monitoring the progress of sales orders and deliveries.
- Performing credit checks and assessing the risk associated with customers.
Query Logic
The view joins the vbak table to retrieve data on sales document header information. It includes fields that provide insights into the status of the document, such as confirmation status, delivery status, billing status, and credit check status.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VA03 | Display Sales Order |
| VL01N | Create Delivery |
| VL02N | Change Delivery |
| VL03N | Display Delivery |
| VF01 | Create Invoice |
| VF02 | Change Invoice |
| VF03 | Display Invoice |
| FD32 | Credit Check |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| 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 |