R_MaintTaskListOpMaterialTP

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_MaintTaskListOpMaterialTP.
-- 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_MaintTaskListOpMaterialTP AS
SELECT
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskListSequence,
  TaskListOperationInternalId,
  TaskListOpBOMItmInternalID,
  TaskListOpBOMItmIntVersCounter,
  _TaskListOperation.MaintenanceTaskListOperation AS MaintenanceTaskListOperation,
  BillOfMaterialComponent AS Material,
  case when BillOfMaterialComponent = '' then _BOMItemEAM.BOMItemDescription else _BillOfMaterialComponent._Text[1: Language = $session.system_language ].MaterialName end as MaterialName AS MaterialNameendasMaterialName,
  BillOfMaterialItemQuantity,
  BillOfMaterialItemUnit,
  I_MaintTaskListOpMaterial._SafetyRelevance.SafetyRelevantObject AS SafetyRelevantObject,
  I_MaintTaskListOpMaterial._SafetyRelevance._SafetyRelevanceCode._Text[1: Language = $session.system_language ].SafetyRelevanceActionDesc AS SafetyRelevanceActionDesc,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialItemNodeNumber,
  MatlCompIsMarkedForBackflush,
  IsDeleted,
  ResvnIsMRPRlvtOrPurReqnIsCrted,
  _BOMItemEAM.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  _BOMItemCategoryText.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  _MatlsPlngRelevancy._Text[1: Language = $session.system_language ].MatlsPlngRelevancyCodeName AS MatlsPlngRelevancyCodeName,
  Equipment,
  FunctionalLocation,
  _MaintenanceTaskList.Plant AS Plant,
  _MaintenanceTaskList.TaskListStatus AS TaskListStatus,
  _MaintenanceTaskList.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  case TechObjIsEquipOrFuncnlLoc when 'EAMS_EQUI' then _Equipmentts._LocationAccountAssignment.ControllingArea else _FunctionalLocation._LocationAccountAssignment.ControllingArea end as ControllingArea AS ControllingAreaendasControllingArea,
  case TechObjIsEquipOrFuncnlLoc when 'EAMS_EQUI' then _Equipmentts._LocationAccountAssignment.CostCenter else _FunctionalLocation._LocationAccountAssignment.CostCenter end as CostCenter AS CostCenterendasCostCenter,
  case TechObjIsEquipOrFuncnlLoc when 'EAMS_EQUI' then _Equipmentts._LocationAccountAssignment.MaintenancePlant else _FunctionalLocation._LocationAccountAssignment.MaintenancePlant end as MaintenancePlant AS MaintenancePlantendasMaintenancePlant
LEFT OUTER JOIN R_MaintTaskListOpBasicTP AS _TaskListOperation ON TaskListGroup = _TaskListOperation.TaskListGroup AND TaskListGroupCounter = _TaskListOperation.TaskListGroupCounter AND TaskListSequence = _TaskListOperation.TaskListSequence AND TaskListOperationInternalId = _TaskListOperation.TaskListOperationInternalId AND TaskListType = _TaskListOperation.TaskListType AND TaskListOpBOMItmIntVersCounter = _TaskListOperation.TaskListOpBOMItmIntVersCounter  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_EquipmentTimeSeg AS _Equipmentts ON Equipment = _Equipmentts.Equipment AND _Equipmentts.ValidityEndDate = '99991231' AND _Equipmentts.EquipUsagePeriodSequenceNumber = '001'  -- association [0..1]
;