C_SuplrComprnViaPurVals

Supplier Comparison Via Purchase Values | view: CMMSUPPCOMPURVAL | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, EKBZ, EKBZH, EKBE, EKBEH, T001, TKA02, TKA01, T005, T005T, MARA, T023, T023T, MAKT, T001W, T163B, T024, T024E, T000, LFA1
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
💲 Display Currency (DisplayCurrency):
InvoiceAmtInDisplayCurrency Invoice Amount
GoodsReceiptAmountInDspCrcy Goods Receipt Amount
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
PurchaseOrderQty Purchase Order Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PlantName Plant Name TEXT30
SupplierName Name of Supplier TEXT80
CountryName Country/Region Name TEXT50
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
TotalSpendAmount null
ReceivedPurOrderAmtRateInPct null
InvoicedPurOrderAmtRateInPct null
PurchasingSpendRatio null
OpenOrderAmountInDspCrcy null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_SUPLRCOMPRNVIAPURVALS.COMPANYCODE == T001.BUKRS
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == T001.MANDT
Cost Center
  • ?
  • Cost Center
  • Client
  • ?
  • C_SUPLRCOMPRNVIAPURVALS.[column in domain "DATBI"] == CSKS.DATBI
  • C_SUPLRCOMPRNVIAPURVALS.COSTCENTER == CSKS.KOSTL
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == CSKS.MANDT
  • C_SUPLRCOMPRNVIAPURVALS.[column in domain "KOKRS"] == CSKS.KOKRS
Material Number
  • Material Number
  • Client
  • C_SUPLRCOMPRNVIAPURVALS.MATERIAL == MARA.MATNR
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == T023.MANDT
  • C_SUPLRCOMPRNVIAPURVALS.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == T001W.MANDT
  • C_SUPLRCOMPRNVIAPURVALS.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == T006.MANDT
  • C_SUPLRCOMPRNVIAPURVALS.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • C_SUPLRCOMPRNVIAPURVALS.PURCHASINGGROUP == T024.EKGRP
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == T024E.MANDT
  • C_SUPLRCOMPRNVIAPURVALS.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • C_SUPLRCOMPRNVIAPURVALS.SUPPLIER == LFA1.LIFNR
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == LFA1.MANDT
Supplier Country/Region
  • Client
  • Supplier Country/Region
  • C_SUPLRCOMPRNVIAPURVALS.MANDT == T005.MANDT
  • C_SUPLRCOMPRNVIAPURVALS.SUPPLIERCOUNTRY == T005.LAND1