I_MaintOrderActualCostCube

Maintenance Order Actual Cost Cube | view: IMTORDACTCOSTC | TRAN | Extraction: Not supported | Component: Maintenance Orders

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

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

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
PostingDate	Posting Date

Column Name	Description
MaintenanceOrderIsPlanned	Planned Parts/Work	Show values
MaintenanceOrderPlanningCode	Maintenance order planning indicator	Show values
TechObjIsEquipOrFuncnlLoc	Technical Object Type	Show values

Column Name	Description	Domain name
PostingMonth	Calendar Month	NUM2
MaintOrdMainWorkCenter	Main work center for maintenance tasks	ARBPL
MaintOrdMainWorkCenterPlant	Plant associated with main work center	WERKS
MaintenanceItem	Maintenance item	POSNU
WorkCenter	Work Center	ARBPL
OrderOperation	Operation/Activity Number
OrderSuboperation	Suboperation
TechnicalObjectDescription	Technical Object Description	TEXT40
ManufacturerPartTypeName	Manufacturer model number	TYPBZ
TechnicalObjectType	Type of Technical Object	EQART
AssetManufacturerName	Manufacturer of Asset	TEXT30
LastChangeDateTime	Time Stamp of Last Change	TZNTSTMPS
FiscalPeriod	Fiscal Period	POPER
LedgerFiscalYear	Ledger Fiscal Year	GJAHR

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

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