VFINR

VFINR is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
ContractValueInPaytCurrency ContractValueInPaytCurrency 2
ContractValueInQtanCurrency ContractValueInQtanCurrency 2
ContractValueInStstcCurrency ContractValueInStstcCurrency 2
ExternalKeyFigureValue ExternalKeyFigureValue 4
MarketValInPaytCurrency MarketValInPaytCurrency 2
MarketValueInQtanCurrency MarketValueInQtanCurrency 2
MarketValueInStstcCurrency MarketValueInStstcCurrency 2
OptionDeltaFactorKeyFigure OptionDeltaFactorKeyFigure 2
PaymentCurrency PaymentCurrency 3
QuotationCurrency QuotationCurrency 3
RiskAnalyzerKeyFigInPaytCrcy RiskAnalyzerKeyFigInPaytCrcy 1
RiskAnalyzerKeyFigInQtanCrcy RiskAnalyzerKeyFigInQtanCrcy 1
RiskAnalyzerKeyFigInStstcCrcy RiskAnalyzerKeyFigInStstcCrcy 1
RiskAnalyzerKeyFigureName RiskAnalyzerKeyFigureName 1
StatisticsCurrency StatisticsCurrency 3
UndiscountedMTMVaInQtanCrcy UndiscountedMTMVaInQtanCrcy 2
UndiscountedMTMValInPaytCrcy UndiscountedMTMValInPaytCrcy 2
UndiscountedMTMValInStstcCrcy UndiscountedMTMValInStstcCrcy 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VFINR (
    CONTRACTVALUEINPAYTCURRENCY,
    CONTRACTVALUEINQTANCURRENCY,
    CONTRACTVALUEINSTSTCCURRENCY,
    EXTERNALKEYFIGUREVALUE,
    MARKETVALINPAYTCURRENCY,
    MARKETVALUEINQTANCURRENCY,
    MARKETVALUEINSTSTCCURRENCY,
    OPTIONDELTAFACTORKEYFIGURE,
    PAYMENTCURRENCY,
    QUOTATIONCURRENCY,
    RISKANALYZERKEYFIGINPAYTCRCY,
    RISKANALYZERKEYFIGINQTANCRCY,
    RISKANALYZERKEYFIGINSTSTCCRCY,
    RISKANALYZERKEYFIGURENAME,
    STATISTICSCURRENCY,
    UNDISCOUNTEDMTMVAINQTANCRCY,
    UNDISCOUNTEDMTMVALINPAYTCRCY,
    UNDISCOUNTEDMTMVALINSTSTCCRCY
);