I_DERIVATIVECMMDTYEXPSR

CDS View
74 Fields 7 CDS Views

Drvtv Basic Layer Select data from VFIND

I_DERIVATIVECMMDTYEXPSR is a CDS View in S/4HANA. Drvtv Basic Layer Select data from VFIND. It contains 74 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_BrkrRecnclnEvalEODayLatest view inner COMPOSITE Ltst EOD Eval of Commodity Derivatives
I_BrkrRecnclnExpsrEODayLatest view inner COMPOSITE Ltst Vers Financial Transactions Data
P_CmmdtyFinVersSumQtyTrans view from COMPOSITE Commodity Financial Transaction
P_DerivativePosTechLayer view from COMPOSITE
P_DrvtvInstrDODAllVersion view from COMPOSITE
P_DrvtvInstrMatGrpg view from COMPOSITE
P_DrvtvPosEndOfDayTechLayer view from COMPOSITE

Fields (74)

KeyField CDS FieldsUsed in Views
KEY CommodityExposureCategory CommodityExposureCategory 3
KEY CommodityPriceExposure CommodityPriceExposure 4
KEY CommodityPriceExposureVersion CommodityPriceExposureVersion 4
KEY CommodityPriceSubExposure CommodityPriceSubExposure 3
KEY CompanyCode CompanyCode 4
_CompanyCode _CompanyCode 3
_DerivativeContrSpecification _DCS,_DerivativeContrSpecification 4
_FinAssetsMgmtProductType _FinAssetsMgmtProductType 3
_MarketIdentifierCode _MarketIdentifierCode 3
_PhysicalCommodity _PhysicalCommodity 3
_UnitOfMeasure _UnitOfMeasure 3
CalculationPeriodEndDate CalculationPeriodEndDate 4
CalculationPeriodStartDate CalculationPeriodStartDate 3
CashFlowDirection CashFlowDirection 3
CmmdtyForwardIndexTiming CmmdtyForwardIndexTiming 3
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook 2
CmmdtyPriceExpsrMassUnit CmmdtyPriceExpsrMassUnit 3
CmmdtyPriceExpsrPaymentAmount CmmdtyPriceExpsrPaymentAmount 1
CmmdtyPriceExpsrQtyInMassUnit CmmdtyPriceExpsrQtyInMassUnit 3
CmmdtyPriceExpsrQtyInVolUnit CmmdtyPriceExpsrQtyInVolUnit 3
CmmdtyPriceExpsrVolumeUnit CmmdtyPriceExpsrVolumeUnit 3
Commodity Commodity 3
CommodityHedgePlanExposureID CommodityHedgePlanExposureID 2
CommodityPriceExposureBaseQty CommodityPriceExposureBaseQty 3
CommodityPriceExposureBaseUnit CommodityPriceExposureBaseUnit 3
CommodityPriceExposureQuantity CommodityPriceExposureQuantity 3
CommodityPriceExposureUnit CommodityPriceExposureUnit 4
CommodityPriceFixationStatus CommodityPriceFixationStatus 3
DeliveryDate DeliveryDate 4
DerivativeContract DerivativeContract 3
DerivativeContractMaturityCode DerivativeContractMaturityCode 3
DerivativeContrSpecification DerivativeContrSpecification 4
EndOfDayBusinessEntityKey EndOfDayBusinessEntityKey 3
ExposureDueDate ExposureDueDate 3
FinancialAssetsMgmtProductType FinancialAssetsMgmtProductType 3
FinancialInstrActivityCategory FinancialInstrActivityCategory 3
FinancialInstrProductCategory FinancialInstrProductCategory 4
FinancialInstrumentProductType FinancialInstrumentProductType 3
FinancialObject FinancialObject 3
FinancialTransactionPortfolio FinancialTransactionPortfolio 2
FinInstrExternalReference FinInstrExternalReference 3
FinInstrTransactionCategory FinInstrTransactionCategory 3
HasError HasError 3
IsNotRelevantForMTMRisk IsNotRelevantForMTMRisk 4
MarketIdentifierCode MarketIdentifierCode 4
MaturityKeyDate MaturityKeyDate 3
MaximumVersion MaximumVersion 3
NumberOfCommodityContracts NumberOfCommodityContracts 3
OptionExerciseType OptionExerciseType 3
OptionPutCallCode OptionPutCallCode 3
OptionStrikeCurrency OptionStrikeCurrency 3
OptionStrikePrice OptionStrikePrice 3
ParDrvtvContractSpecification ParDrvtvContractSpecification 2
PaymentCurrency PaymentCurrency 3
PnLEventType PnLEventType 3
QuotationCurrency QuotationCurrency 2
QuotationPriceType QuotationPriceType 2
ReportingDate ReportingDate 3
ReportingMonth ReportingMonth 3
ReportingYear ReportingYear 3
RiskAnalyzerVersionUUID RiskAnalyzerVersionUUID 3
RiskViewIsNotRelevant RiskViewIsNotRelevant 2
TermEndDate TermEndDate 3
TermStartDate TermStartDate 3
TimeToMaturity TimeToMaturity 3
TradedDrvtvContrSpecification TradedDrvtvContrSpecification 2
TreasuryPositionAccount TreasuryPositionAccount 3
TreasuryPositionLongShortCode TreasuryPositionLongShortCode 4
ValidityEndDate ValidityEndDate 3
ValidityEndDateTime ValidityEndDateTime 3
ValidityEndTime ValidityEndTime 3
ValidityStartDate ValidityStartDate 3
ValidityStartDateTime ValidityStartDateTime 3
ValidityStartTime ValidityStartTime 3

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.

