I_OrderComponent

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_OrderComponent.
-- 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: IORDERCOMP

CREATE VIEW I_OrderComponent AS
SELECT
  cast(resb.rspos as pph_rspos preserving type) AS ReservationItem,
  cast(resb.rsart as pph_rsart preserving type) AS RecordType,
  case aufk.OrderCategory when '10' then case resb.plnfl when '' then '000000' else resb.plnfl end else resb.plnfl end as Sequence AS plnflendasSequence,
  cast(resb.flgat as folgenart preserving type) AS SequenceCategory,
  cast(resb.vornr as vdm_vornr preserving type) AS OrderOperation,
  cast(resb.uvorn as vdm_uvorn preserving type) AS OrderSuboperation,
  cast(resb.aufpl as pph_aufpl preserving type) AS OrderInternalID,
  cast(resb.aplzl as operationinternalid preserving type) AS OrderOperationInternalID,
  cast(aufk.Plant as pwwrk preserving type) AS ProductionPlant,
  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.rssta as pph_rssta preserving type) AS ReservationItemCreationCode,
  cast(resb.xloek as sa_loekz preserving type) AS MatlCompIsMarkedForDeletion,
  cast(resb.no_disp as vdm_no_disp preserving type) AS MaterialPlanningRelevance,
  cast(resb.sgtxt as pph_sgtxt preserving type) AS ReservationItemText,
  cast(resb.ltxsp as pph_longtextlang preserving type) AS LongTextLanguage,
  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,
  cast(resb.revlv as vdm_qm_revlv preserving type) AS MaterialRevisionLevel,
  cast(resb.stlty as pph_stlty preserving type) AS BillOfMaterialCategory,
  cast(resb.stlnr as pph_stnum preserving type) AS BillOfMaterialInternalID,
  cast(resb.stlkn as pph_stlkn preserving type) AS BOMItem,
  cast(resb.postp as pph_postp preserving type) AS BOMItemCategory,
  cast(resb.posnr as vdm_sposn preserving type) AS BillOfMaterialItemNumber,
  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,
  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 NumberOfPriceUnits,
  cast(resb.lgort as pph_lgort preserving type) AS StorageLocation,
  cast(resb.shkzg as pph_shkzg preserving type) AS DebitCreditCode,
  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,
  cast(resb.knttp as pph_knttp preserving type) AS AccountAssignmentCategory,
  cast(resb.fipos as fmis_ci_internalname preserving type) AS CommitmentItemShortID,
  cast(resb.roanz as pph_roanz preserving type) AS VariableSizeItemQuantity,
  cast(resb.romen as pph_romen preserving type) AS VariableSizeComponentQuantity,
  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,
  cast(resb.dumps as pph_dumps preserving type) AS MaterialComponentIsPhantomItem,
  cast(resb.nfeag as pph_nfeag preserving type) AS DiscontinuationGroup,
  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.nafkz as pph_nafkz preserving type) AS FollowUpMaterialIsActive,
  cast(resb.beikz as vdm_beikz preserving type) AS MaterialProvisionType,
  cast(resb.erskz as vdm_erskz preserving type) AS MatlComponentSparePartType,
  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,
  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,
  cast(resb.erfmg as pph_erfmg preserving type) AS GoodsMovementEntryQty,
  aufk.OrderCategory AS OrderCategory,
  aufk.OrderType AS OrderType,
  aufk.ObjectInternalID AS OrderObjectInternalID,
  aufk.CompanyCode AS CompanyCode,
  aufk.ControllingArea AS ControllingArea,
  resb.rsnum AS Reservation,
  resb.matkl AS MaterialGroup,
  resb.matnr AS Material,
  resb.werks AS Plant,
  resb.aufnr AS OrderID,
  resb.afpos AS OrderItem,
  resb.kzear AS ReservationIsFinallyIssued,
  resb.xfehl AS MaterialComponentIsMissing,
  resb.schgt AS IsBulkMaterialComponent,
  resb.rgekz AS MatlCompIsMarkedForBackflush,
  resb.kzkup AS MaterialIsCoProduct,
  resb.txtps AS MatlCompIsTextItem,
  resb.kfpos AS MatlCompIsConfigurable,
  resb.clakz AS MaterialComponentIsClassified,
  resb.inpos AS MaterialCompIsIntraMaterial,
  resb.potx1 AS MaterialComponentText,
  resb.potx2 AS MaterialComponentSecondText,
  resb.cuobj AS ProductConfiguration,
  resb.aennr AS ChangeNumber,
  resb.techs AS EffectivityParameterVariant,
  resb.sortf AS MatlCompFreeDefinedAttribute,
  resb.sortf AS MaterialComponentSortText,
  resb.objnr AS ObjectInternalID,
  resb.stlal AS BillOfMaterialVariant,
  resb.bom_versn AS BillOfMaterialVersion,
  resb.stpoz AS BOMItemInternalChangeCount,
  resb.stvkn AS InheritedBOMItemNode,
  resb.potx1 AS BOMItemDescription,
  resb.potx2 AS BOMItemText2,
  resb.lifnr AS Supplier,
  resb.xwaok AS GoodsMovementIsAllowed,
  resb.bwart AS GoodsMovementType,
  resb.ablad AS UnloadingPointName,
  resb.sgt_scat AS StockSegment,
  resb.sgt_rcat AS RequirementSegment,
  resb.charg AS Batch,
  resb.splkz AS BatchSplitType,
  resb.chobj AS BatchClassification,
  resb.berkz AS MaterialStaging,
  resb.lgnum AS Warehouse,
  resb.lgtyp AS StorageType,
  resb.lgpla AS StorageBin,
  resb.sanka AS MaterialCompCostingRelevancy,
  resb.gsber AS BusinessArea,
  resb.saknr AS GLAccount,
  resb.fkber AS FunctionalArea,
  resb.kblnr AS EarmarkedFundsDocument,
  resb.fipex AS CommitmentItem,
  resb.rohps AS MaterialCompIsVariableSized,
  resb.roms1 AS VariableSizeDimension1,
  resb.roms2 AS VariableSizeDimension2,
  resb.roms3 AS VariableSizeDimension3,
  resb.rform AS FormulaKey,
  resb.rform AS VariableSizeCompFormulaKey,
  resb.alpos AS MaterialCompIsAlternativeItem,
  resb.ewahr AS UsageProbabilityPercent,
  resb.original_rsnum AS OriginalReservation,
  resb.original_rspos AS OriginalReservationItem,
  resb.aufwg AS OrderPathValue,
  resb.aufst AS OrderLevelValue,
  resb.baugr AS Assembly,
  resb.bauwg AS AssemblyOrderPathValue,
  resb.baust AS AssemblyOrderLevelValue,
  resb.kzaus AS MatlCompDiscontinuationType,
  resb.fsh_critical_comp AS CriticalComponentType,
  resb.fsh_critical_level AS CriticalComponentLevel,
  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.bdmng AS RequiredQuantity,
  resb.esmng AS MaterialComponentUsageQuantity,
  resb.waers AS Currency,
  resb.enwrt AS WithdrawnQuantityAmount
