P_FinTransFinancialObjectData
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)
| Source | Alias | Join Type |
|---|---|---|
| I_FinancialTransaction | I_FinancialTransaction | from |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA