MTMFIN

MTMFIN is an SAP database table in S/4HANA. It contains 55 fields.

Fields (55)

KeyField CDS FieldsUsed in Views
KEY CommodityExposureCategory CommodityExposureCategory 2
KEY CommodityPriceExposure CommodityPriceExposure 2
KEY CommodityPriceSubExposure CommodityPriceSubExposure 2
KEY CompanyCode CompanyCode 2
KEY RiskAnalyzerVersionUUID VersStockRecordUUID 1
CashFlowDirection CashFlowDirection 2
CmmdtyForwardIndexTiming CmmdtyForwardIndexTiming 2
Commodity PhysicalCommodity 2
CommodityPriceExposureQuantity CommodityQuantity 2
CommodityPriceExposureUnit CommodityUnit 2
DeliveryDate DeliveryDate 2
DerivativeContract DerivativeContract 2
DerivativeContractMaturityCode DerivativeContractMaturityCode 2
DerivativeContrSpecification DerivativeContrSpecification 2
DisplayView DisplayView 2
EvaluationDate EvaluationDate 2
ExposureDueDate ExposureDueDate 2
FinancialAssetsMgmtProductType FinancialAssetsMgmtProductType 2
FinancialInstrActivityCategory FinancialInstrActivityCategory 2
FinancialInstrProductCategory FinancialInstrProductCategory 2
FinancialInstrumentProductType FinancialInstrumentProductType 2
FinancialObject FinancialObject 2
FinInstrExternalReference FinInstrExternalReference 2
FinInstrTransactionCategory FinInstrTransactionCategory 2
HasError HasError 2
HasErrorDescription HasErrorDescription 2
MarketIdentifierCode MarketIdentifierCode 2
MaturityKeyDate MaturityKeyDate 2
MaximumVersion MaximumVersion 2
MTMDataSelectionType MTMDataSelectionType 2
NumberOfCommodityContracts NumberOfCommodityContracts 2
OptionExerciseType OptionExerciseType 2
OptionPutCallCode OptionPutCallCode 2
OptionStrikeCurrency OptionStrikeCurrency 2
PaymentCurrency DocumentCurrency 2
PnLEventType PnLEventType 2
QuotationCurrency QuotationCurrency 2
QuotationPriceType QuotationPriceType 2
ReportingDate ReportingDate 2
RiskAnalyzerKeyFigInPaytCrcy ConditionTermValueInDocCrcy 2
RiskAnalyzerKeyFigInQtanCrcy RiskAnalyzerKeyFigInQtanCrcy 2
RiskAnalyzerKeyFigInStstcCrcy ConditionTermValueInStstcCrcy 2
StatisticsCurrency StatisticsCurrency 2
SystemMessageNumber SystemMessageNumber 2
TermEndDate TermEndDate 2
TermStartDate TermStartDate 2
TimeToMaturity TimeToMaturity 2
TreasuryPositionAccount TreasuryPositionAccount 2
TreasuryPositionLongShortCode TreasuryPositionLongShortCode 2
ValidityEndDate ValidityEndDate 2
ValidityEndDateTime ValidityEndDateTime 2
ValidityEndTime ValidityEndTime 2
ValidityStartDate ValidityStartDate 2
ValidityStartDateTime ValidityStartDateTime 2
ValidityStartTime ValidityStartTime 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 MTMFIN (
    COMMODITYEXPOSURECATEGORY,
    COMMODITYPRICEEXPOSURE,
    COMMODITYPRICESUBEXPOSURE,
    COMPANYCODE,
    RISKANALYZERVERSIONUUID,
    CASHFLOWDIRECTION,
    CMMDTYFORWARDINDEXTIMING,
    COMMODITY,
    COMMODITYPRICEEXPOSUREQUANTITY,
    COMMODITYPRICEEXPOSUREUNIT,
    DELIVERYDATE,
    DERIVATIVECONTRACT,
    DERIVATIVECONTRACTMATURITYCODE,
    DERIVATIVECONTRSPECIFICATION,
    DISPLAYVIEW,
    EVALUATIONDATE,
    EXPOSUREDUEDATE,
    FINANCIALASSETSMGMTPRODUCTTYPE,
    FINANCIALINSTRACTIVITYCATEGORY,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALOBJECT,
    FININSTREXTERNALREFERENCE,
    FININSTRTRANSACTIONCATEGORY,
    HASERROR,
    HASERRORDESCRIPTION,
    MARKETIDENTIFIERCODE,
    MATURITYKEYDATE,
    MAXIMUMVERSION,
    MTMDATASELECTIONTYPE,
    NUMBEROFCOMMODITYCONTRACTS,
    OPTIONEXERCISETYPE,
    OPTIONPUTCALLCODE,
    OPTIONSTRIKECURRENCY,
    PAYMENTCURRENCY,
    PNLEVENTTYPE,
    QUOTATIONCURRENCY,
    QUOTATIONPRICETYPE,
    REPORTINGDATE,
    RISKANALYZERKEYFIGINPAYTCRCY,
    RISKANALYZERKEYFIGINQTANCRCY,
    RISKANALYZERKEYFIGINSTSTCCRCY,
    STATISTICSCURRENCY,
    SYSTEMMESSAGENUMBER,
    TERMENDDATE,
    TERMSTARTDATE,
    TIMETOMATURITY,
    TREASURYPOSITIONACCOUNT,
    TREASURYPOSITIONLONGSHORTCODE,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYENDTIME,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALIDITYSTARTTIME,
    PRIMARY KEY (COMMODITYEXPOSURECATEGORY, COMMODITYPRICEEXPOSURE, COMMODITYPRICESUBEXPOSURE, COMPANYCODE, RISKANALYZERVERSIONUUID)
);