P_SupplierPurchasingSpend

Purchasing Spend for Supplier | view: PSUPLRPURSPND | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Display Currency (DisplayCurrency):
PurOrdNetAmountInDisplayCrcy null
Column Name Description
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_SUPPLIERPURCHASINGSPEND.COMPANYCODE == T001.BUKRS
  • P_SUPPLIERPURCHASINGSPEND.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_SUPPLIERPURCHASINGSPEND.CURRENCY == TCURC.WAERS
  • P_SUPPLIERPURCHASINGSPEND.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • P_SUPPLIERPURCHASINGSPEND.MATERIAL == MARA.MATNR
  • P_SUPPLIERPURCHASINGSPEND.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SUPPLIERPURCHASINGSPEND.MATERIALGROUP == T023.MATKL
  • P_SUPPLIERPURCHASINGSPEND.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • P_SUPPLIERPURCHASINGSPEND.PLANT == T001W.WERKS
  • P_SUPPLIERPURCHASINGSPEND.MANDT == T001W.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_SUPPLIERPURCHASINGSPEND.MANDT == T163.MANDT
  • P_SUPPLIERPURCHASINGSPEND.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_SUPPLIERPURCHASINGSPEND.PURCHASINGGROUP == T024.EKGRP
  • P_SUPPLIERPURCHASINGSPEND.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SUPPLIERPURCHASINGSPEND.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SUPPLIERPURCHASINGSPEND.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_SUPPLIERPURCHASINGSPEND.SUPPLIER == LFA1.LIFNR
  • P_SUPPLIERPURCHASINGSPEND.MANDT == LFA1.MANDT