I_MaintOrdActlPlndCostCube

Maint Order Actual Planned Cost - Cube | view: IMNTORDACTLPLNC | TRAN | Extraction: Not supported | Component: Maintenance Orders
Tables used: SCAL_TT_DATE, AFKO, QMEL, AFIH, RESB, AFVC, AFVV, ESLL, PRTE, ACDOCA, ACDOCP, KLAH, KSSK, T001, TKA02, EQUI, EQUZ, IFLOT, HRRP_ATTR_NODE, HRRP_NODE, ILOA, AUFK, RSADD, RSDB, FCOMC_CATEGORY, PROJ, T006, T006A, PRPS, CRHD, CLF_HDR, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
ActualPlanJournalEntryItem Actual Plan Journal Entry Item
Column Name Description
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
ActualMaintAmountInCoCrcy Amount in Company Code Currency
PlannedMaintAmountInCoCrcy Amount in Company Code Currency
BaselineMaintAmountInCoCrcy Amount in Company Code Currency
EstimatedMaintAmountInCoCrcy Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
ActualMaintAmountInGlobCrcy Amount in Company Code Currency
PlannedMaintAmountInGlobCrcy Amount in Company Code Currency
BaselineMaintAmountInGlobCrcy Amount in Company Code Currency
EstimatedMaintAmountInGlobCrcy Amount in Company Code Currency
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
PlanValuationQuantity Plan Valuation Quantity
ActualValuationQuantity Actual Valuation Quantity
📏 Base Unit of Measure (MaterialBaseUnit):
DeliveredQtyInMatlBaseUnit Quantity
📏 Base Unit of Measure (BaseUnit):
RequirementQuantityInBaseUnit Requirement Quantity
📏 Base Unit of Measure (OperationQuantityUnit):
OperationQuantity Operation Quantity in Unit of Measure of Order
Column Name Description
PostingDate Posting Date
ScheduledBasicStartDate Scheduled start
ScheduledBasicEndDate Scheduled finish
Column Name Description
MaintenanceOrderCategory Order Category Show values
MaintenanceOrderPlanningCode Maintenance order planning indicator Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
PlanningCategory Plan Category FCOM_CATEGORY
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
CostElementGroup Hierarchy parent node
TaskListType Bill of Operations Type PLNTY
TaskListGroup Bill of Operations ID PLNNR
TaskListGroupCounter Bill of Operations Variant ALTNR
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
OperationWorkCenter Work Center ARBPL
OrderOperation Operation/Activity Number VORNR
OperationDescription Operation Short Text TEXT40
OrderSuboperation Suboperation VORNR
SubOperationText Operation Short Text TEXT40
MaintOrderOpCostSourceUnitName External Unit of Measurement in Commercial Format (3-Char.) MSEH3
MaintOrdComponentBaseUnitName External Unit of Measurement in Commercial Format (3-Char.) MSEH3
EquipmentManufacturerName Manufacturer of Asset TEXT30
EquipmentMfrPrtTypeName Manufacturer model number TYPBZ
EquipmentManufacturerPrtNmbr Manufacturer part number MAPAR
FuncnlLocationManufacturerName Manufacturer of Asset TEXT30
FuncnlLocationMfrPrtTypeName Manufacturer model number TYPBZ
FuncnlLocationMfrPrtNmbr Manufacturer part number MAPAR
EquipmentClassFromClfn Class number KLASSE
FuncnlLocationClassFromClfn Class number KLASSE
WBSElement Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
SerialNumber Equipment Number EQUNR
ComponentDescription BOM Item Text (Line 1) TEXT40
MaintenanceOrderBaseUnitName External Unit of Measurement in Commercial Format (3-Char.) MSEH3
PurReqnAssgdToMaintOrdComp Purchase Requisition Number BANFN
PurchaseOrderItem Item Number of Purchasing Document EBELP
ServiceEntrySheetItemDesc Short Text TEXT40
MMServicePackage Service Package PACKNO
MMServicePackageLine Service Package Item INTROW
ServiceName Short Text TEXT40
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation RSPOS
ReservationType Type of Reservation RSART
PurReqnAssgdToMaintOrderOp Purchase Requisition Number BANFN
MaintOrdOpQuantityUnitName External Unit of Measurement in Commercial Format (3-Char.) MSEH3
MaintOrderConfirmation Completion confirmation number for the operation CO_RUECK
MaintOrderConfCntrValue Confirmation counter CIM_COUNT
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocumentItem Reference Document Item NUMC6
AssetManufacturerName Manufacturer of Asset TEXT30
PurchaseRequisition Purchase Requisition Number BANFN
WBSDescription WBS Element Name TEXT40
PostingMonth Calendar Month NUM2
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.ABCINDICATOR == T370C.ABCKZ
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T370C.MANDT
Assembly
  • Assembly
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.ASSEMBLY == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == MARA.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.BASEUNIT == T006.MSEHI
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T006.MANDT
Business Area
  • Client
  • Business Area
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == TGSB.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.BUSINESSAREA == TGSB.GSBER
Catalog Profile
  • Client
  • Catalog Profile
  • Catalog Profile
  • Catalog Profile
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T352B.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.CATALOGPROFILE == T352B.RBNR
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCTIONALLOCATIONCODECATALOG == T352B.RBNR
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENTCODECATALOG == T352B.RBNR
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.COMPANYCODE == T001.BUKRS
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == TCURC.MANDT
Construction type material of the object
  • Client
  • Construction type material of the object
  • Construction type material of the object
  • Construction type material of the object
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == MARA.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENTCONSTRUCTIONMATERIAL == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCNLLOCCONSTRUCTIONMATERIAL == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.CONSTRUCTIONMATERIAL == MARA.MATNR
Controlling Area
  • Client
  • Controlling Area
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == TKA01.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.CONTROLLINGAREA == TKA01.KOKRS
CO Object Currency
  • CO Object Currency
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == TCURC.MANDT
Cost Center
  • Cost Center
  • ?
  • Client
  • Controlling Area
  • I_MAINTORDACTLPLNDCOSTCUBE.COSTCENTER == CSKS.KOSTL
  • I_MAINTORDACTLPLNDCOSTCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == CSKS.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.CONTROLLINGAREA == CSKS.KOKRS
