I_RoutingHeaderSearchModel

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_RoutingHeaderSearchModel.
-- 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 I_RoutingHeaderSearchModel AS
SELECT
  plko.plnty AS BillOfOperationsType,
  plko.plnnr AS BillOfOperationsGroup,
  plko.plnal AS BillOfOperationsVariant,
  plko.zaehl AS BOOInternalVersionCounter,
  plko.versn AS BillOfOperationsVersion,
  plko.loekz AS IsDeleted,
  plko.loekz_inherited AS IsImplicitlyDeleted,
  case when plko.arbty = ' ' and plko.arbid <> '00000000' then 'A ' else plko.arbty end as WorkCenterTypeCode AS arbtyendasWorkCenterTypeCode,
  plko.arbid AS WorkCenterInternalID,
  plko.txtsp AS LongTextLanguageCode,
  plko.werks AS Plant,
  plko.verwe AS BillOfOperationsUsage,
  plko.statu AS BillOfOperationsStatus,
  plko.vagrp AS ResponsiblePlannerGroup,
  plko.losvn AS MinimumLotSizeQuantity,
  plko.losbs AS MaximumLotSizeQuantity,
  plko.plnme AS BillOfOperationsUnit,
  plko.plnnr_alt AS ReplacedBillOfOperations,
  plko.delkz AS IsMarkedForDeletion,
  cast (plko.qprziehver as vdm_qprziehver preserving type ) AS SmplDrawingProcedure,
  plko.qversnprzv AS SmplDrawingProcedureVersion,
  cast (plko.qdynhead as vdm_qdynhead preserving type ) AS InspectionLotDynamicLevel,
  plko.qdynregel AS InspLotDynamicRule,
  plko.qdynstring AS InspLotDynamicCriteria,
  plko.strat AS MaintenanceStrategy,
  plko.iwerk AS MaintenancePlanningPlant,
  plko.istru AS Assembly,
  plko.anlzu AS OperationSystemCondition,
  plko.adpsp AS ReferenceElement,
  plko.kokrs AS ControllingArea,
  cast(plko.pspnr as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  plko.kzkfg AS BillOfOperationIsConfigurable,
  cast(plko.tstmp_bw as tzntstmps) AS BillOfOperationsDateTime,
  cast(plko.annam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  plko.aedat AS LastChangeDate,
  cast(plko.aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  case plko.changeddatetime when 0 then cast( '19000101010101' as tzntstmps ) else plko.changeddatetime end as ChangedDateTime AS changeddatetimeendasChangedDateTime,
  cast(plko.datuv as pph_begda preserving type) AS ValidityStartDate,
  cast(plko.valid_to as pph_endda preserving type) AS ValidityEndDate,
  plko.abdat AS LastUsageDate,
  plko.abanz AS NumberOfUsages
FROM plko
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsTypeText AS _BillOfOperationsTypeText ON BillOfOperationsType = _BillOfOperationsTypeText.BillOfOperationsType AND _BillOfOperationsTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsUsage AS _BillOfOperationsUsage ON BillOfOperationsUsage = _BillOfOperationsUsage.BillOfOperationsUsage  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsStatus AS _BillOfOperationsStatus ON BillOfOperationsStatus = _BillOfOperationsStatus.BillOfOperationsStatus  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsStatusText AS _BillOfOperationsStatusText ON BillOfOperationsStatus = _BillOfOperationsStatusText.BillOfOperationsStatus AND _BillOfOperationsStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ResponsiblePlannerGroup AS _ResponsiblePlannerGroup ON ResponsiblePlannerGroup = _ResponsiblePlannerGroup.ResponsiblePlannerGroup AND Plant = _ResponsiblePlannerGroup.Plant  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BillOfOperationsUnit ON BillOfOperationsUnit = _BillOfOperationsUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_InspSubsetFieldCombination AS _InspSubsetFieldCombination ON InspSubsetFieldCombination = _InspSubsetFieldCombination.InspSubsetFieldCombination  -- association [0..1]
LEFT OUTER JOIN I_SampleDrawingProcedure AS _SampleDrawingProcedure ON SmplDrawingProcedure = _SampleDrawingProcedure.SmplDrawingProcedure  -- association [0..1]
LEFT OUTER JOIN I_SmplDrwgProcedureVersion AS _SmplDrwgProcedureVersion ON SmplDrawingProcedure = _SmplDrwgProcedureVersion.SmplDrawingProcedure AND SmplDrawingProcedureVersion = _SmplDrwgProcedureVersion.SmplDrawingProcedureVersion  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceStrategy AS _MaintenanceStrategy ON MaintenanceStrategy = _MaintenanceStrategy.MaintenanceStrategy  -- association [0..1]
LEFT OUTER JOIN I_InspectionLotDynamicLevel AS _InspectionLotDynamicLevel ON InspectionLotDynamicLevel = _InspectionLotDynamicLevel.InspectionLotDynamicLevel  -- association [0..1]
LEFT OUTER JOIN I_InspLotDynamicRule AS _InspLotDynamicRule ON InspLotDynamicRule = _InspLotDynamicRule.InspLotDynamicRule  -- association [0..1]
LEFT OUTER JOIN I_LineHierarchy AS _LineHierarchy ON LineHierarchyInternalID = _LineHierarchy.LineHierarchyInternalID AND _LineHierarchy.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_InspExtNumberingOfValues AS _InspExtNumbering ON InspExternalNumberingOfValues = _InspExtNumbering.InspExternalNumberingOfValues  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON Assembly = _Assembly.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlanningPlant ON MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationSystCondition AS _OperationSystemCondition ON OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ConfigurableIndicator ON BillOfOperationIsConfigurable = _ConfigurableIndicator.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguageCode = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_RoutingSequenceSearchModel AS _RtgSqncSrchMod ON BillOfOperationsType = _RtgSqncSrchMod.BillOfOperationsType AND BillOfOperationsGroup = _RtgSqncSrchMod.BillOfOperationsGroup AND BillOfOperationsVariant = _RtgSqncSrchMod.BillOfOperationsVariant  -- association [0..*]
LEFT OUTER JOIN I_RoutingMaterialSearchModel AS _RtgMaterialSrchMod ON BillOfOperationsType = _RtgMaterialSrchMod.BillOfOperationsType AND BillOfOperationsGroup = _RtgMaterialSrchMod.BillOfOperationsGroup AND BillOfOperationsVariant = _RtgMaterialSrchMod.BillOfOperationsVariant AND Plant = _RtgMaterialSrchMod.Plant  -- association [0..*]
LEFT OUTER JOIN P_RtgMainHeaderSrchMod AS _RtgMainHeaderSrchMod ON BillOfOperationsType = _RtgMainHeaderSrchMod.BillOfOperationsType AND BillOfOperationsGroup = _RtgMainHeaderSrchMod.BillOfOperationsGroup AND BillOfOperationsVariant = _RtgMainHeaderSrchMod.BillOfOperationsVariant  -- association [0..1]
;