C_NonMngdPurchasingSpend3

Non Managed Purchasing Spend Cube | view: CMMNONMNGDPUSPN3 | TRAN | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, BKPF, BSEG, MARA, USR21, T001, T014
Column Name Description
Column Name Description
💲 Display Currency (DisplayCurrency):
NonManagedSpendAmount Non Managed Spend Amount in Display Currency
TotalSpendAmount Total Spend Amount
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
AccountingDocument Accounting Document Number BELNR
Supplier Supplier LIFNR
CompanyCode Company Code BUKRS
AccountingDocCreatedByUser Name of Person Responsible for Creating the Object USNAM
WBSElement WBS Element PS_POSNR
CostCenter Cost Center KOSTL
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
Fund Fund BP_GEBER
ProfitCenter Profit Center PRCTR
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
CreatedByUserFullName Created by User (Description) SUIDTECHDESC
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • C_NONMNGDPURCHASINGSPEND3.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_NONMNGDPURCHASINGSPEND3.MANDT == T003.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_NONMNGDPURCHASINGSPEND3.CONTROLLINGAREA == TKA01.KOKRS
  • C_NONMNGDPURCHASINGSPEND3.MANDT == TKA01.MANDT
G/L Account
  • G/L Account
  • ?
  • Client
  • C_NONMNGDPURCHASINGSPEND3.GLACCOUNT == SKB1.SAKNR
  • C_NONMNGDPURCHASINGSPEND3.[column in domain "BUKRS"] == SKB1.BUKRS
  • C_NONMNGDPURCHASINGSPEND3.MANDT == SKB1.MANDT
Material Number
  • Material Number
  • Material Number
  • Client
  • C_NONMNGDPURCHASINGSPEND3.MATERIAL == MARA.MATNR
  • C_NONMNGDPURCHASINGSPEND3.PRODUCT == MARA.MATNR
  • C_NONMNGDPURCHASINGSPEND3.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Material Group
  • Client
  • C_NONMNGDPURCHASINGSPEND3.PRODUCTGROUP == T023.MATKL
  • C_NONMNGDPURCHASINGSPEND3.MATERIALGROUP == T023.MATKL
  • C_NONMNGDPURCHASINGSPEND3.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • C_NONMNGDPURCHASINGSPEND3.PLANT == T001W.WERKS
  • C_NONMNGDPURCHASINGSPEND3.MANDT == T001W.MANDT
Material Number
  • Material Number
  • Material Number
  • Client
  • C_NONMNGDPURCHASINGSPEND3.MATERIAL == MARA.MATNR
  • C_NONMNGDPURCHASINGSPEND3.PRODUCT == MARA.MATNR
  • C_NONMNGDPURCHASINGSPEND3.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Material Group
  • Client
  • C_NONMNGDPURCHASINGSPEND3.PRODUCTGROUP == T023.MATKL
  • C_NONMNGDPURCHASINGSPEND3.MATERIALGROUP == T023.MATKL
  • C_NONMNGDPURCHASINGSPEND3.MANDT == T023.MANDT