C_PurOrdServiceSpendQuery

Service Spend | view: CMMPOSERSPNDQ | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, EKKO, EKPO, EKET, MMPUR_SES_HEADER, MMPUR_SES_ITEM, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, EKKO, EKPO, MARA, T163K, T005, T005T, MARA, T001W, MARA, T023, T023T, MAKT, T163B, T024, T024E, T163, T163Y, LFA1, T161M
Column Name Description
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Display Currency (DisplayCurrency):
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
TotalNetAmount Confirmed Amount of Service Entry Sheet
InvoiceAmtInDisplayCurrency Invoice Amount
ExpectedOverallLimitAmount Expected Value of Overall Limit
OverallLimitAmount Overall Limit
Column Name Description
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingDocumentStatus null
PurchasingDocumentStatusName Purchasing Document Status Name
MaterialName Product Description TEXT40
MaterialGroupName Product Group Description TEXT20
CountryName Country/Region Name TEXT50
PlantName Plant Name TEXT30
ProductType Product Type MTART
ProductTypeCode Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
CalendarWeek Calendar Week NUM2
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarYear Calendar Year NUM4
PurgDocItemCategoryName Text for Item Category TEXT20
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_PURORDSERVICESPENDQUERY.MANDT == T001.MANDT
  • C_PURORDSERVICESPENDQUERY.COMPANYCODE == T001.BUKRS
Material Number
  • Material Number
  • Client
  • C_PURORDSERVICESPENDQUERY.MATERIAL == MARA.MATNR
  • C_PURORDSERVICESPENDQUERY.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_PURORDSERVICESPENDQUERY.MANDT == T023.MANDT
  • C_PURORDSERVICESPENDQUERY.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURORDSERVICESPENDQUERY.MANDT == T001W.MANDT
  • C_PURORDSERVICESPENDQUERY.PLANT == T001W.WERKS
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • C_PURORDSERVICESPENDQUERY.PURCHASEORDERITEMCATEGORY == T163.PSTYP
  • C_PURORDSERVICESPENDQUERY.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURORDSERVICESPENDQUERY.PURCHASINGGROUP == T024.EKGRP
  • C_PURORDSERVICESPENDQUERY.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURORDSERVICESPENDQUERY.MANDT == T024E.MANDT
  • C_PURORDSERVICESPENDQUERY.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • C_PURORDSERVICESPENDQUERY.MANDT == LFA1.MANDT
  • C_PURORDSERVICESPENDQUERY.SUPPLIER == LFA1.LIFNR
Country/Region Key
  • Country/Region Key
  • Client
  • C_PURORDSERVICESPENDQUERY.SUPPLIERCOUNTRY == T005.LAND1
  • C_PURORDSERVICESPENDQUERY.MANDT == T005.MANDT