I_MaintenanceOrderComponent

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_MaintenanceOrderComponent.
-- 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: IMAINTORDCOMP

CREATE VIEW I_MaintenanceOrderComponent AS
SELECT
  resb.aufnr AS MaintenanceOrder,
  resb.vornr AS MaintenanceOrderOperation,
  resb.posnr AS MaintenanceOrderComponent,
  resb.rsnum AS Reservation,
  resb.rspos AS ReservationItem,
  resb.rsart AS ReservationType,
  resb.uvorn AS MaintenanceOrderSubOperation,
  resb.matnr AS Material,
  resb.potx1 AS ComponentDescription,
  resb.bdmng AS RequirementQuantityInBaseUnit,
  resb.meins AS BaseUnit,
  resb.erfmg AS QuantityInUnitOfEntry,
  resb.erfme AS UnitOfEntry,
  resb.bdter AS RequirementDate,
  resb.bdztp AS RequirementTime,
  resb.lifnr AS Supplier,
  resb.werks AS Plant,
  resb.lgort AS StorageLocation,
  resb.aufpl AS MaintOrderRoutingNumber,
  resb.aplzl AS MaintOrderOperationCounter,
  resb.objnr AS MaintOrderComponentInternalID,
  resb.postp AS ItemCategory,
  resb.matkl AS MaterialGroup,
  where we check the system status resb.xloek as IsDeleted AS xloekasIsDeleted,
  resb.enmng AS QuantityWithdrawnInBaseUnit,
  resb.kzear AS ReservationIsFinallyIssued,
  rsdb_banfn.banfn AS PurchaseRequisition,
  rsdb_banfn.bnfpo AS PurchaseRequisitionItem,
  resb.producttype AS ProductTypeCode,
  resb.startdate AS PerformancePeriodStartDate,
  resb.enddate AS PerformancePeriodEndDate,
  resb.performanceperiodstarttime AS PerformancePeriodStartTime,
  resb.performanceperiodendtime AS PerformancePeriodEndTime,
  resb.serviceduration AS LeanServiceDuration,
  resb.servicedurationunit AS LeanServiceDurationUnit,
  resb.funct AS DistributionFunction,
  resb.operationworkcenteralignment AS SrvcSchedgIsAlignedWthOpWrkCtr,
  resb.serviceperformer AS ServicePerformer,
  resb.bwart AS GoodsMovementType,
  cast(resb.enmng as pph_enmng preserving type) AS WithdrawnQuantity,
  cast(resb.vmeng as pph_vmeng preserving type) AS ConfirmedAvailableQuantity,
  resb.shkzg AS MaintOrderCompDebitCreditCode,
  resb.fldlogssupplyprocess AS FldLogsSupplyProcess,
  resb.xwaok AS GoodsMovementIsAllowed,
  resb.charg AS MaintenanceOrderComponentBatch,
  resb.fmeng AS QuantityIsFixed,
  resb.waers AS MaintOrdOpComponentCurrency,
  resb.saknr AS MaintOrdOpComponentGLAccount,
  resb.sanka AS MaintOrdOpCompCostingRelevancy,
  resb.ewahr AS MaintCompAltvProdUsgeRateInPct,
  resb.sortf AS MaintOrderOpComponentSortText,
  resb.schgt AS MaintOrdOpCompIsBulkProduct,
  resb.beikz AS MaterialProvisionType,
  cast( resb.pspel as ps_s4_pspnr preserving type ) AS MaintOrdOpCompAssgdWBSElmntInt,
  resb.gpreis AS MaintOrderOpComponentPrice,
  resb.peinh AS MaintOrdOpCompPriceUnitQty,
  resb.rgekz AS MatlCompIsMarkedForBackflush,
  resb.ekgrp AS PurchasingGroup,
  resb.lifzt AS DeliveryTimeInDays,
  resb.wempf AS MaintOrdOpCompGdsRecipientName,
  resb.ablad AS MaintOrdOpCompUnloadingPtTxt,
  resb.webaz AS GoodsReceiptDurationInWorkDays,
  resb.infnr AS PurchasingInfoRecord,
  resb.nlfzv AS OperationLeadTimeOffset,
  resb.nlfmv AS OpsLeadTimeOffsetUnit,
  rsadd.bednr AS MaintOrdOpCompProcmtTrckgNmbr,
  rsadd.ekorg AS ResponsiblePurchaseOrg,
  resb.ebeln AS MaintOrdOpCompPurOutlineAgrmt,
  resb.ebelp AS MaintOrdCompPurOutlineAgrmtItm,
  cast( rsdb_banfn.aobar as ps_s4_aobar preserving type ) AS OrderOpRelationshipIntType,
  rsdb_banfn.zeinh AS OpRelshpOffsetDurationUnit,
  rsdb_banfn.dauer AS OpRelshpOffsetDuration,
  resb.dbskz AS MaintOrdCompIsDirectlyProcured,
  resb.sobkz AS MaintOrdOpCompSpecialStockType,
  resb.roms1 AS VariableSizeDimension1,
  resb.romei AS VariableSizeDimensionUnit,
  resb.rform AS VariableSizeCompFormulaKey,
  resb.roms2 AS VariableSizeDimension2,
  cast(resb.roanz as vdm_roanz) AS NumberOfVariableSizeItem,
  resb.roms3 AS VariableSizeDimension3,
  resb.romen AS VariableSizeItemQuantity,
  resb.rokme AS VariableSizeComponentUnit,
  resb.kzmpf AS RqmtDateIsEnteredManually,
  rsadd.idnlf AS SupplierProduct,
  rsadd.afnam AS MaintOrdOpCompRequisitioner,
  rsadd.overalllimitamount AS OverallLimitAmount,
  rsadd.expectedoveralllimitamount AS ExpectedOverallLimitAmount,
  resb.maintordcompcmtdqtyiskept AS MaintOrdCompCmtdQtyIsKept,
  rsadd.catalogid AS MaintOrdOpCompProcmtCatalog,
  rsadd.catalog_prod_id AS MaintOrdOpCompProcmtCatalogItm,
  resb.fldlogsversion AS FldLogsSupProcVersion
