C_PurOrdServiceSpend

Purchase Order Service Spend | view: CMMPOSERVICESPND | TRAN | 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, T163K, MARA, T163B, LFA1, T161M

🔑 Keys (2)
💰 Amounts (5)
∑ Quantities
📅 Dates (1)
☰ Categorical
Other (8)
🔗 Relations (11)

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
OverallLimitAmount	Overall Limit
ExpectedOverallLimitAmount	Expected Value of Overall Limit
InvoiceAmtInDisplayCurrency	Invoice Amount

Column Name	Description

Column Name	Description
PurchaseOrderDate	Purchase Order Date

Column Name	Description

Column Name	Description	Domain name
PurchasingDocumentStatus	null
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

Master Data Relations	Join Conditions
Company Code Client Company Code	`C_PURORDSERVICESPEND.MANDT == T001.MANDT` `C_PURORDSERVICESPEND.COMPANYCODE == T001.BUKRS`
Material Number Client Material Number Material Number	`C_PURORDSERVICESPEND.MANDT == MARA.MANDT` `C_PURORDSERVICESPEND.MATERIAL == MARA.MATNR` `C_PURORDSERVICESPEND.PRODUCT == MARA.MATNR`
Material Group Client Material Group Material Group	`C_PURORDSERVICESPEND.MANDT == T023.MANDT` `C_PURORDSERVICESPEND.PRODUCTGROUP == T023.MATKL` `C_PURORDSERVICESPEND.MATERIALGROUP == T023.MATKL`
Plant Client Plant	`C_PURORDSERVICESPEND.MANDT == T001W.MANDT` `C_PURORDSERVICESPEND.PLANT == T001W.WERKS`
Material Number Client Material Number Material Number	`C_PURORDSERVICESPEND.MANDT == MARA.MANDT` `C_PURORDSERVICESPEND.MATERIAL == MARA.MATNR` `C_PURORDSERVICESPEND.PRODUCT == MARA.MATNR`
Material Group Client Material Group Material Group	`C_PURORDSERVICESPEND.MANDT == T023.MANDT` `C_PURORDSERVICESPEND.PRODUCTGROUP == T023.MATKL` `C_PURORDSERVICESPEND.MATERIALGROUP == T023.MATKL`
Item category in purchasing document Client Item category in purchasing document	`C_PURORDSERVICESPEND.MANDT == T163.MANDT` `C_PURORDSERVICESPEND.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Purchasing Group Purchasing Group Client	`C_PURORDSERVICESPEND.PURCHASINGGROUP == T024.EKGRP` `C_PURORDSERVICESPEND.MANDT == T024.MANDT`
Purchasing organization Client Purchasing organization	`C_PURORDSERVICESPEND.MANDT == T024E.MANDT` `C_PURORDSERVICESPEND.PURCHASINGORGANIZATION == T024E.EKORG`
Supplier Supplier Client	`C_PURORDSERVICESPEND.SUPPLIER == LFA1.LIFNR` `C_PURORDSERVICESPEND.MANDT == LFA1.MANDT`
Country/Region Key Country/Region Key Client	`C_PURORDSERVICESPEND.SUPPLIERCOUNTRY == T005.LAND1` `C_PURORDSERVICESPEND.MANDT == T005.MANDT`