P_MPSESData

Service Entry Sheet Data | view: PMPSESDATA | Extraction: Not supported | Component: Commercial Project Management - Project Workspace
Tables used: EKKOEKPOEKBEEKBEHESSRESLLT163BESLH
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem null
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
Column Name Description
InvoiceAmtInCoCodeCrcy Invoice Value Entered (in Local Currency)
PurOrdAmountInCompanyCodeCrcy Amount in Local Currency
Column Name Description
Quantity Quantity
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
MaterialDocumentYear Material Document Year GJAHR
PurchaseOrderStatus null
OrderStatusText null
ReferenceDocumentFiscalYear Fiscal Year of a Reference Document GJAHR
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • P_MPSESDATA.MANDT == TCURC.MANDT
  • P_MPSESDATA.CURRENCY == TCURC.WAERS
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_MPSESDATA.DELIVERYQUANTITYUNIT == T006.MSEHI
  • P_MPSESDATA.MANDT == T006.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • P_MPSESDATA.GOODSMOVEMENTTYPE == T156.BWART
  • P_MPSESDATA.MANDT == T156.MANDT
Material Number
  • Client
  • Material Number
  • P_MPSESDATA.MANDT == MARA.MANDT
  • P_MPSESDATA.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • P_MPSESDATA.PLANT == T001W.WERKS
  • P_MPSESDATA.MANDT == T001W.MANDT
Purchase Order History Category
  • Purchase Order History Category
  • Client
  • P_MPSESDATA.PURCHASEORDERHISTCATEGORY == T163B.BEWTP
  • P_MPSESDATA.MANDT == T163B.MANDT
Purchase Order Type
  • Purchase Order Type
  • Client
  • ?
  • P_MPSESDATA.PURCHASEORDERTYPE == T161.BSART
  • P_MPSESDATA.MANDT == T161.MANDT
  • P_MPSESDATA.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_MPSESDATA.MANDT == T024.MANDT
  • P_MPSESDATA.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_MPSESDATA.PURCHASINGORGANIZATION == T024E.EKORG
  • P_MPSESDATA.MANDT == T024E.MANDT