C_MaintOrdActualCostDataQ

Maintenance Order Actual Cost Data Query | view: CMTORDACTCOSTDQ | Extraction: Not supported | Component: Maintenance Orders

Tables used: SCAL_TT_DATE, AFKO, QMEL, AFIH, ACDOCA, T004, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, HRRP_ATTR_NODE, HRRP_NODE, SKA1, ILOA, AUFK, CRHD, ITOBCUST, IFLOUSR, FINSC_LEDGER_REP

🔑 Keys (6)
💰 Amounts (3)
∑ Quantities
📅 Dates
☰ Categorical (2)
Other (9)
🔗 Relations (26)

Column Name	Description
SourceLedger FK	Source Ledger
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
AccountingDocument	Journal Entry
LedgerGLLineItem	Ledger Journal Entry Item
Ledger FK	Ledger in General Ledger Accounting

Column Name	Description
AmountInCompanyCodeCurrency	Amount in Company Code Currency
AmountInGlobalCurrency	Amount in Global Currency
AmountInTransactionCurrency	Amount in Transaction Currency

Column Name	Description

Column Name	Description

Column Name	Description
MaintenanceOrderIsPlanned	Planned Parts/Work	Show values
MaintenanceOrderPlanningCode	Maintenance order planning indicator	Show values

