I_ProjectMaterialCompBasicData

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_ProjectMaterialCompBasicData.
-- 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: IPRJMATCOMBASDAT

CREATE VIEW I_ProjectMaterialCompBasicData AS
SELECT
  resb.rsnum AS Reservation,
  cast ( resb.rspos as ps_s4_rspos preserving type ) AS ReservationItem,
  resb.rsart AS RecordType,
  resb.aufpl AS ProjectNetworkInternalID,
  resb.aplzl AS NetworkActivityInternalID,
  cast ( resb.aufnr as ps_s4_aufnr preserving type ) AS ProjectNetwork,
  cast ( resb.vornr as ps_vornr preserving type ) AS NetworkActivity,
  resb.matnr AS Material,
  cast ( resb.bdter as ps_s4_bdter preserving type ) AS MatlCompRequirementDate,
  cast ( resb.lifzt as ps_s4_lifzt ) AS DeliveryDurationInDays,
  resb.webaz AS GoodsReceiptDurationInDays,
  cast ( resb.waers as waers ) AS Currency,
  resb.werks AS Plant,
  cast ( resb.posnr as char4 preserving type ) AS BillOfMaterialItemNumber,
  resb.objnr AS MaterialComponentObject,
  cast ( resb.bwart as bwartwa ) AS GoodsMovementType,
  cast ( resb.xfehl as xfehl ) AS MaterialComponentIsMissing,
  resb.bdmng - resb.enmng AS OpenQuantity,
  resb.kzear AS ReservationIsFinallyIssued,
  cast ( resb.kdauf as ps_s4_kdauf ) AS SalesOrder,
  cast ( resb.kdpos as ps_s4_kdpos ) AS SalesOrderItem,
  cast ( resb.wempf as ps_s4_wempf ) AS GoodsRecipientName,
  cast ( resb.ablad as ps_s4_ablad preserving type ) AS UnloadingPointName,
  cast ( resb.xwaok as xwaok ) AS GoodsMovementIsAllowed,
  cast ( resb.xloek as ps_s4_loevm ) AS MatlCompIsMarkedForDeletion,
  cast ( resb.lgort as ps_s4_lgort_d preserving type ) AS StorageLocation,
  cast ( resb.ekgrp as ekgrp ) AS PurchasingGroup,
  cast ( resb.enmng as mmiv_quantity_received ) AS ReceivedQuantity,
  cast ( resb.flmng as ps_s4_flmng ) AS ShortfallQuantity,
  resb.lmeng AS MRPRequiredQuantityInBaseUnit,
  cast ( resb.sanka as ps_s4_ck_selkz ) AS MaterialCompIsCostRelevant,
  resb.lifnr AS Creditor,
  resb.gpreis AS MaterialComponentPrice,
  resb.peinh AS MaterialPriceUnitQty,
  cast ( resb.rgekz as rgekz ) AS MatlCompIsMarkedForBackflush,
  cast ( resb.saknr as saknr ) AS GLAccount,
  cast ( resb.schgt as schgt ) AS IsBulkMaterialComponent,
  resb.kzvbr AS ConsumptionPosting,
  resb.aennr AS ProjectObjectChangeNumber,
  cast ( resb.rform as ps_s4_rform preserving type ) AS FormulaKey,
  cast ( resb.postp as ps_s4_postp preserving type ) AS BOMItemCategory,
  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,
  1 AS NumberOfAssignedMaterials,
  resb.stlty AS BillOfMaterialCategory,
  cast( resb.stlnr as pph_stnum preserving type ) AS BillOfMaterialInternalID,
  resb.stlal AS BillOfMaterialVariant,
  resb.flgex AS MatlCompIsProcuredExternally,
  resb.vorab AS IsPreliminaryOrder,
  resb.knttp AS AccountAssignmentCategory,
  resb.sobkz AS MaterialCompIsSpecialStock,
  resb.pbdnr AS RequirementPlan,
  resb.txtps AS MatlCompIsTextItem,
  resb.funct AS DistributionFunction,
  resb.verti AS QuantityDistributionKey,
  cast ( resb.sortf as eqfnr ) AS SortField,
  resb.no_disp AS MatlCompIsRelevantForMRP,
  resb.charg AS Batch,
  cast ( resb.meins as meins ) AS BaseUnit,
  cast ( resb.erfme as meins ) AS EntryUnit,
  resb.vmeng AS ConfirmedAvailableQuantity,
  resb.bdmng AS RequirementQuantityInBaseUnit,
  case when resb.shkzg = 'S' then resb.erfmg * -1 else resb.erfmg end as QuantityInEntryUnit AS erfmgendasQuantityInEntryUnit,
  resb.umren AS MaterialQtyToBaseQtyDnmntr,
  resb.umrez AS QuantityNumerator,
  resb.infnr AS PurchasingInfoRecord,
  resb.matkl AS MaterialGroup,
  resb.roms1 AS VariableSizeDimension1,
  resb.roms2 AS VariableSizeDimension2,
  resb.roms3 AS VariableSizeDimension3,
  resb.romei AS VariableSizeDimensionUnit,
  resb.rform AS VariableSizeCompFormulaKey,
  cast(resb.roanz as vdm_roanz) AS NumberOfVariableSizeItem,
  resb.nomng AS QuantityInUnitOfEntry,
  resb.romen AS VariableSizeItemQuantity,
  resb.rokme AS VariableSizeComponentUnit,
  resb.producttype AS ProductTypeGroupCode,
  resb.serviceperformer AS ServicePerformer,
  resb.startdate AS PerformancePeriodStartDate,
  resb.enddate AS PerformancePeriodEndDate,
  resb.serviceduration AS LeanServiceDuration,
  resb.servicedurationunit AS LeanServiceDurationUnit,
  cast( resb.pspel as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  resb.fldlogsdelivisheldonshore AS FldLogsDelivIsHeldOnShore,
  resb.fldlogssupplyprocess AS FldLogsSupplyProcess,
  resb.fldlogsversion AS FldLogsSupProcVersion
FROM resb
LEFT OUTER JOIN I_ProjMatCompAdditionalData AS _ProjMatCompAdditionalData ON Reservation = _ProjMatCompAdditionalData.Reservation AND ReservationItem = _ProjMatCompAdditionalData.ReservationItem AND RecordType = _ProjMatCompAdditionalData.RecordType  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetworkBasicData AS _ProjectNetworkBasicData ON ProjectNetworkInternalID = _ProjectNetworkBasicData.ProjectNetworkInternalID AND _ProjectNetworkBasicData.OrderCategory = '20'  -- association [1..1]
LEFT OUTER JOIN I_ProjNtwkActyMatBOMAssembly AS _ProjNtwkActyMatBOMAssembly ON BillOfMaterialCategory = _ProjNtwkActyMatBOMAssembly.BillOfMaterialCategory AND BillOfMaterialInternalID = _ProjNtwkActyMatBOMAssembly.BillOfMaterial AND BillOfMaterialVariant = _ProjNtwkActyMatBOMAssembly.BillOfMaterialVariant  -- 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_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BomItemCategoryText AS _BillOfMatItemCategoryText ON BOMItemCategory = _BillOfMatItemCategoryText.BillOfMaterialItemCategory AND _BillOfMatItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MRPQuantityDistrKeyText AS _MRPQuantityDistrKeyText ON Plant = _MRPQuantityDistrKeyText.Plant AND QuantityDistributionKey = _MRPQuantityDistrKeyText.QuantityDistributionKey AND _MRPQuantityDistrKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisitionItemBasic AS _PurchaseRequisitionItemBasic ON Reservation = _PurchaseRequisitionItemBasic.SettlementReservation AND ReservationItem = _PurchaseRequisitionItemBasic.SettlementReservationItem AND _PurchaseRequisitionItemBasic.IsDeleted = ' '  -- association [0..1]
LEFT OUTER JOIN E_ReservationDocumentItem AS _ReservationExtension ON Reservation = _ReservationExtension.Reservation AND ReservationItem = _ReservationExtension.ReservationItem AND RecordType = _ReservationExtension.RecordType  -- association [1..1]
LEFT OUTER JOIN E_ProjectMaterialComponent AS _MaterialExtension ON Reservation = _MaterialExtension.Reservation AND ReservationItem = _MaterialExtension.ReservationItem AND RecordType = _MaterialExtension.RecordType  -- association [1..1]
;