FROM resb
LEFT OUTER JOIN rsdb AS rsdb_banfn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN rsadd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON _MaintenanceOrderOperation.MaintenanceOrder = MaintenanceOrder AND _MaintenanceOrderOperation.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _MaintenanceOrderOperation.MaintOrderOperationCounter = MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON _MaterialGroup.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON _StorageLocation.Plant = Plant AND _StorageLocation.StorageLocation = StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON _StatusObject.StatusObject = MaintOrderComponentInternalID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_PMUnitOfMeasureVH AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = BaseUnit  -- association [0..1]
LEFT OUTER JOIN I_PMUnitOfMeasureVH AS _UnitOfMeasureEntry ON _UnitOfMeasureEntry.UnitOfMeasure = UnitOfEntry  -- association [0..1]
LEFT OUTER JOIN I_SafetyRelevance AS _SafetyRelevance ON _SafetyRelevance.SafetyRelevantObjectType = 'MA' AND _SafetyRelevance.SafetyRelevantObject = Material  -- association [0..1]
LEFT OUTER JOIN I_BomItemCategoryText AS _ItemCategoryText ON _ItemCategoryText.BillOfMaterialItemCategory = ItemCategory  -- association [0..*]
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON _PurchaseRequisitionItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseRequisitionItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ReservationIsFinallyIssued ON ReservationIsFinallyIssued = _ReservationIsFinallyIssued.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductTypeCode ON _ProductTypeCode.ProductTypeCode = ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN I_ReservationItem AS _ReservationItem ON _ReservationItem.Reservation = Reservation AND _ReservationItem.ReservationItem = ReservationItem AND _ReservationItem.RecordType = ReservationType  -- association [0..1]
LEFT OUTER JOIN I_PurReqnOrResvnGeneration AS _PurReqnOrResvnGeneration ON PurReqnOrResvnGeneration = _PurReqnOrResvnGeneration.PurReqnOrResvnGeneration  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _StatusObjectActiveStatus ON MaintOrderComponentInternalID = _StatusObjectActiveStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN I_MaintOrdCompDelivDateAdjmtT AS _MaintOrdCompDelivDateAdjmtT ON MaintOrdCompDeliveryDateAdjmt = _MaintOrdCompDelivDateAdjmtT.MaintOrdCompDeliveryDateAdjmt  -- association [0..*]
;