I_PlannedOrderComponent

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_PlannedOrderComponent.
-- 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: IPPPLNDORDCOMP

CREATE VIEW I_PlannedOrderComponent 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,
  plaf.PlannedOrder AS PlannedOrder,
  plaf.PlannedOrderType AS PlannedOrderType,
  cast(resb.bdter as pph_bdter preserving type) AS MatlCompRequirementDate,
  cast(resb.bdztp as pph_bdztp preserving type) AS MatlCompRequirementTime,
  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,
  resb.kfpos AS MatlCompIsConfigurable,
  cast(resb.bdart as pph_bdart preserving type) AS RequirementType,
  resb.matkl AS MaterialGroup,
  resb.matnr AS Material,
  resb.werks AS Plant,
  plaf.MRPArea AS MRPArea,
  plaf.MRPController AS MRPController,
  plaf.ProductionSupervisor AS ProductionSupervisor,
  plaf.ProductionVersion AS ProductionVersion,
  cast(resb.kdauf as co_kdauf preserving type) AS SalesOrder,
  cast(resb.kdpos as co_kdpos preserving type) AS SalesOrderItem,
  cast(resb.pspel as pph_pspel preserving type) AS WBSElementInternalID,
  cast(resb.pspel as ps_s4_pspnr preserving type) AS WBSElementInternalID_2,
  resb.cuobj AS ProductConfiguration,
  cast(resb.aennr as changenumber preserving type) AS ChangeNumber,
  resb.sortf AS SortField,
  resb.sortf AS MatlCompFreeDefinedAttribute,
  cast(resb.revlv as vdm_qm_revlv preserving type) AS MaterialRevisionLevel,
  cast(resb.no_disp as vdm_no_disp preserving type) AS MaterialPlanningRelevance,
  cast(resb.stlty as pph_stlty preserving type) AS BillOfMaterialCategory,
  resb.stlnr AS BillOfMaterialInternalID,
  cast(resb.stlnr as pph_stnum preserving type) AS BillOfMaterialInternalID_2,
  resb.stlal AS BillOfMaterialVariant,
  cast(resb.stlkn as pph_stlkn preserving type) AS BOMItem,
  resb.stpoz AS BOMItemInternalChangeCount,
  cast(resb.postp as pph_postp preserving type) AS BOMItemCategory,
  resb.posnr AS BillOfMaterialItemNumber,
  cast(resb.posnr as vdm_sposn preserving type) AS BillOfMaterialItemNumber_2,
  resb.potx1 AS BOMItemDescription,
  resb.potx2 AS BOMItemText2,
  cast(resb.sernr as pph_sernr preserving type) AS BOMExplosion,
  cast(resb.ekgrp as pph_ekgrp preserving type) AS PurchasingGroup,
  resb.lifnr AS Supplier,
  cast(resb.lifzt as pph_lifzt preserving type) AS DeliveryDurationInDays,
  resb.xwaok AS GoodsMovementIsAllowed,
  cast(resb.lgort as pph_lgort preserving type) AS StorageLocation,
  resb.charg AS Batch,
  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,
  resb.berkz AS MaterialStaging,
  resb.lgnum AS Warehouse,
  resb.lgtyp AS StorageType,
  resb.lgpla AS StorageBin,
  resb.gsber AS BusinessArea,
  resb.saknr AS GLAccount,
  cast(resb.knttp as pph_knttp preserving type) AS AccountAssignmentCategory,
  cast(resb.fipos as bbpfipos preserving type) AS CommitmentItem,
  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.roanz as vdm_roanz) AS NumberOfVariableSizeComponents,
  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
FROM resb
INNER JOIN I_PlannedOrder AS plaf 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_PlannedOrderType AS _PlannedOrderType ON PlannedOrderType = _PlannedOrderType.PlannedOrderType  -- 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_ProductUnitsOfMeasure AS _ProductUnitsOfMeasure ON Material = _ProductUnitsOfMeasure.Product  -- association [1..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.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_ProductStorageLocation AS _ProductStorageLocation ON Material = _ProductStorageLocation.Product AND Plant = _ProductStorageLocation.Plant AND StorageLocation = _ProductStorageLocation.StorageLocation  -- association [0..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_ProductPlantMRP AS _ProductPlantMRPArea ON Material = _ProductPlantMRPArea.Product AND Plant = _ProductPlantMRPArea.Plant AND MRPArea = _ProductPlantMRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- 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_ProductionVersion AS _ProductionVersion ON Material = _ProductionVersion.Material AND Plant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- 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_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasic ON WBSElementInternalID_2 = _WBSElementBasic.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_BOMExplosionDate AS _BOMExplosion ON BOMExplosion = _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_BillOfMaterialItemBasic AS _BillOfMaterialItemBasic ON BillOfMaterialCategory = _BillOfMaterialItemBasic.BillOfMaterialCategory AND BillOfMaterialInternalID_2 = _BillOfMaterialItemBasic.BillOfMaterial AND BOMItem = _BillOfMaterialItemBasic.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemBasic.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_PurchaseRequisition_Api01 AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- 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_Batch AS _Batch_2 ON Material = _Batch_2.Material AND Plant = _Batch_2.Plant AND Batch = _Batch_2.Batch  -- 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 [1..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_MatlCompDiscontinuationType AS _MatlCompDiscontinuationType ON MatlCompDiscontinuationType = _MatlCompDiscontinuationType.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_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- 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_Product AS _Assembly ON Assembly = _Assembly.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _FollowUpMaterial ON FollowUpMaterial = _FollowUpMaterial.Product  -- 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_UnitOfMeasure AS _OpLeadTimeOffsetUnit ON OperationLeadTimeOffsetUnit = _OpLeadTimeOffsetUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_PlannedOrder AS _PlannedOrder ON PlannedOrder = _PlannedOrder.PlannedOrder  -- association [1..1]
LEFT OUTER JOIN E_ReservationDocumentItem AS _Extension ON Reservation = _Extension.Reservation AND ReservationItem = _Extension.ReservationItem AND RecordType = _Extension.RecordType  -- association [1..1]
;