I_Liquidityitem_Base

DDL: I_LIQUIDITYITEM_BASE SQL: ILIQBASE Type: view BASIC
9 Fields 2 Data Sources

Base View for liqudity hierarchy

I_Liquidityitem_Base is a Basic CDS View that provides data about "Base View for liqudity hierarchy" in SAP S/4HANA. It reads from 2 data sources (fclm_lqh_attr, fclm_lqh_hier) and exposes 9 fields with key fields mandt, ProductHierarchy, HierarchyNode, ParentNode, HierarchyNodeLevel.

Data Sources (2)

SourceAliasJoin Type
fclm_lqh_attr att from
fclm_lqh_hier hier left_outer

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ILIQBASE view
EndUserText.label Base View for liqudity hierarchy view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
ObjectModel.dataCategory #HIERARCHY view
hierarchy.parentChild.recurse.parent ParentNode view
hierarchy.parentChild.recurse.child HierarchyNode view
hierarchy.parentChild.siblingsOrder.by HierarchyNode view
hierarchy.parentChild.siblingsOrder.direction ASC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY mandt fclm_lqh_hier mandt Editing Client
KEY ProductHierarchy fclm_lqh_attr hier_id Hierarchy Old ID
KEY HierarchyNode fclm_lqh_hier nodeid Workflow Step
KEY ParentNode fclm_lqh_hier parentid UUID
KEY HierarchyNodeLevel fclm_lqh_hier nodelevel Node Level
LiquidityItem fclm_lqh_hier node_ref_key Node Reference Key
ProductHierarchyName fclm_lqh_attr name Zone name
ValidityStartDate fclm_lqh_attr datefrom Valid From
ValidityEndDate fclm_lqh_attr dateto Valid-To Date

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_Liquidityitem_Base.
-- 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: ILIQBASE

CREATE VIEW I_Liquidityitem_Base AS
SELECT
  hier.mandt AS mandt,
  att.hier_id AS ProductHierarchy,
  hier.nodeid AS HierarchyNode,
  hier.parentid AS ParentNode,
  hier.nodelevel AS HierarchyNodeLevel,
  hier.node_ref_key AS LiquidityItem,
  att.name AS ProductHierarchyName,
  att.datefrom AS ValidityStartDate,
  att.dateto AS ValidityEndDate
FROM fclm_lqh_attr AS att
LEFT OUTER JOIN fclm_lqh_hier AS hier ON /* join condition not captured in parsed metadata */
;

Learn More