@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALTRANSACTION"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[
"I_FINANCIALTRANSACTION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/