Cost Center
  • ?
  • Cost Center
  • Client
  • Controlling Area
  • I_MAINTORDACTLPLNDCOSTCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTORDACTLPLNDCOSTCUBE.COSTCENTERCOMPANYCODE == CSKS.KOSTL
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == CSKS.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.CONTROLLINGAREA == CSKS.KOKRS
Cost Source Unit
  • Client
  • Cost Source Unit
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T006.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.COSTSOURCEUNIT == T006.MSEHI
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENT == EQUI.EQUNR
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == EQUI.MANDT
Catalog Profile
  • Client
  • Catalog Profile
  • Catalog Profile
  • Catalog Profile
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T352B.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.CATALOGPROFILE == T352B.RBNR
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCTIONALLOCATIONCODECATALOG == T352B.RBNR
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENTCODECATALOG == T352B.RBNR
Construction type material of the object
  • Client
  • Construction type material of the object
  • Construction type material of the object
  • Construction type material of the object
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == MARA.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENTCONSTRUCTIONMATERIAL == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCNLLOCCONSTRUCTIONMATERIAL == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.CONSTRUCTIONMATERIAL == MARA.MATNR
Type of Technical Object
  • Client
  • Type of Technical Object
  • Type of Technical Object
  • Type of Technical Object
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T370K.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCTIONALLOCATIONOBJECTTYPE == T370K.EQART
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENTOBJECTTYPE == T370K.EQART
  • I_MAINTORDACTLPLNDCOSTCUBE.TECHNICALOBJECTTYPE == T370K.EQART
