R_FINTRANSSECURITYQUANTITYFLOW

CDS View
37 Fields 2 CDS Views

Fin Trans Security Quantity Flow

R_FINTRANSSECURITYQUANTITYFLOW is a CDS View in S/4HANA. Fin Trans Security Quantity Flow. It contains 37 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FinTransSecurity view inner COMPOSITE Fin Trans Securities Information
R_FinTransSecurity view from COMPOSITE Fin. Trans.: Securities Information

Fields (37)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FinancialTransaction FinancialTransaction 2
CalculationDate CalculationDate 2
FinancialInstrumentActivity FinancialInstrumentActivity 1
FinTransFlowCreationDate FinTransFlowCreationDate 1
FinTransFlowCreationTime FinTransFlowCreationTime 1
FinTransFlowNomAmtCrcy FinTransFlowNomAmtCrcy 1
FinTransFlowNumber FinTransFlowNumber 1
FinTransFlowPaymentDate FinTransFlowPaymentDate 2
FinTransForwardPriceCostRate FinTransForwardPriceCostRate 2
FinTransFwdPrcDividendPercent FinTransFwdPrcDividendPercent 2
FinTransFwdPrcIntrstCompRate FinTransFwdPrcIntrstCompRate 2
FinTransLoclCrcyCnvrsnRate FinTransLoclCrcyCnvrsnRate 1
FinTransMatSpotPrcCrcyUnitRate FinTransMatSpotPrcCrcyUnitRate 2
FinTransMaturitySpotPricePct FinTransMaturitySpotPricePct 2
FinTransPaymentCrcyCnvrsnRate FinTransPaymentCrcyCnvrsnRate 1
FinTransPositionCrcyCnvrsnRate FinTransPositionCrcyCnvrsnRate 1
FinTransPositionValueDate FinTransPositionValueDate 2
FinTransSpotPriceCrcyUnitRate FinTransSpotPriceCrcyUnitRate 2
FinTransSpotPricePercent FinTransSpotPricePercent 2
FinTransTradedNomAmt FinTransTradedNomAmt 1
FinTransTradedNumberOfUnits FinTransTradedNumberOfUnits 2
FinTransTradedOriglNomAmt FinTransTradedOriglNomAmt 2
FinTransTradedPriceCrcyUnit FinTransTradedPriceCrcyUnit 2
FinTransTradedPricePercent FinTransTradedPricePercent 2
FinTransTrdPriceCrcyUnitRate FinTransTrdPriceCrcyUnitRate 2
LocalCurrency LocalCurrency 2
MarketValInPaytCurrency MarketValInPaytCurrency 1
MarketValueInLocalCurrency MarketValueInLocalCurrency 1
MarketValueInPositionCurrency MarketValueInPositionCurrency 1
MarketValueInQtanCurrency MarketValueInQtanCurrency 2
PaymentCurrency PaymentCurrency 1
PositionCurrency PositionCurrency 1
QuotationCurrency QuotationCurrency 2
SecurityAccount SecurityAccount 1
SecurityClass SecurityClass 1
SecurityExchange SecurityExchange 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Fin Trans Security Quantity Flow
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_FINTRANSSECURITYQUANTITYFLOW (
    COMPANYCODE,
    FINANCIALTRANSACTION,
    CALCULATIONDATE,
    FINANCIALINSTRUMENTACTIVITY,
    FINTRANSFLOWCREATIONDATE,
    FINTRANSFLOWCREATIONTIME,
    FINTRANSFLOWNOMAMTCRCY,
    FINTRANSFLOWNUMBER,
    FINTRANSFLOWPAYMENTDATE,
    FINTRANSFORWARDPRICECOSTRATE,
    FINTRANSFWDPRCDIVIDENDPERCENT,
    FINTRANSFWDPRCINTRSTCOMPRATE,
    FINTRANSLOCLCRCYCNVRSNRATE,
    FINTRANSMATSPOTPRCCRCYUNITRATE,
    FINTRANSMATURITYSPOTPRICEPCT,
    FINTRANSPAYMENTCRCYCNVRSNRATE,
    FINTRANSPOSITIONCRCYCNVRSNRATE,
    FINTRANSPOSITIONVALUEDATE,
    FINTRANSSPOTPRICECRCYUNITRATE,
    FINTRANSSPOTPRICEPERCENT,
    FINTRANSTRADEDNOMAMT,
    FINTRANSTRADEDNUMBEROFUNITS,
    FINTRANSTRADEDORIGLNOMAMT,
    FINTRANSTRADEDPRICECRCYUNIT,
    FINTRANSTRADEDPRICEPERCENT,
    FINTRANSTRDPRICECRCYUNITRATE,
    LOCALCURRENCY,
    MARKETVALINPAYTCURRENCY,
    MARKETVALUEINLOCALCURRENCY,
    MARKETVALUEINPOSITIONCURRENCY,
    MARKETVALUEINQTANCURRENCY,
    PAYMENTCURRENCY,
    POSITIONCURRENCY,
    QUOTATIONCURRENCY,
    SECURITYACCOUNT,
    SECURITYCLASS,
    SECURITYEXCHANGE,
    PRIMARY KEY (COMPANYCODE, FINANCIALTRANSACTION)
);

Learn More