I_FinTransAdditionalAttribute

DDL: I_FINTRANSADDITIONALATTRIBUTE SQL: IFINTRADDATTR Type: view COMPOSITE
27 Fields 1 Data Sources 1 Associations

Financial Trans Additional Attribute

I_FinTransAdditionalAttribute is a Composite CDS View that provides data about "Financial Trans Additional Attribute" in SAP S/4HANA. It reads from 1 data source (I_FinancialTransaction) and exposes 27 fields with key fields CompanyCode, FinancialTransaction. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FinancialTransaction FinancialTransaction from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFINTRADDATTR view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Financial Trans Additional Attribute view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinancialTransaction CompanyCode Receiver Company Code
KEY FinancialTransaction I_FinancialTransaction FinancialTransaction Transaction
FinancialInstrProductCategory I_FinancialTransaction FinancialInstrProductCategory
FinTransGeneralValuationClass I_FinancialTransaction FinTransGeneralValuationClass Gen. Valn Class
Portfolio I_FinancialTransaction Portfolio Portfolio
TreasuryFinanceProject I_FinancialTransaction TreasuryFinanceProject Finance Project
FinancialInstrumentAssignment I_FinancialTransaction FinancialInstrumentAssignment
FinancialInstrumentReference I_FinancialTransaction FinancialInstrumentReference
FinancialInstrCharacteristic I_FinancialTransaction FinancialInstrCharacteristic Characteristics
Fund I_FinancialTransaction Fund Sender Fund
GrantID I_FinancialTransaction GrantID Sender Grant
FinTransIsRiskMitigating I_FinancialTransaction FinTransIsRiskMitigating Risk Mitigation
FinancialInstrumentGuarantor I_FinancialTransaction FinancialInstrumentGuarantor Guarantor
TreasuryFacility I_FinancialTransaction TreasuryFacility Facility
TreasuryFacilityCompanyCode I_FinancialTransaction TreasuryFacilityCompanyCode CoCd of Facility
FinTransAuthorizationGroup I_FinancialTransaction FinTransAuthorizationGroup Authoriz. Group
BusinessPlace I_FinancialTransaction BusinessPlace Business place
CostCenter I_FinancialTransaction CostCenter Cost Center
ProfitCenter I_FinancialTransaction ProfitCenter Profit Center
FunctionalArea I_FinancialTransaction FunctionalArea Sendr Fctl Area
WBSElementInternalID I_FinancialTransaction WBSElementInternalID WBS Internal ID
TrsyPosCustomDiffntnTerm1 I_FinancialTransaction TrsyPosCustomDiffntnTerm1 Cust.Diff.Term Val.
TrsyPosCustomDiffntnTerm2 I_FinancialTransaction TrsyPosCustomDiffntnTerm2 Cust.Diff.Term Val.
TrsyPosCustomDiffntnTerm3 I_FinancialTransaction TrsyPosCustomDiffntnTerm3 Cust.Diff.Term Val.
TrsyPosCustomDiffntnTerm4 I_FinancialTransaction TrsyPosCustomDiffntnTerm4 Cust.Diff.Term Val.
TrsyPosCustomDiffntnTerm5 I_FinancialTransaction TrsyPosCustomDiffntnTerm5 Cust.Diff.Term Val.
_FinancialTransaction _FinancialTransaction

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_FinTransAdditionalAttribute.
-- 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: IFINTRADDATTR

CREATE VIEW I_FinTransAdditionalAttribute AS
SELECT
  FinancialTransaction.CompanyCode AS CompanyCode,
  FinancialTransaction.FinancialTransaction AS FinancialTransaction,
  FinancialTransaction.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  FinancialTransaction.FinTransGeneralValuationClass AS FinTransGeneralValuationClass,
  FinancialTransaction.Portfolio AS Portfolio,
  FinancialTransaction.TreasuryFinanceProject AS TreasuryFinanceProject,
  FinancialTransaction.FinancialInstrumentAssignment AS FinancialInstrumentAssignment,
  FinancialTransaction.FinancialInstrumentReference AS FinancialInstrumentReference,
  FinancialTransaction.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
  FinancialTransaction.Fund AS Fund,
  FinancialTransaction.GrantID AS GrantID,
  FinancialTransaction.FinTransIsRiskMitigating AS FinTransIsRiskMitigating,
  FinancialTransaction.FinancialInstrumentGuarantor AS FinancialInstrumentGuarantor,
  FinancialTransaction.TreasuryFacility AS TreasuryFacility,
  FinancialTransaction.TreasuryFacilityCompanyCode AS TreasuryFacilityCompanyCode,
  FinancialTransaction.FinTransAuthorizationGroup AS FinTransAuthorizationGroup,
  FinancialTransaction.BusinessPlace AS BusinessPlace,
  FinancialTransaction.CostCenter AS CostCenter,
  FinancialTransaction.ProfitCenter AS ProfitCenter,
  FinancialTransaction.FunctionalArea AS FunctionalArea,
  FinancialTransaction.WBSElementInternalID AS WBSElementInternalID,
  FinancialTransaction.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  FinancialTransaction.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  FinancialTransaction.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  FinancialTransaction.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  FinancialTransaction.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5
FROM I_FinancialTransaction AS FinancialTransaction
LEFT OUTER JOIN I_FinTransOverallView AS _FinancialTransaction ON CompanyCode = _FinancialTransaction.CompanyCode AND FinancialTransaction = _FinancialTransaction.FinancialTransaction  -- association [1..1]
;

Learn More