C_ProjMatComponentWithVersion

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 C_ProjMatComponentWithVersion.
-- 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: CPROJMATCOMPVERS

CREATE VIEW C_ProjMatComponentWithVersion AS
SELECT
  cast(ProjectMaterialComponent.Material as dmcc_product) AS Material,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ServicePerformer,
  LeanServiceDuration,
  LeanServiceDurationUnit,
  OverallLimitAmount,
  ExpectedOverallLimitAmount,
  ProjectMaterialComponent._PlantName.PlantName AS PlantName,
  cast( ProjectMaterialComponent._StorageLocation.StorageLocationName as ps_s4_lgort_name) AS StorageLocationName,
  cast (ProjectMaterialComponent._AccAssgnmtCategory[1: Language = $session.system_language ].AcctAssignmentCategoryName as ps_s4_knttx ) AS AcctAssignmentCategoryName,
  ProjectMaterialComponent._InventorySpecialStockType._Text[1: Language = $session.system_language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  ProjectMaterialComponent._Supplier.BPSupplierName AS SupplierName,
  ProjectMaterialComponent._ConsumptionPostingName._Text[1: Language = $session.system_language ].ConsumptionPostingName AS ConsumptionPostingName,
  cast (ProjectMaterialComponent._PlantName.FactoryCalendar as appca) AS FactoryCalendar,
  ProjectMaterialComponent._Material.MaterialGroup AS MaterialGroup,
  cast(ProjectMaterialComponent._Material._MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupName as ps_s4_wgbez ) AS MaterialGroupName,
  ProjectMaterialComponent._ProjMatlProcurementType._Text[1: Language = $session.system_language ].ProcurementTypeName AS ProcurementTypeName,
  ProjectMaterialComponent._ProjMatBomCategory._Text[1: Language = $session.system_language ].BillOfMaterialCategoryDesc AS BillOfMaterialCategoryDesc,
  ProjectMaterialComponent._BillOfMaterialCategory._Text[1: Language = $session.system_language ].BillOfMaterialCategoryDesc AS MatlCompMainAssemblyCatName,
  ProjectMaterialComponent._SpecialStockValuationName._Text[1:Language = $session.system_language ].InventorySpclStkValnTypeName AS InventorySpclStkValnTypeName,
  cast( _ProjectVersionHeader.ProjectVersionDescription as wty_vetxt) AS ProjectVersionDescription,
  cast (case when _WBSElement.WBSElement is null then '' else _WBSElement.WBSElement end as ps_posid_edit) as WBSElement AS WBSElementendasps_posid_editasWBSElement,
  ProjectMaterialComponent.Reservation AS Reservation,
  ProjectMaterialComponent.Version AS Version,
  ProjectMaterialComponent.ReservationItem AS ReservationItem,
  ProjectMaterialComponent.RecordType AS RecordType,
  ProjectMaterialComponent.ProductTypeCode AS ProductTypeCode,
  ProjectMaterialComponent.MatlCompRequirementDate AS MatlCompRequirementDate,
  ProjectMaterialComponent.RequirementQuantityInBaseUnit AS RequirementQuantityInBaseUnit,
  ProjectMaterialComponent.WithdrawnQuantity AS WithdrawnQuantity,
  ProjectMaterialComponent.CommittedQuantity AS CommittedQuantity,
  ProjectMaterialComponent.OpenQuantity AS OpenQuantity,
  ProjectMaterialComponent.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  ProjectMaterialComponent.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  ProjectMaterialComponent.FldLogsSupplyProcess AS FldLogsSupplyProcess,
  ProjectMaterialComponent.FldLogsDelivIsHeldOnShore AS FldLogsDelivIsHeldOnShore,
  ProjectMaterialComponent.FldLogsVersion AS FldLogsVersion,
  ProjectMaterialComponent.SalesOrder AS SalesOrder,
  ProjectMaterialComponent.Plant AS Plant,
  ProjectMaterialComponent.GoodsRecipientName AS GoodsRecipientName,
  ProjectMaterialComponent.StorageLocation AS StorageLocation,
  ProjectMaterialComponent.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  ProjectMaterialComponent.GoodsMovementType AS GoodsMovementType,
  ProjectMaterialComponent.AccountAssignmentCategory AS AccountAssignmentCategory,
  ProjectMaterialComponent.MaterialCompIsSpecialStock AS MaterialCompIsSpecialStock,
  ProjectMaterialComponent.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  ProjectMaterialComponent.BaseUnit AS BaseUnit,
  ProjectMaterialComponent.PurchasingGroup AS PurchasingGroup,
  ProjectMaterialComponent.ReceivedQuantity AS ReceivedQuantity,
  ProjectMaterialComponent.ShortfallQuantity AS ShortfallQuantity,
  ProjectMaterialComponent.MRPRequiredQuantityInBaseUnit AS MRPRequiredQuantityInBaseUnit,
  ProjectMaterialComponent.MaterialCompIsCostRelevant AS MaterialCompIsCostRelevant,
  ProjectMaterialComponent.Creditor AS Creditor,
  ProjectMaterialComponent.Supplier AS Supplier,
  ProjectMaterialComponent.DeliveryDurationInDays AS DeliveryDurationInDays,
  ProjectMaterialComponent.MaterialComponentPrice AS MaterialComponentPrice,
  ProjectMaterialComponent.Currency AS Currency,
  ProjectMaterialComponent.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  ProjectMaterialComponent.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  ProjectMaterialComponent.GLAccount AS GLAccount,
  ProjectMaterialComponent.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  ProjectMaterialComponent.ConsumptionPosting AS ConsumptionPosting,
  ProjectMaterialComponent.ProjectObjectChangeNumber AS ProjectObjectChangeNumber,
  ProjectMaterialComponent.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  ProjectMaterialComponent.FormulaKey AS FormulaKey,
  ProjectMaterialComponent.UnloadingPointName AS UnloadingPointName,
  ProjectMaterialComponent.BOMItemCategory AS BOMItemCategory,
  ProjectMaterialComponent.RqmtDateIsEnteredManually AS RqmtDateIsEnteredManually,
  ProjectMaterialComponent.ProductionSeries AS ProductionSeries,
  ProjectMaterialComponent.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  ProjectMaterialComponent.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  ProjectMaterialComponent.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  ProjectMaterialComponent.BOMItemDescription AS BOMItemDescription,
  ProjectMaterialComponent.ProcurementType AS ProcurementType,
  ProjectMaterialComponent.AssemblyName AS AssemblyName,
  ProjectMaterialComponent.LastChangeDate AS LastChangeDate,
  ProjectMaterialComponent.LastChangedByUser AS LastChangedByUser,
  ProjectMaterialComponent.CreationDate AS CreationDate,
  ProjectMaterialComponent.CreatedByUser AS CreatedByUser,
  ProjectMaterialComponent.BOMHeaderText AS BOMHeaderText,
  ProjectMaterialComponent.ProjectWithCodingMask AS Project,
  ProjectMaterialComponent.WBSElementInternalID AS WBSElementInternalID,
  ProjectMaterialComponent.ProjectNetwork AS ProjectNetwork,
  ProjectMaterialComponent.NetworkActivity AS NetworkActivity,
  _NetworkActivity.NetworkActivityDescription AS NetworkActivityDescription,
  _ProductTypeText.Name AS ProductTypeName,
  _Project.ProjectObject AS ProjectObject,
  _Project.ProjectDescription AS ProjectDescription,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  _ProjectVersionHeader.ProjectVersionGroupName AS ProjectVersionGroupName,
  _SupplyProcessText.FldLogsSupplyProcessText AS FldLogsSupplyProcessText,
  _SupyProcVerText.FldLogsSupProcVersText AS FldLogsSupProcVersText,
  _WBSElement.WBSElementObject AS WBSElementObject,
  _WBSElement.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  _WBSElement.WBSDescription AS WBSDescription
LEFT OUTER JOIN C_ProjectBasicInfo AS _Project ON Project = _Project.ProjectWithCodingMask AND Version = _Project.Version  -- association [0..1]
LEFT OUTER JOIN C_WBSElementBasicInfo AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND Version = _WBSElement.Version  -- association [0..1]
LEFT OUTER JOIN C_ProjectNetworkBasicInfo AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork AND Version = _ProjectNetwork.Version  -- association [0..1]
LEFT OUTER JOIN C_NetworkActivityBasicInfo AS _NetworkActivity ON ProjectNetwork = _NetworkActivity.ProjectNetwork AND NetworkActivity = _NetworkActivity.NetworkActivity AND Version = _NetworkActivity.Version AND _NetworkActivity.SuperiorNtwkActivityExternalID = ''  -- association [0..1]
LEFT OUTER JOIN C_ProjMatCompPurDocItems AS _MatCompPurDocItem ON Reservation = _MatCompPurDocItem.Reservation AND ReservationItem = _MatCompPurDocItem.ReservationItem AND RecordType = _MatCompPurDocItem.RecordType  -- association [0..*]
LEFT OUTER JOIN I_ProjectValueHelp AS _ProjectValueHelp ON Project = _ProjectValueHelp.Project  -- association [0..1]
LEFT OUTER JOIN I_WBSElementValueHelp AS _WBSElementValueHelp ON WBSElement = _WBSElementValueHelp.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementWithCodingMaskVH AS _WBSElementWithCodingMaskVH ON _WBSElementWithCodingMaskVH.WBSElement = WBSElement  -- association [0..1]
LEFT OUTER JOIN I_ProjectWithCodingMaskVH AS _ProjectWithCodingMaskVH ON _ProjectWithCodingMaskVH.Project = Project  -- association [0..1]
LEFT OUTER JOIN I_ProjectNtwkValueHelp AS _ProjectNtwkValueHelp ON ProjectNetwork = _ProjectNtwkValueHelp.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityValueHelp AS _NetworkActivityValueHelp ON ProjectNetwork = _NetworkActivityValueHelp.ProjectNetwork AND NetworkActivity = _NetworkActivityValueHelp.NetworkActivity  -- association [0..1]
LEFT OUTER JOIN I_ProjectVersionVH AS _ProjectVersionVH ON _ProjectVersionVH.ProjectObjectExternalID = Project AND _ProjectVersionVH.Version = Version AND _ProjectVersionVH.ObjectType = 'PD'  -- association [0..1]
LEFT OUTER JOIN I_ProjectVersionHeader AS _ProjectVersionHeader ON Project = _ProjectVersionHeader.Project AND Version = _ProjectVersionHeader.Version  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCodeText AS _ProductTypeText ON ProductTypeCode = _ProductTypeText.ProductTypeCode AND _ProductTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSupplyProcessText AS _SupplyProcessText ON FldLogsSupplyProcess = _SupplyProcessText.FldLogsSupplyProcess AND _SupplyProcessText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSupProcVersVH AS _SupyProcVerText ON FldLogsSupplyProcess = _SupyProcVerText.FldLogsSupplyProcess AND FldLogsVersion = _SupyProcVerText.FldLogsSupProcVersion  -- association [0..1]
;