R_FinancialTransactionNPV

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 R_FinancialTransactionNPV.
-- 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 R_FinancialTransactionNPV AS
SELECT
  bukrs AS CompanyCode,
  rfha AS FinancialTransaction,
  okuart AS FinancialTransactionNPVType,
  databs AS NetPresentValueValidityDate,
  rantyp AS TreasuryContractType,
  cast( barwert as ftr_npv ) AS NetPresentValueAmountInNPVCrcy,
  wbarwert AS NetPresentValueCurrency,
  cast( intrinsic_value as ftr_npv_intrinsic_value ) AS IntrinsicValueAmountInNPVCrcy,
  cast( time_value as ftr_npv_time_value ) AS TimeValueAmountInNPVCrcy,
  cast( clean_price as ftr_npv_clean_price ) AS CleanPriceAmountInNPVCrcy,
  cast( barwert_in as ftr_npv_incoming ) AS IncomingNPVAmountInNPVCrcy,
  cast( barwert_out as ftr_npv_outgoing ) AS OutgoingNPVAmountInNPVCrcy,
  cast( barwert_rf as ftr_npv_riskfree ) AS RiskFreeNPVAmountInNPVCrcy,
  cva AS CreditValueAdjmtAmtInNPVCrcy,
  dva AS DebitValueAdjmtAmtInNPVCrcy,
  cva_type AS CreditValueAdjustmentType,
  create_name AS CreatedByUser,
  cast( create_tcode as ftr_npv_creation_tcode preserving type ) AS CreationTransactionCode,
  change_name AS LastChangedByUser,
  cast( change_tcode as ftr_npv_change_tcode preserving type ) AS ChangeTransactionCode,
  create_date AS FinTransNPVCreationDate,
  create_time AS FinTransNPVCreationTime,
  change_date AS FinTransNPVChangeDate,
  change_time AS FinTransNPVChangeTime,
  log_guid AS FinTransNPVCalculationLogUUID,
  check_sum AS FinancialTransactionNPVHash
FROM vtvbar
LEFT OUTER JOIN I_FinancialTransaction AS _FinancialTransaction ON CompanyCode = _FinancialTransaction.CompanyCode AND FinancialTransaction = _FinancialTransaction.FinancialTransaction  -- association [1..1]
LEFT OUTER JOIN I_FinancialTransactionNPVType AS _NPVType ON FinancialTransactionNPVType = _NPVType.FinancialTransactionNPVType  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_TreasuryContractType AS _TreasuryContractType ON TreasuryContractType = _TreasuryContractType.TreasuryContractType  -- association [1..1]
;