P_ShrtTrmCshPosAccWithProfile

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_ShrtTrmCshPosAccWithProfile.
-- 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_ShrtTrmCshPosAccWithProfile AS
SELECT
  prof.CashPositionProfile AS CashPositionProfile,
  account.BankAccountInternalID AS BankAccountInternalID,
  account.BankAccountCurrency AS BankAccountCurrency,
  account.BankAccountNumber AS BankAccountNumber,
  account.BankAccountType AS BankAccountType,
  account.BankCountry AS BankCountry,
  account.CompanyCode AS CompanyCode,
  account.Bank AS Bank,
  account.Country AS Country,
  account.RiskPartnerNo AS RiskPartnerNo,
  prof.CashPositionHierLevel1 AS CashPositionHierLevel1,
  prof.CashPositionHierLevel2 AS CashPositionHierLevel2,
  prof.CashPositionHierLevel3 AS CashPositionHierLevel3,
  prof.CashPositionHierSource AS CashPositionHierSource,
  prof.CashPositionRootNode AS CashPositionRootNode,
  prof.CashPositionRootNodeIsNeeded AS CashPositionRootNodeIsNeeded,
  case when prof.CashPositionHierLevel1 = '01' then account.CompanyCode when prof.CashPositionHierLevel1 = '02' then account.BankCountry when prof.CashPositionHierLevel1 = '03' then concat( account.BankCountry, account.Bank ) when prof.CashPositionHierLevel1 = '04' then account.BankAccountCurrency when prof.CashPositionHierLevel1 = '05' then account.Country when prof.CashPositionHierLevel1 = '06' then account.RiskPartnerNo else '' end as GroupValue1 AS RiskPartnerNoelseendasGroupValue1,
  case when prof.CashPositionHierLevel2 = '01' then account.CompanyCode when prof.CashPositionHierLevel2 = '02' then account.BankCountry when prof.CashPositionHierLevel2 = '03' then concat( account.BankCountry, account.Bank ) when prof.CashPositionHierLevel2 = '04' then account.BankAccountCurrency when prof.CashPositionHierLevel2 = '05' then account.Country when prof.CashPositionHierLevel2 = '06' then account.RiskPartnerNo else '' end as GroupValue2 AS RiskPartnerNoelseendasGroupValue2,
  case when prof.CashPositionHierLevel3 = '01' then account.CompanyCode when prof.CashPositionHierLevel3 = '02' then account.BankCountry when prof.CashPositionHierLevel3 = '03' then concat( account.BankCountry, account.Bank ) when prof.CashPositionHierLevel3 = '04' then account.BankAccountCurrency when prof.CashPositionHierLevel3 = '05' then account.Country when prof.CashPositionHierLevel3 = '06' then account.RiskPartnerNo else '' end as GroupValue3 AS client,
  p_CashPositionProfile: $parameters.p_CashPositionProfile AS p_CashPositionProfile,
  p_KeyDate: $parameters.p_KeyDate AS p_KeyDate,
  case when prof.CashPositionHierLevel3 = '01' then account.CompanyCode when prof.CashPositionHierLevel3 = '02' then account.BankCountry when prof.CashPositionHierLevel3 = '03' then concat( account.BankCountry, account.Bank ) when prof.CashPositionHierLevel3 = '04' then account.BankAccountCurrency when prof.CashPositionHierLevel3 = '05' then account.Country when prof.CashPositionHierLevel3 = '06' then account.RiskPartnerNo else '' end as GroupValue3 AS RiskPartnerNoelseendasGroupValue3
FROM P_ShrtTrmCshPosAccFilter
CROSS JOIN I_CashPositionProfile AS prof
LEFT OUTER JOIN I_CashSnapshotWthCshPosPrpsVH AS snapshot ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ShrtTrmCshPosAccFilter
;