C_MaintOrdActlPlndCostQuery

Maint. Order Actual Planned Cost Query | view: CMNTORDAPLNQ | 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, IFLOS, IFLOT, HRRP_ATTR_NODE, HRRP_NODE, ILOA, AUFK, RSADD, RSDB, T001W, NRIV, T352R, FCOMC_CATEGORY, PROJ, CNLDST_SHORTTX, T006, T006A, PRPS, CRHD, CLF_HDR, ITOBCUST, IFLOUSR, FINSC_LEDGER_REP, T024I, T399I, 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
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
ActualMaintAmountInGlobCrcy Amount in Company Code Currency
BaselineMaintAmountInGlobCrcy Amount in Company Code Currency
PlannedMaintAmountInGlobCrcy Amount in Company Code Currency
EstimatedMaintAmountInGlobCrcy Amount in Company Code Currency
ActlPlnDiffAmtInGlobalCrcy null
ActlBslnDiffAmtInGlobalCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
ScheduledBasicStartDate Scheduled start
ScheduledBasicEndDate Scheduled finish
Column Name Description
MaintenanceOrderPlanningCode Maintenance order planning indicator Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
PostingMonth Calendar Month NUM2
FiscalPeriod Fiscal Period POPER
PlanningCategory Plan Category FCOM_CATEGORY
CostElementGroup Hierarchy parent node
MaintenancePlannerGroupName Name of the Maintenance Planner Group TEXT18
PlantName Name TEXT30
MaintenanceRevisionDesc Revision description TEXT40
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
MaintenancePlantName Plant Name TEXT30
MaintOrderPlanningCodeName Short Text for Fixed Values DDTEXT
SerialNumber Equipment Number EQUNR
FunctionalLocationLabelName Functional Location Label ILOM_STRNO
OperationWorkCenter Work Center ARBPL
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
BreakdownWeek null
OrderOperation Undefined range (can be used for patch levels) CHAR4
OrderSuboperation Undefined range (can be used for patch levels) CHAR4
EquipmentManufacturerName Manufacturer of Asset TEXT30
FuncnlLocationManufacturerName Manufacturer of Asset TEXT30
ManufacturerName Manufacturer of Asset TEXT30
ConstructionMaterial Construction type material of the object MATNR
EquipmentManufacturerPrtNmbr Manufacturer part number MAPAR
FuncnlLocationMfrPrtNmbr Manufacturer part number MAPAR
ManufacturerPrtNmbr Manufacturer part number MAPAR
EquipmentMfrPrtTypeName Manufacturer model number TYPBZ
FuncnlLocationMfrPrtTypeName Manufacturer model number TYPBZ
ManufacturerPrtTypeName Manufacturer model number TYPBZ
TechnicalObjectType Type of Technical Object EQART
CatalogProfile Catalog Profile RBNR
TaskList null
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
WBSDescription WBS Element Name TEXT40
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
ProjectDescription Project Definition Name TEXT40
WBSElement Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.ABCINDICATOR == T370C.ABCKZ
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T370C.MANDT
Assembly
  • Client
  • Assembly
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == MARA.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.ASSEMBLY == MARA.MATNR
Business Area
  • Client
  • Business Area
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == TGSB.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T004.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T001.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == TCURC.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == TKA01.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_MAINTORDACTLPLNDCOSTQUERY.COSTCENTER == CSKS.KOSTL
  • C_MAINTORDACTLPLNDCOSTQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == CSKS.MANDT
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • C_MAINTORDACTLPLNDCOSTQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == CSKS.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_MAINTORDACTLPLNDCOSTQUERY.COSTCENTERCOMPANYCODE == CSKS.KOSTL
Equipment Number
  • Equipment Number
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.EQUIPMENT == EQUI.EQUNR
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == EQUI.MANDT
Construction type material of the object
  • Client
  • Construction type material of the object
  • Construction type material of the object
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == MARA.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.EQUIPMENTCONSTRUCTIONMATERIAL == MARA.MATNR
  • C_MAINTORDACTLPLNDCOSTQUERY.FUNCNLLOCCONSTRUCTIONMATERIAL == MARA.MATNR
