P_SalesOrderInSupplyPurgIssue3

SOFM Purchasing Issue 3 | view: PSOFISSUESU013 | Extraction: Not supported | Component: Sales Analytics
Tables used: EKKO, EKPO, EKKN, EKET, EKES, VBKD, VEDA, VBAK, VBAP, TKA01, T024E, T000, PRPS
Column Name Description
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
SalesDocumentDate Document Date (Date Received/Sent)
DueDate null
DeliveryDate null
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
IsFinallyInvoiced Final Invoice Indicator Show values
PurchasingDocumentCategory Purchasing Document Category Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
Column Name Description Domain name
PurchasingDocumentItem Item Number of Purchasing Document EBELP
SalesDocumentItem Sales Document Item POSNR
PurchaseOrderByCustomer Customer Reference BSTKD
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
PlannedDeliveryDurationInDays null
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • P_SALESORDERINSUPPLYPURGISSUE3.MANDT == TVKOV.MANDT
  • P_SALESORDERINSUPPLYPURGISSUE3.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SALESORDERINSUPPLYPURGISSUE3.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • P_SALESORDERINSUPPLYPURGISSUE3.MANDT == TVTA.MANDT
  • P_SALESORDERINSUPPLYPURGISSUE3.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SALESORDERINSUPPLYPURGISSUE3.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SALESORDERINSUPPLYPURGISSUE3.SALESORGANIZATION == TVTA.VKORG
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_SALESORDERINSUPPLYPURGISSUE3.MANDT == T006.MANDT
  • P_SALESORDERINSUPPLYPURGISSUE3.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
Order type in order header
  • Client
  • Sales Document Type
  • P_SALESORDERINSUPPLYPURGISSUE3.MANDT == TVAK.MANDT
  • P_SALESORDERINSUPPLYPURGISSUE3.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • P_SALESORDERINSUPPLYPURGISSUE3.MANDT == TVBVK.MANDT
  • P_SALESORDERINSUPPLYPURGISSUE3.SALESOFFICE == TVBVK.VKBUR
  • P_SALESORDERINSUPPLYPURGISSUE3.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • P_SALESORDERINSUPPLYPURGISSUE3.MANDT == TVKO.MANDT
  • P_SALESORDERINSUPPLYPURGISSUE3.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • P_SALESORDERINSUPPLYPURGISSUE3.SOLDTOPARTY == KNA1.KUNNR
  • P_SALESORDERINSUPPLYPURGISSUE3.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Sales office
  • Division
  • Sales Organization
  • P_SALESORDERINSUPPLYPURGISSUE3.MANDT == TVKBZ.MANDT
  • P_SALESORDERINSUPPLYPURGISSUE3.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SALESORDERINSUPPLYPURGISSUE3.SALESOFFICE == TVKBZ.VKBUR
  • P_SALESORDERINSUPPLYPURGISSUE3.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SALESORDERINSUPPLYPURGISSUE3.SALESORGANIZATION == TVKBZ.VKORG