C_MaintOrderActlPlndCostItem

Detailed Cost Analysis in Maint. Order | view: CMNTORDACTPLNCIT | 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, HRRP_DIRECTORY, HRRP_NODET, ILOA, AUFK, RSADD, RSDB, FCOMC_CATEGORY, PROJ, T006, T006A, PRPS, CRHD, CLF_HDR, SKAT, T004, 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
💲 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 (MaterialBaseUnit):
DeliveredQtyInMatlBaseUnit Actual Valuation Quantity
📏 Cost Source Unit (BaseUnit):
RequirementQuantityInBaseUnit Actual Valuation Quantity
📏 Base Unit of Measure (OperationQuantityUnit):
OperationQuantity Actual Valuation Quantity
PlanValuationQuantity Plan Valuation Quantity
ActualValuationQuantity Actual Valuation Quantity
TargetQtyInCostSourceUnit Actual Valuation Quantity
Column Name Description
PostingDate Posting Date
Column Name Description
MaintenanceOrderPlanningCode Maintenance order planning indicator 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
WBSDescription WBS Element Name TEXT40
GLAccountName G/L Account Short Text TEXT20
CostElementGroup Hierarchy parent node
CostElementGroupName Hierarchy node description TEXT50
OperationWorkCenter Work Center ARBPL
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
OrderOperation Operation/Activity Number VORNR
OperationDescription null
OrderSuboperation Suboperation VORNR
SubOperationText Operation Short Text TEXT40
MaintenanceOrderOperation null
Product BOM Item Text (Line 1) TEXT40
MaintOrdComponentBaseUnitName External Unit of Measurement in Commercial Format (3-Char.) MSEH3
MaintenanceOrderBaseUnitName External Unit of Measurement in Commercial Format (3-Char.) MSEH3
MaintOrdOpQuantityUnitName External Unit of Measurement in Commercial Format (3-Char.) MSEH3
MaintOrderOpCostSourceUnitName External Unit of Measurement in Commercial Format (3-Char.) MSEH3
MMServicePackage Service Package PACKNO
MMServicePackageLine Service Package Item INTROW
ServiceName Short Text TEXT40
PurchaseOrderItem Item Number of Purchasing Document EBELP
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation RSPOS
ReservationType Type of Reservation RSART
ComponentDescription BOM Item Text (Line 1) TEXT40
PurReqnAssgdToMaintOrdComp Reference document number AWREF
PurReqnAssgdToMaintOrderOp Reference document number AWREF
MaintOrderConfirmation Completion confirmation number for the operation CO_RUECK
MaintOrderConfCntrValue Confirmation counter CIM_COUNT
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocument null
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.ASSEMBLY == MARA.MATNR
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == MARA.MANDT
Cost Source Unit
  • Client
  • Cost Source Unit
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T006.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.BASEUNIT == T006.MSEHI
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.CHARTOFACCOUNTS == T004.KTOPL
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.COMPANYCODE == T001.BUKRS
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == TCURC.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.COMPANYCODECURRENCY == TCURC.WAERS
Equipment Number
  • Client
  • Equipment Number
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == EQUI.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Functional Location
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.FUNCTIONALLOCATION == IFLOT.TPLNR
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == IFLOT.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.GLACCOUNT == SKB1.SAKNR
  • C_MAINTORDERACTLPLNDCOSTITEM.COMPANYCODE == SKB1.BUKRS
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.GLOBALCURRENCY == TCURC.WAERS
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Maintenance activity type
  • Maintenance activity type
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T353I.MANDT
Order ID
  • Client
  • Order ID
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == AUFK.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Client
  • Order Type
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T003O.CLIENT
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTENANCEORDERTYPE == T003O.AUART
Revision for Plant Maintenance and Customer Service
  • Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTENANCEREVISION == T352R.REVNR
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T352R.MANDT
Priority
  • Priority
  • Client
  • Priority Type
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTPRIORITY == T356.PRIOK
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T356.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTPRIORITYTYPE == T356.ARTPR
Priority Type
  • Client
  • Priority Type
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T356A.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTPRIORITYTYPE == T356A.ARTPR
Cost Source Unit
  • Cost Source Unit
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.MATERIALBASEUNIT == T006.MSEHI
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T006.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.OPERATIONQUANTITYUNIT == T006.MSEHI
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T006.MANDT
Product Group
  • Client
  • Product Group
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T023.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.PRODUCTGROUP == T023.MATKL
Reference Document Type C_MAINTORDERACTLPLNDCOSTITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Responsible Cost Center
  • ?
  • Client
  • ?
  • Responsible Cost Center
  • C_MAINTORDERACTLPLNDCOSTITEM.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == CSKS.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.[column in domain "DATBI"] == CSKS.DATBI
  • C_MAINTORDERACTLPLNDCOSTITEM.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == CRID.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_MAINTORDERACTLPLNDCOSTITEM.WORKCENTERINTERNALID == CRID.OBJID
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
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T024I.MANDT
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_MAINTORDERACTLPLNDCOSTITEM.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_MAINTORDERACTLPLNDCOSTITEM.MANDT == T399I.MANDT