I_MaintTaskListOperation

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_MaintTaskListOperation.
-- 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: IMAINTTLOP

CREATE VIEW I_MaintTaskListOperation 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,
  plas.CreationDate AS CreationDate,
  plas.LastChangeDate AS LastChangeDate,
  plpo.OperationText AS OperationText,
  plpo.OperationControlProfile AS OperationControlProfile,
  plpo.WorkCenterInternalID AS WorkCenterInternalID,
  plpo.WorkCenterTypeCode AS WorkCenterTypeCode,
  plpo.Plant AS Plant,
  plpo.OpPlannedWorkQuantity AS OpPlannedWorkQuantity,
  plpo.OpWorkQuantityUnit AS OpWorkQuantityUnit,
  plpo.ChangeNumber AS ChangeNumber,
  plpo.ValidityStartDate AS ValidityStartDate,
  case plpo.ValidityEndDate when '00000000' then cast ('99991231' as datub) else plpo.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  plpo.OperationStandardTextCode AS OperationStandardTextCode,
  plpo.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
  plpo.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  plpo.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  plpo.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  plpo.PurchasingInfoRecord AS PurchasingInfoRecord,
  plpo.Supplier AS Supplier,
  plpo.PurchaseContract AS PurchaseContract,
  plpo.PurchaseContractItem AS PurchaseContractItem,
  plpo.OperationStandardDuration AS OperationStandardDuration,
  plpo.OperationStandardDurationUnit AS OperationStandardDurationUnit,
  plpo.NumberOfCapacities AS NumberOfCapacities,
  plpo.OperationSystemCondition AS OperationSystemCondition,
  plpo.CostCtrActivityType AS CostCtrActivityType,
  plpo.OperationCalculationControl AS OperationCalculationControl,
  plpo.Assembly AS Assembly,
  plpo.PurchaseOrderQty AS PurchaseOrderQty,
  plpo.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  plpo.FunctionalLocation AS FunctionalLocation,
  plpo.Equipment AS Equipment,
  plpo.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  plpo.PurchasingOrganization AS PurchasingOrganization,
  case when plas.IsDeleted = 'X' then plas.IsDeleted else plpo.IsDeleted end as IsDeleted AS IsDeletedendasIsDeleted,
  plas.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  plpo.OperationUnit AS OperationUnit,
  plpo.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  plpo.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  plpo.OperationReferenceQuantity AS OperationReferenceQuantity,
  plpo.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  plpo.CostElement AS CostElement,
  plpo.PurchasingGroup AS PurchasingGroup,
  plpo.MaterialGroup AS MaterialGroup,
  plpo.OperationCostingRelevancyType AS OperationCostingRelevancyType,
  plpo.MinimumDuration AS MinimumDuration,
  plpo.MinimumDurationUnit AS MinimumDurationUnit,
  plpo.OperationWorkPercent AS OperationWorkPercent,
  plpo.CapRqmtsDistributionFunction AS CapRqmtsDistributionFunction,
  plpo.CompanyCode AS CompanyCode,
  plpo.FactoryCalendar AS FactoryCalendar,
  plpo.CapacityRequirementDistrKey AS CapacityRequirementDistrKey,
  plpo.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  plpo.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  plas.BOOOperationInternalID AS BOOOperationInternalID,
  plpo.BillOfOperationsGroup AS BillOfOperationsGroup,
  plpo.BillOfOperationsType AS BillOfOperationsType,
  plas._BillOfOperationsGroup AS _TaskListGroup,
  plas._BillOfOperations AS _TaskListGroupCounter,
  plas._BillOfOperationsSequence AS _TaskListSequence,
  plpo._BOOOperationInternalID AS _TaskListOperationInternalId,
  plpo._BOOOperationInternalID AS _BOOOperationInternalID,
  plas._BillOfOperationsGroup AS _BillOfOperationsGroup,
  plas._BillOfOperationsType AS _BillOfOperationsType,
  plas._BillOfOperationsSequence AS _BillOfOperationsSequence,
  plpo._Assembly AS _Assembly,
  plpo._Equipment AS _Equipment,
  plpo._FunctionalLocation AS _FunctionalLocation,
  plpo._ChangeMaster AS _ChangeMaster,
  plpo._OperationCalculationControl AS _OperationCalculationControl,
  plpo._OperationControlProfile AS _OperationControlProfile,
  plpo._OpExternalProcessingCurrency AS _OpExternalProcessingCurrency,
  plpo._OperationStandardText AS _OperationStandardText,
  plpo._OperationSystemCondition AS _OperationSystemCondition,
  plpo._Plant AS _Plant,
  plpo._PurchasingInfoRecord AS _PurchasingInfoRecord,
  plpo._PurchaseContract AS _PurchaseContract,
  plpo._PurchaseContractItem AS _PurchaseContractItem,
  plpo._PurchasingOrganization AS _PurchasingOrganization,
  plpo._Supplier AS _Supplier,
  plpo._WorkCenter AS _WorkCenter,
  plpo._WorkCenterType AS _WorkCenterType,
  plpo._OperationUnit AS _OperationUnit,
  plpo._PurchasingGroup AS _PurchasingGroup,
  plpo._OperationStandardDurationUnit AS _OperationStandardDurationUnit,
  plpo._PurchaseOrderQtyUnit AS _PurchaseOrderQtyUnit,
  plpo._MaterialGroup AS _MaterialGroup,
  plpo._MinimumDurationUnit AS _MinimumDurationUnit,
  plpo._CompanyCode AS _CompanyCode,
  plpo._FactoryCalendar AS _FactoryCalendar,
  plpo._MaintOperationExecStageCode AS _MaintOperationExecStageCode
FROM I_BillOfOperationsOpBasic AS plpo
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS plas ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillOfOperationsOpBasic AS superior 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 I_MaintenanceTaskListType AS _TaskListType ON _TaskListType.TaskListType = TaskListType  -- association [0..1]
;