R_MaintTaskListOpBasicTP
Tasklist Operations
R_MaintTaskListOpBasicTP is a Transactional CDS View that provides data about "Tasklist Operations" in SAP S/4HANA. It reads from 1 data source (I_BOOSqncOperationAssgmtChgSt) and exposes 81 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It has 6 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BOOSqncOperationAssgmtChgSt | plas | inner |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_MaintenanceTaskList | _MaintenanceTaskList | _MaintenanceTaskList.TaskListType = $projection.TaskListType and _MaintenanceTaskList.TaskListGroup = $projection.TaskListGroup and _MaintenanceTaskList.TaskListGroupCounter = $projection.TaskListGroupCounter |
| [0..*] | R_MaintTaskListSubOpTP | _SubOp | $projection.TaskListType = _SubOp.TaskListType and $projection.TaskListGroup = _SubOp.TaskListGroup and $projection.TaskListGroupCounter = _SubOp.TaskListGroupCounter and $projection.MaintenanceTaskListOperation = _SubOp.MaintenanceTaskListOperation |
| [0..*] | R_MaintTaskListOpMaterialTP | _OpMaterial | $projection.TaskListType = _OpMaterial.TaskListType and $projection.TaskListGroup = _OpMaterial.TaskListGroup and $projection.TaskListGroupCounter = _OpMaterial.TaskListGroupCounter and $projection.TaskListSequence = _OpMaterial.TaskListSequence and $projection.TaskListOperationInternalId = _OpMaterial.TaskListOperationInternalId |
| [0..*] | R_MaintTaskListOpRelshpTP | _OpRelation | $projection.TaskListType = _OpRelation.TaskListType and $projection.TaskListGroup = _OpRelation.TaskListGroup and $projection.TaskListGroupCounter = _OpRelation.TaskListGroupCounter and $projection.TaskListOperationInternalId = _OpRelation.SuccssrBOOOpInternalID and $projection.TaskListSequence = _OpRelation.TaskListSequence |
| [0..1] | I_MaintTaskListOpTechObj | _MaintTaskListTechObj | $projection.TaskListType = _MaintTaskListTechObj.TaskListType and $projection.TaskListGroup = _MaintTaskListTechObj.TaskListGroup and $projection.TaskListGroupCounter = _MaintTaskListTechObj.TaskListGroupCounter and $projection.TaskListSequence = _MaintTaskListTechObj.TaskListSequence and $projection.TaskListOperationInternalId = _MaintTaskListTechObj.TaskListOperationInternalId and $projection.TaskListOpBOMItmIntVersCounter = _MaintTaskListTechObj.TaskListOpBOMItmIntVersCounter |
| [0..1] | R_MaintTaskListOpLongTextTP | _OpLongText | $projection.TaskListType = _OpLongText.TaskListType and $projection.TaskListGroup = _OpLongText.TaskListGroup and $projection.TaskListGroupCounter = _OpLongText.TaskListGroupCounter and $projection.TaskListSequence = _OpLongText.TaskListSequence and $projection.TaskListOperationInternalId = _OpLongText.TaskListOperationInternalId and $projection.TaskListOpBOMItmIntVersCounter = _OpLongText.TaskListOpBOMItmIntVersCounter |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.dataMaintenance | #RESTRICTED | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Tasklist Operations | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view |
Fields (81)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | TaskListType | I_BOOSqncOperationAssgmtChgSt | BillOfOperationsType | Task List Type |
| KEY | TaskListGroup | I_BOOSqncOperationAssgmtChgSt | BillOfOperationsGroup | Group |
| KEY | TaskListGroupCounter | I_BOOSqncOperationAssgmtChgSt | BillOfOperationsVariant | Group Counter |
| KEY | TaskListSequence | I_BOOSqncOperationAssgmtChgSt | BillOfOperationsSequence | Sequence |
| KEY | TaskListOperationInternalId | plpo | BOOOperationInternalID | Task list node |
| KEY | TaskListOpBOMItmIntVersCounter | plpo | BOOOpInternalVersionCounter | Counter |
| MaintenanceTaskListOperation | ||||
| MaintOperationExecStageCode | plpo | MaintOperationExecStageCode | Execution Stage | |
| OperationText | plpo | OperationText | Description | |
| OperationControlProfile | plpo | OperationControlProfile | Control Key | |
| WorkCenter | ||||
| Plant | plpo | Plant | Valuation Area | |
| TechnicalObject | _MaintTaskListTechObj | TechnicalObject | Technical Object | |
| TechObjIsEquipOrFuncnlLoc | _MaintTaskListTechObj | TechObjIsEquipOrFuncnlLoc | Tech. Obj. Type | |
| Assembly | plpo | Assembly | Pegged Reqmt | |
| OperationCalculationControl | plpo | OperationCalculationControl | Calculation key | |
| OpPlannedWorkQuantity | plpo | OpPlannedWorkQuantity | ||
| OpWorkQuantityUnit | plpo | OpWorkQuantityUnit | ||
| WorkCenterInternalID | plpo | WorkCenterInternalID | Work Center | |
| WorkCenterTypeCode | plpo | WorkCenterTypeCode | Object Type | |
| NumberOfCapacities | plpo | NumberOfCapacities | Number | |
| PurchaseOrderQty | ||||
| PurchaseOrderQuantityUnit | plpo | PurchaseOrderQuantityUnit | Order Unit | |
| OperationStandardDuration | plpo | OperationStandardDuration | ||
| OperationStandardDurationUnit | plpo | OperationStandardDurationUnit | ||
| CostCtrActivityType | plpo | CostCtrActivityType | Activity Type | |
| MaterialGroup | plpo | MaterialGroup | Product Group | |
| OpExternalProcessingPrice | plpo | OpExternalProcessingPrice | Price | |
| OpExternalProcessingCurrency | plpo | OpExternalProcessingCurrency | Currency | |
| CostElement | plpo | CostElement | G/L Account | |
| PurchasingGroup | plpo | PurchasingGroup | Purchasing Group | |
| PurchasingOrganization | plpo | PurchasingOrganization | Purchasing Organization | |
| Supplier | plpo | Supplier | Supplier | |
| ChangeNumber | plpo | ChangeNumber | Change Number | |
| ValidityStartDate | plpo | ValidityStartDate | Validity Start Date | |
| ValidityEndDate | plpo | ValidityEndDate | ValidTo | |
| OperationStandardTextCode | plpo | OperationStandardTextCode | Std Text Key | |
| PurchasingInfoRecdAddlGrpgName | plpo | PurchasingInfoRecdAddlGrpgName | Sort Term | |
| NumberOfOperationPriceUnits | plpo | NumberOfOperationPriceUnits | Price Unit | |
| PurchasingInfoRecord | plpo | PurchasingInfoRecord | Info Record | |
| PurchasingInfoRecordCategory | plpo | PurchasingInfoRecordCategory | Infotype | |
| PurchaseContract | plpo | PurchaseContract | Purchasing Doc. | |
| PurchaseContractItem | plpo | PurchaseContractItem | Item | |
| OperationSystemCondition | plpo | OperationSystemCondition | SystemCondition | |
| Equipment | plpo | Equipment | Equipment check | |
| IsDeleted | plpo | IsDeleted | TRUE | |
| MaintOperationalChecklistType | plpo | MaintOperationalChecklistType | Checklist Type | |
| _Assembly | plpo | _Assembly | ||
| _ChangeMaster | plpo | _ChangeMaster | ||
| _Equipment | plpo | _Equipment | ||
| _MaintenanceTaskList | _MaintenanceTaskList | |||
| _OperationCalculationControl | plpo | _OperationCalculationControl | ||
| _OperationControlProfile | plpo | _OperationControlProfile | ||
| _OperationStandardText | plpo | _OperationStandardText | ||
| _OperationSystemCondition | plpo | _OperationSystemCondition | ||
| _Plant | plpo | _Plant | ||
| _PurchasingInfoRecord | plpo | _PurchasingInfoRecord | ||
| _PurchasingOrganization | plpo | _PurchasingOrganization | ||
| _Supplier | plpo | _Supplier | ||
| IsBusinessPurposeCompleted | ||||
| SupplierAccountGroup | ||||
| AuthorizationGroup | ||||
| TaskListStatus | _MaintenanceTaskList | TaskListStatus | ||
| MaintenancePlanningPlant | ||||
| MaintenancePlannerGroup | ||||
| ControllingArea | ||||
| CostCenter | ||||
| MaintenancePlant | ||||
| ResponsiblePlannerGroup | _MaintenanceTaskList | ResponsiblePlannerGroup | ||
| _WorkCenter | plpo | _WorkCenter | ||
| _WorkCenterType | plpo | _WorkCenterType | ||
| _MaintOperationExecStageCode | plpo | _MaintOperationExecStageCode | ||
| _TechnicalObject | _MaintTaskListTechObj | _TechnicalObject | ||
| _TechObjIsEquipOrFuncnlLoc | _MaintTaskListTechObj | _TechObjIsEquipOrFuncnlLoc | ||
| _NonHistOp | _NonHistOp | |||
| _OpMaterial | _OpMaterial | |||
| _OpRelation | _OpRelation | |||
| _MaintTaskListTechObj | _MaintTaskListTechObj | |||
| _OpLongText | _OpLongText | |||
| _SubOp | _SubOp | |||
| _Header | _Header |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view R_MaintTaskListOpBasicTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW R_MaintTaskListOpBasicTP AS
SELECT
plas.BillOfOperationsType AS TaskListType,
plas.BillOfOperationsGroup AS TaskListGroup,
plas.BillOfOperationsVariant AS TaskListGroupCounter,
plas.BillOfOperationsSequence AS TaskListSequence,
plpo.BOOOperationInternalID AS TaskListOperationInternalId,
plpo.BOOOpInternalVersionCounter AS TaskListOpBOMItmIntVersCounter,
cast(plpo.Operation as pph_vornr preserving type) AS MaintenanceTaskListOperation,
plpo.MaintOperationExecStageCode AS MaintOperationExecStageCode,
plpo.OperationText AS OperationText,
plpo.OperationControlProfile AS OperationControlProfile,
plpo._WorkCenter.WorkCenter AS WorkCenter,
plpo.Plant AS Plant,
_MaintTaskListTechObj.TechnicalObject AS TechnicalObject,
_MaintTaskListTechObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
plpo.Assembly AS Assembly,
plpo.OperationCalculationControl AS OperationCalculationControl,
plpo.OpPlannedWorkQuantity AS OpPlannedWorkQuantity,
plpo.OpWorkQuantityUnit AS OpWorkQuantityUnit,
plpo.WorkCenterInternalID AS WorkCenterInternalID,
plpo.WorkCenterTypeCode AS WorkCenterTypeCode,
plpo.NumberOfCapacities AS NumberOfCapacities,
Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit' plpo.PurchaseOrderQty AS PurchaseOrderQty,
plpo.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
plpo.OperationStandardDuration AS OperationStandardDuration,
plpo.OperationStandardDurationUnit AS OperationStandardDurationUnit,
plpo.CostCtrActivityType AS CostCtrActivityType,
plpo.MaterialGroup AS MaterialGroup,
plpo.OpExternalProcessingPrice AS OpExternalProcessingPrice,
plpo.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
plpo.CostElement AS CostElement,
plpo.PurchasingGroup AS PurchasingGroup,
plpo.PurchasingOrganization AS PurchasingOrganization,
plpo.Supplier AS Supplier,
plpo.ChangeNumber AS ChangeNumber,
plpo.ValidityStartDate AS ValidityStartDate,
plpo.ValidityEndDate AS ValidityEndDate,
plpo.OperationStandardTextCode AS OperationStandardTextCode,
plpo.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
plpo.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
plpo.PurchasingInfoRecord AS PurchasingInfoRecord,
plpo.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
plpo.PurchaseContract AS PurchaseContract,
plpo.PurchaseContractItem AS PurchaseContractItem,
plpo.OperationSystemCondition AS OperationSystemCondition,
plpo.Equipment AS Equipment,
plpo.IsDeleted AS IsDeleted,
plpo.MaintOperationalChecklistType AS MaintOperationalChecklistType,
plpo._Assembly AS _Assembly,
plpo._ChangeMaster AS _ChangeMaster,
plpo._Equipment AS _Equipment,
plpo._OperationCalculationControl AS _OperationCalculationControl,
plpo._OperationControlProfile AS _OperationControlProfile,
plpo._OperationStandardText AS _OperationStandardText,
plpo._OperationSystemCondition AS _OperationSystemCondition,
plpo._Plant AS _Plant,
plpo._PurchasingInfoRecord AS _PurchasingInfoRecord,
plpo._PurchasingOrganization AS _PurchasingOrganization,
plpo._Supplier AS _Supplier,
plpo._Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
plpo._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
plpo._Supplier.AuthorizationGroup AS AuthorizationGroup,
_MaintenanceTaskList.TaskListStatus AS TaskListStatus,
_MaintenanceTaskList._TechnicalObject.MaintenancePlanningPlant AS MaintenancePlanningPlant,
_MaintenanceTaskList._TechnicalObject.MaintenancePlannerGroup AS MaintenancePlannerGroup,
_MaintenanceTaskList._TechnicalObject._LocationAccountAssignment.ControllingArea AS ControllingArea,
_MaintenanceTaskList._TechnicalObject._LocationAccountAssignment.CostCenter AS CostCenter,
_MaintenanceTaskList._TechnicalObject._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
_MaintenanceTaskList.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
plpo._WorkCenter AS _WorkCenter,
plpo._WorkCenterType AS _WorkCenterType,
plpo._MaintOperationExecStageCode AS _MaintOperationExecStageCode,
_MaintTaskListTechObj._TechnicalObject AS _TechnicalObject,
_MaintTaskListTechObj._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS plas ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenanceTaskList AS _MaintenanceTaskList ON _MaintenanceTaskList.TaskListType = TaskListType AND _MaintenanceTaskList.TaskListGroup = TaskListGroup AND _MaintenanceTaskList.TaskListGroupCounter = TaskListGroupCounter -- association [1..1]
LEFT OUTER JOIN R_MaintTaskListSubOpTP AS _SubOp ON TaskListType = _SubOp.TaskListType AND TaskListGroup = _SubOp.TaskListGroup AND TaskListGroupCounter = _SubOp.TaskListGroupCounter AND MaintenanceTaskListOperation = _SubOp.MaintenanceTaskListOperation -- association [0..*]
LEFT OUTER JOIN R_MaintTaskListOpMaterialTP AS _OpMaterial ON TaskListType = _OpMaterial.TaskListType AND TaskListGroup = _OpMaterial.TaskListGroup AND TaskListGroupCounter = _OpMaterial.TaskListGroupCounter AND TaskListSequence = _OpMaterial.TaskListSequence AND TaskListOperationInternalId = _OpMaterial.TaskListOperationInternalId -- association [0..*]
LEFT OUTER JOIN R_MaintTaskListOpRelshpTP AS _OpRelation ON TaskListType = _OpRelation.TaskListType AND TaskListGroup = _OpRelation.TaskListGroup AND TaskListGroupCounter = _OpRelation.TaskListGroupCounter AND TaskListOperationInternalId = _OpRelation.SuccssrBOOOpInternalID AND TaskListSequence = _OpRelation.TaskListSequence -- association [0..*]
LEFT OUTER JOIN I_MaintTaskListOpTechObj AS _MaintTaskListTechObj ON TaskListType = _MaintTaskListTechObj.TaskListType AND TaskListGroup = _MaintTaskListTechObj.TaskListGroup AND TaskListGroupCounter = _MaintTaskListTechObj.TaskListGroupCounter AND TaskListSequence = _MaintTaskListTechObj.TaskListSequence AND TaskListOperationInternalId = _MaintTaskListTechObj.TaskListOperationInternalId AND TaskListOpBOMItmIntVersCounter = _MaintTaskListTechObj.TaskListOpBOMItmIntVersCounter -- association [0..1]
LEFT OUTER JOIN R_MaintTaskListOpLongTextTP AS _OpLongText ON TaskListType = _OpLongText.TaskListType AND TaskListGroup = _OpLongText.TaskListGroup AND TaskListGroupCounter = _OpLongText.TaskListGroupCounter AND TaskListSequence = _OpLongText.TaskListSequence AND TaskListOperationInternalId = _OpLongText.TaskListOperationInternalId AND TaskListOpBOMItmIntVersCounter = _OpLongText.TaskListOpBOMItmIntVersCounter -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA