R_ProjNtwkActyMatlCompTP

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 R_ProjNtwkActyMatlCompTP.
-- 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.

CREATE VIEW R_ProjNtwkActyMatlCompTP AS
SELECT
  Reservation,
  ReservationItem,
  RecordType,
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  ProjectNetwork,
  NetworkActivity,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  Plant,
  BOMItemCategory,
  BillOfMaterialItemNumber,
  BOMItemDescription,
  RqmtDateIsEnteredManually,
  MatlCompRequirementDate,
  OperationLeadTimeOffset,
  OperationLeadTimeOffsetUnit,
  GoodsRecipientName,
  UnloadingPointName,
  MatlCompIsMarkedForDeletion AS IsMarkedForDeletion,
  StorageLocation,
  ProductionSeries,
  GoodsMovementIsAllowed,
  ReservationIsFinallyIssued,
  IsBulkMaterialComponent,
  MatlCompIsMarkedForBackflush,
  MaterialComponentIsMissing,
  BillOfMaterialInternalID,
  BillOfMaterialVariant,
  GoodsMovementType,
  MatlCompProcurementType,
  BaseUnit,
  RequirementQuantityInBaseUnit,
  case when EntryUnit <> ' ' and EntryUnit <> BaseUnit then case when ConfirmedAvailableQuantity = RequirementQuantityInBaseUnit then case when RequirementQuantityInBaseUnit is null then cast (RequirementQuantityInBaseUnit as abap.fltp) else cast (QuantityInEntryUnit as abap.fltp) end else case when QuantityNumerator is not initial then cast(ConfirmedAvailableQuantity as abap.fltp) * ( cast(MaterialQtyToBaseQtyDnmntr as abap.fltp) / cast(QuantityNumerator as abap.fltp)) end end else cast(ConfirmedAvailableQuantity as abap.fltp) end as CommittedQuantity AS fltpendasCommittedQuantity,
  QuantityDistributionKey,
  SortField,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  BillOfMaterialCategory,
  BOMExplosionFixedKeyDate,
  Batch,
  MaterialCompIsCostRelevant,
  PurchasingGroup,
  MaterialComponentPrice,
  Currency,
  PurchasingInfoRecord,
  MaterialPriceUnitQty,
  GLAccount,
  Creditor,
  GoodsReceiptDurationInDays,
  DeliveryDurationInDays,
  MaterialGroup,
  QuantityInEntryUnit,
  EntryUnit,
  PurchaseRequisition,
  _PurchaseRequisitionItemBasic.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchasingOrganization,
  case when ( _PurchaseRequisitionItemBasic.OverallLimitAmount is not initial and _PurchaseRequisitionItemBasic.ExpectedOverallLimitAmount is not initial ) then _PurchaseRequisitionItemBasic.PurContractForOverallLimit else _PurchaseRequisitionItemBasic.PurchaseContract end as PurchaseContract AS PurchaseContractendasPurchaseContract,
  RequisitionerUser,
  RequirementTracking,
  PurgInfoRecdDataIsFixed,
  MatlCompProcmtIndicatorCode,
  AddressNumber,
  Customer,
  Supplier,
  VariableSizeDimension1,
  VariableSizeDimension2,
  VariableSizeDimension3,
  VariableSizeDimensionUnit,
  VariableSizeCompFormulaKey,
  NumberOfVariableSizeItem,
  QuantityInUnitOfEntry,
  VariableSizeItemQuantity,
  VariableSizeComponentUnit,
  ProductTypeGroupCode,
  ServicePerformer,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  LeanServiceDuration,
  LeanServiceDurationUnit,
  OverallLimitAmount,
  ExpectedOverallLimitAmount,
  _ProjNtwkObjPurReqGrpgInd.PurReqnCollectiveIndicatorCode AS PurReqnCollectiveIndicatorCode,
  ProjectNetworkComponentID,
  WBSElementInternalID,
  WBSElementExternalID,
  FldLogsDelivIsHeldOnShore,
  FldLogsSupplyProcess,
  FldLogsSupProcVersion,
  _ProjectNetwork.ProjectInternalID AS ProjectInternalID,
  _ProjectNetworkActivity.WBSElementInternalID AS AssignedWBSElementInternalID,
  _ProjectNetworkActivity.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive,
  _ProjectNetworkActivity.NetworkActivityObject AS NetworkActivityObject
FROM I_ProjectMaterialComponentData
LEFT OUTER JOIN R_ProjectNetworkTP AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [1..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]
LEFT OUTER JOIN I_ProjNtwkObjPurReqGrpgInd AS _ProjNtwkObjPurReqGrpgInd ON ProjectNetworkComponentID = _ProjNtwkObjPurReqGrpgInd.ProjectNetworkComponentID AND ProjectNetwork = _ProjNtwkObjPurReqGrpgInd.ProjectNetwork AND NetworkActivity = _ProjNtwkObjPurReqGrpgInd.NetworkActivity AND PurchaseRequisition = _ProjNtwkObjPurReqGrpgInd.PurchaseRequisition  -- association [0..1]
;