P_SalesOrderInDelivDueDate

SOFM Due Date Calculation For Sales Orders in Delivery | view: PSODUEDATEREUSE5 | Extraction: Not supported | Component: Sales Analytics
Tables used: LIKPLIPSVBAK
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
TotalCreditCheckStatus Overall Status of Credit Checks Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HdrGoodsMvtIncompletionStatus Goods Movement Incompletion Status (Header) Show values
HeaderPackingIncompletionSts Packing Incompletion Status (Header) Show values
HeaderPickgIncompletionStatus Picking/Putaway Incompletion Status (Header) 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
OverallChmlCmplncStatus Total Product Marketability Check Status Show values
OverallDangerousGoodsStatus Total Dangerous Goods Check Status Show values
OverallSafetyDataSheetStatus Total Safety Data Sheet Check Status Show values
ChmlCmplncStatus Product Marketability Check Status Show values
DangerousGoodsStatus Dangerous Goods Check Status Show values
SafetyDataSheetStatus Safety Data Sheet Check Status 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
Master Data Relations Join Conditions
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • P_SALESORDERINDELIVDUEDATE.DELIVERYBLOCKREASON == TVLS.LIFSP
  • P_SALESORDERINDELIVDUEDATE.MANDT == TVLS.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • P_SALESORDERINDELIVDUEDATE.SALESORGANIZATION == TVKOV.VKORG
  • P_SALESORDERINDELIVDUEDATE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SALESORDERINDELIVDUEDATE.MANDT == TVKOV.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • P_SALESORDERINDELIVDUEDATE.SALESORGANIZATION == TVTA.VKORG
  • P_SALESORDERINDELIVDUEDATE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SALESORDERINDELIVDUEDATE.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SALESORDERINDELIVDUEDATE.MANDT == TVTA.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • P_SALESORDERINDELIVDUEDATE.SALESDOCUMENTTYPE == TVAK.AUART
  • P_SALESORDERINDELIVDUEDATE.MANDT == TVAK.MANDT
Sales group
  • Sales group
  • Sales office
  • Client
  • P_SALESORDERINDELIVDUEDATE.SALESGROUP == TVBVK.VKGRP
  • P_SALESORDERINDELIVDUEDATE.SALESOFFICE == TVBVK.VKBUR
  • P_SALESORDERINDELIVDUEDATE.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • P_SALESORDERINDELIVDUEDATE.SALESORGANIZATION == TVKO.VKORG
  • P_SALESORDERINDELIVDUEDATE.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • P_SALESORDERINDELIVDUEDATE.SOLDTOPARTY == KNA1.KUNNR
  • P_SALESORDERINDELIVDUEDATE.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Distribution Channel
  • Division
  • Sales office
  • Client
  • P_SALESORDERINDELIVDUEDATE.SALESORGANIZATION == TVKBZ.VKORG
  • P_SALESORDERINDELIVDUEDATE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SALESORDERINDELIVDUEDATE.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SALESORDERINDELIVDUEDATE.SALESOFFICE == TVKBZ.VKBUR
  • P_SALESORDERINDELIVDUEDATE.MANDT == TVKBZ.MANDT