C_ProdStrucFilterBar

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_ProdStrucFilterBar.
-- 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: CPSFILTERBAR

CREATE VIEW C_ProdStrucFilterBar AS
SELECT
  _VariantList.ProductStructureVariantUUID AS ProductStructureVariantUUID,
  _VariantList.ProdStrucVariantChgStateIntID AS ProdStrucVariantChgStateIntID,
  _NodeVH.ProductStructureNodeName AS ProductStructureNodeName,
  _NodeType.ProductStructureNodeType AS ProductStructureNodeType,
  _VariantList.Class AS Class,
  _VariantList.Material AS Material,
  _VariantList.ProdStrucVariantChangeNumber AS ProdStrucVariantChangeNumber,
  _VariantList.ProductStructureCreatedByUser AS ProductStructureCreatedByUser,
  _VariantList.ProductStructureCreationDate AS ProductStructureCreationDate,
  _VariantList.ProductStructureVariantName AS ProductStructureVariantName,
  _VariantList.ProductStructureVariantType AS ProductStructureVariantType,
  _VariantList.ProductStrucLastChangedByUser AS ProductStrucLastChangedByUser,
  _VariantList.ProductStrucLastChangedDate AS ProductStrucLastChangedDate
FROM C_ProdStrucVariant AS _VariantList
LEFT OUTER JOIN C_ProdStrucMaterialVH AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN C_ProdStrucChangeMasterVH AS _ChangeMasterVH ON ProdStrucVariantChangeNumber = _ChangeMasterVH.ProdStrucVariantChangeNumber  -- association [0..1]
LEFT OUTER JOIN C_ProductStructureVariantVH AS _VariantVH ON ProductStructureVariantName = _VariantVH.ProductStructureVariantName  -- association [1..*]
LEFT OUTER JOIN C_ProdStrucVariantType AS _VariantType ON ProductStructureVariantType = _VariantType.ProductStructureVariantType  -- association [1..1]
LEFT OUTER JOIN C_ProductStructureNodeVH AS _NodeVH ON productstructurenodename = _NodeVH.ProductStructureNodeName  -- association [1..*]
LEFT OUTER JOIN C_ProdStrucNodeType AS _NodeType ON productstructurenodetype = _NodeType.ProductStructureNodeType  -- association [1..1]
LEFT OUTER JOIN C_ProdStrucClassVH AS _ClassVH ON Class = _ClassVH.Class  -- association [0..1]
;