P_SlsOrderInSupplyPurgIssue1

SOFM Purchasing Issue 1 V2 | view: PSOFISSUESU011V2 | Extraction: Not supported | Component: Sales Analytics
Tables used: EKKO, EKPO, EKKN, EKET, EKES, VBAK, VBAP, VBFA, EKKO, EKPO, TKA01, T000
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
SalesDocumentDate Document Date (Date Received/Sent)
DeliveryDate null
DueDate Due Date
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
SalesDocumentItem Sales Document Item POSNR
DueDays Next Action in Days DUE_DAYS
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • P_SLSORDERINSUPPLYPURGISSUE1.MANDT == TVKOV.MANDT
  • P_SLSORDERINSUPPLYPURGISSUE1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SLSORDERINSUPPLYPURGISSUE1.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • P_SLSORDERINSUPPLYPURGISSUE1.MANDT == TVTA.MANDT
  • P_SLSORDERINSUPPLYPURGISSUE1.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SLSORDERINSUPPLYPURGISSUE1.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SLSORDERINSUPPLYPURGISSUE1.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Client
  • Sales Document Type
  • P_SLSORDERINSUPPLYPURGISSUE1.MANDT == TVAK.MANDT
  • P_SLSORDERINSUPPLYPURGISSUE1.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales group
  • Sales office
  • P_SLSORDERINSUPPLYPURGISSUE1.MANDT == TVBVK.MANDT
  • P_SLSORDERINSUPPLYPURGISSUE1.SALESGROUP == TVBVK.VKGRP
  • P_SLSORDERINSUPPLYPURGISSUE1.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • P_SLSORDERINSUPPLYPURGISSUE1.MANDT == TVKO.MANDT
  • P_SLSORDERINSUPPLYPURGISSUE1.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • P_SLSORDERINSUPPLYPURGISSUE1.MANDT == KNA1.MANDT
  • P_SLSORDERINSUPPLYPURGISSUE1.SOLDTOPARTY == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Division
  • Sales office
  • Sales Organization
  • P_SLSORDERINSUPPLYPURGISSUE1.MANDT == TVKBZ.MANDT
  • P_SLSORDERINSUPPLYPURGISSUE1.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SLSORDERINSUPPLYPURGISSUE1.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SLSORDERINSUPPLYPURGISSUE1.SALESOFFICE == TVKBZ.VKBUR
  • P_SLSORDERINSUPPLYPURGISSUE1.SALESORGANIZATION == TVKBZ.VKORG