C_PurchaseOrderSpend

Purchase Order Spend | view: CMMPURORDSPND | TRAN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
💲 Display Currency (DisplayCurrency):
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
Column Name Description
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
PurgCatUUID Purchasing Category UUID /BOBF/CONF_KEY
SupplierCountry Supplier Country/Region LAND1
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
YearQuarter Year Quarter NUM5
PurchasingDocumentStatus null
ProductTypeCode Product Type Group CHAR2
ProductType Product Type MTART
ServicePerformer Service Performer BU_PARTNER
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
WBSElementInternalID Work Breakdown Structure Element (WBS Element) PS_POSNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription WBS Element Name TEXT40
CustomerProjectName Customer Project Name /CPD/SHORT_TEXT
CustProjWorkPackageName Plan Item Description /CPD/PLAN_ITEM_NAME
CostCenter Cost Center KOSTL
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_PURCHASEORDERSPEND.MANDT == T001.MANDT
  • C_PURCHASEORDERSPEND.COMPANYCODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • C_PURCHASEORDERSPEND.MANDT == MARA.MANDT
  • C_PURCHASEORDERSPEND.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURCHASEORDERSPEND.MANDT == T023.MANDT
  • C_PURCHASEORDERSPEND.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURCHASEORDERSPEND.MANDT == T001W.MANDT
  • C_PURCHASEORDERSPEND.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURCHASEORDERSPEND.PURCHASINGGROUP == T024.EKGRP
  • C_PURCHASEORDERSPEND.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURCHASEORDERSPEND.MANDT == T024E.MANDT
  • C_PURCHASEORDERSPEND.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • C_PURCHASEORDERSPEND.MANDT == LFA1.MANDT
  • C_PURCHASEORDERSPEND.SUPPLIER == LFA1.LIFNR