C_FinancialTransactionNPVTP

DDL: C_FINANCIALTRANSACTIONNPVTP Type: view_entity CONSUMPTION Package: FTR_NPV_IMPL

Financial Transaction Net Present Value

C_FinancialTransactionNPVTP is a Consumption CDS View that provides data about "Financial Transaction Net Present Value" in SAP S/4HANA. It reads from 1 data source (R_FinancialTransactionNPVTP) and exposes 36 fields with key fields CompanyCode, FinancialTransaction, FinancialTransactionNPVType, NetPresentValueValidityDate. It is exposed through 2 OData services (ASQL_F7601, UI_FINTRANSACTIONNPV_MNG). It is used in 1 Fiori application: Manage Net Present Values. Part of development package FTR_NPV_IMPL.

Data Sources (1)

SourceAliasJoin Type
R_FinancialTransactionNPVTP R_FinancialTransactionNPVTP projection

Annotations (14)

NameValueLevelField
EndUserText.label Financial Transaction Net Present Value view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Search.searchable true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix NEX view
AbapCatalog.extensibility.quota.maximumFields 200 view
AbapCatalog.extensibility.quota.maximumBytes 20000 view
AccessControl.personalData.blocking #NOT_REQUIRED view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7601 ASQL_F7601 C2 NOT_RELEASED
UI_FINTRANSACTIONNPV_MNG UI_FINTRANSACTIONNPV_MNG V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F7601 Manage Net Present Values Transactional With this app, you can manage your net present values.

Manage Net Present Values

Business Role: Treasury Specialist - Back Office

With this app, you can manually enter net present values (NPVs) of financial transactions as well as display, change, and delete existing NPVs in the NPV table. The NPV of a financial transaction is the calculated value of a financial transaction on a specific date based on market data. Which calculation method is applied depends on the type of financial transaction. For most transactions, the NPV is determined by discounting the future cash flows. However, different calculation methods are used for options. The NPV calculation of financial transactions is a method of determining the fair value of a financial transaction on a specific date as required by accounting principles. The NPVs in the NPV table are either externally calculated NPVs that have been entered manually or via an API into the NPV table or NPVs that have been calculated by the system using the Calculate Net Present Values - With CVA and DVA app.

