I_FinTransOverallView

DDL: I_FINTRANSOVERALLVIEW SQL: IFINTRANOVALL Type: view COMPOSITE Package: FTTR_CORE
34 Fields 2 Data Sources 9 Associations

Financial Transaction Overall

I_FinTransOverallView is a Composite CDS View that provides data about "Financial Transaction Overall" in SAP S/4HANA. It reads from 2 data sources (I_FinTransActivity, I_FinancialTransaction) and exposes 34 fields with key fields CompanyCode, FinancialTransaction. It has 9 associations to related views. Part of development package FTTR_CORE.

Data Sources (2)

SourceAliasJoin Type
I_FinTransActivity CurrentActivity inner
I_FinancialTransaction FinancialTransaction from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_FinTransAttribute _Attribute $projection.CompanyCode = _Attribute.CompanyCode and $projection.FinancialTransaction = _Attribute.FinancialTransaction
[1..1] I_FinTransAdditionalAttribute _AdditionalAttribute $projection.CompanyCode = _AdditionalAttribute.CompanyCode and $projection.FinancialTransaction = _AdditionalAttribute.FinancialTransaction
[1..*] I_FinTransMainFlow _MainFlow $projection.CompanyCode = _MainFlow.CompanyCode and $projection.FinancialTransaction = _MainFlow.FinancialTransaction
[0..*] I_FinTransAdditionalFlow _AdditionalFlow $projection.CompanyCode = _AdditionalFlow.CompanyCode and $projection.FinancialTransaction = _AdditionalFlow.FinancialTransaction
[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

Annotations (12)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFINTRANOVALL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Financial Transaction Overall view
ObjectModel.representativeKey FinancialTransaction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinancialTransaction CompanyCode Receiver Company Code
KEY FinancialTransaction I_FinancialTransaction FinancialTransaction Transaction
FinancialInstrProductCategory I_FinancialTransaction FinancialInstrProductCategory Prod. Category
FinancialInstrumentActivity I_FinTransActivity FinancialInstrumentActivity Activity
FinancialInstrumentStatus I_FinancialTransaction FinancialInstrumentStatus Active Status
Counterparty I_FinancialTransaction Counterparty Supplier
FinTransActyConclusionDate I_FinTransActivity FinTransActyConclusionDate
FinTransActyConclusionTime I_FinTransActivity FinTransActyConclusionTime ContrConcTime
FinTransActyConclusionTimeZone I_FinTransActivity FinTransActyConclusionTimeZone Time Zone Contr.Date
FinInstrExternalReference I_FinTransActivity FinInstrExternalReference ExtOrderNo
MarketIdentifierCode I_FinancialTransaction MarketIdentifierCode MIC
Trader I_FinTransActivity Trader Trader
FinancialInstrContactPerson I_FinTransActivity FinancialInstrContactPerson Contact Person
CreatedByUser I_FinancialTransaction CreatedByUser User Name
FinTransCreationDate I_FinancialTransaction FinTransCreationDate
FinTransCreationTime I_FinancialTransaction FinTransCreationTime Entry Time
LastChangedByUser I_FinancialTransaction LastChangedByUser User Name
LastChangeDate I_FinancialTransaction LastChangeDate Time Stamp
FinInstrumentLastChangedTime I_FinancialTransaction FinInstrumentLastChangedTime Time Changed
FinancialInstrumentProductType I_FinancialTransaction FinancialInstrumentProductType Product Type
FinancialInstrTransactionType I_FinancialTransaction FinancialInstrTransactionType
TradeLegalBasis TradeIdentifier TradeLegalBasis
ExternalTradeIdentifier TradeIdentifier ExternalTradeIdentifier
ClassificationOfFinInstr I_FinancialTransaction ClassificationOfFinInstr CFI Code
TreasuryFinancialObject I_FinancialTransaction TreasuryFinancialObject Val. Obj. No.
_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 I_FinTransOverallView.
-- 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.
-- SQL view name: IFINTRANOVALL

CREATE VIEW I_FinTransOverallView AS
SELECT
  FinancialTransaction.CompanyCode AS CompanyCode,
  FinancialTransaction.FinancialTransaction AS FinancialTransaction,
  FinancialTransaction.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  CurrentActivity.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  FinancialTransaction.FinancialInstrumentStatus AS FinancialInstrumentStatus,
  FinancialTransaction.Counterparty AS Counterparty,
  CurrentActivity.FinTransActyConclusionDate AS FinTransActyConclusionDate,
  CurrentActivity.FinTransActyConclusionTime AS FinTransActyConclusionTime,
  CurrentActivity.FinTransActyConclusionTimeZone AS FinTransActyConclusionTimeZone,
  CurrentActivity.FinInstrExternalReference AS FinInstrExternalReference,
  FinancialTransaction.MarketIdentifierCode AS MarketIdentifierCode,
  CurrentActivity.Trader AS Trader,
  CurrentActivity.FinancialInstrContactPerson AS FinancialInstrContactPerson,
  FinancialTransaction.CreatedByUser AS CreatedByUser,
  FinancialTransaction.FinTransCreationDate AS FinTransCreationDate,
  FinancialTransaction.FinTransCreationTime AS FinTransCreationTime,
  FinancialTransaction.LastChangedByUser AS LastChangedByUser,
  FinancialTransaction.LastChangeDate AS LastChangeDate,
  FinancialTransaction.FinInstrumentLastChangedTime AS FinInstrumentLastChangedTime,
  FinancialTransaction.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  FinancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  TradeIdentifier.TradeLegalBasis AS TradeLegalBasis,
  TradeIdentifier.ExternalTradeIdentifier AS ExternalTradeIdentifier,
  FinancialTransaction.ClassificationOfFinInstr AS ClassificationOfFinInstr,
  FinancialTransaction.TreasuryFinancialObject AS TreasuryFinancialObject
FROM I_FinancialTransaction AS FinancialTransaction
INNER JOIN I_FinTransActivity AS CurrentActivity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinTransAttribute AS _Attribute ON CompanyCode = _Attribute.CompanyCode AND FinancialTransaction = _Attribute.FinancialTransaction  -- association [1..1]
LEFT OUTER JOIN I_FinTransAdditionalAttribute AS _AdditionalAttribute ON CompanyCode = _AdditionalAttribute.CompanyCode AND FinancialTransaction = _AdditionalAttribute.FinancialTransaction  -- association [1..1]
LEFT OUTER JOIN I_FinTransMainFlow AS _MainFlow ON CompanyCode = _MainFlow.CompanyCode AND FinancialTransaction = _MainFlow.FinancialTransaction  -- association [1..*]
LEFT OUTER JOIN I_FinTransAdditionalFlow AS _AdditionalFlow ON CompanyCode = _AdditionalFlow.CompanyCode AND FinancialTransaction = _AdditionalFlow.FinancialTransaction  -- association [0..*]
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..*]
;

Learn More