P_ShrtTrmCshPosGrouping

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_ShrtTrmCshPosGrouping.
-- 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: PSTCPGROUPING
-- Parameters: p_CashPositionProfile : fclm_cp_profile_name

CREATE VIEW P_ShrtTrmCshPosGrouping AS
SELECT
  CashPositionProfile,
  concat(coalesce(GroupValue3,'#'), concat(coalesce(GroupValue2,'#'),coalesce(GroupValue1, '#')) ) AS CashPositionHierNode,
  concat(coalesce(GroupValue2,'#'), coalesce(GroupValue1,'#')) AS CashPositionHierParentNode,
  cast(GroupValue3 as fclm_cp_hiernode_value) AS CashPositionHierNodeValue,
  CashPositionHierLevel3 AS CashPositionHierNodeType,
  'BA' AS CashPositionHierNextNodeType,
  cast('' as fclm_bam_acc_id ) AS BankAccountInternalID,
  cast('' as fclm_bam_acc_num ) AS BankAccountNumber,
  cast('' as fclm_cpl_name) AS CashPool,
  cast('' as fclm_cpl_assgn_text) AS CashPoolAssignmentText,
  cast('' as fclm_cpl_assgn_is_head_acc) AS CashPoolAssgmtIsHeadBkAcct,
  cast('' as waers) AS CashPositionDisplayCurrency,
  cast('' as fclm_bam_acc_id) AS CshPoolHierRootBkAcctIntID,
  cast(case when CashPositionHierLevel1 = '01' then GroupValue1 else '' end as bukrs ) AS CompanyCode,
  cast(case when CashPositionHierLevel1 = '03' then substring(GroupValue1, 3,15) else '' end as bankl ) AS Bank,
  cast(case when CashPositionHierLevel1 = '04' then GroupValue1 else '' end as waers) AS BankAccountCurrency,
  cast(case when CashPositionHierLevel1 = '05' then GroupValue1 else '' end as land1 ) AS Country,
  cast( case when CashPositionHierLevel1 = '06' then GroupValue1 else '' end as bu_partner ) AS RiskPartnerNo,
  '' AS BankCountry
FROM P_ShrtTrmCshPosGroupingField
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Bank_2 AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON BankAccountCurrency = _CurrencyText.Currency AND _CurrencyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _RiskPartner ON RiskPartnerNo = _RiskPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_UniversalHierNodeText AS _NodeText ON CashPositionHierNode = _NodeText.UniversalHierNodeID  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _BankCountryText ON BankCountry = _BankCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CompanyCountryText ON Country = _CompanyCountryText.Country  -- association [0..*]
-- UNION ALL with additional select branch(es): I_CashPositionProfile, P_ShrtTrmCshPosAccWithProfile
;