P_SalesOrderInDelivItmDueDate

SOFM Due Date Calculation For Sales Orders in Delivery | view: PSODUEDATEREUSE8 | Extraction: Not supported | Component: Sales Analytics
Tables used: LIKP, LIPS, VBAK, VBKD
Column Name Description
SalesOrder Sales Document
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
SalesDocumentDate Document Date (Date Received/Sent)
PlannedGoodsIssueDate Planned Goods Movement Date
BillingDocumentDate Billing Date
DueDate null
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
GoodsMovementStatus Goods Movement Status (Item) Show values
OverallDelivReltdBillgStatus Delivery-Related Billing Status (All Items) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
ItemPackingIncompletionStatus Packing Incompletion Status (Item) Show values
ItemPickingIncompletionStatus Picking/Putaway Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
ItemGdsMvtIncompletionSts Goods Movement Incompletion Status (Item) Show values
TrdCmplncEmbargoSts Embargo Status (Item) Show values
TrdCmplncSnctndListChkSts Screening Status (Item) Show values
TrdCmplncLegalControlSts Legal Control Check Status Show values
OverallPickingStatus Picking Status/Putaway Status (All Items) Show values
Column Name Description Domain name
PurchaseOrderByCustomer Customer Reference BSTKD
Master Data Relations Join Conditions
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • P_SALESORDERINDELIVITMDUEDATE.MANDT == TVLS.MANDT
  • P_SALESORDERINDELIVITMDUEDATE.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • P_SALESORDERINDELIVITMDUEDATE.MANDT == TVKOV.MANDT
  • P_SALESORDERINDELIVITMDUEDATE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SALESORDERINDELIVITMDUEDATE.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • P_SALESORDERINDELIVITMDUEDATE.MANDT == TVTA.MANDT
  • P_SALESORDERINDELIVITMDUEDATE.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SALESORDERINDELIVITMDUEDATE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SALESORDERINDELIVITMDUEDATE.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Client
  • Sales Document Type
  • P_SALESORDERINDELIVITMDUEDATE.MANDT == TVAK.MANDT
  • P_SALESORDERINDELIVITMDUEDATE.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • P_SALESORDERINDELIVITMDUEDATE.MANDT == TVBVK.MANDT
  • P_SALESORDERINDELIVITMDUEDATE.SALESOFFICE == TVBVK.VKBUR
  • P_SALESORDERINDELIVITMDUEDATE.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • P_SALESORDERINDELIVITMDUEDATE.MANDT == TVKO.MANDT
  • P_SALESORDERINDELIVITMDUEDATE.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • P_SALESORDERINDELIVITMDUEDATE.MANDT == KNA1.MANDT
  • P_SALESORDERINDELIVITMDUEDATE.SOLDTOPARTY == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Distribution Channel
  • Sales Organization
  • P_SALESORDERINDELIVITMDUEDATE.MANDT == TVKBZ.MANDT
  • P_SALESORDERINDELIVITMDUEDATE.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SALESORDERINDELIVITMDUEDATE.SALESOFFICE == TVKBZ.VKBUR
  • P_SALESORDERINDELIVITMDUEDATE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SALESORDERINDELIVITMDUEDATE.SALESORGANIZATION == TVKBZ.VKORG