Construction type material of the object
  • Client
  • Construction type material of the object
  • Construction type material of the object
  • Construction type material of the object
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == MARA.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENTCONSTRUCTIONMATERIAL == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCNLLOCCONSTRUCTIONMATERIAL == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.CONSTRUCTIONMATERIAL == MARA.MATNR
Functional Location
  • Client
  • Functional Location
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == IFLOT.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCTIONALLOCATION == IFLOT.TPLNR
Catalog Profile
  • Client
  • Catalog Profile
  • Catalog Profile
  • Catalog Profile
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T352B.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.CATALOGPROFILE == T352B.RBNR
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCTIONALLOCATIONCODECATALOG == T352B.RBNR
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENTCODECATALOG == T352B.RBNR
Type of Technical Object
  • Client
  • Type of Technical Object
  • Type of Technical Object
  • Type of Technical Object
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T370K.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCTIONALLOCATIONOBJECTTYPE == T370K.EQART
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENTOBJECTTYPE == T370K.EQART
  • I_MAINTORDACTLPLNDCOSTCUBE.TECHNICALOBJECTTYPE == T370K.EQART
G/L Account
  • Company Code
  • Client
  • G/L Account
  • I_MAINTORDACTLPLNDCOSTCUBE.COMPANYCODE == SKB1.BUKRS
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == SKB1.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Global Currency
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.GLOBALCURRENCY == TCURC.WAERS
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Maintenance activity type
  • Maintenance activity type
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T353I.MANDT
Location of maintenance object
  • Client
  • ?
  • Location of maintenance object
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T499S.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.[column in domain "WERKS_D"] == T499S.WERKS
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEOBJECTLOCATION == T499S.STAND
Order ID
  • Order ID
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T003O.CLIENT
Maintenance Plan
  • Maintenance Plan
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEPLAN == MPLA.WARPL
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == MPLA.MANDT
Location Plant
  • Client
  • Location Plant
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T001W.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEPLANT == T001W.WERKS
Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • Revision for Plant Maintenance and Customer Service
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T352R.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEREVISION == T352R.REVNR
Priority
  • Priority Type
  • Client
  • Priority
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTPRIORITYTYPE == T356.ARTPR
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T356.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTPRIORITYTYPE == T356A.ARTPR
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T356A.MANDT
Material Number
  • Client
  • Material Number
  • Product Number
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == MARA.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.MATERIAL == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.PRODUCT == MARA.MATNR
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.MATERIALBASEUNIT == T006.MSEHI
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T006.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T006.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.OPERATIONQUANTITYUNIT == T006.MSEHI
Plant Section
  • Client
  • ?
  • Plant Section
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T357.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.[column in domain "WERKS_D"] == T357.WERKS
  • I_MAINTORDACTLPLNDCOSTCUBE.PLANTSECTION == T357.BEBER
Product Number
  • Material Number
  • Product Number
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.MATERIAL == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.PRODUCT == MARA.MATNR
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.PRODUCTGROUP == T023.MATKL
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T023.MANDT
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • I_MAINTORDACTLPLNDCOSTCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == CEPC.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_MAINTORDACTLPLNDCOSTCUBE.PROFITCENTER == CEPC.PRCTR
Reference Document Type I_MAINTORDACTLPLNDCOSTCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Responsible Cost Center
  • ?
  • Client
  • Controlling Area
  • Responsible Cost Center
  • I_MAINTORDACTLPLNDCOSTCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == CSKS.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_MAINTORDACTLPLNDCOSTCUBE.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Type of Technical Object
  • Client
  • Type of Technical Object
  • Type of Technical Object
  • Type of Technical Object
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T370K.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.FUNCTIONALLOCATIONOBJECTTYPE == T370K.EQART
  • I_MAINTORDACTLPLNDCOSTCUBE.EQUIPMENTOBJECTTYPE == T370K.EQART
  • I_MAINTORDACTLPLNDCOSTCUBE.TECHNICALOBJECTTYPE == T370K.EQART
Transaction Currency
  • Client
  • Transaction Currency
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == TCURC.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
Object ID of the resource
  • ?
  • Client
  • Object ID of the resource
  • I_MAINTORDACTLPLNDCOSTCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == CRID.MANDT
  • I_MAINTORDACTLPLNDCOSTCUBE.WORKCENTERINTERNALID == CRID.OBJID
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
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTORDACTLPLNDCOSTCUBE.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTORDACTLPLNDCOSTCUBE.MANDT == T399I.MANDT