I_BlockedSalesOrder

Blocked Sales Order | view: ISDBLKDSLSORDER | Extraction: Not supported | Component: Sales Analytics
Tables used: LIKPLIPSVBAKFPLTVBAPVBEP
Column Name Description
SalesOrder Sales Order
Issue Issue Show values
Column Name Description
💲 Display Currency (DisplayCurrency):
TotalNetAmountInDisplayCrcy null
Column Name Description
Column Name Description
Column Name Description
Issue Issue Show values
Column Name Description Domain name
NumberOfSalesOrders Number of Sales Orders INT4
NmbrOfIssuesIncomplete Number of Issues for Incomplete in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesDeliveryBlkd Number of Issues for Delivery Block in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesCreditBlocked Number of Issues for Credit Block in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesBillingBlocked Number of Issues for Invoicing Block in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_BLOCKEDSALESORDER.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_BLOCKEDSALESORDER.MANDT == TVKOV.MANDT
  • I_BLOCKEDSALESORDER.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • I_BLOCKEDSALESORDER.ORGANIZATIONDIVISION == TVTA.SPART
  • I_BLOCKEDSALESORDER.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_BLOCKEDSALESORDER.MANDT == TVTA.MANDT
  • I_BLOCKEDSALESORDER.SALESORGANIZATION == TVTA.VKORG
Sales group
  • Sales office
  • Client
  • Sales group
  • I_BLOCKEDSALESORDER.SALESOFFICE == TVBVK.VKBUR
  • I_BLOCKEDSALESORDER.MANDT == TVBVK.MANDT
  • I_BLOCKEDSALESORDER.SALESGROUP == TVBVK.VKGRP
Order type in order header
  • Sales Document Type
  • Client
  • I_BLOCKEDSALESORDER.SALESORDERTYPE == TVAK.AUART
  • I_BLOCKEDSALESORDER.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_BLOCKEDSALESORDER.MANDT == TVKO.MANDT
  • I_BLOCKEDSALESORDER.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • I_BLOCKEDSALESORDER.MANDT == KNA1.MANDT
  • I_BLOCKEDSALESORDER.SOLDTOPARTY == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Sales office
  • Distribution Channel
  • Client
  • Sales Organization
  • I_BLOCKEDSALESORDER.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_BLOCKEDSALESORDER.SALESOFFICE == TVKBZ.VKBUR
  • I_BLOCKEDSALESORDER.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_BLOCKEDSALESORDER.MANDT == TVKBZ.MANDT
  • I_BLOCKEDSALESORDER.SALESORGANIZATION == TVKBZ.VKORG