C_PurgSpendComparison3

Purchasing Spend Comparison Cube | view: CMMPURSPNDCOMP3 | TRAN | 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
PurchaseOrderDate Purchasing Document Date
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
Column Name Description Domain name
Supplier Account Number of Supplier LIFNR
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
CompanyCode Company Code BUKRS
PurchaseOrderType Order Type (Purchasing) BSART
PurchaseOrderItemCategory Item category in purchasing document PSTYP
MaterialGroup Material Group MATKL
Material Material Number MATNR
Plant Plant WERKS
ProductType Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
ComparisonPurchasingGroup Comparison Purchasing Group EKGRP
ComparisonPurchasingOrg Comparison Purchasing Organization EKORG
ComparisonMaterialGroup Comparison Material Group MATKL
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
Master Data Relations Join Conditions
Comparison Supplier Country/Region
  • Client
  • Comparison Supplier Country/Region
  • Supplier Country/Region
  • C_PURGSPENDCOMPARISON3.MANDT == T005.MANDT
  • C_PURGSPENDCOMPARISON3.COMPARISONSUPPLIERCOUNTRY == T005.LAND1
  • C_PURGSPENDCOMPARISON3.SUPPLIERCOUNTRY == T005.LAND1
Cost Center
  • Client
  • Cost Center
  • ?
  • ?
  • C_PURGSPENDCOMPARISON3.MANDT == CSKS.MANDT
  • C_PURGSPENDCOMPARISON3.COSTCENTER == CSKS.KOSTL
  • C_PURGSPENDCOMPARISON3.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURGSPENDCOMPARISON3.[column in domain "KOKRS"] == CSKS.KOKRS
Supplier Country/Region
  • Client
  • Comparison Supplier Country/Region
  • Supplier Country/Region
  • C_PURGSPENDCOMPARISON3.MANDT == T005.MANDT
  • C_PURGSPENDCOMPARISON3.COMPARISONSUPPLIERCOUNTRY == T005.LAND1
  • C_PURGSPENDCOMPARISON3.SUPPLIERCOUNTRY == T005.LAND1