P_FinTransFinancialObjectData

DDL: P_FINTRANSFINANCIALOBJECTDATA Type: view COMPOSITE Package: FTR_ANALYZER_GENERAL_CORE

Financial Transaction - Financial Object Data

P_FinTransFinancialObjectData is a Composite CDS View that provides data about "Financial Transaction - Financial Object Data" in SAP S/4HANA. It reads from 1 data source (I_FinancialTransaction) and exposes 38 fields with key fields CompanyCode, FinancialTransaction. Part of development package FTR_ANALYZER_GENERAL_CORE.

Data Sources (1)

SourceAliasJoin Type
I_FinancialTransaction I_FinancialTransaction from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PFINTRANFODAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FinancialTransaction FinancialTransaction
TreasuryFinancialObject TreasuryFinancialObject
CreatedByUser CreatedByUser
FinTransCreationDate FinTransCreationDate
FinTransCreationTime FinTransCreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
FinInstrumentLastChangedTime FinInstrumentLastChangedTime
TreasuryContractType TreasuryContractType
FinancialInstrProductCategory FinancialInstrProductCategory
FinancialInstrumentProductType FinancialInstrumentProductType
FinInstrTransactionCategory FinInstrTransactionCategory
FinancialInstrTransactionType FinancialInstrTransactionType
FinTransProcessingCategory FinTransProcessingCategory
TermStartDate TermStartDate
TermStartDateIsInclusive TermStartDateIsInclusive
FinTransNoticePeriod FinTransNoticePeriod
FinTransNoticePeriodUnit FinTransNoticePeriodUnit
FinTransFactoryCalendar1 FinTransFactoryCalendar1
FinTransFactoryCalendar2 FinTransFactoryCalendar2
Counterparty Counterparty
FinancialInstrumentGuarantor FinancialInstrumentGuarantor
Portfolio Portfolio
TreasuryFinanceProject TreasuryFinanceProject
FinancialInstrumentAssignment FinancialInstrumentAssignment
FinancialInstrumentReference FinancialInstrumentReference
FinancialInstrCharacteristic FinancialInstrCharacteristic
TransactionCurrency TransactionCurrency
FinInstrumentOutgoingCurrency FinInstrumentOutgoingCurrency
FinInstrumentIncomingCurrency FinInstrumentIncomingCurrency
TradedCurrency TradedCurrency
SecurityClass SecurityClass
SecurityAccount SecurityAccount
TermEndDate TermEndDate
_Currency _Currency
_IncomingCurrency _IncomingCurrency
_OutgoingCurrency _OutgoingCurrency
@AbapCatalog: { sqlViewName:            'PFINTRANFODAT',
                compiler.compareFilter: true,
                preserveKey:            true,
                buffering: { status:    #NOT_ALLOWED } }

@AccessControl: { authorizationCheck: #NOT_REQUIRED,  // SubVal selects with 'PRIVILEGED ACCESS'

                  personalData.blocking: #NOT_REQUIRED }

@Metadata.ignorePropagatedAnnotations:true

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: { usageType.dataClass:      #TRANSACTIONAL,
                usageType.serviceQuality: #D,
                usageType.sizeCategory:   #M,
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE  ] }

@VDM: { viewType: #COMPOSITE,
        private:  true }
define view P_FinTransFinancialObjectData
  as select from I_FinancialTransaction
{
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_CompanyCodeStdVH',
                                                    element: 'CompanyCode' }}]
  key CompanyCode,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinancialTransactionStdVH',
                                                   element: 'FinancialTransaction' }}]
  key FinancialTransaction,
      TreasuryFinancialObject,

      CreatedByUser,
      FinTransCreationDate,
      FinTransCreationTime,
      LastChangedByUser,
      LastChangeDate,
      FinInstrumentLastChangedTime,

      TreasuryContractType,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinancialInstrProdCat',
                                                     element: 'FinancialInstrProductCategory' }}]
      FinancialInstrProductCategory,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinancialInstrProductType',
                                                     element: 'FinancialInstrumentProductType' }}]
      FinancialInstrumentProductType,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinInstrTranscat',
                                                     element: 'FinInstrTransactionCategory' }}]
      FinInstrTransactionCategory,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinancialInstrTransType',
                                                     element: 'FinancialInstrTransactionType' }}]
      FinancialInstrTransactionType,
      FinTransProcessingCategory,

      TermStartDate,
      TermStartDateIsInclusive,

      FinTransNoticePeriod,
      FinTransNoticePeriodUnit,
      FinTransFactoryCalendar1,
      FinTransFactoryCalendar2,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinTransacCounterPartyStdVH',
                                                     element: 'BusinessPartner' }}]
      Counterparty,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinTransacCounterPartyStdVH',
                                                     element: 'BusinessPartner' }}]
      FinancialInstrumentGuarantor,

      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_TreasuryPortfolio',
                                                     element: 'Portfolio' }}]
      Portfolio,
      TreasuryFinanceProject,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinancialInstrAssignment',
                                                     element: 'FinancialInstrumentAssignment' }}]
      FinancialInstrumentAssignment,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinancialInstrReference',
                                                     element: 'FinancialInstrumentReference' }}]
      FinancialInstrumentReference,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_FinancialInstrCharacteristic',
                                                     element: 'FinancialInstrCharacteristic' }}]
      FinancialInstrCharacteristic,
      // TreasuryValuationClass,

      // BusinessArea,

      // ControllingArea,

      // CostCenter,

      // HedgingClassification,

      // ProfitCenter,

      // WBSElementInternalID,

      // TreasuryFacilityCompanyCode,

      // TreasuryFacility,

      // FinancialInstrumentStatus,

      // FinTransReleaseStatus,

      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_CurrencyStdVH',
                                                     element: 'Currency' }}]
      TransactionCurrency,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_CurrencyStdVH',
                                                     element: 'Currency' }}]
      FinInstrumentOutgoingCurrency,
      @Consumption.valueHelpDefinition: [{ entity: { name:    'I_CurrencyStdVH',
                                                     element: 'Currency' }}]
      FinInstrumentIncomingCurrency,
      TradedCurrency,

      // @Consumption.valueHelpDefinition: [{ entity: { name:    'I_SecurityClassStdVH',

      //                                                element: 'SecurityClass' }}]

      SecurityClass,
      // SecurityClassIntlScrtyIdnNmbr,

      // ClassificationOfFinInstr,

      // @Consumption.valueHelpDefinition: [{ entity: { name:    'I_SecurityAccountStdVH',

      //                                                element: 'SecurityAccount' }}]

      SecurityAccount,
      // FuturesAccount,

      // FinTransCentralClearingOption,

      // FinTransCentralClearingStatus,

      // FinTransCentralClearingDate,

      // FinTransCntrlClrgActualDate,

      // CentralClearingAccount,

      // FinTransIsRiskMitigating,

      // FinInstrLastActiveActivity,

      TermEndDate,

      /* Associations */
      // _Assignment,

      // _BusinessArea,

      // _Calendar,

      // _Calendar2,

      // _CentralClearingAccount,

      // _CentralClearingOption,

      // _CentralClearingStatus,

      // _Characteristics,

      // _CompanyCode,

      // _ContractActivity,

      // _ContractType,

      // _ControllingArea,

      // _CostCenter,

      // _CostCenter_2,

      // _Counterparty,

      _Currency,
      // _CurrentActivity,

      // _FacilityCompanyCode,

      // _FinancialInstrProdCat,

      // _FinancialInstrProdType,

      // _FinancialInstrTransType,

      // _FinInstrTransCat,

      // _FuturesAccount,

      // _Guarantor,

      _IncomingCurrency,
      // _Interest,

      // _LetterOfCredit,

      // _Nominal,

      // _NoticePeriodUnit,

      _OutgoingCurrency
      // _Portfolio

      // _ProcessingCategory,

      // _ProfitCenter,

      // _ProfitCenter_2,

      // _Reference,

      // _ReleaseStatus,

      // _Security,

      // _SecurityAccount,

      // _SecurityClass

      // _Status,

      // _TabActivity,

      // _TabCondition,

      // _TabFlow,

      // _TradedCurrency,

      // _TreasuryHedgingClassfctn,

      // _ValuationClass,

      // _WBSElement

}