P_SlsOrdItmNotDelivdDueDte

SOFM Due Date Calculation For Not Deliv. Sales Order Items | view: PSODUEDATEREUS2 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAKVBAPVBEPJESTJSTOTJ07TJ31
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
Column Name Description
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
Column Name Description
DueDate null
Column Name Description
BillingBlockStatus Billing Block Status (Item) Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
DeliveryConfirmationStatus Delivery Confirmation Status (Item) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
BusTransacExecutionAllowance Modification flag Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • P_SLSORDITMNOTDELIVDDUEDTE.MANDT == TVKOV.MANDT
  • P_SLSORDITMNOTDELIVDDUEDTE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SLSORDITMNOTDELIVDDUEDTE.SALESORGANIZATION == TVKOV.VKORG
Billing Block for Item
  • Billing Block for Item
  • Client
  • P_SLSORDITMNOTDELIVDDUEDTE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • P_SLSORDITMNOTDELIVDDUEDTE.MANDT == TVFS.MANDT
Division in order header
  • Division
  • Client
  • Distribution Channel
  • Sales Organization
  • P_SLSORDITMNOTDELIVDDUEDTE.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SLSORDITMNOTDELIVDDUEDTE.MANDT == TVTA.MANDT
  • P_SLSORDITMNOTDELIVDDUEDTE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SLSORDITMNOTDELIVDDUEDTE.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Sales Document Type
  • Client
  • P_SLSORDITMNOTDELIVDDUEDTE.SALESDOCUMENTTYPE == TVAK.AUART
  • P_SLSORDITMNOTDELIVDDUEDTE.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • P_SLSORDITMNOTDELIVDDUEDTE.MANDT == TVKO.MANDT
  • P_SLSORDITMNOTDELIVDDUEDTE.SALESORGANIZATION == TVKO.VKORG