C_MaintOrderActualCostQ

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

Tables used: SCAL_TT_DATE, AFKO, QMEL, AFIH, ACDOCA, CSKS, CSKT, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, HRRP_DIRECTORY, HRRP_FSV_DIR, HRRP_ATTR_NODE, HRRP_NODE, ILOA, AUFK, CRHD, ITOBCUST, IFLOUSR, FINSC_LEDGER_REP, T024I

🔑 Keys (7)
💰 Amounts (3)
∑ Quantities
📅 Dates
☰ Categorical (1)
Other (18)
🔗 Relations (27)

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
GLAccountHierarchy	G/L Account Hierarchy

Column Name	Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency	Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency	Amount in Global Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency	Amount in Transaction Currency

Column Name	Description

Column Name	Description

Column Name	Description
MaintenanceOrderIsPlanned	Checkbox	Show values

Column Name	Description	Domain name
PostingMonth	Calendar Month	NUM2
MaintenanceOrderPlanningCode	Maintenance order planning indicator
MaintOrdMainWorkCenter	Main work center for maintenance tasks
MaintOrdMainWorkCenterPlant	Plant associated with main work center
MaintenancePlannerGroupName	Name of the Maintenance Planner Group	TEXT18
MaintenanceItem	Maintenance item	POSNU
WorkCenter	Work Center	ARBPL
OrderOperation	Operation/Activity Number	VORNR
OrderSuboperation	Suboperation	VORNR
TechObjIsEquipOrFuncnlLoc	Technical Object Type
ManufacturerPartTypeName	Manufacturer model number	TYPBZ
TechnicalObjectType	Type of Technical Object	EQART
AssetManufacturerName	Manufacturer of Asset	TEXT30
CostElementGroup	null
LastChangeDateTime	Time Stamp of Last Change	TZNTSTMPS
FiscalPeriod	Fiscal Period	POPER
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
CostCenterName	Cost Center Name	TEXT20

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`C_MAINTORDERACTUALCOSTQ.ABCINDICATOR == T370C.ABCKZ` `C_MAINTORDERACTUALCOSTQ.MANDT == T370C.MANDT`
Assembly Client Assembly	`C_MAINTORDERACTUALCOSTQ.MANDT == MARA.MANDT` `C_MAINTORDERACTUALCOSTQ.ASSEMBLY == MARA.MATNR`
Location Client Location Location Plant	`C_MAINTORDERACTUALCOSTQ.MANDT == T499S.MANDT` `C_MAINTORDERACTUALCOSTQ.ASSETLOCATION == T499S.STAND` `C_MAINTORDERACTUALCOSTQ.MAINTENANCEPLANT == T499S.WERKS`
Catalog Profile Client Catalog Profile	`C_MAINTORDERACTUALCOSTQ.MANDT == T352B.MANDT` `C_MAINTORDERACTUALCOSTQ.CATALOGPROFILE == T352B.RBNR`
Chart of Accounts Client Chart of Accounts	`C_MAINTORDERACTUALCOSTQ.MANDT == T004.MANDT` `C_MAINTORDERACTUALCOSTQ.CHARTOFACCOUNTS == T004.KTOPL`
Company Code Client Company Code	`C_MAINTORDERACTUALCOSTQ.MANDT == T001.MANDT` `C_MAINTORDERACTUALCOSTQ.COMPANYCODE == T001.BUKRS`
Company Code Currency Client Company Code Currency	`C_MAINTORDERACTUALCOSTQ.MANDT == TCURC.MANDT` `C_MAINTORDERACTUALCOSTQ.COMPANYCODECURRENCY == TCURC.WAERS`
Construction type material of the object Construction type material of the object Client	`C_MAINTORDERACTUALCOSTQ.CONSTRUCTIONMATERIAL == MARA.MATNR` `C_MAINTORDERACTUALCOSTQ.MANDT == MARA.MANDT`
Controlling Area Client Controlling Area	`C_MAINTORDERACTUALCOSTQ.MANDT == TKA01.MANDT` `C_MAINTORDERACTUALCOSTQ.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center for Basic Settlement Cost Center for Basic Settlement Client Controlling Area ?	`C_MAINTORDERACTUALCOSTQ.COSTCENTER == CSKS.KOSTL` `C_MAINTORDERACTUALCOSTQ.MANDT == CSKS.MANDT` `C_MAINTORDERACTUALCOSTQ.CONTROLLINGAREA == CSKS.KOKRS` `C_MAINTORDERACTUALCOSTQ.[column in domain "DATBI"] == CSKS.DATBI`
Fiscal Year Variant Client Fiscal Year Variant	`C_MAINTORDERACTUALCOSTQ.MANDT == T009.MANDT` `C_MAINTORDERACTUALCOSTQ.FISCALYEARVARIANT == T009.PERIV`
G/L Account Client Company Code G/L Account	`C_MAINTORDERACTUALCOSTQ.MANDT == SKB1.MANDT` `C_MAINTORDERACTUALCOSTQ.COMPANYCODE == SKB1.BUKRS` `C_MAINTORDERACTUALCOSTQ.GLACCOUNT == SKB1.SAKNR`
Global Currency Client Global Currency	`C_MAINTORDERACTUALCOSTQ.MANDT == TCURC.MANDT` `C_MAINTORDERACTUALCOSTQ.GLOBALCURRENCY == TCURC.WAERS`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting Source Ledger	`C_MAINTORDERACTUALCOSTQ.MANDT == FINSC_LEDGER.MANDT` `C_MAINTORDERACTUALCOSTQ.LEDGER == FINSC_LEDGER.RLDNR` `C_MAINTORDERACTUALCOSTQ.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Maintenance activity type Client Maintenance activity type	`C_MAINTORDERACTUALCOSTQ.MANDT == T353I.MANDT` `C_MAINTORDERACTUALCOSTQ.MAINTENANCEACTIVITYTYPE == T353I.ILART`
Order ID Client Order ID	`C_MAINTORDERACTUALCOSTQ.MANDT == AUFK.MANDT` `C_MAINTORDERACTUALCOSTQ.MAINTENANCEORDER == AUFK.AUFNR`
Order Type Client Order Type	`C_MAINTORDERACTUALCOSTQ.MANDT == T003O.CLIENT` `C_MAINTORDERACTUALCOSTQ.MAINTENANCEORDERTYPE == T003O.AUART`
Maintenance Plan Client Maintenance Plan	`C_MAINTORDERACTUALCOSTQ.MANDT == MPLA.MANDT` `C_MAINTORDERACTUALCOSTQ.MAINTENANCEPLAN == MPLA.WARPL`
Location Plant Client Location Plant	`C_MAINTORDERACTUALCOSTQ.MANDT == T001W.MANDT` `C_MAINTORDERACTUALCOSTQ.MAINTENANCEPLANT == T001W.WERKS`
Plant Section Plant Section Client ?	`C_MAINTORDERACTUALCOSTQ.PLANTSECTION == T357.BEBER` `C_MAINTORDERACTUALCOSTQ.MANDT == T357.MANDT` `C_MAINTORDERACTUALCOSTQ.[column in domain "WERKS_D"] == T357.WERKS`
Responsible Cost Center Client Controlling Area Responsible Cost Center ?	`C_MAINTORDERACTUALCOSTQ.MANDT == CSKS.MANDT` `C_MAINTORDERACTUALCOSTQ.CONTROLLINGAREA == CSKS.KOKRS` `C_MAINTORDERACTUALCOSTQ.RESPONSIBLECOSTCENTER == CSKS.KOSTL` `C_MAINTORDERACTUALCOSTQ.[column in domain "DATBI"] == CSKS.DATBI`
Source Ledger Client Ledger in General Ledger Accounting Source Ledger	`C_MAINTORDERACTUALCOSTQ.MANDT == FINSC_LEDGER.MANDT` `C_MAINTORDERACTUALCOSTQ.LEDGER == FINSC_LEDGER.RLDNR` `C_MAINTORDERACTUALCOSTQ.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Technical Object Identifier Client Technical Object Identifier	`C_MAINTORDERACTUALCOSTQ.MANDT == EQUI.MANDT` `C_MAINTORDERACTUALCOSTQ.TECHNICALOBJECTLABEL == EQUI.EQUNR`
Transaction Currency Client Transaction Currency	`C_MAINTORDERACTUALCOSTQ.MANDT == TCURC.MANDT` `C_MAINTORDERACTUALCOSTQ.TRANSACTIONCURRENCY == TCURC.WAERS`
Plant Client Plant	`C_MAINTORDERACTUALCOSTQ.MANDT == T001W.MANDT` `C_MAINTORDERACTUALCOSTQ.WORKCENTERPLANT == 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 Maintenance Planning Plant Client	`C_MAINTORDERACTUALCOSTQ.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_MAINTORDERACTUALCOSTQ.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `C_MAINTORDERACTUALCOSTQ.MANDT == T024I.MANDT`
Maintenance Planning Plant Maintenance Planning Plant Client	`C_MAINTORDERACTUALCOSTQ.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `C_MAINTORDERACTUALCOSTQ.MANDT == T399I.MANDT`