P_ShrtTrmCshPosGroupingField

DDL: P_SHRTTRMCSHPOSGROUPINGFIELD Type: view_entity COMPOSITE Package: FCLM_CP_SHORTTERM

Short Term Cash Position Grouping Fields

P_ShrtTrmCshPosGroupingField is a Composite CDS View that provides data about "Short Term Cash Position Grouping Fields" in SAP S/4HANA. It reads from 1 data source (P_ShrtTrmCshPosAccPreGrp) and exposes 8 fields with key fields CashPositionProfile, GroupValue1, GroupValue2, GroupValue3. Part of development package FCLM_CP_SHORTTERM.

Data Sources (1)

SourceAliasJoin Type
P_ShrtTrmCshPosAccPreGrp P_ShrtTrmCshPosAccPreGrp from

Parameters (3)

NameTypeDefault
p_CashPositionProfile fclm_cp_profile_name
p_KeyDate vdm_v_key_date
p_CashSnapshot fclm_snapshot_id

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CashPositionProfile CashPositionProfile
KEY GroupValue1 GroupValue1
KEY GroupValue2 GroupValue2
KEY GroupValue3 GroupValue3
CashPositionHierLevel1 CashPositionHierLevel1
CashPositionHierLevel2 CashPositionHierLevel2
CashPositionHierLevel3 CashPositionHierLevel3
CashPositionRootNode CashPositionRootNode

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 P_ShrtTrmCshPosGroupingField.
-- 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.
-- Parameters: p_CashPositionProfile : fclm_cp_profile_name, p_KeyDate : vdm_v_key_date, p_CashSnapshot : fclm_snapshot_id

CREATE VIEW P_ShrtTrmCshPosGroupingField AS
SELECT
  CashPositionProfile,
  GroupValue1,
  GroupValue2,
  GroupValue3,
  CashPositionHierLevel1,
  CashPositionHierLevel2,
  CashPositionHierLevel3,
  CashPositionRootNode
FROM P_ShrtTrmCshPosAccPreGrp
;