C_PurgSpendOffContract2

Off Contract Spend Cube | view: CMMSPNDCNTRT2 | TRAN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
💲 Display Currency (DisplayCurrency):
PurchaseOrderAmount Purchase Order Net Amount
AmtWithContractRefInDspCrcy Amount with Contract Reference
AmtWithoutContractRefInDspCrcy Amount without Contract Reference
Column Name Description
Column Name Description
PurchaseOrderDate Purchasing Document Date
Column Name Description
PurgDocMigrtnIsCmpltdForAnlyts Indicator for Data Migration of Schedule Line Show values
PurchaseOrderCategory Purchasing Document Category Show values
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
YearWeek Year Week NUM6
YearMonth Year Month NUM6
YearQuarter Year Quarter NUM5
PurchaseOrderType Order Type (Purchasing) BSART
PurchaseOrderItemCategory Item category in purchasing document PSTYP
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
CompanyCode Company Code BUKRS
Supplier Account Number of Supplier LIFNR
Material Material Number MATNR
MaterialGroup Material Group MATKL
Plant Plant WERKS
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurchaseOutlineAgreement Number of principal purchase agreement EBELN
PurchaseOutlineAgreementItem Item number of principal purchase agreement EBELP
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
Master Data Relations Join Conditions
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • C_PURGSPENDOFFCONTRACT2.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURGSPENDOFFCONTRACT2.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PURGSPENDOFFCONTRACT2.COSTCENTER == CSKS.KOSTL
  • C_PURGSPENDOFFCONTRACT2.MANDT == CSKS.MANDT
Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_PURGSPENDOFFCONTRACT2.SUPPLIERCOUNTRY == T005.LAND1
  • C_PURGSPENDOFFCONTRACT2.MANDT == T005.MANDT