I_DebtInvestmentNominal

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_DebtInvestmentNominal.
-- 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: IDBTINVESTNMNL
-- Parameters: P_KeyDate : vdm_v_key_date, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst

CREATE VIEW I_DebtInvestmentNominal AS
SELECT
  CompanyCode,
  FinancialTransaction,
  SecurityAccount,
  SecurityClass,
  SecurityAccountGroup,
  FinancialInstrumentProductType,
  _FinancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  _FinancialTransaction.TreasuryFinancialObject AS TreasuryFinancialObject,
  _FinancialTransaction.Counterparty AS Counterparty,
  _FinancialInstrProductType.TreasuryContractType AS TreasuryContractType,
  _FinancialTransaction.Portfolio AS Portfolio,
  FinancialInstrProductCategory,
  TrsyCshFlowDebtInvmtCode,
  TransactionCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  NominalCurrency,
  PositionCurrency,
  NominalAmountInNominalCurrency,
  BookValueAmtInPositionCurrency
FROM P_DebtInvestmentNominal
LEFT OUTER JOIN I_FinancialTransaction AS _FinancialTransaction ON FinancialTransaction = _FinancialTransaction.FinancialTransaction AND CompanyCode = _FinancialTransaction.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _FinancialInstrProductType ON FinancialInstrumentProductType = _FinancialInstrProductType.FinancialInstrumentProductType  -- association [1..1]
LEFT OUTER JOIN I_FinancialInstrTransType AS _FinancialInstrTransType ON FinancialInstrumentProductType = _FinancialInstrTransType.FinancialInstrumentProductType AND financialinstrtransactiontype = _FinancialInstrTransType.FinancialInstrTransactionType  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_TrsyCshFlowDebtInvmtCode AS _TrsyCshFlowDebtInvmtCode ON TrsyCshFlowDebtInvmtCode = _TrsyCshFlowDebtInvmtCode.TrsyCshFlowDebtInvmtCode  -- association [1..1]
;