P_SalesOrderInSupplyMfgIssue1

SOFM Manufacturing Issue 1 | view: PSOFISSUESU021 | Extraction: Not supported | Component: Sales Analytics
Tables used: AFKO, AFPO, VBAK, AUFK
Column Name Description
ManufacturingOrder Manufacturing Order ID
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
SalesDocumentDate Document Date (Date Received/Sent)
DueDate null
Column Name Description
ManufacturingOrderCategory Order Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
MfgOrderReleasedDateOverdue null
MfgOrderStartDateOverdue null
MfgOrderEndDateOverdue null
SalesDocument Sales Document VBELN
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • P_SALESORDERINSUPPLYMFGISSUE1.MANDT == TVKOV.MANDT
  • P_SALESORDERINSUPPLYMFGISSUE1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SALESORDERINSUPPLYMFGISSUE1.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • P_SALESORDERINSUPPLYMFGISSUE1.MANDT == TVTA.MANDT
  • P_SALESORDERINSUPPLYMFGISSUE1.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SALESORDERINSUPPLYMFGISSUE1.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SALESORDERINSUPPLYMFGISSUE1.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Client
  • Sales Document Type
  • P_SALESORDERINSUPPLYMFGISSUE1.MANDT == TVAK.MANDT
  • P_SALESORDERINSUPPLYMFGISSUE1.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • P_SALESORDERINSUPPLYMFGISSUE1.MANDT == TVBVK.MANDT
  • P_SALESORDERINSUPPLYMFGISSUE1.SALESOFFICE == TVBVK.VKBUR
  • P_SALESORDERINSUPPLYMFGISSUE1.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • P_SALESORDERINSUPPLYMFGISSUE1.MANDT == TVKO.MANDT
  • P_SALESORDERINSUPPLYMFGISSUE1.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • P_SALESORDERINSUPPLYMFGISSUE1.MANDT == KNA1.MANDT
  • P_SALESORDERINSUPPLYMFGISSUE1.SOLDTOPARTY == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Distribution Channel
  • Sales office
  • Sales Organization
  • P_SALESORDERINSUPPLYMFGISSUE1.MANDT == TVKBZ.MANDT
  • P_SALESORDERINSUPPLYMFGISSUE1.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SALESORDERINSUPPLYMFGISSUE1.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SALESORDERINSUPPLYMFGISSUE1.SALESOFFICE == TVKBZ.VKBUR
  • P_SALESORDERINSUPPLYMFGISSUE1.SALESORGANIZATION == TVKBZ.VKORG