Type of Technical Object
  • Type of Technical Object
  • Type of Technical Object
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.EQUIPMENTOBJECTTYPE == T370K.EQART
  • C_MAINTORDACTLPLNDCOSTQUERY.FUNCTIONALLOCATIONOBJECTTYPE == T370K.EQART
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T370K.MANDT
Construction type material of the object
  • Client
  • Construction type material of the object
  • Construction type material of the object
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == MARA.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.EQUIPMENTCONSTRUCTIONMATERIAL == MARA.MATNR
  • C_MAINTORDACTLPLNDCOSTQUERY.FUNCNLLOCCONSTRUCTIONMATERIAL == MARA.MATNR
30 Characters
  • Client
  • 30 Characters
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == IFLOT.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.FUNCTIONALLOCATION == IFLOT.TPLNR
Type of Technical Object
  • Type of Technical Object
  • Type of Technical Object
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.EQUIPMENTOBJECTTYPE == T370K.EQART
  • C_MAINTORDACTLPLNDCOSTQUERY.FUNCTIONALLOCATIONOBJECTTYPE == T370K.EQART
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T370K.MANDT
G/L Account
  • Client
  • Company Code
  • G/L Account
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == SKB1.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.COMPANYCODE == SKB1.BUKRS
  • C_MAINTORDACTLPLNDCOSTQUERY.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == TCURC.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Maintenance activity type
  • Maintenance activity type
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T353I.MANDT
Location of maintenance object
  • Location of maintenance object
  • ?
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEOBJECTLOCATION == T499S.STAND
  • C_MAINTORDACTLPLNDCOSTQUERY.[column in domain "WERKS_D"] == T499S.WERKS
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T499S.MANDT
Order ID
  • Client
  • Order ID
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == AUFK.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Order Type
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEORDERTYPE == T003O.AUART
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T003O.CLIENT
Maintenance Plan
  • Client
  • Maintenance Plan
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == MPLA.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEPLAN == MPLA.WARPL
Location Plant
  • Location Plant
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEPLANT == T001W.WERKS
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T001W.MANDT
Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Revision for Plant Maintenance and Customer Service
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEREVISION == T352R.REVNR
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T352R.MANDT
Priority
  • Priority
  • Client
  • Priority Type
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTPRIORITY == T356.PRIOK
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T356.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTPRIORITYTYPE == T356.ARTPR
Priority Type
  • Client
  • Priority Type
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T356A.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTPRIORITYTYPE == T356A.ARTPR
Plant Section
  • Plant Section
  • ?
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.PLANTSECTION == T357.BEBER
  • C_MAINTORDACTLPLNDCOSTQUERY.[column in domain "WERKS_D"] == T357.WERKS
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T357.MANDT
Product Number
  • Product Number
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.PRODUCT == MARA.MATNR
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.PRODUCTGROUP == T023.MATKL
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T023.MANDT
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • C_MAINTORDACTLPLNDCOSTQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == CEPC.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_MAINTORDACTLPLNDCOSTQUERY.PROFITCENTER == CEPC.PRCTR
Responsible Cost Center
  • ?
  • Responsible Cost Center
  • Controlling Area
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_MAINTORDACTLPLNDCOSTQUERY.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_MAINTORDACTLPLNDCOSTQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == CSKS.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Object ID of the resource
  • ?
  • Client
  • Object ID of the resource
  • C_MAINTORDACTLPLNDCOSTQUERY.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == CRID.MANDT
  • C_MAINTORDACTLPLNDCOSTQUERY.WORKCENTERINTERNALID == CRID.OBJID
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_MAINTORDACTLPLNDCOSTQUERY.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_MAINTORDACTLPLNDCOSTQUERY.MANDT == T399I.MANDT