C_PurgSpendComprn

Purchasing Spend Comparison | view: CMMPURGSPNDCOMP | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchasing Document
AccountAssignmentNumber Sequential Number of Account Assignment
ComparisonSupplier Comparison Supplier
Column Name Description
💲 Display Currency (DisplayCurrency):
NetAmountInDisplayCurrency Purchase Order Net Amount
ComparisonNetAmtInDspCrcy Comparison Net Amount in Display Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ComparisonSupplierName Name of Supplier TEXT80
Supplier Account Number of Supplier LIFNR
SupplierName Name of Supplier TEXT80
CountryName Country/Region Name TEXT50
PurchasingOrganization Purchasing organization EKORG
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroup Purchasing Group EKGRP
PurchasingGroupName Purchasing Group Name TEXT18
CompanyCode Company Code BUKRS
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
PurchaseOrderType Order Type (Purchasing)
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurchaseOrderItemCategory Item category in purchasing document
PurgDocItemCategoryName Text for Item Category TEXT20
Material Material Number MATNR
MaterialName Material Description TEXT40
MaterialGroup Material Group MATKL
MaterialGroupName Product Group Description TEXT20
Plant Plant WERKS
PlantName Plant Name TEXT30
ProductType Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
ComparisonPurchasingGroup Comparison Purchasing Group EKGRP
ComparisonPurchasingGroupName Purchasing Group Name TEXT18
ComparisonPurchasingOrg Comparison Purchasing Organization EKORG
ComparisonPurchasingOrgName Purchasing Organization Name TEXT20
ComparisonMaterialGroup Comparison Material Group MATKL
ComparisonMaterialGroupName Product Group Description TEXT20
ComparisonSupplierCountryName Country/Region Name TEXT50
PurchasingSpendRatio null
Master Data Relations Join Conditions
Comparison Supplier Country/Region
  • Comparison Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_PURGSPENDCOMPRN.COMPARISONSUPPLIERCOUNTRY == T005.LAND1
  • C_PURGSPENDCOMPRN.SUPPLIERCOUNTRY == T005.LAND1
  • C_PURGSPENDCOMPRN.MANDT == T005.MANDT
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • C_PURGSPENDCOMPRN.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURGSPENDCOMPRN.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PURGSPENDCOMPRN.COSTCENTER == CSKS.KOSTL
  • C_PURGSPENDCOMPRN.MANDT == CSKS.MANDT
Supplier Country/Region
  • Comparison Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_PURGSPENDCOMPRN.COMPARISONSUPPLIERCOUNTRY == T005.LAND1
  • C_PURGSPENDCOMPRN.SUPPLIERCOUNTRY == T005.LAND1
  • C_PURGSPENDCOMPRN.MANDT == T005.MANDT