I_MaintOrderActualCostDataCube

Maint Order Actual Cost Data - Cube | view: IMTORDACTCOSTDC | TRAN | Extraction: Full only | 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 (1)
☰ Categorical (2)
Other (16)
🔗 Relations (34)

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
💲 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

Column Name	Description	Domain name
PostingMonth	Calendar Month	NUM2
FiscalPeriod	Fiscal Period	POPER
MaintOrdMainWorkCenter	Work Center	ARBPL
MaintenanceItem	Maintenance item	POSNU
WorkCenter	Work Center	ARBPL
OrderOperation	Operation/Activity Number	VORNR
OrderSuboperation	Suboperation	VORNR
IsSettlement	null
EquipmentName	Description of technical object	TEXT40
FunctionalLocationLabelName	Functional Location Label	ILOM_STRNO
FunctionalLocationName	Description of functional location	TEXT40
ManufacturerPartTypeName	Manufacturer model number	TYPBZ
TechnicalObjectType	Type of Technical Object	EQART
AssetManufacturerName	Manufacturer of Asset	TEXT30
CostElementGroup	Hierarchy parent node
LastChangeDateTime	Time Stamp of Last Change	TZNTSTMPS

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

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	`I_MAINTORDERACTUALCOSTDATACUBE.MAINTENANCEPLANNERGROUP == T024I.INGRP` `I_MAINTORDERACTUALCOSTDATACUBE.MANDT == T024I.MANDT` `I_MAINTORDERACTUALCOSTDATACUBE.MAINTENANCEPLANNINGPLANT == T024I.IWERK`
Maintenance Planning Plant Client Maintenance Planning Plant	`I_MAINTORDERACTUALCOSTDATACUBE.MANDT == T399I.MANDT` `I_MAINTORDERACTUALCOSTDATACUBE.MAINTENANCEPLANNINGPLANT == T399I.IWERK`