Key Features: Display Net Present Value Data The app displays the NPV data of financial transactions that are stored in the NPV table. The app provides an overview list of the NPV data selected as well as navigation to the details page for each entry in the NPV overview table. Detail Log For NPV data calculated by the system (using the Calculate Net Present Values - With CVA and DVA app), the app provides the Detail Log. The Detail Log shows calculation details and results as well as the calculation parameters and market data values (such as Evaluation Type, FX Rates, Yield Curves, Credit Spreads) that are used to calculate the NPV key figures and components. Display Transaction Details You can use the Transaction Details button to jump to the financial transaction for which the NPV data has been entered. Enter Net Present Value Data Choose the Create button to enter the NPV data for a financial transaction. Enter the header data: Choose the financial transaction using the value help available for the Transaction field. The value help provides several fields, such as Company Code, Product Type, Transaction Type, Counterparty, Created By, and Created On, as filters for selecting the financial transaction. After you choose a transaction, the Company Code field is filled automatically. Choose the price/NPV type. Enter the effective-from date. If you want to enter different NPVs for a financial transaction on the same date, you must enter them with different price/NPV types. Enter the NPV details. When you enter the NPV data manually for a financial transaction, the system validates the data entered: If either the CVA or the DVA field is filled for the NPV of a financial transaction, the NPV key figures must satisfy the following formula: NPV = risk-free NPV – CVA – DVA NPV data for options If the intrinsic value or time value is entered, the NPV key figures must satisfy the following formula: NPV = intrinsic value + time value Note To speed up data entry, you can use the Copy function. Change Net Present Values You can change the NPV data entered. Delete Net Present Values You can delete NPV data. Change Documents The creation of NPVs, changes made to NPV data, and the deletion of a data record from the NPV table are documented in the change documents for change document object FTR_NPV Manage Net Present Values. You can see change documents on the Change History tab. For the change type Insert, only the user who created the NPV data record and the date and time when it was created are stored in the change document. Change documents for the change type Change store the fields in which a change was made, the new and old values of those fields, the user who made the change, and the date and time of the change. Note To display change documents for the change type Delete (Single-Field Documentation) for deleted NPV records, use the Display Change Documents app. You can also add additional columns to the table using the  Settings button. From the list, you can select additional fields, such as Table Name or Change Document Number, that you want to be shown in the table. If not all chosen columns are visible, you can use the  Show More per Row button to display all details. You can switch back to the default view using the Show Less per Row button. Note Change documents are written in the system time zone. On the Change History tab, the system converts the times into the time zone of the user in accordance with their SAP Fiori launchpad settings. You can display the change documents using the Display Change Documents app. For more information, see also Show Change Documents.

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
CompanyCodeName _CompanyCode CompanyCodeName Company Name
FinancialTransactionNPVTypeTxtlocalized
NetPresentValueCurrency NetPresentValueCurrency Currency of NPV
NetPresentValueAmountInNPVCrcy NetPresentValueAmountInNPVCrcy Net Present Value
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
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _UserCreate UserDescription Full Name
CreationTransactionCode CreationTransactionCode Creation TCode
FinTransNPVCreationDateTime FinTransNPVCreationDateTime Creation timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _UserLastChange UserDescription Full Name
ChangeTransactionCode ChangeTransactionCode Change Tcode
FinTransNPVChangeDateTime FinTransNPVChangeDateTime Changed at timestamp
FinTransNPVLastChangeDateTime FinTransNPVLastChangeDateTime Last changed
FinTransNPVCalculationLogUUID FinTransNPVCalculationLogUUID Log GUID
Counterparty _FinancialTransaction Counterparty Supplier
BusinessPartnerName
FinancialInstrumentProductType _FinancialTransaction FinancialInstrumentProductType
FinancialInstrProdTypeNamelocalized
TermEndDate
FinancialInstrumentStatus _FinancialTransaction FinancialInstrumentStatus
FinancialInstrumentStatusNamelocalized
_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 C_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 C_FinancialTransactionNPVTP AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinancialTransactionNPVType,
  NetPresentValueValidityDate,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _NPVType._Text.FinancialTransactionNPVTypeTxt : localized AS FinancialTransactionNPVTypeTxtlocalized,
  NetPresentValueCurrency,
  NetPresentValueAmountInNPVCrcy,
  IntrinsicValueAmountInNPVCrcy,
  TimeValueAmountInNPVCrcy,
  CleanPriceAmountInNPVCrcy,
  IncomingNPVAmountInNPVCrcy,
  OutgoingNPVAmountInNPVCrcy,
  RiskFreeNPVAmountInNPVCrcy,
  CreditValueAdjmtAmtInNPVCrcy,
  DebitValueAdjmtAmtInNPVCrcy,
  CreatedByUser,
  _UserCreate.UserDescription AS CreatedByUserDescription,
  CreationTransactionCode,
  FinTransNPVCreationDateTime,
  LastChangedByUser,
  _UserLastChange.UserDescription AS LastChangedByUserDescription,
  ChangeTransactionCode,
  FinTransNPVChangeDateTime,
  FinTransNPVLastChangeDateTime,
  FinTransNPVCalculationLogUUID,
  _FinancialTransaction.Counterparty AS Counterparty,
  cast( _FinancialTransaction._Counterparty.BusinessPartnerName as ftr_npv_business_partner_name preserving type ) AS BusinessPartnerName,
  _FinancialTransaction.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  _FinancialTransaction._FinancialInstrProdType._Text.FinancialInstrProdTypeName : localized AS FinancialInstrProdTypeNamelocalized,
  _FinancialTransaction._CurrentActivity.TermEndDate AS TermEndDate,
  _FinancialTransaction.FinancialInstrumentStatus AS FinancialInstrumentStatus,
  _FinancialTransaction._Status._Text.FinancialInstrumentStatusName : localized AS FinancialInstrumentStatusNamelocalized
FROM R_FinancialTransactionNPVTP
;