R_MaintOrderOpComponentTP

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 R_MaintOrderOpComponentTP.
-- 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 R_MaintOrderOpComponentTP AS
SELECT
  MaintenanceOrder,
  cast( MaintenanceOrderOperation as maintenanceorderoperation preserving type ) AS MaintenanceOrderOperation,
  cast( MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) AS MaintenanceOrderSubOperation,
  cast( MaintenanceOrderComponent as maintenanceordercomponent preserving type ) AS MaintenanceOrderComponent,
  cast( MaintenanceOrderOperation as maintenanceorderoperation preserving type ) AS MaintOrderOperationForEdit,
  cast( MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) AS MaintOrderSubOperationForEdit,
  cast( MaintenanceOrderComponent as maintenanceordercomponent preserving type ) AS MaintOrderComponentForEdit,
  Reservation,
  ReservationItem,
  ReservationType,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  Material AS Product,
  BaseUnit,
  UnitOfEntry,
  case RequirementTime when '240000' then tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( RequirementDate, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_dats( dats_tims_to_tstmp(RequirementDate, RequirementTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as RequirementDate AS clientNULLendasRequirementDate,
  case RequirementTime when '240000' then tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( RequirementDate, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_tims( dats_tims_to_tstmp(RequirementDate, RequirementTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as RequirementTime AS clientNULLendasRequirementTime,
  Plant,
  StorageLocation,
  ItemCategory AS MaintOrdOpCompItemCategory,
  GoodsMovementType,
  ReservationIsFinallyIssued,
  case when PurchaseRequisition is null or PurchaseRequisition is initial then MaterialGroup else _PurchaseRequisitionItem.MaterialGroup end as MaterialGroup AS MaterialGroupendasMaterialGroup,
  PurReqnOrResvnGeneration AS MaintOrdOpCompIsMRPRelevant,
  MaterialCompIsProcuredDirectly,
  ProductTypeCode,
  ServicePerformer,
  case PerformancePeriodEndTime when '240000' then tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( PerformancePeriodEndDate, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_dats( dats_tims_to_tstmp(PerformancePeriodEndDate, PerformancePeriodEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as PerformancePeriodEndDate AS clientNULLendasPerformancePeriodEndDate,
  case PerformancePeriodEndTime when '240000' then tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( PerformancePeriodEndDate, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_tims( dats_tims_to_tstmp(PerformancePeriodEndDate, PerformancePeriodEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as PerformancePeriodEndTime AS clientNULLendasPerformancePeriodEndTime,
  LeanServiceDuration,
  LeanServiceDurationUnit,
  DistributionFunction,
  MaintOrdCompDeliveryDateAdjmt,
  SrvcSchedgIsAlignedWthOpWrkCtr,
  MaintOrderCompDebitCreditCode,
  GoodsMovementIsAllowed,
  MaintenanceOrderComponentBatch,
  MaintOrderComponentInternalID,
  QuantityIsFixed,
  MaintOrdOpComponentCurrency,
  MaintOrdOpComponentGLAccount,
  MaintOrdOpCompCostingRelevancy,
  MaintCompAltvProdUsgeRateInPct,
  MaintOrderOpComponentSortText,
  MaintOrdOpCompIsBulkProduct,
  MaterialProvisionType,
  MaintOrdOpCompAssgdWBSElmntInt,
  cast ( _WBSElement.WBSElement as vdm_ps_posid preserving type ) AS WBSElement,
  MaintOrderOpComponentPrice,
  MaintOrdOpCompPriceUnitQty,
  MatlCompIsMarkedForBackflush,
  PurchasingGroup,
  DeliveryTimeInDays,
  MaintOrdOpCompGdsRecipientName,
  MaintOrdOpCompUnloadingPtTxt,
  GoodsReceiptDurationInWorkDays,
  PurchasingInfoRecord,
  OperationLeadTimeOffset,
  OpsLeadTimeOffsetUnit,
  MaintOrdOpCompRequisitioner,
  MaintOrdOpCompProcmtTrckgNmbr,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  OverallLimitAmount,
  ExpectedOverallLimitAmount,
  MaintOrdOpCompSpecialStockType,
  VariableSizeDimension1,
  VariableSizeDimensionUnit,
  VariableSizeCompFormulaKey,
  VariableSizeDimension2,
  NumberOfVariableSizeItem,
  VariableSizeDimension3,
  VariableSizeItemQuantity,
  VariableSizeComponentUnit,
  RqmtDateIsEnteredManually,
  SupplierProduct,
  MaintOrdCompCmtdQtyIsKept,
  MaintOrdOpCompPurOutlineAgrmt,
  MaintOrdCompPurOutlineAgrmtItm,
  IsDeleted,
  MaintOrdOpCompProcmtCatalog,
  MaintOrdOpCompProcmtCatalogItm,
  QuantityWithdrawnInBaseUnit,
  ConfirmedAvailableQuantity,
  _ReservationItem.RecipientLocationCode AS RecipientLocationCode,
  _MaintenanceOrder.ControllingArea AS ControllingArea
FROM I_MaintenanceOrderComponent
LEFT OUTER JOIN R_MaintenanceOrderTP AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = MaintOrdOpCompAssgdWBSElmntInt  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON _MaterialGroup.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = ResponsiblePurchaseOrg  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN R_MaintOrderOpCompLongTextTP AS _MaintOrderOpCompLongText ON /* condition not available in parsed metadata */  -- association [0..*]
;