P_ProdnRoutingOpSubordOpDEX

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 P_ProdnRoutingOpSubordOpDEX.
-- 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 P_ProdnRoutingOpSubordOpDEX AS
SELECT
  plnty AS BillOfOperationsType,
  plnnr AS ProductionRoutingGroup,
  plnkn AS ProductionRoutingOpIntID,
  zaehl AS ProductionRoutingOpIntVersion,
  versn AS BillOfOperationsVersion,
  arbid AS WorkCenterInternalID,
  loekz AS IsDeleted,
  loekz_inherited AS IsImplicitlyDeleted,
  sumnr AS SuperiorOperationInternalID,
  vintv AS BOORefOperationIncrementValue,
  oprid AS OperationExternalID,
  cast(vornr as vdm_vornr preserving type) AS Operation,
  txtsp AS LongTextLanguageCode,
  werks AS Plant,
  steus AS OperationControlProfile,
  ktsch AS OperationStandardTextCode,
  cast (vplnr as billofoperationsrefgroup preserving type) AS BillOfOperationsRefGroup,
  cast (vplal as billofoperationsrefvariant preserving type) AS BillOfOperationsRefVariant,
  uavo_aufl AS OrderHasNoSubOperations,
  meinh AS OperationUnit,
  umrez AS OpQtyToBaseQtyNmrtr,
  umren AS OpQtyToBaseQtyDnmntr,
  zmerh AS BillOfOperationsBreakDuration,
  zeier AS BillOfOperationsBreakDurnUnit,
  vgw01 AS StandardWorkQuantity1,
  vge01 AS StandardWorkQuantityUnit1,
  lar01 AS CostCtrActivityType1,
  zgr01 AS PerfEfficiencyRatioCode1,
  vgw02 AS StandardWorkQuantity2,
  vge02 AS StandardWorkQuantityUnit2,
  lar02 AS CostCtrActivityType2,
  zgr02 AS PerfEfficiencyRatioCode2,
  vgw03 AS StandardWorkQuantity3,
  vge03 AS StandardWorkQuantityUnit3,
  lar03 AS CostCtrActivityType3,
  zgr03 AS PerfEfficiencyRatioCode3,
  vgw04 AS StandardWorkQuantity4,
  vge04 AS StandardWorkQuantityUnit4,
  lar04 AS CostCtrActivityType4,
  zgr04 AS PerfEfficiencyRatioCode4,
  vgw05 AS StandardWorkQuantity5,
  vge05 AS StandardWorkQuantityUnit5,
  lar05 AS CostCtrActivityType5,
  zgr05 AS PerfEfficiencyRatioCode5,
  vgw06 AS StandardWorkQuantity6,
  vge06 AS StandardWorkQuantityUnit6,
  lar06 AS CostCtrActivityType6,
  zgr06 AS PerfEfficiencyRatioCode6,
  prz01 AS BusinessProcess,
  ablipkz AS TeardownAndWaitIsParallel,
  zlmax AS MaximumWaitDuration,
  zeilm AS MaximumWaitDurationUnit,
  zlpro AS MinimumWaitDuration,
  zeilp AS MinimumWaitDurationUnit,
  zwnor AS StandardQueueDuration,
  zeiwn AS StandardQueueDurationUnit,
  zwmin AS MinimumQueueDuration,
  zeiwm AS MinimumQueueDurationUnit,
  ztnor AS StandardMoveDuration,
  zeitn AS StandardMoveDurationUnit,
  ztmin AS MinimumMoveDuration,
  zeitm AS MinimumMoveDurationUnit,
  cast (splim as maximumnumberofsplits preserving type) AS MaximumNumberOfSplits,
  zminb AS MinProcessingDurationPerSplit,
  zeimb AS MinProcessingDurnPerSplitUnit,
  cast (uekan as operationoverlappingispossible preserving type) AS OperationOverlappingIsPossible,
  flies AS OperationsIsAlwaysOverlapping,
  zminu AS OverlapMinimumDuration,
  zeimu AS OverlapMinimumDurationUnit,
  minwe AS OverlapMinimumTransferQty,
  meinh AS OverlapMinimumTransferQtyUnit,
  offstb AS StartDateOffsetDuration,
  ehoffe AS EndDateOffsetDurationUnit,
  offste AS EndDateOffsetDuration,
  loanz AS NumberOfTimeTickets,
  rsanz AS NumberOfConfirmationSlips,
  logrp AS EmployeeWageGroup,
  loart AS EmployeeWageType,
  qualf AS EmployeeSuitability,
  anzma AS NumberOfEmployees,
  rasch AS OperationSetupType,
  rfgrp AS OperationSetupGroupCategory,
  rfsch AS OperationSetupGroup,
  cast (ckselkz as operationcostingrelevancytype preserving type) AS OperationCostingRelevancyType,
  nvadd AS IsNonValueAddedOperation,
  infnr AS PurchasingInfoRecord,
  ekorg AS PurchasingOrganization,
  ebeln AS PurchaseContract,
  ebelp AS PurchaseContractItem,
  sortl AS PurchasingInfoRecdAddlGrpgName,
  matkl AS MaterialGroup,
  ekgrp AS PurchasingGroup,
  lifnr AS Supplier,
  plifz AS PlannedDeliveryDuration,
  peinh AS NumberOfOperationPriceUnits,
  preis AS OpExternalProcessingPrice,
  qpart AS InspectionLotType,
  sakto AS CostElement,
  waers AS OpExternalProcessingCurrency,
  qlkapar AS CapacityCategoryCode,
  phflg AS BOOOperationIsPhase,
  pvzkn AS BOOPhaseSuperiorOpInternalID,
  phseq AS ControlRecipeDestination,
  daumi AS MinimumDuration,
  daume AS MinimumDurationUnit,
  prznt AS OperationWorkPercent,
  vertl AS CapRqmtsDistributionFunction,
  bukrs AS CompanyCode,
  kalid AS FactoryCalendar,
  vertn AS CapacityRequirementDistrKey,
  qkzprfrei AS InspSbstHasNoTimeOrQuantity,
  plpo.dauno AS OperationStandardDuration,
  plpo.daune AS OperationStandardDurationUnit,
  plpo.anzzl AS NumberOfCapacities,
  plpo.anlzu AS OperationSystemCondition,
  plpo.larnt AS CostCtrActivityType,
  plpo.indet AS OperationCalculationControl,
  plpo.istru AS Assembly,
  plpo.bmvrg AS PurchaseOrderQty,
  plpo.bmeih AS PurchaseOrderQuantityUnit,
  plpo.esokz AS PurchasingInfoRecordCategory,
  plpo.tplnr AS FunctionalLocation,
  plpo.equnr AS Equipment,
  slwid AS FreeDefinedTableFieldSemantic,
  usr00 AS FreeDefinedAttribute01,
  usr01 AS FreeDefinedAttribute02,
  usr02 AS FreeDefinedAttribute03,
  usr03 AS FreeDefinedAttribute04,
  usr04 AS FreeDefinedQuantity1,
  use04 AS FreeDefinedQuantity1Unit,
  usr05 AS FreeDefinedQuantity2,
  use05 AS FreeDefinedQuantity2Unit,
  usr06 AS FreeDefinedAmount1,
  use06 AS FreeDefinedAmount1Currency,
  usr07 AS FreeDefinedAmount2,
  use07 AS FreeDefinedAmount2Currency,
  usr08 AS FreeDefinedDate1,
  usr09 AS FreeDefinedDate2,
  usr10 AS FreeDefinedIndicator1,
  usr11 AS FreeDefinedIndicator2,
  cast( plpo.execution_stage as eam_premainpost_cds preserving type ) AS MaintOperationExecStageCode,
  cast (annam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  aedat AS LastChangeDate,
  cast (aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  cast(datuv as pph_begda preserving type) AS ValidityStartDate,
  cast(valid_to as pph_endda preserving type) AS ValidityEndDate,
  arbei AS OpPlannedWorkQuantity,
  arbeh AS OpWorkQuantityUnit
FROM plpo
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND ProductionRoutingGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BOOOperationInternalID AS _BOOOperationInternalID ON BillOfOperationsType = _BOOOperationInternalID.BillOfOperationsType AND ProductionRoutingGroup = _BOOOperationInternalID.BillOfOperationsGroup AND ProductionRoutingOpIntID = _BOOOperationInternalID.BOOOperationInternalID  -- association [1..1]
;