R_FinancialTransactionNPVDraft

DDL: R_FINANCIALTRANSACTIONNPVDRAFT Type: view_entity BASIC Package: FTR_NPV_IMPL
35 Fields 1 Data Sources 1 Associations

Financial Transaction NPV

R_FinancialTransactionNPVDraft is a Basic CDS View that provides data about "Financial Transaction NPV" in SAP S/4HANA. It reads from 1 data source (ftr_npv_d) and exposes 35 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
ftr_npv_d ftr_npv_d from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix NEX view
AbapCatalog.extensibility.quota.maximumFields 100 view
AbapCatalog.extensibility.quota.maximumBytes 100000 view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Financial Transaction NPV view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (35)

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 fintransnpvlastchangedatetime Last changed
FinTransNPVCalculationLogUUID fintransnpvcalculationloguuid Log GUID
FinancialTransactionNPVHash financialtransactionnpvhash Hash Value
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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_FinancialTransactionNPVDraft.
-- 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_FinancialTransactionNPVDraft 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,
  FinTransNPVLastChangeDateTime,
  FinTransNPVCalculationLogUUID,
  FinancialTransactionNPVHash,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM ftr_npv_d
LEFT OUTER JOIN E_FinancialTransactionNPVDraft AS _Extension ON CompanyCode = _Extension.CompanyCode AND FinancialTransaction = _Extension.FinancialTransaction AND FinancialTransactionNPVType = _Extension.FinancialTransactionNPVType AND NetPresentValueValidityDate = _Extension.NetPresentValueValidityDate  -- association [1..1]
;

Learn More