I_ProjMatCompVersBasicData

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_ProjMatCompVersBasicData.
-- 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: IPRMATCOMVERSBD

CREATE VIEW I_ProjMatCompVersBasicData AS
SELECT
  vsresb_cn.rsnum AS Reservation,
  cast (vsresb_cn.rspos as ps_s4_rspos preserving type ) AS ReservationItem,
  vsresb_cn.rsart AS RecordType,
  vsresb_cn.vsnmr AS Version,
  vsresb_cn.matnr AS Material,
  cast ( vsresb_cn.bdter as ps_s4_bdter preserving type ) AS MatlCompRequirementDate,
  cast (vsresb_cn.lifzt as ps_s4_lifzt) AS DeliveryDurationInDays,
  vsresb_cn.webaz AS GoodsReceiptDurationInDays,
  cast (vsresb_cn.waers as waers) AS Currency,
  vsresb_cn.werks AS Plant,
  cast( vsresb_cn.posnr as char4 preserving type ) AS BillOfMaterialItemNumber,
  vsresb_cn.objnr AS MaterialComponentObject,
  vsresb_cn.aufpl AS ProjectNetworkInternalID,
  vsresb_cn.aplzl AS NetworkActivityInternalID,
  cast (vsresb_cn.bwart as bwartwa) AS GoodsMovementType,
  cast (vsresb_cn.xfehl as xfehl) AS MaterialComponentIsMissing,
  vsresb_cn.bdmng - vsresb_cn.enmng AS OpenQuantity,
  cast(vsresb_cn.bdmng as ps_s4_bdmng preserving type ) AS RequirementQuantityInBaseUnit,
  cast (vsresb_cn.enmng as pph_enmng ) AS WithdrawnQuantity,
  case when vsresb_cn.erfme <> ' ' and vsresb_cn.erfme <> vsresb_cn.meins then case when vsresb_cn.vmeng = vsresb_cn.bdmng then case when vsresb_cn.bdmng is null then vsresb_cn.bdmng else vsresb_cn.erfmg end else cast(vsresb_cn.vmeng as abap.fltp) * ( cast(vsresb_cn.umren as abap.fltp) / cast(vsresb_cn.umrez as abap.fltp)) end else cast(vsresb_cn.vmeng as abap.fltp) end as CommittedQuantity AS fltpendasCommittedQuantity,
  vsresb_cn.kzear AS ReservationIsFinallyIssued,
  cast (vsresb_cn.kdauf as ps_s4_kdauf) AS SalesOrder,
  cast(vsresb_cn.kdpos as ps_s4_kdpos) AS SalesOrderItem,
  cast(vsresb_cn.wempf as ps_s4_wempf ) AS GoodsRecipientName,
  cast( vsresb_cn.ablad as ps_s4_ablad preserving type ) AS UnloadingPointName,
  cast (vsresb_cn.xwaok as xwaok) AS GoodsMovementIsAllowed,
  cast (vsresb_cn.xloek as ps_s4_loevm) AS MatlCompIsMarkedForDeletion,
  cast( vsresb_cn.lgort as ps_s4_lgort_d preserving type ) AS StorageLocation,
  vsresb_cn.meins AS BaseUnit,
  cast (vsresb_cn.ekgrp as ekgrp) AS PurchasingGroup,
  cast (vsresb_cn.enmng as mmiv_quantity_received) AS ReceivedQuantity,
  cast (vsresb_cn.flmng as ps_s4_flmng) AS ShortfallQuantity,
  vsresb_cn.lmeng AS MRPRequiredQuantityInBaseUnit,
  cast (vsresb_cn.sanka as ps_s4_ck_selkz) AS MaterialCompIsCostRelevant,
  vsresb_cn.lifnr AS Creditor,
  vsresb_cn.gpreis AS MaterialComponentPrice,
  vsresb_cn.peinh AS MaterialPriceUnitQty,
  cast (vsresb_cn.rgekz as rgekz) AS MatlCompIsMarkedForBackflush,
  cast (vsresb_cn.saknr as saknr) AS GLAccount,
  cast (vsresb_cn.schgt as schgt) AS IsBulkMaterialComponent,
  vsresb_cn.kzvbr AS ConsumptionPosting,
  vsresb_cn.aennr AS ProjectObjectChangeNumber,
  cast(vsresb_cn.rform as ps_s4_rform preserving type ) AS FormulaKey,
  cast(vsresb_cn.postp as ps_s4_postp preserving type ) AS BOMItemCategory,
  cast (vsresb_cn.kzmpf as ps_s4_kzmpf) AS RqmtDateIsEnteredManually,
  cast (vsresb_cn.sernr as ps_s4_sernr) AS ProductionSeries,
  cast (vsresb_cn.nlfzv as ps_s4_cs_nlfzv) AS OperationLeadTimeOffset,
  cast (vsresb_cn.nlfmv as ps_s4_cs_nlfmv) AS OperationLeadTimeOffsetUnit,
  cast (vsresb_cn.potx1 as ps_s4_potx1) AS BOMItemDescription,
  cast(vsresb_cn.aufnr as ps_s4_aufnr preserving type ) AS ProjectNetwork,
  cast(vsresb_cn.vornr as ps_vornr preserving type ) AS NetworkActivity,
  cast (vsresb_cn.knttp as ps_s4_knttp) AS AccountAssignmentCategory,
  cast (vsresb_cn.sobkz as sobkz) AS MaterialCompIsSpecialStock,
  vsresb_cn.stlal AS BillOfMaterialVariant,
  vsresb_cn.stlty AS BillOfMaterialCategory,
  1 AS NumberOfAssignedMaterials
FROM vsresb_cn
;