R_FinancialTransactionNPVTP

DDL: R_FINANCIALTRANSACTIONNPVTP Type: view_entity TRANSACTIONAL Package: FTR_NPV_IMPL
36 Fields 1 Data Sources 1 Associations

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 36 fields with key fields CompanyCode, FinancialTransaction, FinancialTransactionNPVType, NetPresentValueValidityDate. It has 1 association to related views. Part of development package FTR_NPV_IMPL.

Data Sources (1)

SourceAliasJoin Type
R_FinancialTransactionNPV R_FinancialTransactionNPV from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_FinancialTransactionNPV _Extension $projection.CompanyCode = _Extension.CompanyCode and $projection.FinancialTransaction = _Extension.FinancialTransaction and $projection.FinancialTransactionNPVType = _Extension.FinancialTransactionNPVType and $projection.NetPresentValueValidityDate = _Extension.NetPresentValueValidityDate

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Fin Transaction Net Present Value - TP view
ObjectModel.sapObjectNodeType.name FinancialTransactionNPV view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix NEX view
AbapCatalog.extensibility.quota.maximumFields 100 view
AbapCatalog.extensibility.quota.maximumBytes 100000 view

Fields (36)

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
FinTransNPVCreationDateTime FinTransNPVCreationDateTime Creation timestamp
FinTransNPVChangeDateTime FinTransNPVChangeDateTime Changed at timestamp
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
_NPVTypeText _NPVTypeText
_UserCreate _UserCreate
_UserLastChange _UserLastChange
_NPVCurrency _NPVCurrency

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,
  FinTransNPVCreationDateTime,
  FinTransNPVChangeDateTime,
  LastChangedByUser,
  ChangeTransactionCode,
  FinTransNPVChangeDate,
  FinTransNPVChangeTime,
  cast(coalesce(FinTransNPVChangeDateTime, FinTransNPVCreationDateTime) as ftr_npv_last_change_tstmp preserving type) AS FinTransNPVLastChangeDateTime,
  FinTransNPVCalculationLogUUID,
  FinancialTransactionNPVHash
FROM R_FinancialTransactionNPV
LEFT OUTER JOIN E_FinancialTransactionNPV AS _Extension ON CompanyCode = _Extension.CompanyCode AND FinancialTransaction = _Extension.FinancialTransaction AND FinancialTransactionNPVType = _Extension.FinancialTransactionNPVType AND NetPresentValueValidityDate = _Extension.NetPresentValueValidityDate  -- association [1..1]
;

Learn More