Column Name	Description	Domain name
PostingMonth	Calendar Month	NUM2
MaintOrdMainWorkCenter	Work Center
MaintenanceItem	Maintenance item	POSNU
WorkCenter	Work Center
FunctionalLocationLabelName	Functional Location Label	ILOM_STRNO
ManufacturerPartTypeName	Manufacturer model number	TYPBZ
TechnicalObjectType	Type of Technical Object	EQART
AssetManufacturerName	Manufacturer of Asset	TEXT30
CostElementGroup	Hierarchy parent node

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`C_MAINTORDACTUALCOSTDATAQ.ABCINDICATOR == T370C.ABCKZ` `C_MAINTORDACTUALCOSTDATAQ.MANDT == T370C.MANDT`
Assembly Assembly Client	`C_MAINTORDACTUALCOSTDATAQ.ASSEMBLY == MARA.MATNR` `C_MAINTORDACTUALCOSTDATAQ.MANDT == MARA.MANDT`
Location of maintenance object Client Maintenance Plant Location of maintenance object	`C_MAINTORDACTUALCOSTDATAQ.MANDT == T499S.MANDT` `C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEPLANT == T499S.WERKS` `C_MAINTORDACTUALCOSTDATAQ.ASSETLOCATION == T499S.STAND`
Catalog Profile Client Catalog Profile	`C_MAINTORDACTUALCOSTDATAQ.MANDT == T352B.MANDT` `C_MAINTORDACTUALCOSTDATAQ.CATALOGPROFILE == T352B.RBNR`
Chart of Accounts Chart of Accounts Client	`C_MAINTORDACTUALCOSTDATAQ.CHARTOFACCOUNTS == T004.KTOPL` `C_MAINTORDACTUALCOSTDATAQ.MANDT == T004.MANDT`
Company Code Company Code Client	`C_MAINTORDACTUALCOSTDATAQ.COMPANYCODE == T001.BUKRS` `C_MAINTORDACTUALCOSTDATAQ.MANDT == T001.MANDT`
Construction type material of the object Client Construction type material of the object	`C_MAINTORDACTUALCOSTDATAQ.MANDT == MARA.MANDT` `C_MAINTORDACTUALCOSTDATAQ.CONSTRUCTIONMATERIAL == MARA.MATNR`
Controlling Area Controlling Area Controlling Area Client	`C_MAINTORDACTUALCOSTDATAQ.LOCACCTASSGMTCONTROLLINGAREA == TKA01.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.CONTROLLINGAREA == TKA01.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.MANDT == TKA01.MANDT`
Cost Center Controlling Area Controlling Area ? Client Cost Center	`C_MAINTORDACTUALCOSTDATAQ.LOCACCTASSGMTCONTROLLINGAREA == CSKS.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.CONTROLLINGAREA == CSKS.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.[column in domain "DATBI"] == CSKS.DATBI` `C_MAINTORDACTUALCOSTDATAQ.MANDT == CSKS.MANDT` `C_MAINTORDACTUALCOSTDATAQ.COSTCENTER == CSKS.KOSTL`
G/L Account G/L Account Company Code Client	`C_MAINTORDACTUALCOSTDATAQ.GLACCOUNT == SKB1.SAKNR` `C_MAINTORDACTUALCOSTDATAQ.COMPANYCODE == SKB1.BUKRS` `C_MAINTORDACTUALCOSTDATAQ.MANDT == SKB1.MANDT`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting Source Ledger	`C_MAINTORDACTUALCOSTDATAQ.MANDT == FINSC_LEDGER.MANDT` `C_MAINTORDACTUALCOSTDATAQ.LEDGER == FINSC_LEDGER.RLDNR` `C_MAINTORDACTUALCOSTDATAQ.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Controlling Area Controlling Area Controlling Area Client	`C_MAINTORDACTUALCOSTDATAQ.LOCACCTASSGMTCONTROLLINGAREA == TKA01.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.CONTROLLINGAREA == TKA01.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Controlling Area Cost Center Client	`C_MAINTORDACTUALCOSTDATAQ.[column in domain "DATBI"] == CSKS.DATBI` `C_MAINTORDACTUALCOSTDATAQ.LOCACCTASSGMTCONTROLLINGAREA == CSKS.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.CONTROLLINGAREA == CSKS.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.LOCACCTASSGMTCOSTCENTER == CSKS.KOSTL` `C_MAINTORDACTUALCOSTDATAQ.MANDT == CSKS.MANDT`
Maintenance activity type Maintenance activity type Client	`C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEACTIVITYTYPE == T353I.ILART` `C_MAINTORDACTUALCOSTDATAQ.MANDT == T353I.MANDT`
Order ID Order ID Client	`C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEORDER == AUFK.AUFNR` `C_MAINTORDACTUALCOSTDATAQ.MANDT == AUFK.MANDT`
Order Type Order Type Client	`C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEORDERTYPE == T003O.AUART` `C_MAINTORDACTUALCOSTDATAQ.MANDT == T003O.CLIENT`
Maintenance Plan Client Maintenance Plan	`C_MAINTORDACTUALCOSTDATAQ.MANDT == MPLA.MANDT` `C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEPLAN == MPLA.WARPL`
Maintenance Plant Client Maintenance Plant	`C_MAINTORDACTUALCOSTDATAQ.MANDT == T001W.MANDT` `C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEPLANT == T001W.WERKS`
Plant Client Plant Plant	`C_MAINTORDACTUALCOSTDATAQ.MANDT == T001W.MANDT` `C_MAINTORDACTUALCOSTDATAQ.WORKCENTERPLANT == T001W.WERKS` `C_MAINTORDACTUALCOSTDATAQ.MAINTORDMAINWORKCENTERPLANT == T001W.WERKS`
Plant Section Plant Section Client Maintenance Plant	`C_MAINTORDACTUALCOSTDATAQ.PLANTSECTION == T357.BEBER` `C_MAINTORDACTUALCOSTDATAQ.MANDT == T357.MANDT` `C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEPLANT == T357.WERKS`
Responsible Cost Center Controlling Area Controlling Area Client ? Responsible Cost Center	`C_MAINTORDACTUALCOSTDATAQ.LOCACCTASSGMTCONTROLLINGAREA == CSKS.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.CONTROLLINGAREA == CSKS.KOKRS` `C_MAINTORDACTUALCOSTDATAQ.MANDT == CSKS.MANDT` `C_MAINTORDACTUALCOSTDATAQ.[column in domain "DATBI"] == CSKS.DATBI` `C_MAINTORDACTUALCOSTDATAQ.RESPONSIBLECOSTCENTER == CSKS.KOSTL`
Source Ledger Ledger in General Ledger Accounting Source Ledger Client	`C_MAINTORDACTUALCOSTDATAQ.LEDGER == FINSC_LEDGER.RLDNR` `C_MAINTORDACTUALCOSTDATAQ.SOURCELEDGER == FINSC_LEDGER.RLDNR` `C_MAINTORDACTUALCOSTDATAQ.MANDT == FINSC_LEDGER.MANDT`
Plant Client Plant Plant	`C_MAINTORDACTUALCOSTDATAQ.MANDT == T001W.MANDT` `C_MAINTORDACTUALCOSTDATAQ.WORKCENTERPLANT == T001W.WERKS` `C_MAINTORDACTUALCOSTDATAQ.MAINTORDMAINWORKCENTERPLANT == T001W.WERKS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Planner Group for Customer Service and Plant Maintenance Client Maintenance Planning Plant	`C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_MAINTORDACTUALCOSTDATAQ.MANDT == T024I.MANDT` `C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEPLANNINGPLANT == T024I.IWERK`
Maintenance Planning Plant Client Maintenance Planning Plant	`C_MAINTORDACTUALCOSTDATAQ.MANDT == T399I.MANDT` `C_MAINTORDACTUALCOSTDATAQ.MAINTENANCEPLANNINGPLANT == T399I.IWERK`