C_SuplrComprnViaPurVals2

Supplier Comparison via Purchase Values Cube | view: CMMSPLRCMPURVAL2 | TRAN | 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, T163B, 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):
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
InvoiceAmtInDisplayCurrency Invoice Amount
GoodsReceiptAmountInDspCrcy Goods Receipt Amount
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
PurchaseOrderQty Purchase Order Quantity
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
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
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == T001.MANDT
  • C_SUPLRCOMPRNVIAPURVALS2.COMPANYCODE == T001.BUKRS
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • C_SUPLRCOMPRNVIAPURVALS2.[column in domain "DATBI"] == CSKS.DATBI
  • C_SUPLRCOMPRNVIAPURVALS2.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_SUPLRCOMPRNVIAPURVALS2.COSTCENTER == CSKS.KOSTL
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == CSKS.MANDT
Material Number
  • Client
  • Material Number
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == MARA.MANDT
  • C_SUPLRCOMPRNVIAPURVALS2.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == T023.MANDT
  • C_SUPLRCOMPRNVIAPURVALS2.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • C_SUPLRCOMPRNVIAPURVALS2.PLANT == T001W.WERKS
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == T006.MANDT
  • C_SUPLRCOMPRNVIAPURVALS2.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group
  • Client
  • Purchasing Group
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == T024.MANDT
  • C_SUPLRCOMPRNVIAPURVALS2.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == T024E.MANDT
  • C_SUPLRCOMPRNVIAPURVALS2.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == LFA1.MANDT
  • C_SUPLRCOMPRNVIAPURVALS2.SUPPLIER == LFA1.LIFNR
Supplier Country/Region
  • Client
  • Supplier Country/Region
  • C_SUPLRCOMPRNVIAPURVALS2.MANDT == T005.MANDT
  • C_SUPLRCOMPRNVIAPURVALS2.SUPPLIERCOUNTRY == T005.LAND1