I_ProjectMaterialComponent

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_ProjectMaterialComponent.
-- 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: IPROJMATCOMP

CREATE VIEW I_ProjectMaterialComponent AS
SELECT
  cast (resb.rspos as ps_s4_rspos preserving type ) AS ReservationItem,
  cast(resb.aufnr as ps_s4_aufnr preserving type ) AS ProjectNetwork,
  cast (resb.bwart as bwartwa) AS GoodsMovementType,
  cast (resb.kzmpf as ps_s4_kzmpf) AS RqmtDateIsEnteredManually,
  cast (resb.sernr as ps_s4_sernr) AS ProductionSeries,
  cast (resb.nlfzv as ps_s4_cs_nlfzv) AS OperationLeadTimeOffset,
  cast (resb.nlfmv as ps_s4_cs_nlfmv) AS OperationLeadTimeOffsetUnit,
  cast (resb.potx1 as ps_s4_potx1) AS BOMItemDescription,
  cast (resb.ekgrp as ekgrp) AS PurchasingGroup,
  cast (resb.kdauf as ps_s4_kdauf) AS SalesOrder,
  cast(resb.kdpos as ps_s4_kdpos) AS SalesOrderItem,
  cast( resb.lgort as ps_s4_lgort_d preserving type ) AS StorageLocation,
  cast( NetworkActivity.WBSElementInternalID as ps_s4_pspnr) AS WBSElementInternalID,
  cast (resb.saknr as saknr) AS GLAccount,
  cast (resb.sanka as ps_s4_ck_selkz) AS MaterialCompIsCostRelevant,
  cast (resb.rgekz as rgekz) AS MatlCompIsMarkedForBackflush,
  cast (resb.schgt as schgt) AS IsBulkMaterialComponent,
  cast (resb.sobkz as sobkz) AS MaterialCompIsSpecialStock,
  cast (resb.txtps as txtps) AS MatlCompIsTextItem,
  cast (resb.xfehl as xfehl) AS MaterialComponentIsMissing,
  cast (resb.xloek as ps_s4_loevm) AS MatlCompIsMarkedForDeletion,
  cast (resb.knttp as ps_s4_knttp) AS AccountAssignmentCategory,
  cast (resb.no_disp as no_disp_plus) AS MatlCompIsRelevantForMRP,
  cast(resb.wempf as ps_s4_wempf ) AS GoodsRecipientName,
  cast (resb.xwaok as xwaok) AS GoodsMovementIsAllowed,
  cast (rsadd.changeby as ps_s4_aenam) AS LastChangedByUser,
  cast (rsadd.changedat as ps_s4_aedat) AS LastChangeDate,
  cast (rsadd.creaby as ernam) AS CreatedByUser,
  cast (rsadd.creadat as erdat) AS CreationDate,
  cast (rsadd.emlif as emlif) AS Supplier,
  cast( NetworkActivity.Project as psb_bo_pspid_de preserving type ) AS Project,
  cast ( resb.bdter as ps_s4_bdter preserving type ) AS MatlCompRequirementDate,
  cast (resb.dbskz as dbskz) AS MaterialCompIsProcuredDirectly,
  cast (resb.dumps as dumps) AS MaterialComponentIsPhantomItem,
  cast (resb.flgex as flgex) AS MatlCompIsProcuredExternally,
  cast(resb.vornr as pt_vornr_receiver preserving type ) AS NetworkActivity,
  cast (resb.waers as waers) AS Currency,
  cast (resb.flmng as ps_s4_flmng) AS ShortfallQuantity,
  cast (resb.enmng as pph_enmng ) AS WithdrawnQuantity,
  cast (resb.enmng as mmiv_quantity_received) AS ReceivedQuantity,
  cast(resb.bdmng as ps_s4_bdmng preserving type ) AS RequirementQuantityInBaseUnit,
  cast (resb.lifzt as ps_s4_lifzt) AS DeliveryDurationInDays,
  cast( resb.ablad as ps_s4_ablad preserving type ) AS UnloadingPointName,
  cast(resb.rform as ps_s4_rform preserving type ) AS FormulaKey,
  cast(resb.postp as ps_s4_postp preserving type ) AS BOMItemCategory,
  case when resb.erfme <> ' ' and resb.erfme <> resb.meins then case when resb.vmeng = resb.bdmng then case when resb.bdmng is null then resb.bdmng else resb.erfmg end else cast(resb.vmeng as abap.fltp) * ( cast(resb.umren as abap.fltp) / cast(resb.umrez as abap.fltp)) end else cast(resb.vmeng as abap.fltp) end as CommittedQuantity AS fltpendasCommittedQuantity,
  resb.bdmng - resb.enmng AS OpenQuantity,
  cast(PurReq.PurchaseRequisition as ps_s4_banfn preserving type) AS PurchaseRequisition,
  grpga.grpnr AS GroupingWBSElementInternalID,
  NetworkActivity.ProjectWithCodingMask AS ProjectWithCodingMask,
  PurReq.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurOrd.PurchaseOrder AS PurchaseOrder,
  PurOrd.PurchaseOrderItem AS PurchaseOrderItem,
  resb.rsnum AS Reservation,
  resb.rsart AS RecordType,
  resb.werks AS Plant,
  resb.matnr AS Material,
  resb.aufpl AS ProjectNetworkInternalID,
  resb.aplzl AS NetworkActivityInternalID,
  resb.stlty AS BillOfMaterialCategory,
  resb.posnr AS BillOfMaterialItemNumber,
  resb.kzbws AS InventorySpecialStockValnType,
  resb.kzvbr AS ConsumptionPosting,
  resb.lifnr AS Creditor,
  resb.meins AS BaseUnit,
  resb.objnr AS MaterialComponentObject,
  resb.kzear AS ReservationIsFinallyIssued,
  resb.lmeng AS MRPRequiredQuantityInBaseUnit,
  resb.vmeng AS ConfirmedAvailableQuantity,
  resb.gpreis AS MaterialComponentPrice,
  resb.enwrt AS WithdrawnQuantityAmount,
  resb.webaz AS GoodsReceiptDurationInDays,
  resb.peinh AS MaterialPriceUnitQty,
  resb.aennr AS ProjectObjectChangeNumber,
  resb.matkl AS MaterialGroup,
  resb.umren AS MaterialQtyToBaseQtyDnmntr,
  resb.umrez AS QuantityNumerator,
  resb.fldlogssupplyprocess AS FldLogsSupplyProcess,
  resb.fldlogsdelivisheldonshore AS FldLogsDelivIsHeldOnShore,
  resb.fldlogsversion AS FldLogsVersion,
  resb.producttype AS ProductTypeCode,
  resb.startdate AS PerformancePeriodStartDate,
  resb.enddate AS PerformancePeriodEndDate,
  resb.serviceperformer AS ServicePerformer,
  resb.serviceduration AS LeanServiceDuration,
  resb.servicedurationunit AS LeanServiceDurationUnit,
  rsadd.afnam AS RequisitionerUser,
  rsadd.fplnr AS BillingPlan,
  rsadd.overalllimitamount AS OverallLimitAmount,
  rsadd.expectedoveralllimitamount AS ExpectedOverallLimitAmount,
  _BillOfMaterial.Assembly AS BillOfMaterial,
  _BillOfMaterial.AssemblyName AS BOMHeaderText,
  _BillOfMaterial.BillOfMaterialCategory AS MaterialCompMainAssemblyCat,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  _ProjectNetwork.ControllingArea AS ControllingArea,
  _ProjMatBOMAssembly.Assembly AS Assembly,
  _ProjMatBOMAssembly.AssemblyName AS AssemblyName
