I_MAINTTASKLISTOPERATIONTP
Maintenance Task List Operation
I_MAINTTASKLISTOPERATIONTP is a CDS View in S/4HANA. Maintenance Task List Operation. It contains 33 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ObjPgMaintTaskListAndOp | view | from | CONSUMPTION | Maintenance Task List And Operation |
| C_ObjPgMaintTaskListOperation | view | from | CONSUMPTION | Maintenance Task List Operation |
Fields (33)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceTaskListOperation | MaintenanceTaskListOperation | 1 |
| KEY | MaintTaskListSubOperation | MaintTaskListSubOperation | 1 |
| KEY | TaskListGroup | TaskListGroup | 1 |
| KEY | TaskListGroupCounter | TaskListGroupCounter | 1 |
| KEY | TaskListOpBOMItmIntVersCounter | TaskListOpBOMItmIntVersCounter | 1 |
| KEY | TaskListOperationInternalId | TaskListOperationInternalId | 1 |
| KEY | TaskListSequence | TaskListSequence | 1 |
| KEY | TaskListType | TaskListType | 1 |
| Assembly | OperationAssembly | 1 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| MaintOperationExecStageCode | MaintOperationExecStageCode | 1 | |
| NumberOfCapacities | NumberOfCapacities | 1 | |
| NumberOfOperationPriceUnits | NumberOfOperationPriceUnits | 1 | |
| OperationCalculationControl | OperationCalculationControl | 1 | |
| OperationControlProfile | OperationControlProfile | 1 | |
| OperationStandardDuration | OperationStandardDuration | 1 | |
| OperationStandardDurationUnit | OperationStandardDurationUnit | 1 | |
| OperationStandardTextCode | OperationStandardTextCode | 1 | |
| OperationSystemCondition | OperationSystemCondition | 1 | |
| OperationText | OperationText | 1 | |
| OpExternalProcessingCurrency | OpExternalProcessingCurrency | 1 | |
| OpExternalProcessingPrice | OpExternalProcessingPrice | 1 | |
| OpPlannedWorkQuantity | OpPlannedWorkQuantity | 1 | |
| OpWorkQuantityUnit | OpWorkQuantityUnit | 1 | |
| PurchaseContract | PurchaseContract | 1 | |
| PurchaseContractItem | PurchaseContractItem | 1 | |
| PurchaseOrderQty | PurchaseOrderQty | 1 | |
| PurchaseOrderQuantityUnit | PurchaseOrderQuantityUnit | 1 | |
| PurchasingInfoRecdAddlGrpgName | PurchasingInfoRecdAddlGrpgName | 1 | |
| PurchasingInfoRecord | PurchasingInfoRecord | 1 | |
| Supplier | Supplier | 1 | |
| ValidityEndDate | OperationValidityEndDate | 1 | |
| ValidityStartDate | OperationValidityStartDate | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Maintenance Task List Operation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTTASKLISTOPERATIONTP (
MAINTENANCETASKLISTOPERATION,
MAINTTASKLISTSUBOPERATION,
TASKLISTGROUP,
TASKLISTGROUPCOUNTER,
TASKLISTOPBOMITMINTVERSCOUNTER,
TASKLISTOPERATIONINTERNALID,
TASKLISTSEQUENCE,
TASKLISTTYPE,
ASSEMBLY,
COSTCTRACTIVITYTYPE,
MAINTOPERATIONEXECSTAGECODE,
NUMBEROFCAPACITIES,
NUMBEROFOPERATIONPRICEUNITS,
OPERATIONCALCULATIONCONTROL,
OPERATIONCONTROLPROFILE,
OPERATIONSTANDARDDURATION,
OPERATIONSTANDARDDURATIONUNIT,
OPERATIONSTANDARDTEXTCODE,
OPERATIONSYSTEMCONDITION,
OPERATIONTEXT,
OPEXTERNALPROCESSINGCURRENCY,
OPEXTERNALPROCESSINGPRICE,
OPPLANNEDWORKQUANTITY,
OPWORKQUANTITYUNIT,
PURCHASECONTRACT,
PURCHASECONTRACTITEM,
PURCHASEORDERQTY,
PURCHASEORDERQUANTITYUNIT,
PURCHASINGINFORECDADDLGRPGNAME,
PURCHASINGINFORECORD,
SUPPLIER,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
PRIMARY KEY (MAINTENANCETASKLISTOPERATION, MAINTTASKLISTSUBOPERATION, TASKLISTGROUP, TASKLISTGROUPCOUNTER, TASKLISTOPBOMITMINTVERSCOUNTER, TASKLISTOPERATIONINTERNALID, TASKLISTSEQUENCE, TASKLISTTYPE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA