R_FinTransSecurity

DDL: R_FINTRANSSECURITY SQL: RFINTRANSSCRTY Type: view COMPOSITE
29 Fields 1 Data Sources

Fin. Trans.: Securities Information

R_FinTransSecurity is a Composite CDS View that provides data about "Fin. Trans.: Securities Information" in SAP S/4HANA. It reads from 1 data source (R_FinTransSecurityQuantityFlow) and exposes 29 fields.

Data Sources (1)

SourceAliasJoin Type
R_FinTransSecurityQuantityFlow MainFlow from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName RFINTRANSSCRTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Fin. Trans.: Securities Information view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view

Fields (29)

KeyFieldSource TableSource FieldDescription
CompanyCode R_FinTransSecurityQuantityFlow CompanyCode Receiver Company Code
FinancialTransaction R_FinTransSecurityQuantityFlow FinancialTransaction Transaction
FinancialInstrumentActivity R_FinTransSecurityQuantityFlow FinancialInstrumentActivity Activity
FinTransFlowCreationDate R_FinTransSecurityQuantityFlow FinTransFlowCreationDate Entry Date
FinTransFlowCreationTime R_FinTransSecurityQuantityFlow FinTransFlowCreationTime
FinTransFlowNumber R_FinTransSecurityQuantityFlow FinTransFlowNumber Flow
FinTransTradedOriglNomAmt R_FinTransSecurityQuantityFlow FinTransTradedOriglNomAmt Original Nom.Amt PC
FinTransTradedNumberOfUnits R_FinTransSecurityQuantityFlow FinTransTradedNumberOfUnits
FinTransTradedPricePercent R_FinTransSecurityQuantityFlow FinTransTradedPricePercent
FinTransTrdPriceCrcyUnitRate R_FinTransSecurityQuantityFlow FinTransTrdPriceCrcyUnitRate
FinTransTradedPriceCrcyUnit R_FinTransSecurityQuantityFlow FinTransTradedPriceCrcyUnit
MarketValueInQtanCurrency R_FinTransSecurityQuantityFlow MarketValueInQtanCurrency Mkt Val. in QC
QuotationCurrency R_FinTransSecurityQuantityFlow QuotationCurrency Price Currency
PaymentCurrencyendasPaymentCurrency
PositionCurrencyendasPositionCurrency
LocalCurrency R_FinTransSecurityQuantityFlow LocalCurrency Local Currency
FinTransSpotPricePercent R_FinTransSecurityQuantityFlow FinTransSpotPricePercent
FinTransSpotPriceCrcyUnitRate R_FinTransSecurityQuantityFlow FinTransSpotPriceCrcyUnitRate
FinTransMaturitySpotPricePct R_FinTransSecurityQuantityFlow FinTransMaturitySpotPricePct
FinTransMatSpotPrcCrcyUnitRate R_FinTransSecurityQuantityFlow FinTransMatSpotPrcCrcyUnitRate
FinTransForwardPriceCostRate R_FinTransSecurityQuantityFlow FinTransForwardPriceCostRate
FinTransFwdPrcIntrstCompRate R_FinTransSecurityQuantityFlow FinTransFwdPrcIntrstCompRate
FinTransFwdPrcDividendPercent R_FinTransSecurityQuantityFlow FinTransFwdPrcDividendPercent Div. Percentage
SecurityExchange R_FinTransSecurityQuantityFlow SecurityExchange Exchange
SecurityClass R_FinTransSecurityQuantityFlow SecurityClass Treasury ID No.
SecurityAccount R_FinTransSecurityQuantityFlow SecurityAccount Securities Acct
FinTransPositionValueDate R_FinTransSecurityQuantityFlow FinTransPositionValueDate Position Value Date
FinTransFlowPaymentDate R_FinTransSecurityQuantityFlow FinTransFlowPaymentDate
CalculationDate R_FinTransSecurityQuantityFlow CalculationDate Calculat. date

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 R_FinTransSecurity.
-- 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: RFINTRANSSCRTY

CREATE VIEW R_FinTransSecurity AS
SELECT
  MainFlow.CompanyCode AS CompanyCode,
  MainFlow.FinancialTransaction AS FinancialTransaction,
  MainFlow.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  MainFlow.FinTransFlowCreationDate AS FinTransFlowCreationDate,
  MainFlow.FinTransFlowCreationTime AS FinTransFlowCreationTime,
  MainFlow.FinTransFlowNumber AS FinTransFlowNumber,
  MainFlow.FinTransTradedOriglNomAmt AS FinTransTradedOriglNomAmt,
  MainFlow.FinTransTradedNumberOfUnits AS FinTransTradedNumberOfUnits,
  MainFlow.FinTransTradedPricePercent AS FinTransTradedPricePercent,
  MainFlow.FinTransTrdPriceCrcyUnitRate AS FinTransTrdPriceCrcyUnitRate,
  MainFlow.FinTransTradedPriceCrcyUnit AS FinTransTradedPriceCrcyUnit,
  MainFlow.MarketValueInQtanCurrency AS MarketValueInQtanCurrency,
  MainFlow.QuotationCurrency AS QuotationCurrency,
  case when ( MainFlow.PaymentCurrency is initial and PaymentFlow.PaymentCurrency is not initial) then PaymentFlow.PaymentCurrency else MainFlow.PaymentCurrency end as PaymentCurrency AS PaymentCurrencyendasPaymentCurrency,
  case when ( MainFlow.PositionCurrency is initial and PaymentFlow.PositionCurrency is not initial) then PaymentFlow.PositionCurrency else MainFlow.PositionCurrency end as PositionCurrency AS PositionCurrencyendasPositionCurrency,
  MainFlow.LocalCurrency AS LocalCurrency,
  MainFlow.FinTransSpotPricePercent AS FinTransSpotPricePercent,
  MainFlow.FinTransSpotPriceCrcyUnitRate AS FinTransSpotPriceCrcyUnitRate,
  MainFlow.FinTransMaturitySpotPricePct AS FinTransMaturitySpotPricePct,
  MainFlow.FinTransMatSpotPrcCrcyUnitRate AS FinTransMatSpotPrcCrcyUnitRate,
  MainFlow.FinTransForwardPriceCostRate AS FinTransForwardPriceCostRate,
  MainFlow.FinTransFwdPrcIntrstCompRate AS FinTransFwdPrcIntrstCompRate,
  MainFlow.FinTransFwdPrcDividendPercent AS FinTransFwdPrcDividendPercent,
  MainFlow.SecurityExchange AS SecurityExchange,
  MainFlow.SecurityClass AS SecurityClass,
  MainFlow.SecurityAccount AS SecurityAccount,
  MainFlow.FinTransPositionValueDate AS FinTransPositionValueDate,
  MainFlow.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  MainFlow.CalculationDate AS CalculationDate
FROM R_FinTransSecurityQuantityFlow AS MainFlow
;

Learn More