I_MaintTaskListOpTechObj

DDL: I_MAINTTASKLISTOPTECHOBJ SQL: IMAINTTLOPTECOBJ Type: view COMPOSITE
73 Fields 1 Data Sources 4 Associations

Maint. Task List Operation w/ Tech. Obj.

I_MaintTaskListOpTechObj is a Composite CDS View that provides data about "Maint. Task List Operation w/ Tech. Obj." in SAP S/4HANA. It reads from 1 data source (I_MaintTaskListOperation) and exposes 73 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintTaskListOperation I_MaintTaskListOperation from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_TechnicalObject _TechnicalObject _TechnicalObject.TechnicalObject = $projection.TechnicalObject and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
[0..1] I_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
[0..1] I_Currency _Currency _Currency.Currency = $projection.OpExternalProcessingCurrency
[0..1] I_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData.PurchasingInfoRecord = $projection.PurchasingInfoRecord and _PurgInfoRecdOrgPlantData.PurchasingOrganization = $projection.PurchasingOrganization and _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory = $projection.PurchasingInfoRecordCategory and _PurgInfoRecdOrgPlantData.Plant = $projection.Plant

Annotations (9)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IMAINTTLOPTECOBJ view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maint. Task List Operation w/ Tech. Obj. view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY TaskListType I_MaintTaskListOperation TaskListType Task List Type
KEY TaskListGroup I_MaintTaskListOperation TaskListGroup Group
KEY TaskListGroupCounter I_MaintTaskListOperation TaskListGroupCounter Group Counter
KEY TaskListSequence I_MaintTaskListOperation TaskListSequence Sequence
KEY TaskListOperationInternalId I_MaintTaskListOperation TaskListOperationInternalId Node
TaskListOpBOMItmIntVersCounter I_MaintTaskListOperation TaskListOpBOMItmIntVersCounter Counter
MaintenanceTaskListOperation I_MaintTaskListOperation MaintenanceTaskListOperation
MaintTaskListSubOperation I_MaintTaskListOperation MaintTaskListSubOperation
OperationText I_MaintTaskListOperation OperationText Description
OperationControlProfile I_MaintTaskListOperation OperationControlProfile Control Key
WorkCenterInternalID I_MaintTaskListOperation WorkCenterInternalID Work Center
WorkCenterTypeCode I_MaintTaskListOperation WorkCenterTypeCode Object Type
Plant I_MaintTaskListOperation Plant Valuation Area
OpPlannedWorkQuantity I_MaintTaskListOperation OpPlannedWorkQuantity
OpWorkQuantityUnit I_MaintTaskListOperation OpWorkQuantityUnit
ChangeNumber I_MaintTaskListOperation ChangeNumber Change Number
ValidityStartDate I_MaintTaskListOperation ValidityStartDate Validity Start Date
ValidityEndDate I_MaintTaskListOperation ValidityEndDate ValidTo
OperationStandardTextCode I_MaintTaskListOperation OperationStandardTextCode Std Text Key
PurchasingInfoRecdAddlGrpgName I_MaintTaskListOperation PurchasingInfoRecdAddlGrpgName Sort Term
PurchasingInfoRecord I_MaintTaskListOperation PurchasingInfoRecord Info Record
PurchasingInfoRecordCategory I_MaintTaskListOperation PurchasingInfoRecordCategory Infotype
PurchasingOrganization I_MaintTaskListOperation PurchasingOrganization Purchasing Organization
Supplier I_MaintTaskListOperation Supplier Supplier
PurchaseContract I_MaintTaskListOperation PurchaseContract Purchasing Doc.
PurchaseContractItem I_MaintTaskListOperation PurchaseContractItem Item
OperationStandardDuration I_MaintTaskListOperation OperationStandardDuration
OperationStandardDurationUnit I_MaintTaskListOperation OperationStandardDurationUnit
NumberOfCapacities I_MaintTaskListOperation NumberOfCapacities Number
OperationSystemCondition I_MaintTaskListOperation OperationSystemCondition SystemCondition
CostCtrActivityType I_MaintTaskListOperation CostCtrActivityType Activity Type
OperationCalculationControl I_MaintTaskListOperation OperationCalculationControl Calculation key
Assembly I_MaintTaskListOperation Assembly Pegged Reqmt
PurchaseOrderQty I_MaintTaskListOperation PurchaseOrderQty Purchase Order Quantity
PurchaseOrderQuantityUnit I_MaintTaskListOperation PurchaseOrderQuantityUnit Order Unit
FunctionalLocation I_MaintTaskListOperation FunctionalLocation Object ID
Equipment I_MaintTaskListOperation Equipment Equipment check
IsDeleted I_MaintTaskListOperation IsDeleted TRUE
IsImplicitlyDeleted I_MaintTaskListOperation IsImplicitlyDeleted
TaskListOperationObjectKey I_MaintTaskListOperation TaskListOperationObjectKey
MaintOperationExecStageCode I_MaintTaskListOperation MaintOperationExecStageCode Execution Stage
BillOfOperationsGroup I_MaintTaskListOperation BillOfOperationsGroup Group
BillOfOperationsType I_MaintTaskListOperation BillOfOperationsType Task List Type
BOOOperationInternalID I_MaintTaskListOperation BOOOperationInternalID Task list node
MaintOperationalChecklistType I_MaintTaskListOperation MaintOperationalChecklistType Checklist Type
MaintenanceJobVerification I_MaintTaskListOperation MaintenanceJobVerification
MaintenanceActivityType I_MaintTaskListOperation MaintenanceActivityType MaintActivType
_Currency _Currency
_Assembly I_MaintTaskListOperation _Assembly
_ChangeMaster I_MaintTaskListOperation _ChangeMaster
_Equipment I_MaintTaskListOperation _Equipment
_FunctionalLocation I_MaintTaskListOperation _FunctionalLocation
_MaintenanceTaskList I_MaintTaskListOperation _MaintenanceTaskList
_OperationCalculationControl I_MaintTaskListOperation _OperationCalculationControl
_OperationControlProfile I_MaintTaskListOperation _OperationControlProfile
_OperationStandardText I_MaintTaskListOperation _OperationStandardText
_OperationSystemCondition I_MaintTaskListOperation _OperationSystemCondition
_Plant I_MaintTaskListOperation _Plant
_PurchaseContract I_MaintTaskListOperation _PurchaseContract
_PurchaseContractItem I_MaintTaskListOperation _PurchaseContractItem
_PurchasingInfoRecord I_MaintTaskListOperation _PurchasingInfoRecord
_PurchasingOrganization I_MaintTaskListOperation _PurchasingOrganization
_Supplier I_MaintTaskListOperation _Supplier
_TaskListType I_MaintTaskListOperation _TaskListType
_TaskListGroup I_MaintTaskListOperation _TaskListGroup
_TaskListGroupCounter I_MaintTaskListOperation _TaskListGroupCounter
_TaskListSequence I_MaintTaskListOperation _TaskListSequence
_TaskListOperationInternalId I_MaintTaskListOperation _TaskListOperationInternalId
_WorkCenter I_MaintTaskListOperation _WorkCenter
_WorkCenterType I_MaintTaskListOperation _WorkCenterType
_MaintOperationExecStageCode I_MaintTaskListOperation _MaintOperationExecStageCode
_TechnicalObject _TechnicalObject
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc

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 I_MaintTaskListOpTechObj.
-- 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.
-- SQL view name: IMAINTTLOPTECOBJ

