I_MaintTaskListOpData

Maintenance Task List Operation Data | view: IPMTSKLISTOPDATA | TRAN | Extraction: Full only | Component: Maintenance Task Lists
Tables used: PLPO, PLAS
Column Name Description
TaskListType FK Task List Type
TaskListGroup Key for Task List Group
TaskListGroupCounter Group Counter
TaskListSequence Sequence
TaskListOperationInternalId Number of the Task List Node
Column Name Description
💲 Currency Key (OpExternalProcessingCurrency):
OpExternalProcessingPrice Net Price in Purchasing Info Record
Column Name Description
📏 Unit of measure for activity (OperationUnit):
OperationReferenceQuantity Base Quantity
📏 Normal duration/unit (OperationStandardDurationUnit):
OperationStandardDuration Normal duration of the activity
📏 Unit for the minimum duration (MinimumDurationUnit):
MinimumDuration Minimum activity duration
📏 Unit for work (OpWorkQuantityUnit):
OpPlannedWorkQuantity Work involved in the activity
📏 Operation order quantity unit (PurchaseOrderQuantityUnit):
PurchaseOrderQty Purchase Order Quantity: Operation
Column Name Description
ValidityStartDate Valid-From Date
CreationDate Created On
LastChangeDate Last Changed On
ValidityEndDate Valid-To Date
Column Name Description
IsDeleted Deletion Indicator Show values
WorkCenterTypeCode Object types of the CIM resource Show values
PurchasingInfoRecordCategory Purchasing info record category Show values
Column Name Description Domain name
TaskListOpBOMItmIntVersCounter Internal counter CIM_COUNT
MaintTaskListSubOperation Operation/Activity Number VORNR
MaintenanceTaskListOperation Operation/Activity Number VORNR
WorkCenterInternalID Object ID NUM08
OperationText Operation Short Text TEXT40
OpQtyToBaseQtyDnmntr Denominator for Converting Routing and Operation UoM UMBSN
OpQtyToBaseQtyNmrtr Numerator for Converting Routing and Operation UoM UMBSZ
PurchasingInfoRecdAddlGrpgName Sort Term for Non-Stock Info Records CHAR10
PlannedDeliveryDuration Planned Delivery Time in Days DEC3
NumberOfOperationPriceUnits Price unit DEC5
NumberOfCapacities Number of capacities required INT1
OperationWorkPercent Work percentage INT1
BOOOperationInternalID Number of the Task List Node KNTNR
BillOfOperationsGroup Key for Task List Group PLNNR
Master Data Relations Join Conditions
Task List Type
  • Client
  • Task List Type
  • Task List Type
  • I_MAINTTASKLISTOPDATA.MANDT == TCA01.MANDT
  • I_MAINTTASKLISTOPDATA.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • I_MAINTTASKLISTOPDATA.TASKLISTTYPE == TCA01.PLNTY
Distr.cap.reqmts (plant maint.,process order, network)
  • Distr.cap.reqmts (plant maint.,process order, network)
  • Client
  • I_MAINTTASKLISTOPDATA.CAPACITYREQUIREMENTDISTRKEY == TC29.VERTL
  • I_MAINTTASKLISTOPDATA.MANDT == TC29.MANDT
Change Number
  • Client
  • Change Number
  • I_MAINTTASKLISTOPDATA.MANDT == AENR.MANDT
  • I_MAINTTASKLISTOPDATA.CHANGENUMBER == AENR.AENNR
Company Code
  • Client
  • Company Code
  • I_MAINTTASKLISTOPDATA.MANDT == T001.MANDT
  • I_MAINTTASKLISTOPDATA.COMPANYCODE == T001.BUKRS
Cost Element
  • Client
  • Cost Element
  • ?
  • I_MAINTTASKLISTOPDATA.MANDT == CSKA.MANDT
  • I_MAINTTASKLISTOPDATA.COSTELEMENT == CSKA.KSTAR
  • I_MAINTTASKLISTOPDATA.[column in domain "KTOPL"] == CSKA.KTOPL
Factory Calendar I_MAINTTASKLISTOPDATA.FACTORYCALENDAR == TFACD.IDENT
Material Group
  • Client
  • Material Group
  • I_MAINTTASKLISTOPDATA.MANDT == T023.MANDT
  • I_MAINTTASKLISTOPDATA.MATERIALGROUP == T023.MATKL
