Fields (55)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA