R_FinTransCndnSingleDateTP

DDL: R_FINTRANSCNDNSINGLEDATETP Type: view_entity TRANSACTIONAL Package: RAP_FIN_TRM_TM_FT
24 Fields 1 Data Sources 1 Associations

Fin Trans Condition Single Date - TP

R_FinTransCndnSingleDateTP is a Transactional CDS View that provides data about "Fin Trans Condition Single Date - TP" in SAP S/4HANA. It reads from 1 data source (I_FinTransCndnSingleDate) and exposes 24 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, FinConditionItem. It has 1 association to related views. Part of development package RAP_FIN_TRM_TM_FT.

Data Sources (1)

SourceAliasJoin Type
I_FinTransCndnSingleDate I_FinTransCndnSingleDate from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_FinancialTransactionTP _FinancialTransaction $projection.CompanyCode = _FinancialTransaction.CompanyCode and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Fin Trans Condition Single Date - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FinancialTransaction FinancialTransaction Transaction
KEY FinancialInstrumentActivity FinancialInstrumentActivity
KEY FinancialTransactionDirection FinancialTransactionDirection
KEY FinConditionItem FinConditionItem
KEY ConditionItemValidityStartDate ConditionItemValidityStartDate
KEY FinConditionSubItem FinConditionSubItem
FinConditionConditionCategory FinConditionConditionCategory
CalculationDate CalculationDate
CalcDateIsAsEndDateMonthEnd CalcDateIsAsEndDateMonthEnd
DueDate DueDate Promised For
DueDateIsAsEndDateMonthEnd DueDateIsAsEndDateMonthEnd
ConditionPercentageRate ConditionPercentageRate
FinConditionFixedAmount FinConditionFixedAmount
FinConditionFixedAmountCrcy FinConditionFixedAmountCrcy
InterestRateAdjustmentDate InterestRateAdjustmentDate
IntrstRateAdjmtDateIsMonthEnd IntrstRateAdjmtDateIsMonthEnd
FinancialInstrProductCategory FinancialInstrProductCategory
_CompanyCode _CompanyCode
_Activity _Activity
_Direction _Direction
_FinancialTransaction _FinancialTransaction
_Condition _Condition
_FinTrans _FinTrans

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_FinTransCndnSingleDateTP.
-- 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_FinTransCndnSingleDateTP AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinancialInstrumentActivity,
  FinancialTransactionDirection,
  FinConditionItem,
  ConditionItemValidityStartDate,
  FinConditionSubItem,
  FinConditionConditionCategory,
  CalculationDate,
  CalcDateIsAsEndDateMonthEnd,
  DueDate,
  DueDateIsAsEndDateMonthEnd,
  ConditionPercentageRate,
  FinConditionFixedAmount,
  FinConditionFixedAmountCrcy,
  InterestRateAdjustmentDate,
  IntrstRateAdjmtDateIsMonthEnd,
  FinancialInstrProductCategory
FROM I_FinTransCndnSingleDate
LEFT OUTER JOIN R_FinancialTransactionTP AS _FinancialTransaction ON CompanyCode = _FinancialTransaction.CompanyCode AND FinancialTransaction = _FinancialTransaction.FinancialTransaction  -- association [1..1]
;

Learn More