CREATE VIEW I_MaintTaskListOpTechObj AS
SELECT
  I_MaintTaskListOperation.TaskListType AS TaskListType,
  I_MaintTaskListOperation.TaskListGroup AS TaskListGroup,
  I_MaintTaskListOperation.TaskListGroupCounter AS TaskListGroupCounter,
  I_MaintTaskListOperation.TaskListSequence AS TaskListSequence,
  I_MaintTaskListOperation.TaskListOperationInternalId AS TaskListOperationInternalId,
  I_MaintTaskListOperation.TaskListOpBOMItmIntVersCounter AS TaskListOpBOMItmIntVersCounter,
  I_MaintTaskListOperation.MaintenanceTaskListOperation AS MaintenanceTaskListOperation,
  I_MaintTaskListOperation.MaintTaskListSubOperation AS MaintTaskListSubOperation,
  I_MaintTaskListOperation.OperationText AS OperationText,
  I_MaintTaskListOperation.OperationControlProfile AS OperationControlProfile,
  I_MaintTaskListOperation.WorkCenterInternalID AS WorkCenterInternalID,
  I_MaintTaskListOperation.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_MaintTaskListOperation.Plant AS Plant,
  I_MaintTaskListOperation.OpPlannedWorkQuantity AS OpPlannedWorkQuantity,
  I_MaintTaskListOperation.OpWorkQuantityUnit AS OpWorkQuantityUnit,
  I_MaintTaskListOperation.ChangeNumber AS ChangeNumber,
  I_MaintTaskListOperation.ValidityStartDate AS ValidityStartDate,
  I_MaintTaskListOperation.ValidityEndDate AS ValidityEndDate,
  I_MaintTaskListOperation.OperationStandardTextCode AS OperationStandardTextCode,
  I_MaintTaskListOperation.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
  I_MaintTaskListOperation.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_MaintTaskListOperation.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  I_MaintTaskListOperation.PurchasingOrganization AS PurchasingOrganization,
  I_MaintTaskListOperation.Supplier AS Supplier,
  I_MaintTaskListOperation.PurchaseContract AS PurchaseContract,
  I_MaintTaskListOperation.PurchaseContractItem AS PurchaseContractItem,
  I_MaintTaskListOperation.OperationStandardDuration AS OperationStandardDuration,
  I_MaintTaskListOperation.OperationStandardDurationUnit AS OperationStandardDurationUnit,
  I_MaintTaskListOperation.NumberOfCapacities AS NumberOfCapacities,
  I_MaintTaskListOperation.OperationSystemCondition AS OperationSystemCondition,
  I_MaintTaskListOperation.CostCtrActivityType AS CostCtrActivityType,
  I_MaintTaskListOperation.OperationCalculationControl AS OperationCalculationControl,
  I_MaintTaskListOperation.Assembly AS Assembly,
  I_MaintTaskListOperation.PurchaseOrderQty AS PurchaseOrderQty,
  I_MaintTaskListOperation.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  I_MaintTaskListOperation.FunctionalLocation AS FunctionalLocation,
  I_MaintTaskListOperation.Equipment AS Equipment,
  I_MaintTaskListOperation.IsDeleted AS IsDeleted,
  I_MaintTaskListOperation.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  I_MaintTaskListOperation.TaskListOperationObjectKey AS TaskListOperationObjectKey,
  I_MaintTaskListOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  I_MaintTaskListOperation.BillOfOperationsGroup AS BillOfOperationsGroup,
  I_MaintTaskListOperation.BillOfOperationsType AS BillOfOperationsType,
  I_MaintTaskListOperation.BOOOperationInternalID AS BOOOperationInternalID,
  I_MaintTaskListOperation.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  I_MaintTaskListOperation.MaintenanceJobVerification AS MaintenanceJobVerification,
  I_MaintTaskListOperation.MaintenanceActivityType AS MaintenanceActivityType,
  I_MaintTaskListOperation._Assembly AS _Assembly,
  I_MaintTaskListOperation._ChangeMaster AS _ChangeMaster,
  I_MaintTaskListOperation._Equipment AS _Equipment,
  I_MaintTaskListOperation._FunctionalLocation AS _FunctionalLocation,
  I_MaintTaskListOperation._MaintenanceTaskList AS _MaintenanceTaskList,
  I_MaintTaskListOperation._OperationCalculationControl AS _OperationCalculationControl,
  I_MaintTaskListOperation._OperationControlProfile AS _OperationControlProfile,
  I_MaintTaskListOperation._OperationStandardText AS _OperationStandardText,
  I_MaintTaskListOperation._OperationSystemCondition AS _OperationSystemCondition,
  I_MaintTaskListOperation._Plant AS _Plant,
  I_MaintTaskListOperation._PurchaseContract AS _PurchaseContract,
  I_MaintTaskListOperation._PurchaseContractItem AS _PurchaseContractItem,
  I_MaintTaskListOperation._PurchasingInfoRecord AS _PurchasingInfoRecord,
  I_MaintTaskListOperation._PurchasingOrganization AS _PurchasingOrganization,
  I_MaintTaskListOperation._Supplier AS _Supplier,
  I_MaintTaskListOperation._TaskListType AS _TaskListType,
  I_MaintTaskListOperation._TaskListGroup AS _TaskListGroup,
  I_MaintTaskListOperation._TaskListGroupCounter AS _TaskListGroupCounter,
  I_MaintTaskListOperation._TaskListSequence AS _TaskListSequence,
  I_MaintTaskListOperation._TaskListOperationInternalId AS _TaskListOperationInternalId,
  I_MaintTaskListOperation._WorkCenter AS _WorkCenter,
  I_MaintTaskListOperation._WorkCenterType AS _WorkCenterType,
  I_MaintTaskListOperation._MaintOperationExecStageCode AS _MaintOperationExecStageCode
FROM I_MaintTaskListOperation
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = OpExternalProcessingCurrency  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecdOrgPlantData AS _PurgInfoRecdOrgPlantData ON _PurgInfoRecdOrgPlantData.PurchasingInfoRecord = PurchasingInfoRecord AND _PurgInfoRecdOrgPlantData.PurchasingOrganization = PurchasingOrganization AND _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory AND _PurgInfoRecdOrgPlantData.Plant = Plant  -- association [0..1]
;

Learn More