P_FinTransManageOption

DDL: P_FINTRANSMANAGEOPTION SQL: PFINTRNASMNGOPT Type: view COMPOSITE
46 Fields 1 Data Sources

P_FinTransManageOption is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_FinancialTransactionOption) and exposes 46 fields with key fields FinancialTransaction, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
P_FinancialTransactionOption Option from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFINTRNASMNGOPT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY FinancialTransaction P_FinancialTransactionOption FinancialTransaction Transaction
KEY CompanyCode P_FinancialTransactionOption CompanyCode Receiver Company Code
OptionExerciseType P_FinancialTransactionOption OptionExerciseType
OptionSettlementType P_FinancialTransactionOption OptionSettlementType
OptionExpirationDate P_FinancialTransactionOption OptionExpirationDate
OptionPutCallCode P_FinancialTransactionOption OptionPutCallCode
TermStartDate P_FinancialTransactionOption TermStartDate
Counterparty P_FinancialTransactionOption Counterparty Supplier
TermEndDate P_FinancialTransactionOption TermEndDate
OptionUnderlyingProductType
OptionUndrlgTransactionType
FinancialInstrProductCategory P_FinancialTransactionOption FinancialInstrProductCategory
OptnUndrlgTreasuryContractType P_FinancialTransactionOption OptnUndrlgTreasuryContractType Treasury Contract Type
OptionUndrlgFXStrikeRate P_FinancialTransactionOption OptionUndrlgFXStrikeRate
ForeignExchangeValueDate P_FinancialTransactionOption ForeignExchangeValueDate
CurrencyPair
OptionUndrlgTradedAmount
OptionUndrlgTradedCurrency P_FinancialTransactionOption OptionUndrlgTradedCurrency
FinTransFlowPaytAmtendasFXOppositeAmount
OptionUnderlyingTermStartDate P_FinancialTransactionOption OptionUnderlyingTermStartDate
OptionUnderlyingTermEndDate P_FinancialTransactionOption OptionUnderlyingTermEndDate
FinancialTransactionFromExer P_FinancialTransactionOption FinancialTransactionFromExer
FinInstrOutgCndnPctgRate UnderlyingCondition FinInstrOutgCndnPctgRate
FinInstrIncgCndnPctgRate UnderlyingCondition FinInstrIncgCndnPctgRate
FinInstrOutgIntrstReference UnderlyingCondition FinInstrOutgIntrstReference
FinInstrIncgIntrstReference UnderlyingCondition FinInstrIncgIntrstReference
FinInstrOutgIntrstCalcMeth UnderlyingCondition FinInstrOutgIntrstCalcMeth
FinInstrIncgIntrstCalcMeth UnderlyingCondition FinInstrIncgIntrstCalcMeth
FinInstrOutgCndnIntrstCategory UnderlyingCondition FinInstrOutgCndnIntrstCategory
FinInstrIncgCndnIntrstCategory UnderlyingCondition FinInstrIncgCndnIntrstCategory
OutgIntrstMarkupMarkdownVal UnderlyingCondition OutgIntrstMarkupMarkdownVal
IncgIntrstMarkupMarkdownVal UnderlyingCondition IncgIntrstMarkupMarkdownVal
FinInstrumentOutgoingCurrency P_FinancialTransactionOption FinInstrumentOutgoingCurrency
FinInstrOutgoingNominalAmount SwaptionFlow FinInstrOutgoingNominalAmount
FinInstrumentIncomingCurrency P_FinancialTransactionOption FinInstrumentIncomingCurrency
FinInstrIncomingNominalAmount SwaptionFlow FinInstrIncomingNominalAmount
SecurityClass P_FinancialTransactionOption SecurityClass
SecurityAccount P_FinancialTransactionOption SecurityAccount
QuotationCurrencyendasQuotationCurrency
FinTransFlowNomAmt UnderlyingFlow FinTransFlowNomAmt
FinTransFlowNomAmtCrcy UnderlyingFlow FinTransFlowNomAmtCrcy
FinTransTradedNumberOfUnits UnderlyingFlow FinTransTradedNumberOfUnits
FinTransTradedPricePercent UnderlyingFlow FinTransTradedPricePercent
FinTransTrdPriceCrcyUnitRate UnderlyingFlow FinTransTrdPriceCrcyUnitRate
FinTransTradedPriceCrcyUnit UnderlyingFlow FinTransTradedPriceCrcyUnit
SecurityExchange UnderlyingFlow SecurityExchange

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 P_FinTransManageOption.
-- 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: PFINTRNASMNGOPT

