C_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 C_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.
-- SQL view name: CSTCPBALANCE

CREATE VIEW C_ShrtTrmCshPosLatestBalance AS
SELECT
  profile.CashPositionProfile AS CashPositionProfile,
  Currency.Currency AS DisplayCurrency,
  balance.BankAccountInternalID AS BankAccountInternalID,
  $session.user_date AS KeyDate,
  balance.CashBalanceType AS CashBalanceType,
  balance._BankAccount.BankAccountNumber AS BankAccountNumber,
  balance._BankAccountText[1:Language=$session.system_language].BankAccountDescription AS BankAccountDescription,
  balance.CompanyCode AS CompanyCode,
  balance.CashBalanceAmount AS CashBalanceFormattedAmount,
  balance.CashBalanceAmount AS CashBalanceAmount,
  balance.CashBalanceCurrency AS CashBalanceCurrency,
  cast(0 as fqm_amount) AS CashBalanceAmountInDspCurrency,
  profile.CashPositionCurrencySource AS CashPositionCurrencySource,
  _CshPosCurSoucText[1:Language = $session.system_language].CashPositionCurrencySourceText AS CashPositionCurrencySourceText,
  balance.CashBalanceChannel AS CashBalanceChannel,
  balance.CashBalanceDate AS CashBalanceDate,
  balance.CreatedByUser AS CreatedByUser,
  balance.CashBalanceCreatedAtDateTime AS CashBalanceCreatedAtDateTime,
  balance.BankStatementShortID AS BankStatementShortID,
  balance.BankStatement AS BankStatement,
  balance._User AS _User,
  balance._BalanceChannelText AS _BalanceChannelText,
  balance._BalanceTypeText AS _BalanceTypeText,
  balance._BankAccount AS _BankAccount,
  balance._BankAccountText AS _BankAccountText
FROM I_ShrtTrmCshPosLatestBalance AS balance
CROSS JOIN I_CashPositionProfile AS profile
CROSS JOIN I_Currency AS Currency
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON CreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_ShrtTrmCshPosActualFlow AS _OverdueActualFlow ON KeyDate > _OverdueActualFlow.TransactionDate AND CashBalanceDate < _OverdueActualFlow.TransactionDate AND BankAccountInternalID = _OverdueActualFlow.BankAccountInternalID AND CashPositionProfile = _OverdueActualFlow.CashPositionProfile AND DisplayCurrency = _OverdueActualFlow.CashPositionDisplayCurrency  -- association [0..*]
LEFT OUTER JOIN C_CashPositionProfileWithCycle AS _CashPositionProfileWithCycle ON CashPositionProfile = _CashPositionProfileWithCycle.CashPositionProfile  -- association [1..1]
LEFT OUTER JOIN I_CshPosCurrencySourceText AS _CshPosCurSoucText ON CashPositionCurrencySource = _CshPosCurSoucText.CashPositionCurrencySource  -- association [0..*]
;