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
  ProjectMaterialComponent.Reservation AS Reservation,
  ProjectMaterialComponent.Version AS Version,
  ProjectMaterialComponent.ReservationItem AS ReservationItem,
  ProjectMaterialComponent.RecordType AS RecordType,
  ProjectMaterialComponent.Material AS Material,
  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.SalesOrder AS SalesOrder,
  ProjectMaterialComponent.Plant AS Plant,
  ProjectMaterialComponent._PlantName.PlantName AS PlantName,
  ProjectMaterialComponent.GoodsRecipientName AS GoodsRecipientName,
  ProjectMaterialComponent.StorageLocation AS StorageLocation,
  cast( ProjectMaterialComponent._StorageLocation.StorageLocationName as ps_s4_lgort_name) AS StorageLocationName,
  ProjectMaterialComponent.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  ProjectMaterialComponent.GoodsMovementType AS GoodsMovementType,
  ProjectMaterialComponent.AccountAssignmentCategory AS AccountAssignmentCategory,
  cast (ProjectMaterialComponent._AccAssgnmtCategory[1: Language = $session.system_language ].AcctAssignmentCategoryName as ps_s4_knttx ) AS AcctAssignmentCategoryName,
  ProjectMaterialComponent.MaterialCompIsSpecialStock AS MaterialCompIsSpecialStock,
  ProjectMaterialComponent._InventorySpecialStockType._Text[1: Language = $session.system_language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  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,
  cast(ProjectMaterialComponent._Supplier.SupplierName as fap_supplier_name1_gp) AS SupplierName,
  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._ConsumptionPostingName._Text[1: Language = $session.system_language ].ConsumptionPostingName AS ConsumptionPostingName,
  ProjectMaterialComponent.ProjectObjectChangeNumber AS ProjectObjectChangeNumber,
  ProjectMaterialComponent.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  ProjectMaterialComponent.FormulaKey AS FormulaKey,
  ProjectMaterialComponent.UnloadingPointName AS UnloadingPointName,
  cast (ProjectMaterialComponent._PlantName.FactoryCalendar as appca) AS FactoryCalendar,
  ProjectMaterialComponent.BOMItemCategory AS BOMItemCategory,
  ProjectMaterialComponent.RqmtDateIsEnteredManually AS RqmtDateIsEnteredManually,
  ProjectMaterialComponent.ProductionSeries AS ProductionSeries,
  ProjectMaterialComponent._Material.MaterialGroup AS MaterialGroup,
  cast(ProjectMaterialComponent._Material._MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupName as ps_s4_wgbez ) AS MaterialGroupName,
  ProjectMaterialComponent.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  ProjectMaterialComponent.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  ProjectMaterialComponent.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  ProjectMaterialComponent.BOMItemDescription AS BOMItemDescription,
  ProjectMaterialComponent.ProcurementType AS ProcurementType,
  ProjectMaterialComponent._ProjMatlProcurementType._Text[1: Language = $session.system_language ].ProcurementTypeName AS ProcurementTypeName,
  ProjectMaterialComponent.AssemblyName AS AssemblyName,
  ProjectMaterialComponent.LastChangeDate AS LastChangeDate,
  ProjectMaterialComponent.LastChangedByUser AS LastChangedByUser,
  ProjectMaterialComponent.CreationDate AS CreationDate,
  ProjectMaterialComponent.CreatedByUser AS CreatedByUser,
  ProjectMaterialComponent._ProjMatBomCategory._Text[1: Language = $session.system_language ].BillOfMaterialCategoryDesc AS BillOfMaterialCategoryDesc,
  ProjectMaterialComponent.BOMHeaderText AS BOMHeaderText,
  ProjectMaterialComponent._BillOfMaterialCategory._Text[1: Language = $session.system_language ].BillOfMaterialCategoryDesc AS MatlCompMainAssemblyCatName,
  ProjectMaterialComponent._SpecialStockValuationName._Text[1:Language = $session.system_language ].InventorySpclStkValnTypeName AS InventorySpclStkValnTypeName,
  ProjectMaterialComponent.ProjectWithCodingMask AS Project,
  _Project.ProjectObject AS ProjectObject,
  cast( _ProjectVersionHeader.ProjectVersionDescription as wty_vetxt) AS ProjectVersionDescription,
  _ProjectVersionHeader.ProjectVersionGroupName AS ProjectVersionGroupName,
  cast (case when _WBSElement.WBSElement is null then '' else _WBSElement.WBSElement end as ps_posid_edit) as WBSElement AS WBSElementendasps_posid_editasWBSElement,
  ProjectMaterialComponent.WBSElementInternalID AS WBSElementInternalID,
  _WBSElement.WBSElementObject AS WBSElementObject,
  _WBSElement.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  ProjectMaterialComponent.ProjectNetwork AS ProjectNetwork,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  _NetworkActivity.NetworkActivityDescription AS NetworkActivityDescription,
  _Project.ProjectDescription AS ProjectDescription,
  _WBSElement.WBSDescription AS WBSDescription,
  ProjectMaterialComponent.NetworkActivity AS NetworkActivity
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]
;