CREATE VIEW P_FinTransManageOption AS
SELECT
  Option.FinancialTransaction AS FinancialTransaction,
  Option.CompanyCode AS CompanyCode,
  Option.OptionExerciseType AS OptionExerciseType,
  Option.OptionSettlementType AS OptionSettlementType,
  Option.OptionExpirationDate AS OptionExpirationDate,
  Option.OptionPutCallCode AS OptionPutCallCode,
  Option.TermStartDate AS TermStartDate,
  Option.Counterparty AS Counterparty,
  Option.TermEndDate AS TermEndDate,
  cast (Option.FinancialInstrumentProductType as option_underlying_product_type ) AS OptionUnderlyingProductType,
  cast (Option.FinancialInstrTransactionType as option_undrlg_transaction_type ) AS OptionUndrlgTransactionType,
  Option.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  Option.OptnUndrlgTreasuryContractType AS OptnUndrlgTreasuryContractType,
  Option.OptionUndrlgFXStrikeRate AS OptionUndrlgFXStrikeRate,
  Option.ForeignExchangeValueDate AS ForeignExchangeValueDate,
  cast( concat(concat(Option.LeadingCurrency, '/'), Option.FollowingCurrency) as ftr_curr_pair) AS CurrencyPair,
  abs (Option.OptionUndrlgTradedAmount) AS OptionUndrlgTradedAmount,
  Option.OptionUndrlgTradedCurrency AS OptionUndrlgTradedCurrency,
  case when UnderlyingFlow.FinTransFlowSource = 'LEA1' or UnderlyingFlow.FinTransFlowSource = 'LEA2' then UnderlyingFlow.FinTransFlowPaytAmt end as FXOppositeAmount AS FinTransFlowPaytAmtendasFXOppositeAmount,
  Option.OptionUnderlyingTermStartDate AS OptionUnderlyingTermStartDate,
  Option.OptionUnderlyingTermEndDate AS OptionUnderlyingTermEndDate,
  Option.FinancialTransactionFromExer AS FinancialTransactionFromExer,
  UnderlyingCondition.FinInstrOutgCndnPctgRate AS FinInstrOutgCndnPctgRate,
  UnderlyingCondition.FinInstrIncgCndnPctgRate AS FinInstrIncgCndnPctgRate,
  UnderlyingCondition.FinInstrOutgIntrstReference AS FinInstrOutgIntrstReference,
  UnderlyingCondition.FinInstrIncgIntrstReference AS FinInstrIncgIntrstReference,
  UnderlyingCondition.FinInstrOutgIntrstCalcMeth AS FinInstrOutgIntrstCalcMeth,
  UnderlyingCondition.FinInstrIncgIntrstCalcMeth AS FinInstrIncgIntrstCalcMeth,
  UnderlyingCondition.FinInstrOutgCndnIntrstCategory AS FinInstrOutgCndnIntrstCategory,
  UnderlyingCondition.FinInstrIncgCndnIntrstCategory AS FinInstrIncgCndnIntrstCategory,
  UnderlyingCondition.OutgIntrstMarkupMarkdownVal AS OutgIntrstMarkupMarkdownVal,
  UnderlyingCondition.IncgIntrstMarkupMarkdownVal AS IncgIntrstMarkupMarkdownVal,
  Option.FinInstrumentOutgoingCurrency AS FinInstrumentOutgoingCurrency,
  SwaptionFlow.FinInstrOutgoingNominalAmount AS FinInstrOutgoingNominalAmount,
  Option.FinInstrumentIncomingCurrency AS FinInstrumentIncomingCurrency,
  SwaptionFlow.FinInstrIncomingNominalAmount AS FinInstrIncomingNominalAmount,
  Option.SecurityClass AS SecurityClass,
  Option.SecurityAccount AS SecurityAccount,
  case when UnderlyingFlow.TreasuryContractType = '2' and UnderlyingFlow.QuotationCurrency is initial then UnderlyingFlow.FinTransFlowPaytAmtCrcy else UnderlyingFlow.QuotationCurrency end as QuotationCurrency AS QuotationCurrencyendasQuotationCurrency,
  UnderlyingFlow.FinTransFlowNomAmt AS FinTransFlowNomAmt,
  UnderlyingFlow.FinTransFlowNomAmtCrcy AS FinTransFlowNomAmtCrcy,
  UnderlyingFlow.FinTransTradedNumberOfUnits AS FinTransTradedNumberOfUnits,
  UnderlyingFlow.FinTransTradedPricePercent AS FinTransTradedPricePercent,
  UnderlyingFlow.FinTransTrdPriceCrcyUnitRate AS FinTransTrdPriceCrcyUnitRate,
  UnderlyingFlow.FinTransTradedPriceCrcyUnit AS FinTransTradedPriceCrcyUnit,
  UnderlyingFlow.SecurityExchange AS SecurityExchange
FROM P_FinancialTransactionOption AS Option
;

Learn More