R_FinancialTransactionTP

DDL: R_FINANCIALTRANSACTIONTP Type: view_entity TRANSACTIONAL
32 Fields 1 Data Sources 9 Associations

Financial Transaction

R_FinancialTransactionTP is a Transactional CDS View that provides data about "Financial Transaction" in SAP S/4HANA. It reads from 1 data source (I_FinTransOverallView) and exposes 32 fields with key fields CompanyCode, FinancialTransaction. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FinTransOverallView I_FinTransOverallView from

Associations (9)

CardinalityTargetAliasCondition
[1..*] I_FinTransInterestCondition _InterestCondition $projection.CompanyCode = _InterestCondition.CompanyCode and $projection.FinancialTransaction = _InterestCondition.FinancialTransaction
[0..*] I_FinTransInterestAdjmtCndn _AdjustmentCondition $projection.CompanyCode = _AdjustmentCondition.CompanyCode and $projection.FinancialTransaction = _AdjustmentCondition.FinancialTransaction
[0..*] I_FinTransRepaymentCndn _RepaymentCondition $projection.CompanyCode = _RepaymentCondition.CompanyCode and $projection.FinancialTransaction = _RepaymentCondition.FinancialTransaction
[0..*] I_FinTransAccumulatingCndn _AccumulatingCondition $projection.CompanyCode = _AccumulatingCondition.CompanyCode and $projection.FinancialTransaction = _AccumulatingCondition.FinancialTransaction
[0..*] I_FinTransAccruedIntrstCndn _AccruedCondition $projection.CompanyCode = _AccruedCondition.CompanyCode and $projection.FinancialTransaction = _AccruedCondition.FinancialTransaction
[1..1] R_FinTransAttributeTP _Attribute
[1..1] R_FinTransAddlAttributeTP _AdditionalAttribute
[1..*] R_FinTransMainFlowTP _MainFlow
[0..*] R_FinTransAdditionalFlowTP _AdditionalFlow

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Financial Transaction view
ObjectModel.representativeKey FinancialTransaction view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FinancialTransaction FinancialTransaction Transaction
FinancialInstrProductCategory FinancialInstrProductCategory
FinancialInstrumentActivity FinancialInstrumentActivity
FinancialInstrumentStatus FinancialInstrumentStatus
Counterparty Counterparty Supplier
FinTransActyConclusionDate FinTransActyConclusionDate
FinTransActyConclusionTime FinTransActyConclusionTime
FinTransActyConclusionTimeZone FinTransActyConclusionTimeZone
FinInstrExternalReference FinInstrExternalReference
MarketIdentifierCode MarketIdentifierCode MIC
Trader Trader Trader
FinancialInstrContactPerson FinancialInstrContactPerson
CreatedByUser CreatedByUser User Name
FinTransCreationDate FinTransCreationDate
FinTransCreationTime FinTransCreationTime
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
FinInstrumentLastChangedTime FinInstrumentLastChangedTime
FinancialInstrumentProductType FinancialInstrumentProductType
FinancialInstrTransactionType FinancialInstrTransactionType
TradeLegalBasis TradeLegalBasis
ExternalTradeIdentifier ExternalTradeIdentifier
_Attribute _Attribute
_AdditionalAttribute _AdditionalAttribute
_MainFlow _MainFlow
_AdditionalFlow _AdditionalFlow
_InterestCondition _InterestCondition
_AdjustmentCondition _AdjustmentCondition
_RepaymentCondition _RepaymentCondition
_AccumulatingCondition _AccumulatingCondition
_AccruedCondition _AccruedCondition

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_FinancialTransactionTP.
-- 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_FinancialTransactionTP AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinancialInstrProductCategory,
  FinancialInstrumentActivity,
  FinancialInstrumentStatus,
  Counterparty,
  FinTransActyConclusionDate,
  FinTransActyConclusionTime,
  FinTransActyConclusionTimeZone,
  FinInstrExternalReference,
  MarketIdentifierCode,
  Trader,
  FinancialInstrContactPerson,
  CreatedByUser,
  FinTransCreationDate,
  FinTransCreationTime,
  LastChangedByUser,
  LastChangeDate,
  FinInstrumentLastChangedTime,
  FinancialInstrumentProductType,
  FinancialInstrTransactionType,
  TradeLegalBasis,
  ExternalTradeIdentifier
FROM I_FinTransOverallView
LEFT OUTER JOIN I_FinTransInterestCondition AS _InterestCondition ON CompanyCode = _InterestCondition.CompanyCode AND FinancialTransaction = _InterestCondition.FinancialTransaction  -- association [1..*]
LEFT OUTER JOIN I_FinTransInterestAdjmtCndn AS _AdjustmentCondition ON CompanyCode = _AdjustmentCondition.CompanyCode AND FinancialTransaction = _AdjustmentCondition.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_FinTransRepaymentCndn AS _RepaymentCondition ON CompanyCode = _RepaymentCondition.CompanyCode AND FinancialTransaction = _RepaymentCondition.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_FinTransAccumulatingCndn AS _AccumulatingCondition ON CompanyCode = _AccumulatingCondition.CompanyCode AND FinancialTransaction = _AccumulatingCondition.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_FinTransAccruedIntrstCndn AS _AccruedCondition ON CompanyCode = _AccruedCondition.CompanyCode AND FinancialTransaction = _AccruedCondition.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN R_FinTransAttributeTP AS _Attribute ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN R_FinTransAddlAttributeTP AS _AdditionalAttribute ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN R_FinTransMainFlowTP AS _MainFlow ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_FinTransAdditionalFlowTP AS _AdditionalFlow ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More