I_Liquidityitemnode

DDL: I_LIQUIDITYITEMNODE SQL: ILIQITMNODE Type: view BASIC Package: FCLM_LQ_HIERARCHY_D
7 Fields 2 Data Sources

Liquidity Item Node

I_Liquidityitemnode is a Basic CDS View that provides data about "Liquidity Item Node" in SAP S/4HANA. It reads from 2 data sources (fclm_lqh_attr, fclm_lqh_hier) and exposes 7 fields with key fields LiquidityItemHierarchyId, LiquidityItemHierarchy, ValidityEndDate, HierarchyNode. Part of development package FCLM_LQ_HIERARCHY_D.

Data Sources (2)

SourceAliasJoin Type
fclm_lqh_attr fclm_lqh_attr left_outer
fclm_lqh_hier fclm_lqh_hier from

Annotations (8)

NameValueLevelField
EndUserText.label Liquidity Item Node view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ILIQITMNODE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY LiquidityItemHierarchyId fclm_lqh_hier hier_id Hierarchy Old ID
KEY LiquidityItemHierarchy name Zone name
KEY ValidityEndDate dateto Valid-To Date
KEY HierarchyNode nodeid Workflow Step
ParentNode parentid UUID
LiquidityItem
ValidityStartDate datefrom Valid From

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 I_Liquidityitemnode.
-- 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: ILIQITMNODE

CREATE VIEW I_Liquidityitemnode AS
SELECT
  fclm_lqh_hier.hier_id AS LiquidityItemHierarchyId,
  name AS LiquidityItemHierarchy,
  dateto AS ValidityEndDate,
  nodeid AS HierarchyNode,
  parentid AS ParentNode,
  cast( substring(node_ref_key,1,16) as flqpos ) AS LiquidityItem,
  datefrom AS ValidityStartDate
FROM fclm_lqh_hier
LEFT OUTER JOIN fclm_lqh_attr ON /* join condition not captured in parsed metadata */
;

Learn More