I_MPSDDetails

Sales Document Details | view: IMPSDDETAILS | Extraction: Not supported | Component: Commercial Project Management - Project Workspace
Column Name Description
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
SalesDocumentDate Document Date (Date Received/Sent)
ContractStartDate Valid-From Date (Outline Agreements, Product Proposals)
ContractEndDate Valid-To Date (Outline Agreements, Product Proposals)
Column Name Description
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
SalesDocument Sales Document VBELN
PurchaseOrder Customer Reference BSTKD
ShipToParty Customer Number KUNNR
BillToParty Customer Number KUNNR
PayerParty Customer Number KUNNR
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesDocumentType null
PaymentTerms Description of terms of payment TEXT30
Master Data Relations Join Conditions
Sold-to Party
  • Sold-to Party
  • Client
  • I_MPSDDETAILS.CUSTOMER == KNA1.KUNNR
  • I_MPSDDETAILS.MANDT == KNA1.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • I_MPSDDETAILS.SALESORGANIZATION == TVKOV.VKORG
  • I_MPSDDETAILS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_MPSDDETAILS.MANDT == TVKOV.MANDT
Division in order header
  • Division
  • Sales Organization
  • Distribution Channel
  • Client
  • I_MPSDDETAILS.ORGANIZATIONDIVISION == TVTA.SPART
  • I_MPSDDETAILS.SALESORGANIZATION == TVTA.VKORG
  • I_MPSDDETAILS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_MPSDDETAILS.MANDT == TVTA.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_MPSDDETAILS.SALESORGANIZATION == TVKO.VKORG
  • I_MPSDDETAILS.MANDT == TVKO.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • I_MPSDDETAILS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_MPSDDETAILS.MANDT == TCURC.MANDT