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_ObjPgMaintTaskListAndOp.
-- 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: COBJPGMTLANDOP
-- Parameters: P_KeyDate : vdm_v_key_date
CREATE VIEW C_ObjPgMaintTaskListAndOp AS
SELECT
_MaintTaskListOperation.TaskListType AS TaskListType,
_MaintTaskListOperation.TaskListGroup AS TaskListGroup,
_MaintTaskListOperation.TaskListGroupCounter AS TaskListGroupCounter,
_MaintTaskListOperation.TaskListSequence AS TaskListSequence,
_MaintTaskListOperation.TaskListOperationInternalId AS TaskListOperationInternalId,
_MaintTaskListOperation.TaskListOpBOMItmIntVersCounter AS TaskListOpBOMItmIntVersCounter,
_MaintTaskListOperation.MaintenanceTaskListOperation AS MaintenanceTaskListOperation,
_MaintTaskListOperation.MaintTaskListSubOperation AS MaintTaskListSubOperation,
$parameters.P_KeyDate AS KeyDate,
_MaintTaskListOperation.OperationText AS OperationText,
_MaintTaskListOperation.OperationControlProfile AS OperationControlProfile,
_MaintTaskListOperation._OperationControlProfile._Text[1:Language = $session.system_language].OperationControlProfileName AS OperationControlProfileName,
_MaintTaskListOperation._WorkCenter.WorkCenter AS OperationWorkCenter,
_MaintTaskListOperation._WorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS OperationWorkCenterText,
_MaintTaskListOperation._WorkCenter.Plant AS OperationWorkCenterPlant,
_MaintTaskListOperation._WorkCenter._Plant.PlantName AS OperationWorkCenterPlantName,
_MaintTaskListOperation.Assembly AS OperationAssembly,
_MaintTaskListOperation._Assembly._Text[1:Language = $session.system_language].MaterialName AS OperationAssemblyName,
_MaintTaskListOperation.OpPlannedWorkQuantity AS OpPlannedWorkQuantity,
_MaintTaskListOperation.OpWorkQuantityUnit AS OpWorkQuantityUnit,
_MaintTaskListOperation.ValidityStartDate AS OperationValidityStartDate,
_MaintTaskListOperation.ValidityEndDate AS OperationValidityEndDate,
_MaintTaskListOperation.OperationStandardTextCode AS OperationStandardTextCode,
_MaintTaskListOperation._OperationStandardText._Text[1:Language = $session.system_language].OperationStandardTextCodeName AS OperationStandardTextCodeName,
_MaintTaskListOperation.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
_MaintTaskListOperation.OpExternalProcessingPrice AS OpExternalProcessingPrice,
_MaintTaskListOperation.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
_MaintTaskListOperation.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
_MaintTaskListOperation.PurchasingInfoRecord AS PurchasingInfoRecord,
_MaintTaskListOperation.Supplier AS Supplier,
_MaintTaskListOperation._Supplier.SupplierName AS SupplierName,
_MaintTaskListOperation.PurchaseContract AS PurchaseContract,
_MaintTaskListOperation.PurchaseContractItem AS PurchaseContractItem,
_MaintTaskListOperation.OperationStandardDuration AS OperationStandardDuration,
_MaintTaskListOperation.OperationStandardDurationUnit AS OperationStandardDurationUnit,
_MaintTaskListOperation.NumberOfCapacities AS NumberOfCapacities,
_MaintTaskListOperation.CostCtrActivityType AS CostCtrActivityType,
_MaintTaskListOperation.OperationCalculationControl AS OperationCalculationControl,
_MaintTaskListOperation._OperationCalculationControl._Text[1:Language = $session.system_language].OperationCalcControlDesc AS OperationCalcControlDesc,
_MaintTaskListOperation.PurchaseOrderQty AS PurchaseOrderQty,
_MaintTaskListOperation.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
_MaintTaskListOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
case ltrim( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListGroup, '0') when '' then case ltrim( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListGroupCounter, '0') when '' then concat( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListType, '/0/0' ) else concat( concat( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListType, '/0/' ), ltrim( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListGroupCounter, '0') ) end else case ltrim( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListGroupCounter, '0') when '' then concat( concat( concat( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListType, '/' ), ltrim( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListGroup, '0') ), '/0' ) else concat( concat( concat( concat( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListType, '/' ), ltrim( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListGroup, '0') ), '/' ), ltrim( _MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListGroupCounter, '0') ) end end as TaskList AS TaskListGroupCounter0endendasTaskList,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListDesc AS TaskListDesc,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TechnicalObject._TechnicalObjectText[1:Language = $session.system_language].TechnicalObjectDescription AS TechnicalObjectDescription,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._WorkCenter.WorkCenter AS WorkCenter,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._WorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterText,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._WorkCenter.Plant AS WorkCenterPlant,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._WorkCenter._Plant.PlantName AS WorkCenterPlantName,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).MaintenanceStrategy AS MaintenanceStrategy,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._MaintenanceStrategy._MaintenanceStrategyText[1:Language = $session.system_language].MaintenanceStrategyDesc AS MaintenanceStrategyDesc,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._SafetyRelevance._SafetyRelevanceCode._Text[1:Language = $session.system_language].SafetyRelevanceActionDesc AS SafetyRelevanceActionDesc,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).Plant AS Plant,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._Plant.PlantName AS PlantName,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._ResponsiblePlannerGroup.ResponsiblePlannerGroupName AS ResponsiblePlannerGroupName,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).Assembly AS Assembly,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._Assembly._Text[1:Language = $session.system_language].MaterialName AS AssemblyName,
_MaintTaskListOperation.OperationSystemCondition AS OperationSystemCondition,
_MaintTaskListOperation._OperationSystemCondition._Text[1:Language = $session.system_language].OperationSystemConditionText AS OperationSystemConditionText,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListStatus AS TaskListStatus,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TaskListStatus._Text[1:Language = $session.system_language].BillOfOperationsStatusDesc AS TaskListStatusDesc,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).ValidityStartDate AS ValidityStartDate,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).ValidityEndDate AS ValidityEndDate,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).ChangeNumber AS ChangeNumber,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListUsage AS TaskListUsage,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TaskListUsage._Text[1:Language = $session.system_language].BillOfOperationsUsageDesc AS TaskListUsageDesc,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).ReferenceElement AS ReferenceElement,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._PMReferenceElement._Text[1:Language = $session.system_language].ReferenceElementDesc AS ReferenceElementDesc,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).InspSubsetFieldCombination AS InspSubsetFieldCombination,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._InspSubsetFieldCombination._Text[1:Language = $session.system_language].InspSubsetFldCombinationTxt AS InspSubsetFldCombinationTxt,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).InspExternalNumberingOfValues AS InspExternalNumberingOfValues,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._InspExtNumbering._Text[1:Language = $session.system_language].InspExtNumberingOfValuesText AS InspExtNumberingOfValuesText,
_MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
_MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).SafetyRelevantObject AS SafetyRelevantObject,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TaskListObjectKey AS TaskListObjectKey,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).WorkCenterTypeCode AS WorkCenterTypeCode,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).WorkCenterInternalID AS WorkCenterInternalID,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).TechnicalObject AS TechnicalObject,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TechnicalObject.TechnicalObject AS TechObjectWithLeadingZeros,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate).Equipment AS Equipment,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TechnicalObject._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
_MaintTaskListOperation.TechnicalObject AS MaintOperationTechnicalObject,
_MaintTaskListOperation._TechnicalObject.TechnicalObjectLabel AS OperationTechnicalObjectLabel,
_MaintTaskListOperation._TechnicalObject._TechnicalObjectText[1:Language = $session.system_language].TechnicalObjectDescription AS OperationTechnicalObjectDesc,
_MaintTaskListOperation.TechObjIsEquipOrFuncnlLoc AS OperationTechObjIsEquip,
_MaintTaskListOperation._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS OperationTechObjIsEquipDesc,
_MaintTaskListOperation.MaintOperationalChecklistType AS MaintOperationalChecklistType,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._Assembly AS _Assembly,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._InspExtNumbering AS _InspExtNumbering,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._InspSubsetFieldCombination AS _InspSubsetFieldCombination,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._MaintenanceStrategy AS _MaintenanceStrategy,
_MaintTaskListOperation._OperationSystemCondition AS _OperationSystemCondition,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._Plant AS _Plant,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._SafetyRelevance AS _SafetyRelevance,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TaskListStatus AS _TaskListStatus,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TaskListUsage AS _TaskListUsage,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TechnicalObject AS _TechnicalObject,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._WorkCenter._WorkCenter AS _WorkCenter,
_MaintTaskListForKeyDate(P_KeyDate:$parameters.P_KeyDate)._WorkCenter._Plant AS _WorkCenterPlant,
_MaintTaskListOperation._TechObjIsEquipOrFuncnlLoc AS _OpTechObjIsEquipOrFuncnlLoc,
_MaintTaskListOperation._Assembly AS _OperationAssembly,
_MaintTaskListOperation._WorkCenter._WorkCenter AS _OperationWorkCenter,
_MaintTaskListOperation._WorkCenter._Plant AS _OperationWorkCenterPlant,
_MaintTaskListOperation._Supplier AS _Supplier,
_MaintTaskListOperation._OperationControlProfile AS _OperationControlProfile,
_MaintTaskListOperation._OperationStandardText AS _OperationStandardText,
CreatedByUser,
_CreatedByUser.UserDescription AS CreatedByUserDescription,
_MaintenanceTaskListTP.CreationDate AS CreationDate,
LastChangedByUser,
_LastChangedByUser.UserDescription AS LastChangedByUserDescription,
_MaintenanceTaskList.LastChangeDate AS LastChangeDate,
_ChecklistType.MaintenanceChecklistTypeText AS MaintenanceChecklistTypeText
FROM I_MaintTaskListOperationTP AS _MaintTaskListOperation
LEFT OUTER JOIN I_MaintenanceTaskListTP AS _MaintenanceTaskList ON _MaintenanceTaskList.TaskListType = TaskListType AND _MaintenanceTaskList.TaskListGroup = TaskListGroup AND _MaintenanceTaskList.TaskListGroupCounter = TaskListGroupCounter -- association [1..1]
LEFT OUTER JOIN I_MaintTaskListForKeyDate AS _MaintTaskListForKeyDate ON _MaintTaskListForKeyDate.TaskListType = TaskListType AND _MaintTaskListForKeyDate.TaskListGroup = TaskListGroup AND _MaintTaskListForKeyDate.TaskListGroupCounter = TaskListGroupCounter -- association [0..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_TechnicalObjectLabelVH AS _OperationTechObjLabelVH ON _OperationTechObjLabelVH.TechnicalObjectLabel = OperationTechnicalObjectLabel AND _OperationTechObjLabelVH.TechObjIsEquipOrFuncnlLoc = OperationTechObjIsEquip AND _OperationTechObjLabelVH.TechnicalObject = MaintOperationTechnicalObject -- association [0..1]
LEFT OUTER JOIN I_Supplier_VH AS _SupplierVH ON _SupplierVH.Supplier = Supplier -- 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_MaintTaskListQuickVw AS _MaintTaskListQuickVw ON _MaintTaskListQuickVw.TaskListType = TaskListType AND _MaintTaskListQuickVw.TaskListGroup = TaskListGroup AND _MaintTaskListQuickVw.TaskListGroupCounter = TaskListGroupCounter AND _MaintTaskListQuickVw.TaskList = TaskList -- association [0..1]
LEFT OUTER JOIN C_TechObjQuickVw AS _OpTechnicalObjQuickVw ON _OpTechnicalObjQuickVw.TechnicalObject = MaintOperationTechnicalObject AND _OpTechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = OperationTechObjIsEquip AND _OpTechnicalObjQuickVw.TechnicalObjectLabel = OperationTechnicalObjectLabel -- association [0..1]
LEFT OUTER JOIN I_MaintOpExecStageCodeText AS _MaintOpExecStageCodeText ON _MaintOpExecStageCodeText.MaintOperationExecStageCode = MaintOperationExecStageCode -- association [0..*]
LEFT OUTER JOIN C_MaintenanceChecklistTypeVH AS _MaintenanceChecklistTypeVH ON _MaintenanceChecklistTypeVH.MaintOperationalChecklistType = MaintOperationalChecklistType -- association [0..1]
LEFT OUTER JOIN I_MaintenanceChecklistType AS _ChecklistType ON _ChecklistType.MaintOperationalChecklistType = MaintOperationalChecklistType -- 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]
;