Unit for the minimum duration
  • Client
  • Unit for the minimum duration
  • I_MAINTTASKLISTOPDATA.MANDT == T006.MANDT
  • I_MAINTTASKLISTOPDATA.MINIMUMDURATIONUNIT == T006.MSEHI
Control key
  • Client
  • ?
  • Control key
  • I_MAINTTASKLISTOPDATA.MANDT == T430.MANDT
  • I_MAINTTASKLISTOPDATA.[column in domain "PLNAW"] == T430.PLNAW
  • I_MAINTTASKLISTOPDATA.OPERATIONCONTROLPROFILE == T430.STEUS
Operation Costing Relevancy Type
  • Client
  • Operation Costing Relevancy Type
  • I_MAINTTASKLISTOPDATA.MANDT == TCK08.MANDT
  • I_MAINTTASKLISTOPDATA.OPERATIONCOSTINGRELEVANCYTYPE == TCK08.SELKZ
Normal duration/unit
  • Client
  • Normal duration/unit
  • I_MAINTTASKLISTOPDATA.MANDT == T006.MANDT
  • I_MAINTTASKLISTOPDATA.OPERATIONSTANDARDDURATIONUNIT == T006.MSEHI
Standard Text Key
  • Client
  • Standard Text Key
  • I_MAINTTASKLISTOPDATA.MANDT == T435.MANDT
  • I_MAINTTASKLISTOPDATA.OPERATIONSTANDARDTEXTCODE == T435.VLSCH
System Condition
  • Client
  • System Condition
  • I_MAINTTASKLISTOPDATA.MANDT == T357M.MANDT
  • I_MAINTTASKLISTOPDATA.OPERATIONSYSTEMCONDITION == T357M.ANLZU
Unit of measure for activity
  • Client
  • Unit of measure for activity
  • I_MAINTTASKLISTOPDATA.MANDT == T006.MANDT
  • I_MAINTTASKLISTOPDATA.OPERATIONUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • I_MAINTTASKLISTOPDATA.MANDT == TCURC.MANDT
  • I_MAINTTASKLISTOPDATA.OPEXTERNALPROCESSINGCURRENCY == TCURC.WAERS
Unit for work
  • Client
  • Unit for work
  • I_MAINTTASKLISTOPDATA.MANDT == T006.MANDT
  • I_MAINTTASKLISTOPDATA.OPWORKQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_MAINTTASKLISTOPDATA.MANDT == T001W.MANDT
  • I_MAINTTASKLISTOPDATA.PLANT == T001W.WERKS
Operation order quantity unit
  • Client
  • Operation order quantity unit
  • I_MAINTTASKLISTOPDATA.MANDT == T006.MANDT
  • I_MAINTTASKLISTOPDATA.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group for External Processing Activity
  • Client
  • Purchasing Group for External Processing Activity
  • I_MAINTTASKLISTOPDATA.MANDT == T024.MANDT
  • I_MAINTTASKLISTOPDATA.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • I_MAINTTASKLISTOPDATA.MANDT == EINA.MANDT
  • I_MAINTTASKLISTOPDATA.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Purchasing organization
  • Client
  • I_MAINTTASKLISTOPDATA.PURCHASINGORGANIZATION == T024E.EKORG
  • I_MAINTTASKLISTOPDATA.MANDT == T024E.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_MAINTTASKLISTOPDATA.SUPPLIER == LFA1.LIFNR
  • I_MAINTTASKLISTOPDATA.MANDT == LFA1.MANDT
Task List Type
  • Client
  • Task List Type
  • Task List Type
  • I_MAINTTASKLISTOPDATA.MANDT == TCA01.MANDT
  • I_MAINTTASKLISTOPDATA.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • I_MAINTTASKLISTOPDATA.TASKLISTTYPE == TCA01.PLNTY
Other Relations | to Master Data Relations ↑ Join Conditions
Distribution function for capacity requirements
  • Client
  • Distribution function for capacity requirements
  • I_MAINTTASKLISTOPDATA.MANDT == T498.MANDT
  • I_MAINTTASKLISTOPDATA.CAPRQMTSDISTRIBUTIONFUNCTION == T498.VERTL