P_SlsOrdNotDelivdDueDte2

ReuseView | view: PSODUEDATEREUS21 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAK, VBEP
Column Name Description
SalesDocument Sales Document
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
SalesDocumentDate Document Date (Date Received/Sent)
DueDate null
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallDeliveryBlockStatus Overall Delivery Block Status (All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • P_SLSORDNOTDELIVDDUEDTE2.MANDT == TVLS.MANDT
  • P_SLSORDNOTDELIVDDUEDTE2.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • P_SLSORDNOTDELIVDDUEDTE2.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SLSORDNOTDELIVDDUEDTE2.MANDT == TVKOV.MANDT
  • P_SLSORDNOTDELIVDDUEDTE2.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • P_SLSORDNOTDELIVDDUEDTE2.MANDT == TVFS.MANDT
  • P_SLSORDNOTDELIVDDUEDTE2.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • P_SLSORDNOTDELIVDDUEDTE2.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SLSORDNOTDELIVDDUEDTE2.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SLSORDNOTDELIVDDUEDTE2.MANDT == TVTA.MANDT
  • P_SLSORDNOTDELIVDDUEDTE2.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Sales Document Type
  • Client
  • P_SLSORDNOTDELIVDDUEDTE2.SALESDOCUMENTTYPE == TVAK.AUART
  • P_SLSORDNOTDELIVDDUEDTE2.MANDT == TVAK.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • P_SLSORDNOTDELIVDDUEDTE2.MANDT == TVBVK.MANDT
  • P_SLSORDNOTDELIVDDUEDTE2.SALESOFFICE == TVBVK.VKBUR
  • P_SLSORDNOTDELIVDDUEDTE2.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • P_SLSORDNOTDELIVDDUEDTE2.MANDT == TVKO.MANDT
  • P_SLSORDNOTDELIVDDUEDTE2.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • P_SLSORDNOTDELIVDDUEDTE2.SOLDTOPARTY == KNA1.KUNNR
  • P_SLSORDNOTDELIVDDUEDTE2.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Distribution Channel
  • Client
  • Sales office
  • Sales Organization
  • P_SLSORDNOTDELIVDDUEDTE2.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SLSORDNOTDELIVDDUEDTE2.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SLSORDNOTDELIVDDUEDTE2.MANDT == TVKBZ.MANDT
  • P_SLSORDNOTDELIVDDUEDTE2.SALESOFFICE == TVKBZ.VKBUR
  • P_SLSORDNOTDELIVDDUEDTE2.SALESORGANIZATION == TVKBZ.VKORG