R_FinancialTransactionNPVTP

DDL: R_FINANCIALTRANSACTIONNPVTP Type: view_entity TRANSACTIONAL
30 Fields 1 Data Sources

Fin Transaction Net Present Value - TP

R_FinancialTransactionNPVTP is a Transactional CDS View that provides data about "Fin Transaction Net Present Value - TP" in SAP S/4HANA. It reads from 1 data source (R_FinancialTransactionNPV) and exposes 30 fields with key fields CompanyCode, FinancialTransaction, FinancialTransactionNPVType, NetPresentValueValidityDate.

Data Sources (1)

SourceAliasJoin Type
R_FinancialTransactionNPV R_FinancialTransactionNPV from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Fin Transaction Net Present Value - TP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name FinancialTransactionNPV view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FinancialTransaction FinancialTransaction Transaction
KEY FinancialTransactionNPVType FinancialTransactionNPVType Price / NPV Type
KEY NetPresentValueValidityDate NetPresentValueValidityDate Effective From
TreasuryContractType TreasuryContractType Treasury Contract Type
NetPresentValueAmountInNPVCrcy NetPresentValueAmountInNPVCrcy Net Present Value
NetPresentValueCurrency NetPresentValueCurrency Currency of NPV
IntrinsicValueAmountInNPVCrcy IntrinsicValueAmountInNPVCrcy Intr. Value
TimeValueAmountInNPVCrcy TimeValueAmountInNPVCrcy Time Value
CleanPriceAmountInNPVCrcy CleanPriceAmountInNPVCrcy Clean Price
IncomingNPVAmountInNPVCrcy IncomingNPVAmountInNPVCrcy NPV-Incoming Side
OutgoingNPVAmountInNPVCrcy OutgoingNPVAmountInNPVCrcy NPV-Outgoing Side
RiskFreeNPVAmountInNPVCrcy RiskFreeNPVAmountInNPVCrcy Risk-Free NPV
CreditValueAdjmtAmtInNPVCrcy CreditValueAdjmtAmtInNPVCrcy CVA
DebitValueAdjmtAmtInNPVCrcy DebitValueAdjmtAmtInNPVCrcy DVA
CreditValueAdjustmentType CreditValueAdjustmentType CVA/DVA Type
CreatedByUser CreatedByUser User Name
CreationTransactionCode CreationTransactionCode Creation TCode
FinTransNPVCreationDate FinTransNPVCreationDate First Enterd On
FinTransNPVCreationTime FinTransNPVCreationTime Time
LastChangedByUser LastChangedByUser User Name
ChangeTransactionCode ChangeTransactionCode Change Tcode
FinTransNPVChangeDate FinTransNPVChangeDate Last Edited On
FinTransNPVChangeTime FinTransNPVChangeTime Last Edited At
FinTransNPVLastChangeDateTime
FinTransNPVCalculationLogUUID FinTransNPVCalculationLogUUID Log GUID
FinancialTransactionNPVHash FinancialTransactionNPVHash Hash Value
_CompanyCode _CompanyCode
_FinancialTransaction _FinancialTransaction
_NPVType _NPVType

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_FinancialTransactionNPVTP.
-- 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_FinancialTransactionNPVTP AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinancialTransactionNPVType,
  NetPresentValueValidityDate,
  TreasuryContractType,
  NetPresentValueAmountInNPVCrcy,
  NetPresentValueCurrency,
  IntrinsicValueAmountInNPVCrcy,
  TimeValueAmountInNPVCrcy,
  CleanPriceAmountInNPVCrcy,
  IncomingNPVAmountInNPVCrcy,
  OutgoingNPVAmountInNPVCrcy,
  RiskFreeNPVAmountInNPVCrcy,
  CreditValueAdjmtAmtInNPVCrcy,
  DebitValueAdjmtAmtInNPVCrcy,
  CreditValueAdjustmentType,
  CreatedByUser,
  CreationTransactionCode,
  FinTransNPVCreationDate,
  FinTransNPVCreationTime,
  LastChangedByUser,
  ChangeTransactionCode,
  FinTransNPVChangeDate,
  FinTransNPVChangeTime,
  cast( coalesce( FinTransNPVChangeDateTime, FinTransNPVCreationDateTime ) as ftr_npv_last_change_tstmp preserving type ) AS FinTransNPVLastChangeDateTime,
  FinTransNPVCalculationLogUUID,
  FinancialTransactionNPVHash
FROM R_FinancialTransactionNPV
;

Learn More