C_ListFilterBar

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_ListFilterBar.
-- 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: CLISTFILTERBAR

CREATE VIEW C_ListFilterBar AS
SELECT
  _VariantList.ProductStructureVariantUUID AS ProductStructureVariantUUID,
  _VariantList.ProdStrucVariantChgStateIntID AS ProdStrucVariantChgStateIntID,
  _VariantList.Material AS Material,
  _VariantList.ProdStrucVariantChangeNumber AS ProdStrucVariantChangeNumber,
  _VariantList.ProductStructureVariantName AS ProductStructureVariantName,
  _VariantList.ProductStructureVariantType AS ProductStructureVariantType,
  _VariantList.ProductStructureCreatedByUser AS ProductStructureCreatedByUser,
  _VariantList.ProductStructureCreationDate AS ProductStructureCreationDate,
  _VariantList.ProductStructureNodeName AS ProductStructureNodeName,
  _VariantList.ProductStructureNodeType AS ProductStructureNodeType,
  _VariantList.Class AS Class,
  _VariantList.ProductStrucLastChangedByUser AS ProductStrucLastChangedByUser,
  _VariantList.ProductStrucLastChangedDate AS ProductStrucLastChangedDate
FROM C_VariantList AS _VariantList
LEFT OUTER JOIN C_Materialvh AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN C_Chgnrvh AS _Chgnrvh ON ProdStrucVariantChangeNumber = _Chgnrvh.ProdStrucVariantChangeNumber  -- association [0..1]
LEFT OUTER JOIN C_Variantvh AS _Variantvh ON ProductStructureVariantName = _Variantvh.ProductStructureVariantName  -- association [1..*]
LEFT OUTER JOIN C_VariantType AS _VariantType ON ProductStructureVariantType = _VariantType.ProductStructureVariantType  -- association [1..1]
LEFT OUTER JOIN C_Nodevh AS _Nodevh ON ProductStructureNodeName = _Nodevh.ProductStructureNodeName  -- association [1..1]
LEFT OUTER JOIN C_NodeType AS _NodeType ON ProductStructureNodeType = _NodeType.ProductStructureNodeType  -- association [1..1]
LEFT OUTER JOIN I_Classvh AS _Classvh ON Class = _Classvh.Class  -- association [0..1]
;