FROM resb
INNER JOIN I_NetworkActivity AS NetworkActivity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN rsadd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN grpga ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Projmatcomponent01 AS PurReq ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Projmatcomponent01 AS PurOrd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElement AS _WBSGroupElement ON GroupingWBSElementInternalID = _WBSGroupElement.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlantName ON Plant = _PlantName.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivity AS _NetworkActivity ON ProjectNetwork = _NetworkActivity.ProjectNetwork AND NetworkActivity = _NetworkActivity.NetworkActivity  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON MaterialCompIsSpecialStock = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_SpecialStockValuationName AS _SpecialStockValuationName ON InventorySpecialStockValnType = _SpecialStockValuationName.InventorySpecialStockValnType  -- 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_AccAssgnmtCategory AS _AccAssgnmtCategory ON AccountAssignmentCategory = _AccAssgnmtCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BillOfMaterialItemCategory ON BOMItemCategory = _BillOfMaterialItemCategory.BillOfMaterialItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Creditor = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_ProjMatlProcurementType AS _ProjMatlProcurementType ON ProcurementType = _ProjMatlProcurementType.ProcurementType  -- association [1..1]
LEFT OUTER JOIN I_ConsumptionPostingName AS _ConsumptionPostingName ON ConsumptionPosting = _ConsumptionPostingName.ConsumptionPosting  -- association [1..1]
LEFT OUTER JOIN I_ProjMatBomCategory AS _ProjMatBomCategory ON BillOfMaterialCategory = _ProjMatBomCategory.BillOfMaterialCategory  -- association [0..1]
LEFT OUTER JOIN I_ProjMatBomCategory AS _BillOfMaterialCategory ON MaterialCompMainAssemblyCat = _BillOfMaterialCategory.BillOfMaterialCategory  -- association [0..1]
LEFT OUTER JOIN P_ProjMatBOMAssembly AS _ProjMatBOMAssembly ON resb.stlty = _ProjMatBOMAssembly.BillOfMaterialCategory AND resb.stlnr = _ProjMatBOMAssembly.BillOfMaterial AND resb.stlal = _ProjMatBOMAssembly.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN P_ProjMatBOMAssembly AS _BillOfMaterial ON ( rsadd.bstln = _BillOfMaterial.BillOfMaterial AND rsadd.bstlt = _BillOfMaterial.BillOfMaterialCategory ) OR( rsadd.bstln = _BillOfMaterial.BillOfMaterial )  -- association [0..1]
LEFT OUTER JOIN E_ProjectMaterialComponent AS _Extension ON resb.rsnum = _Extension.Reservation AND resb.rspos = _Extension.ReservationItem AND resb.rsart = _Extension.RecordType  -- association [1..1]
;