I_ShrtTrmCshPosLatestBalance

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 I_ShrtTrmCshPosLatestBalance.
-- 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.

CREATE VIEW I_ShrtTrmCshPosLatestBalance AS
SELECT
  LatestBalance.CalendarDate AS KeyDate,
  Balance.BankAccountInternalID AS BankAccountInternalID,
  Balance.CashBalanceType AS CashBalanceType,
  Balance.CompanyCode AS CompanyCode,
  Balance.CashBalanceAmount AS CashBalanceAmount,
  Balance.CashBalanceCurrency AS CashBalanceCurrency,
  Balance.CashBalanceDate AS CashBalanceDate,
  Balance.CashBalanceChannel AS CashBalanceChannel,
  Balance.BankStatementShortID AS BankStatementShortID,
  Balance.BankStatement AS BankStatement,
  Balance.CreatedByUser AS CreatedByUser,
  cast(Balance.CashBalanceCreatedAtDateTime as fclm_d_mmrdbsdt ) AS CashBalanceCreatedAtDateTime,
  Balance.CashClosingAvailBalanceSource AS CashClosingAvailBalanceSource,
  Balance._User AS _User,
  Balance._BalanceChannelText AS _BalanceChannelText,
  Balance._BalanceTypeText AS _BalanceTypeText
FROM P_ShrtTrmCshPosLatestBalTS AS LatestBalance
INNER JOIN I_BankCashBalanceHistory AS Balance ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountText AS _BankAccountText ON BankAccountInternalID = _BankAccountText.BankAccountInternalID  -- association [0..*]
;