P_ShrtTrmCshPosCshPoolHier

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_ShrtTrmCshPosCshPoolHier.
-- 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: PSTCPCPLHIER
-- Parameters: P_CashPositionProfile : fclm_cp_profile_name

CREATE VIEW P_ShrtTrmCshPosCshPoolHier AS
SELECT
  _Profile.CashPositionProfile AS CashPositionProfile,
  case when _CrsCshPoolHdrAcctHierNode(P_KeyDate:$session.user_date).CashPoolAssignment is not null then concat(_Basic.BankAccountInternalID, concat(_Basic.BankAccountCurrency, _IdenticalCshPoolParNode(P_KeyDate:$session.user_date).CompanyCode)) when _CrsCshPoolHdrAcctHierNode(P_KeyDate:$session.user_date).CashPoolAssignment is null then concat(_Basic.BankAccountInternalID, concat(_Basic.BankAccountCurrency, _Basic.CompanyCode)) end as CashPositionHierNode AS CompanyCodeendasCashPositionHierNode,
  _Account.BankAccountNumber AS CashPositionHierNodeValue,
  'BA' AS CashPositionHierNodeType,
  '' AS CashPositionHierNextNodeType,
  _Basic.CashPoolAssignment AS CshPoolAssgmtHierNode,
  _Basic.BankAccountInternalID AS BankAccountInternalID,
  _Account.Bank AS Bank,
  _Account.BankAccountCurrency AS BankAccountCurrency,
  _Account.BankAccountNumber AS BankAccountNumber,
  _Account.BankCountry AS BankCountry,
  _Account.CompanyCode AS CompanyCode,
  _Account.Country AS Country,
  _Account.RiskPartnerNo AS RiskPartnerNo,
  _Basic.CashPool AS CashPool,
  _Basic.CashPoolAssignmentText AS CashPoolAssignmentText,
  _Basic.CashPoolAssgmtIsHeadBkAcct AS CashPoolAssgmtIsHeadBkAcct,
  _Basic.CashPoolAssgmtValdtyStrtDte AS CashPoolAssgmtValdtyStrtDte,
  _Basic.CashPoolAssgmtValdtyEndDte AS CashPoolAssgmtValdtyEndDte,
  _Basic.CashPoolAssgmtIsDeleted AS CashPoolAssgmtIsDeleted,
  _CrsCshPoolSubAcctHierNode(P_KeyDate:$session.user_date).CashPoolAssignment AS CrsCshPoolSubAcctHierNode,
  _CrsCshPoolHdrAcctHierNode(P_KeyDate:$session.user_date).CashPoolAssignment AS CrsCshPoolHdrAcctHierNode,
  _IdenticalCshPoolParNode(P_KeyDate:$session.user_date).CashPoolAssignment AS IdenticalCshPoolParNode,
  _IdenticalCshPoolGrandParNode(P_KeyDate:$session.user_date).CashPoolAssignment AS IdenticalCshPoolGrandParNode,
  _ParentPoolLeftJoin.CashPool AS ParentCashPool,
  _ParentPoolLeftJoin.CashPoolAssgmtIsHeadBkAcct AS ParCshPoolAssgmtIsHeadBkAcct,
  concat(_Basic.BankAccountInternalID, concat(_IdenticalCshPoolParNode(P_KeyDate:$session.user_date).BankAccountInternalID, concat(_Basic.BankAccountCurrency, _IdenticalCshPoolParNode(P_KeyDate:$session.user_date).CompanyCode))) AS CashPositionHierNode,
  concat(_IdenticalCshPoolParNode(P_KeyDate:$session.user_date).BankAccountInternalID, concat(_Basic.BankAccountCurrency, _IdenticalCshPoolParNode(P_KeyDate:$session.user_date).CompanyCode)) AS CashPositionHierParentNode,
  _IdenticalCshPoolParNode(P_KeyDate:$session.user_date).CashPoolAssignment AS CshPoolAssgmtHierParNode
FROM I_CashPoolAssgmtForKeyDate
INNER JOIN I_CashPositionProfile AS _Profile ON /* join condition not captured in parsed metadata */
INNER JOIN P_ShrtTrmCshPosAccWithProfile ON /* join condition not captured in parsed metadata */
INNER JOIN P_ShrtTrmCshPosBankAccount AS _Account ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CashPoolAssgmtForKeyDate AS _CrsCshPoolSubAcctHierNode ON CashPool <> _CrsCshPoolSubAcctHierNode.CashPool AND BankAccountInternalID = _CrsCshPoolSubAcctHierNode.BankAccountInternalID AND CashPoolAssgmtIsHeadBkAcct = 'X' AND _CrsCshPoolSubAcctHierNode.CashPoolAssgmtIsHeadBkAcct = ''  -- association [0..*]
LEFT OUTER JOIN I_CashPoolAssgmtForKeyDate AS _CrsCshPoolHdrAcctHierNode ON CashPool <> _CrsCshPoolHdrAcctHierNode.CashPool AND BankAccountInternalID = _CrsCshPoolHdrAcctHierNode.BankAccountInternalID AND CashPoolAssgmtIsHeadBkAcct = '' AND _CrsCshPoolHdrAcctHierNode.CashPoolAssgmtIsHeadBkAcct = 'X'  -- association [0..*]
LEFT OUTER JOIN I_CashPoolAssgmtForKeyDate AS _IdenticalCshPoolParNode ON CashPool = _IdenticalCshPoolParNode.CashPool AND CashPoolAssgmtIsHeadBkAcct = '' AND _IdenticalCshPoolParNode.CashPoolAssgmtIsHeadBkAcct = 'X'  -- association [0..*]
LEFT OUTER JOIN I_CashPoolAssgmtForKeyDate AS _IdenticalCshPoolGrandParNode ON _ParentPoolLeftJoin.CashPool = _IdenticalCshPoolGrandParNode.CashPool AND _ParentPoolLeftJoin.CashPoolAssgmtIsHeadBkAcct = '' AND _IdenticalCshPoolGrandParNode.CashPoolAssgmtIsHeadBkAcct = 'X'  -- association [0..*]
LEFT OUTER JOIN I_CashPool_2 AS _CashPool ON CashPool = _CashPool.CashPool  -- association [0..1]
-- UNION ALL with additional select branch(es): I_CashPoolAssgmtForKeyDate, P_ShrtTrmCshPosAccWithProfile
;