P_MPGoodsInvoicesSESUnion

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