C_SupplierPurchasingSpend

Purchasing Spend for Supplier | view: CMMSUPLRPURSPND | TRAN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Display Currency (DisplayCurrency):
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
Column Name Description
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
YearQuarter Year Quarter NUM5
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
PlantName Plant Name TEXT30
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_SUPPLIERPURCHASINGSPEND.MANDT == T001.MANDT
  • C_SUPPLIERPURCHASINGSPEND.COMPANYCODE == T001.BUKRS
Material Number
  • Material Number
  • Client
  • C_SUPPLIERPURCHASINGSPEND.MATERIAL == MARA.MATNR
  • C_SUPPLIERPURCHASINGSPEND.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_SUPPLIERPURCHASINGSPEND.MANDT == T023.MANDT
  • C_SUPPLIERPURCHASINGSPEND.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_SUPPLIERPURCHASINGSPEND.MANDT == T001W.MANDT
  • C_SUPPLIERPURCHASINGSPEND.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • C_SUPPLIERPURCHASINGSPEND.MANDT == T024.MANDT
  • C_SUPPLIERPURCHASINGSPEND.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_SUPPLIERPURCHASINGSPEND.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SUPPLIERPURCHASINGSPEND.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • C_SUPPLIERPURCHASINGSPEND.MANDT == LFA1.MANDT
  • C_SUPPLIERPURCHASINGSPEND.SUPPLIER == LFA1.LIFNR