P_ShrtTrmCshPosAcctDimnBAH

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_ShrtTrmCshPosAcctDimnBAH.
-- 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_ShrtTrmCshPosAcctDimnBAH AS
SELECT
  CashPositionProfile,
  cast(BankAccountHier.CashPositionHierNode as fclm_cp_hiernode ) AS CashPositionHierNode,
  $parameters.p_KeyDate AS KeyDate,
  $parameters.p_CashSnapshot AS CashSnapshot,
  cast(BankAccountHier.CashPositionHierParentNode as fclm_cp_hiernode ) AS CashPositionHierParentNode,
  BankAccountHier.CashPositionHierNodeValue AS CashPositionHierNodeValue,
  BankAccountHier.CashPositionHierNodeType AS CashPositionHierNodeType,
  '' AS CashPositionHierNextNodeType,
  _NodeTypeText[1:Language = $session.system_language].CashPositionHierNodeTypeText AS CashPositionHierNodeTypeText,
  _CashPositionProfile.CashPositionProfileDescription AS CashPositionProfileDescription,
  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,
  BankAccountInternalID AS CshPoolHierRootBkAcctIntID,
  CompanyCode,
  Bank,
  BankCountry,
  BankAccountCurrency,
  BankAccountInternalID,
  BankAccountNumber,
  RiskPartnerNo,
  Country,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Bank.BankName AS BankName,
  _CurrencyText.CurrencyName AS CurrencyName,
  _BankCountryText[1:Language=$session.system_language].CountryName AS BankCountryName,
  _CompanyCountryText[1:Language=$session.system_language].CountryName AS CompanyCountryName,
  _BankAccount._Text[1:Language=$session.system_language].BankAccountDescription AS BankAccountDescription,
  _RiskPartner.BusinessPartnerName AS BusinessPartnerName,
  _Snapshot.CashSnapshotDescription AS CashSnapshotDescription
FROM P_ShrtTrmCshPosAccHier
LEFT OUTER JOIN I_ShrtTrmCshPosHierNodeTypeTxt AS _NodeTypeText ON CashPositionHierNodeType = _NodeTypeText.CashPositionHierNodeType  -- association [0..*]
LEFT OUTER JOIN I_CashPositionProfile AS _CashPositionProfile ON CashPositionProfile = _CashPositionProfile.CashPositionProfile  -- association [0..1]
LEFT OUTER JOIN P_ShrtTrmCshPosAcctDimnBAH AS _Parent ON CashPositionProfile = _Parent.CashPositionProfile AND CashPositionHierParentNode = _Parent.CashPositionHierNode AND KeyDate = _Parent.KeyDate AND CashSnapshot = _Parent.CashSnapshot  -- association [0..1]
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_CountryText AS _BankCountryText ON BankCountry = _BankCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CompanyCountryText ON Country = _CompanyCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_CashSnapshot AS _Snapshot ON _Snapshot.CashSnapshot = $parameters.p_CashSnapshot  -- association [0..1]
;