P_PurOrdItmServiceSpnd

Purchase Order Item - Service Spend | view: PPOITMSERSPND | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO
Column Name Description
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
OverallLimitAmount Overall Limit
ExpectedOverallLimitAmount Expected Value of Overall Limit
Column Name Description
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
ProductType Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_PURORDITMSERVICESPND.MANDT == T001.MANDT
  • P_PURORDITMSERVICESPND.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • P_PURORDITMSERVICESPND.DOCUMENTCURRENCY == TCURC.WAERS
  • P_PURORDITMSERVICESPND.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • P_PURORDITMSERVICESPND.MANDT == MARA.MANDT
  • P_PURORDITMSERVICESPND.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURORDITMSERVICESPND.MANDT == T023.MANDT
  • P_PURORDITMSERVICESPND.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • P_PURORDITMSERVICESPND.PLANT == T001W.WERKS
  • P_PURORDITMSERVICESPND.MANDT == T001W.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_PURORDITMSERVICESPND.PURCHASEORDERITEMCATEGORY == T163.PSTYP
  • P_PURORDITMSERVICESPND.MANDT == T163.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURORDITMSERVICESPND.MANDT == T024.MANDT
  • P_PURORDITMSERVICESPND.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURORDITMSERVICESPND.MANDT == T024E.MANDT
  • P_PURORDITMSERVICESPND.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • P_PURORDITMSERVICESPND.SUPPLIER == LFA1.LIFNR
  • P_PURORDITMSERVICESPND.MANDT == LFA1.MANDT