-- Drvtv Basic Layer Select data from VFIND
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DERIVATIVECMMDTYEXPSR (
    COMMODITYEXPOSURECATEGORY,
    COMMODITYPRICEEXPOSURE,
    COMMODITYPRICEEXPOSUREVERSION,
    COMMODITYPRICESUBEXPOSURE,
    COMPANYCODE,
    _COMPANYCODE,
    _DERIVATIVECONTRSPECIFICATION,
    _FINASSETSMGMTPRODUCTTYPE,
    _MARKETIDENTIFIERCODE,
    _PHYSICALCOMMODITY,
    _UNITOFMEASURE,
    CALCULATIONPERIODENDDATE,
    CALCULATIONPERIODSTARTDATE,
    CASHFLOWDIRECTION,
    CMMDTYFORWARDINDEXTIMING,
    CMMDTYHDGPLANEXPOSUREHEDGEBOOK,
    CMMDTYPRICEEXPSRMASSUNIT,
    CMMDTYPRICEEXPSRPAYMENTAMOUNT,
    CMMDTYPRICEEXPSRQTYINMASSUNIT,
    CMMDTYPRICEEXPSRQTYINVOLUNIT,
    CMMDTYPRICEEXPSRVOLUMEUNIT,
    COMMODITY,
    COMMODITYHEDGEPLANEXPOSUREID,
    COMMODITYPRICEEXPOSUREBASEQTY,
    COMMODITYPRICEEXPOSUREBASEUNIT,
    COMMODITYPRICEEXPOSUREQUANTITY,
    COMMODITYPRICEEXPOSUREUNIT,
    COMMODITYPRICEFIXATIONSTATUS,
    DELIVERYDATE,
    DERIVATIVECONTRACT,
    DERIVATIVECONTRACTMATURITYCODE,
    DERIVATIVECONTRSPECIFICATION,
    ENDOFDAYBUSINESSENTITYKEY,
    EXPOSUREDUEDATE,
    FINANCIALASSETSMGMTPRODUCTTYPE,
    FINANCIALINSTRACTIVITYCATEGORY,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALOBJECT,
    FINANCIALTRANSACTIONPORTFOLIO,
    FININSTREXTERNALREFERENCE,
    FININSTRTRANSACTIONCATEGORY,
    HASERROR,
    ISNOTRELEVANTFORMTMRISK,
    MARKETIDENTIFIERCODE,
    MATURITYKEYDATE,
    MAXIMUMVERSION,
    NUMBEROFCOMMODITYCONTRACTS,
    OPTIONEXERCISETYPE,
    OPTIONPUTCALLCODE,
    OPTIONSTRIKECURRENCY,
    OPTIONSTRIKEPRICE,
    PARDRVTVCONTRACTSPECIFICATION,
    PAYMENTCURRENCY,
    PNLEVENTTYPE,
    QUOTATIONCURRENCY,
    QUOTATIONPRICETYPE,
    REPORTINGDATE,
    REPORTINGMONTH,
    REPORTINGYEAR,
    RISKANALYZERVERSIONUUID,
    RISKVIEWISNOTRELEVANT,
    TERMENDDATE,
    TERMSTARTDATE,
    TIMETOMATURITY,
    TRADEDDRVTVCONTRSPECIFICATION,
    TREASURYPOSITIONACCOUNT,
    TREASURYPOSITIONLONGSHORTCODE,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYENDTIME,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALIDITYSTARTTIME,
    PRIMARY KEY (COMMODITYEXPOSURECATEGORY, COMMODITYPRICEEXPOSURE, COMMODITYPRICEEXPOSUREVERSION, COMMODITYPRICESUBEXPOSURE, COMPANYCODE)
);

Learn More