I_ProcOrdMgmtOpCompBasic

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_ProcOrdMgmtOpCompBasic.
-- 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: IPOROPCOMPBSC

CREATE VIEW I_ProcOrdMgmtOpCompBasic AS
SELECT
  resb.rsnum AS Reservation,
  cast(resb.rspos as pph_rspos preserving type) AS ReservationItem,
  cast(resb.rsart as pph_rsart preserving type) AS RecordType,
  resb.matkl AS MaterialGroup,
  resb.matnr AS Material,
  resb.werks AS Plant,
  cast(resb.autyp as manufacturingordercategory preserving type) AS ManufacturingOrderCategory,
  cast(resb.auart as manufacturingordertype preserving type) AS ManufacturingOrderType,
  cast(resb.aufnr as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(resb.flgat as folgenart preserving type) AS MfgOrderSequenceCategory,
  cast(resb.vornr as text4 preserving type) AS ManufacturingOrderOperation,
  cast(resb.pwerk as pwwrk preserving type) AS ProductionPlant,
  cast(resb.aufpl as pph_aufpl preserving type) AS OrderInternalBillOfOperations,
  cast(resb.aplzl as operationinternalid preserving type) AS OrderIntBillOfOperationsItem,
  cast(resb.dispo as assymrpcontrl preserving type) AS AssemblyMRPController,
  cast(resb.fevor as pph_fevor preserving type) AS ProductionSupervisor,
  cast(resb.bdter as pph_bdter preserving type) AS MatlCompRequirementDate,
  cast(resb.bdztp as pph_bdztp preserving type) AS MatlCompRequirementTime,
  cast(resb.sbter as pph_sbter preserving type) AS LatestRequirementDate,
  cast(resb.ftrmi as mfgorderactualreleasedate preserving type) AS MfgOrderActualReleaseDate,
  cast(resb.rssta as pph_rssta preserving type) AS ReservationItemCreationCode,
  resb.kzear AS ReservationIsFinallyIssued,
  cast(resb.xloek as pph_xloek preserving type) AS MatlCompIsMarkedForDeletion,
  resb.xfehl AS MaterialComponentIsMissing,
  resb.schgt AS IsBulkMaterialComponent,
  resb.rgekz AS MatlCompIsMarkedForBackflush,
  resb.txtps AS MatlCompIsTextItem,
  cast(resb.beikz as vdm_beikz preserving type) AS MaterialProvisionType,
  cast(resb.no_disp as vdm_no_disp preserving type) AS MaterialPlanningRelevance,
  resb.kfpos AS MatlCompIsConfigurable,
  resb.clakz AS MaterialComponentIsClassified,
  resb.inpos AS MaterialCompIsIntraMaterial,
  resb.ltxsp AS LongTextLanguageCode,
  cast(resb.bdart as pph_bdart preserving type) AS RequirementType,
  cast(resb.kdauf as co_kdauf preserving type) AS SalesOrder,
  cast(resb.kdpos as co_kdpos preserving type) AS SalesOrderItem,
  cast(resb.pspel as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  resb.cuobj AS ProductConfiguration,
  resb.aennr AS ChangeNumber,
  resb.techs AS EffectivityParameterVariant,
  cast(resb.stlty as pph_stlty preserving type) AS BillOfMaterialCategory,
  cast ( resb.stlnr as pph_stnum preserving type ) AS BillOfMaterialInternalID,
  resb.stlan AS BillOfMaterialVariantUsage,
  resb.stlal AS BillOfMaterialVariant,
  cast ( resb.stlnr2 as pph_stnum preserving type ) AS BillOfMaterial,
  cast(resb.stlkn as pph_stlkn preserving type) AS BOMItem,
  resb.bom_versn AS BillOfMaterialVersion,
  resb.stpoz AS BOMItemInternalChangeCount,
  resb.stvkn AS InheritedBOMItemNode,
  cast(resb.postp as pph_postp preserving type) AS BOMItemCategory,
  cast ( resb.posnr as pph_sposn preserving type ) AS BillOfMaterialItemNumber,
  resb.potx1 AS BOMItemDescription,
  resb.potx2 AS BOMItemText2,
  cast(resb.sernr as pph_sernr preserving type) AS BOMExplosionDateID,
  cast(resb.infnr as pph_infnr preserving type) AS PurchasingInfoRecord,
  cast(resb.ekgrp as pph_ekgrp preserving type) AS PurchasingGroup,
  resb.lifnr AS Supplier,
  cast(resb.lifzt as pph_lifzt preserving type) AS DeliveryDurationInDays,
  cast(resb.webaz as pph_webaz preserving type) AS MaterialGoodsReceiptDuration,
  cast(resb.peinh as pph_peinh preserving type) AS NumberOfOperationPriceUnits,
  resb.xwaok AS GoodsMovementIsAllowed,
  cast(resb.lgort as pph_lgort preserving type) AS StorageLocation,
  resb.charg AS Batch,
  resb.splkz AS BatchSplitType,
  cast(resb.shkzg as pph_shkzg preserving type) AS DebitCreditCode,
  resb.bwart AS GoodsMovementType,
  cast(resb.sobkz as inventoryspecialstocktype preserving type) AS InventorySpecialStockType,
  cast(resb.kzbws as pph_kzbws preserving type) AS InventorySpecialStockValnType,
  cast(resb.kzvbr as pph_kzvbr preserving type) AS ConsumptionPosting,
  cast(resb.prvbe as pph_prvbe preserving type) AS SupplyArea,
  cast(resb.wempf as pph_wempf preserving type) AS GoodsRecipientName,
  resb.ablad AS UnloadingPointName,
  resb.sgt_scat AS StockSegment,
  resb.sgt_rcat AS RequirementSegment,
  resb.lgnum AS Warehouse,
  resb.lgtyp AS StorageType,
  resb.lgpla AS StorageBin,
  resb.sanka AS MaterialCompIsCostRelevant,
  resb.gsber AS BusinessArea,
  resb.bukrs AS CompanyCode,
  resb.saknr AS GLAccount,
  resb.fkber AS FunctionalArea,
  resb.kokrs AS ControllingArea,
  cast(resb.knttp as pph_knttp preserving type) AS AccountAssignmentCategory,
  cast(resb.fipos as fmis_ci_internalname preserving type) AS CommitmentItemShortID,
  cast(resb.fistl as bbpfistl preserving type) AS FundsCenter,
  resb.rohps AS MaterialCompIsVariableSized,
  cast(resb.rokme as pph_rokme preserving type) AS VariableSizeComponentUnit,
  cast(resb.romen as pph_romen preserving type) AS VariableSizeComponentQuantity,
  resb.romei AS VariableSizeDimensionUnit,
  resb.roms1 AS VariableSizeDimension1,
  resb.roms2 AS VariableSizeDimension2,
  resb.roms3 AS VariableSizeDimension3,
  resb.rform AS FormulaKey,
  resb.alpos AS MaterialCompIsAlternativeItem,
  cast(resb.alpgr as pph_alpgr preserving type) AS AlternativeItemGroup,
  cast(resb.alpst as pph_alpst preserving type) AS AlternativeItemStrategy,
  cast(resb.alprf as pph_alprf preserving type) AS AlternativeItemPriority,
  resb.ewahr AS UsageProbabilityPercent,
  cast(resb.dumps as pph_dumps preserving type) AS MaterialComponentIsPhantomItem,
  resb.aufwg AS OrderPathValue,
  resb.aufst AS OrderLevelValue,
  resb.baugr AS Assembly,
  resb.bauwg AS AssemblyOrderPathValue,
  resb.baust AS AssemblyOrderLevelValue,
  cast(resb.nfeag as pph_nfeag preserving type) AS DiscontinuationGroup,
  resb.kzaus AS MatlCompDiscontinuationType,
  cast(resb.nfpkz as pph_kznfp preserving type) AS MatlCompIsFollowUpMaterial,
  cast(resb.nfgrp as pph_nfgrp preserving type) AS FollowUpGroup,
  cast(resb.nomat as pph_nomat preserving type) AS FollowUpMaterial,
  cast(resb.nafkz as pph_nafkz preserving type) AS FollowUpMaterialIsNotActive,
  cast(resb.nlfzt as pph_nlfzt preserving type) AS LeadTimeOffset,
  cast(resb.nlfmv as pph_nlfmv preserving type) AS OperationLeadTimeOffsetUnit,
  cast(resb.nlfzv as pph_nlfzv preserving type) AS OperationLeadTimeOffset,
  resb.fmeng AS QuantityIsFixed,
  resb.netau AS IsNetScrap,
  resb.ausch AS ComponentScrapInPercent,
  resb.avoau AS OperationScrapInPercent,
  resb.umrez AS MaterialQtyToBaseQtyNmrtr,
  resb.umren AS MaterialQtyToBaseQtyDnmntr,
  resb.meins AS BaseUnit,
  resb.bdmng AS RequiredQuantity,
  cast(resb.enmng as pph_enmng preserving type) AS WithdrawnQuantity,
  cast(resb.vmeng as pph_vmeng preserving type) AS ConfirmedAvailableQuantity,
  cast(resb.nomng as pph_nomng preserving type) AS MaterialCompOriginalQuantity,
  resb.erfme AS EntryUnit,
  cast(resb.erfmg as pph_erfmg preserving type) AS GoodsMovementEntryQty,
  resb.waers AS Currency,
  resb.enwrt AS WithdrawnQuantityAmount,
  fsh_critical_comp AS CriticalComponentType,
  fsh_critical_level AS CriticalComponentLevel,
  resb.splrv AS LeadingReservationItem,
  _ManufacturingOrder.ObjectInternalID AS ObjectInternalID,
  case when resb.kzkup <> '' then 'X' end as IsCoProduct AS kzkupthenXendasIsCoProduct
FROM P_ProcOrdOpReservationItem AS resb
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocumentItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem AND RecordType = _ReservationItem.RecordType  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocRecordType AS _ReservationDocRecordType ON RecordType = _ReservationDocRecordType.RecordType  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_SequenceCategory AS _MfgOrderSequenceCategory ON MfgOrderSequenceCategory = _MfgOrderSequenceCategory.SequenceCategory  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderOperationBasic AS _MfgOrderOperation ON OrderInternalBillOfOperations = _MfgOrderOperation.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _MfgOrderOperation.OrderIntBillOfOperationsItem  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemanKey AS _MfgOrderOpBySemanticKey ON ManufacturingOrder = _MfgOrderOpBySemanticKey.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOpBySemanticKey.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOpBySemanticKey.ManufacturingOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_MaterialRequirementType AS _RequirementType ON RequirementType = _RequirementType.RequirementType  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant2 ON Material = _ProductPlant2.Product AND Plant = _ProductPlant2.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProductSupplyPlanning ON Material = _ProductSupplyPlanning.Product AND Plant = _ProductSupplyPlanning.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductStorageLocationBasic AS _ProductStorageLocation2 ON Material = _ProductStorageLocation2.Product AND Plant = _ProductStorageLocation2.Plant AND StorageLocation = _ProductStorageLocation2.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _ProductUnitsOfMeasure ON Material = _ProductUnitsOfMeasure.Product  -- association [1..*]
LEFT OUTER JOIN I_MRPController AS _AssemblyMRPController ON Plant = _AssemblyMRPController.Plant AND AssemblyMRPController = _AssemblyMRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON Plant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_BOMExplosionDate AS _BOMExplosion ON BOMExplosionDateID = _BOMExplosion.BOMExplosionDateID  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemBasic AS _BillOfMaterialItem ON BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterial = _BillOfMaterialItem.BillOfMaterial AND BOMItem = _BillOfMaterialItem.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItem.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BOMItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingInfoRecordApi01 AS _PurchasingInfoRecord ON PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemAPI01 AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisition AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisitionItemAPI01 AS _PurchaseRequisitionItem2 ON PurchaseRequisition = _PurchaseRequisitionItem2.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem2.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON Plant = _SupplierCompanyByPlant.Plant AND Supplier = _SupplierCompanyByPlant.Supplier  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..*]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [1..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_ConsumptionPosting AS _ConsumptionPosting ON ConsumptionPosting = _ConsumptionPosting.ConsumptionPosting  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _SupplyArea ON Plant = _SupplyArea.Plant AND SupplyArea = _SupplyArea.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN I_Warehouse AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_Product AS _PhantomAssembly ON Assembly = _PhantomAssembly.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _FollowUpMaterial ON FollowUpMaterial = _FollowUpMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_MatlCompDiscontinuationType AS _MatlCompDiscontinuationType ON MatlCompDiscontinuationType = _MatlCompDiscontinuationType.MatlCompDiscontinuationType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemShortID AS _CommitmentItemShortID ON CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OpLeadTimeOffsetUnit ON OperationLeadTimeOffsetUnit = _OpLeadTimeOffsetUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSizeCompUnit ON VariableSizeComponentUnit = _VariableSizeCompUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EntryUnit ON EntryUnit = _EntryUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguageCode = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_OrderComponentLongText AS _LongText ON Reservation = _LongText.Reservation AND ReservationItem = _LongText.ReservationItem AND RecordType = _LongText.RecordType  -- association [0..1]
;