C_ObjPgMaintTaskList

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 C_ObjPgMaintTaskList.
-- 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: COBJPGMAINTTL
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW C_ObjPgMaintTaskList AS
SELECT
  $parameters.P_KeyDate AS KeyDate,
  case ltrim( _MaintenanceTaskList.TaskListGroup, '0') when '' then case ltrim( _MaintenanceTaskList.TaskListGroupCounter, '0') when '' then concat( _MaintenanceTaskList.TaskListType, '/0/0' ) else concat( concat( _MaintenanceTaskList.TaskListType, '/0/' ), ltrim( _MaintenanceTaskList.TaskListGroupCounter, '0') ) end else case ltrim( _MaintenanceTaskList.TaskListGroupCounter, '0') when '' then concat( concat( concat( _MaintenanceTaskList.TaskListType, '/' ), ltrim( _MaintenanceTaskList.TaskListGroup, '0') ), '/0' ) else concat( concat( concat( concat( _MaintenanceTaskList.TaskListType, '/' ), ltrim( _MaintenanceTaskList.TaskListGroup, '0') ), '/' ), ltrim( _MaintenanceTaskList.TaskListGroupCounter, '0') ) end end as TaskList AS TaskListGroupCounter0endendasTaskList,
  _MaintenanceTaskList._MaintenanceStrategy._MaintenanceStrategyText[1:Language = $session.system_language].MaintenanceStrategyDesc AS MaintenanceStrategyDesc,
  _MaintenanceTaskList._SafetyRelevance.SafetyRelevanceActionCode AS SafetyRelevanceActionCode,
  _MaintenanceTaskList._SafetyRelevance._SafetyRelevanceCode._Text[1:Language = $session.system_language].SafetyRelevanceActionDesc AS SafetyRelevanceActionDesc,
  _MaintenanceTaskList._Plant.PlantName AS PlantName,
  _MaintenanceTaskList._ResponsiblePlannerGroup.ResponsiblePlannerGroupName AS ResponsiblePlannerGroupName,
  _MaintenanceTaskList._WorkCenter.WorkCenter AS WorkCenter,
  _MaintenanceTaskList._WorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterText,
  _MaintenanceTaskList._WorkCenter.Plant AS WorkCenterPlant,
  _MaintenanceTaskList._WorkCenter._Plant.PlantName AS WorkCenterPlantName,
  _MaintenanceTaskList._Assembly._Text[1:Language = $session.system_language].MaterialName AS AssemblyName,
  _MaintenanceTaskList._OperationSystemCondition._Text[1:Language = $session.system_language].OperationSystemConditionText AS OperationSystemConditionText,
  _MaintenanceTaskList._TaskListStatus._Text[1:Language = $session.system_language].BillOfOperationsStatusDesc AS TaskListStatusDesc,
  _MaintenanceTaskList._TaskListUsage._Text[1:Language = $session.system_language].BillOfOperationsUsageDesc AS TaskListUsageDesc,
  _MaintenanceTaskList._PMReferenceElement._Text[1:Language = $session.system_language].ReferenceElementDesc AS ReferenceElementDesc,
  _MaintenanceTaskList._InspSubsetFieldCombination._Text[1:Language = $session.system_language].InspSubsetFldCombinationTxt AS InspSubsetFldCombinationTxt,
  _MaintenanceTaskList._InspExtNumbering._Text[1:Language = $session.system_language].InspExtNumberingOfValuesText AS InspExtNumberingOfValuesText,
  _MaintenanceTaskList._TechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
  _MaintenanceTaskList._TechnicalObject._TechnicalObjectText[1:Language = $session.system_language].TechnicalObjectDescription AS TechnicalObjectDescription,
  _MaintenanceTaskList._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  cast (' ' as abap.sstring( 1333 )) AS LongText,
  cast ('0' as abap.int2 ) AS TskListNmbrOfAttachedDocuments,
  _MaintenanceTaskList._TechnicalObject.TechnicalObject AS TechObjectWithLeadingZeros,
  _MaintenanceTaskList._TechnicalObject._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _MaintenanceTaskList._SafetyRelevance._SafetyRelevanceCode AS _SafetyRelevanceCode,
  _MaintenanceTaskList._WorkCenter._WorkCenter AS _WorkCenter,
  _MaintenanceTaskList._WorkCenter._Plant AS _WorkCenterPlant,
  _MaintenanceTaskList.TaskListType AS TaskListType,
  _MaintenanceTaskList.TaskListGroup AS TaskListGroup,
  _MaintenanceTaskList.TaskListGroupCounter AS TaskListGroupCounter,
  _MaintenanceTaskList.TaskListDesc AS TaskListDesc,
  _MaintenanceTaskList.MaintenanceStrategy AS MaintenanceStrategy,
  _MaintenanceTaskList.Plant AS Plant,
  _MaintenanceTaskList.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  _MaintenanceTaskList.Assembly AS Assembly,
  _MaintenanceTaskList.OperationSystemCondition AS OperationSystemCondition,
  _MaintenanceTaskList.TaskListStatus AS TaskListStatus,
  _MaintenanceTaskList.ValidityStartDate AS ValidityStartDate,
  _MaintenanceTaskList.ValidityEndDate AS ValidityEndDate,
  _MaintenanceTaskList.ChangeNumber AS ChangeNumber,
  _MaintenanceTaskList.TaskListUsage AS TaskListUsage,
  _MaintenanceTaskList.ReferenceElement AS ReferenceElement,
  _MaintenanceTaskList.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  _MaintenanceTaskList.InspExternalNumberingOfValues AS InspExternalNumberingOfValues,
  _MaintenanceTaskList.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _MaintenanceTaskList.SafetyRelevantObject AS SafetyRelevantObject,
  _MaintenanceTaskList.TaskListObjectKey AS TaskListObjectKey,
  _MaintenanceTaskList.WorkCenterTypeCode AS WorkCenterTypeCode,
  _MaintenanceTaskList.WorkCenterInternalID AS WorkCenterInternalID,
  _MaintenanceTaskList.TechnicalObject AS TechnicalObject,
  _MaintenanceTaskList.Equipment AS Equipment,
  _MaintenanceTaskList._Assembly AS _Assembly,
  _MaintenanceTaskList._InspExtNumbering AS _InspExtNumbering,
  _MaintenanceTaskList._InspSubsetFieldCombination AS _InspSubsetFieldCombination,
  _MaintenanceTaskList._MaintenanceStrategy AS _MaintenanceStrategy,
  _MaintenanceTaskList._OperationSystemCondition AS _OperationSystemCondition,
  _MaintenanceTaskList._Plant AS _Plant,
  _MaintenanceTaskList._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  _MaintenanceTaskList._TaskListGroup AS _TaskListGroup,
  _MaintenanceTaskList._TaskListStatus AS _TaskListStatus,
  _MaintenanceTaskList._TaskListType AS _TaskListType,
  _MaintenanceTaskList._TaskListUsage AS _TaskListUsage,
  _MaintenanceTaskList._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  _MaintenanceTaskList.CreatedByUser AS CreatedByUser,
  _MaintenanceTaskList.CreationDate AS CreationDate,
  _MaintenanceTaskList.LastChangedByUser AS LastChangedByUser,
  _MaintenanceTaskList.LastChangeDate AS LastChangeDate,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription
FROM I_MaintenanceTaskListTP AS _MaintenanceTaskList
LEFT OUTER JOIN C_ObjPgMaintTaskListOperation AS _MaintTaskListOperation ON _MaintTaskListOperation.TaskListType = TaskListType AND _MaintTaskListOperation.TaskListGroup = TaskListGroup AND _MaintTaskListOperation.TaskListGroupCounter = TaskListGroupCounter AND _MaintTaskListOperation.ValidityStartDate <= $parameters.P_KeyDate AND _MaintTaskListOperation.ValidityEndDate >= $parameters.P_KeyDate  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintTskListOpMaintPckg AS _MaintTaskListMaintPackage ON _MaintTaskListMaintPackage.TaskListType = TaskListType AND _MaintTaskListMaintPackage.TaskListGroup = TaskListGroup AND _MaintTaskListMaintPackage.TaskListGroupCounter = TaskListGroupCounter AND _MaintTaskListMaintPackage.ValidityStartDate <= $parameters.P_KeyDate AND _MaintTaskListMaintPackage.ValidityEndDate >= $parameters.P_KeyDate  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintTaskListOpCount AS _MaintTaskListOpCount ON _MaintTaskListOpCount.TaskListType = TaskListType AND _MaintTaskListOpCount.TaskListGroup = TaskListGroup AND _MaintTaskListOpCount.TaskListGroupCounter = TaskListGroupCounter  -- association [1..1]
LEFT OUTER JOIN I_MaintTaskListTypeUnified AS _TaskListTypeUnified ON _TaskListTypeUnified.TaskListType = MaintenanceTaskListType  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectLabelVH AS _TechnicalObjectLabelVH ON _TechnicalObjectLabelVH.TechnicalObjectLabel = technicalobjectlabel AND _TechnicalObjectLabelVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjectLabelVH.TechnicalObject = TechnicalObject  -- association [0..1]
LEFT OUTER JOIN C_TechObjQuickVw AS _TechnicalObjQuickVw ON _TechnicalObjQuickVw.TechnicalObject = TechnicalObject AND _TechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjQuickVw.TechnicalObjectLabel = technicalobjectlabel  -- association [0..1]
LEFT OUTER JOIN C_EAMProductQuickVw AS _EAMProductQuickVw ON _EAMProductQuickVw.Material = Assembly  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN C_MaintTskListRecommendation AS _MaintTaskRecommendation ON TaskListType = _MaintTaskRecommendation.TaskListType AND TaskListGroup = _MaintTaskRecommendation.TaskListGroup AND TaskListGroupCounter = _MaintTaskRecommendation.TaskListGroupCounter  -- association [0..*]
;