I_FinTransAdditionalAttribute

DDL: I_FINTRANSADDITIONALATTRIBUTE SQL: IFINTRADDATTR Type: view COMPOSITE

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.

1 data source(s) 27 fields

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
KEY FinancialTransaction I_FinancialTransaction FinancialTransaction
FinancialInstrProductCategory I_FinancialTransaction FinancialInstrProductCategory
FinTransGeneralValuationClass I_FinancialTransaction FinTransGeneralValuationClass
Portfolio I_FinancialTransaction Portfolio
TreasuryFinanceProject I_FinancialTransaction TreasuryFinanceProject
FinancialInstrumentAssignment I_FinancialTransaction FinancialInstrumentAssignment
FinancialInstrumentReference I_FinancialTransaction FinancialInstrumentReference
FinancialInstrCharacteristic I_FinancialTransaction FinancialInstrCharacteristic
Fund I_FinancialTransaction Fund
GrantID I_FinancialTransaction GrantID
FinTransIsRiskMitigating I_FinancialTransaction FinTransIsRiskMitigating
FinancialInstrumentGuarantor I_FinancialTransaction FinancialInstrumentGuarantor
TreasuryFacility I_FinancialTransaction TreasuryFacility
TreasuryFacilityCompanyCode I_FinancialTransaction TreasuryFacilityCompanyCode
FinTransAuthorizationGroup I_FinancialTransaction FinTransAuthorizationGroup
BusinessPlace I_FinancialTransaction BusinessPlace
CostCenter I_FinancialTransaction CostCenter
ProfitCenter I_FinancialTransaction ProfitCenter
FunctionalArea I_FinancialTransaction FunctionalArea
WBSElementInternalID I_FinancialTransaction WBSElementInternalID
TrsyPosCustomDiffntnTerm1 I_FinancialTransaction TrsyPosCustomDiffntnTerm1
TrsyPosCustomDiffntnTerm2 I_FinancialTransaction TrsyPosCustomDiffntnTerm2
TrsyPosCustomDiffntnTerm3 I_FinancialTransaction TrsyPosCustomDiffntnTerm3
TrsyPosCustomDiffntnTerm4 I_FinancialTransaction TrsyPosCustomDiffntnTerm4
TrsyPosCustomDiffntnTerm5 I_FinancialTransaction TrsyPosCustomDiffntnTerm5
_FinancialTransaction _FinancialTransaction 
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.sqlViewName: 'IFINTRADDATTR'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Trans Additional Attribute'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE

define view I_FinTransAdditionalAttribute
  as select from I_FinancialTransaction as FinancialTransaction

  association [1..1] to I_FinTransOverallView as _FinancialTransaction on  $projection.CompanyCode          = _FinancialTransaction.CompanyCode
                                                                       and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction

{
  key  FinancialTransaction.CompanyCode,
  key  FinancialTransaction.FinancialTransaction,
       FinancialTransaction.FinancialInstrProductCategory,
       FinancialTransaction.FinTransGeneralValuationClass,
       FinancialTransaction.Portfolio,
       FinancialTransaction.TreasuryFinanceProject,
       FinancialTransaction.FinancialInstrumentAssignment,
       FinancialTransaction.FinancialInstrumentReference,
       FinancialTransaction.FinancialInstrCharacteristic,
       FinancialTransaction.Fund,
       FinancialTransaction.GrantID,
       FinancialTransaction.FinTransIsRiskMitigating,
       FinancialTransaction.FinancialInstrumentGuarantor,
       FinancialTransaction.TreasuryFacility,
       FinancialTransaction.TreasuryFacilityCompanyCode,
       FinancialTransaction.FinTransAuthorizationGroup,
       FinancialTransaction.BusinessPlace,
       FinancialTransaction.CostCenter,
       FinancialTransaction.ProfitCenter,
       FinancialTransaction.FunctionalArea,
       FinancialTransaction.WBSElementInternalID,
       FinancialTransaction.TrsyPosCustomDiffntnTerm1,
       FinancialTransaction.TrsyPosCustomDiffntnTerm2,
       FinancialTransaction.TrsyPosCustomDiffntnTerm3,
       FinancialTransaction.TrsyPosCustomDiffntnTerm4,
       FinancialTransaction.TrsyPosCustomDiffntnTerm5,

       _FinancialTransaction
}

Learn More