FROM I_ReservationItem AS resb
INNER JOIN I_OrderBasic AS aufk ON /* join condition not captured in parsed metadata */
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 OrderID = _ManufacturingOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON OrderID = _Order.OrderID  -- association [1..1]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON OrderID = _OrderItem.OrderID AND OrderItem = _OrderItem.OrderItem  -- association [0..1]
LEFT OUTER JOIN I_OrderSequenceBySemKey AS _OrderSequence ON OrderID = _OrderSequence.OrderID AND Sequence = _OrderSequence.Sequence  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBySemKey AS _OrderOperationBySemKey ON OrderID = _OrderOperationBySemKey.OrderID AND Sequence = _OrderOperationBySemKey.Sequence AND OrderOperation = _OrderOperationBySemKey.OrderOperation  -- association [1..1]
LEFT OUTER JOIN I_OrderOperation AS _OrderOperation ON OrderInternalID = _OrderOperation.OrderInternalID AND OrderOperationInternalID = _OrderOperation.OrderOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [1..1]
LEFT OUTER JOIN I_OrderType AS _OrderType ON OrderType = _OrderType.OrderType  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_SequenceCategory AS _SequenceCategory ON SequenceCategory = _SequenceCategory.SequenceCategory  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- 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_MaterialPlant AS _MaterialPlant ON Material = _MaterialPlant.Material AND Plant = _MaterialPlant.Plant  -- 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 _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductStorageLocationBasic AS _ProductStorageLocation ON Material = _ProductStorageLocation.Product AND Plant = _ProductStorageLocation.Plant AND StorageLocation = _ProductStorageLocation.StorageLocation  -- 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_ChangeMstrObjTypeRevisionLvl AS _MaterialRevisionLevel ON MaterialRevisionLevel = _MaterialRevisionLevel.RevisionLevel AND _MaterialRevisionLevel.ChangeNumberObjectType = '41'  -- 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 BillOfMaterialInternalID = _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 _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.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 Plant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_BatchSplitType AS _BatchSplitType ON BatchSplitType = _BatchSplitType.BatchSplitType  -- association [0..1]
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_InvtrySpecialStockValnType AS _InventorySpecialStockValnType ON InventorySpecialStockValnType = _InventorySpecialStockValnType.InventorySpecialStockValnType  -- 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 _DiscontinuationType ON MatlCompDiscontinuationType = _DiscontinuationType.MatlCompDiscontinuationType  -- association [0..1]
LEFT OUTER JOIN I_MatlCompProvisionType AS _ProvisionType ON MaterialProvisionType = _ProvisionType.MaterialProvisionType  -- association [0..1]
LEFT OUTER JOIN I_MatlCompSparePartType AS _SparePartType ON MatlComponentSparePartType = _SparePartType.MatlComponentSparePartType  -- 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_EarmarkedFundsDocument AS _EarmarkedFunds ON EarmarkedFundsDocument = _EarmarkedFunds.EarmarkedFundsDocument  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFundsDocumentItem AS _EarmarkedFundsItem ON EarmarkedFundsDocument = _EarmarkedFundsItem.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _EarmarkedFundsItem.EarmarkedFundsDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON Fund = _Fund.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON CommitmentItem = _CommitmentItem.CommitmentItem  -- association [0..*]
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 _VariableSizeItemUnit ON VariableSizeItemUnit = _VariableSizeItemUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSizeComponentUnit ON VariableSizeComponentUnit = _VariableSizeComponentUnit.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 LongTextLanguage = _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]
;