C_CmmdtyVersFinTransacDEX

DDL: C_CMMDTYVERSFINTRANSACDEX Type: view_entity CONSUMPTION
68 Fields 1 Data Sources

Data Extractor for CMM VFIND Table

C_CmmdtyVersFinTransacDEX is a Consumption CDS View (Fact) that provides data about "Data Extractor for CMM VFIND Table" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyVersFinTransac) and exposes 68 fields with key fields CompanyCode, CommodityExposureCategory, CommodityPriceExposure, CommodityPriceExposureVersion, CommodityPriceSubExposure.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyVersFinTransac I_CmmdtyVersFinTransac from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Data Extractor for CMM VFIND Table view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.dataCategory #FACT view
ObjectModel.modelingPattern #ANALYTICAL_FACT view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY CommodityExposureCategory CommodityExposureCategory Exposure Cat
KEY CommodityPriceExposure CommodityPriceExposure Exposure ID
KEY CommodityPriceExposureVersion CommodityPriceExposureVersion Exposure Version
KEY CommodityPriceSubExposure CommodityPriceSubExposure Expo Subkey
SourceLogicalSystem SourceLogicalSystem Logical System
ValidityStartDateTime ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime ValidityEndDateTime Valid To Timestamp
ValidityStartDate ValidityStartDate Validity Start Date
ValidityStartTime ValidityStartTime Valid From Time
ValidityEndDate ValidityEndDate ValidTo
ValidityEndTime ValidityEndTime Valid To Time
MaximumVersion MaximumVersion Highest Version
RiskAnalyzerVersionUUID RiskAnalyzerVersionUUID Version GUID
FinancialInstrProductCategory FinancialInstrProductCategory Prod. Category
FinancialAssetsMgmtProductType FinancialAssetsMgmtProductType Product Type
FinInstrTransactionCategory FinInstrTransactionCategory Transaction Cat
FinancialInstrumentProductType FinancialInstrumentProductType TransType
FinancialInstrActivityCategory FinancialInstrActivityCategory Activity Cat.
TermStartDate TermStartDate Term Start
TermEndDate TermEndDate Term End
FinancialObject FinancialObject Val. Obj. No.
PnLEventType PnLEventType Type of Event
HasError HasError TRUE
IsNotRelevantForMTMRisk IsNotRelevantForMTMRisk Reporting Relevant
CalculationPeriodEndDate CalculationPeriodEndDate Calc. End Date
FinInstrExternalReference FinInstrExternalReference External Reference
CalculationPeriodStartDate CalculationPeriodStartDate Calc. Start Date
FinancialTransactionPortfolio FinancialTransactionPortfolio Portfolio
ExposureDueDate ExposureDueDate Exp. Due Date
ReportingDate ReportingDate Reporting Date
DeliveryDate DeliveryDate Delivery Date
PricingCommodity PricingCommodity Commodity
DirectionLongShort DirectionLongShort Side
TreasuryPositionLongShortCode TreasuryPositionLongShortCode Long/Short Position
DerivativeContrSpecification DerivativeContrSpecification DCS ID
MarketIdentifierCode MarketIdentifierCode MIC
QuotationPriceType QuotationPriceType Price Type
TimeToMaturity TimeToMaturity Time to Maturity
CmmdtyForwardIndexTiming CmmdtyForwardIndexTiming Timing
MaturityKeyDate MaturityKeyDate Maturity Key Date
DerivativeContractMaturityCode DerivativeContractMaturityCode Contr. Maturity Code
OptionPutCallCode OptionPutCallCode Put/Call
OptionExerciseType OptionExerciseType Exercise Type
PriceFixationStatus PriceFixationStatus Fixation Status
TreasuryPositionAccount TreasuryPositionAccount Futures Acct
DerivativeContract DerivativeContract Derivative Contract
NumberOfCommodityContracts NumberOfCommodityContracts Number of Contracts
CommodityPriceExposureQuantity CommodityPriceExposureQuantity Value
CommodityPriceExposureUnit CommodityPriceExposureUnit Unit of Measure
CommodityPriceExposureBaseQty CommodityPriceExposureBaseQty Base Quantity
CommodityPriceExposureBaseUnit CommodityPriceExposureBaseUnit Weight UoM
CmmdtyPriceExpsrQtyInMassUnit CmmdtyPriceExpsrQtyInMassUnit
CmmdtyPriceExpsrMassUnit CmmdtyPriceExpsrMassUnit
CmmdtyPriceExpsrQtyInVolUnit CmmdtyPriceExpsrQtyInVolUnit
CmmdtyPriceExpsrVolumeUnit CmmdtyPriceExpsrVolumeUnit
CmmdtyPriceExpsrPaymentAmount CmmdtyPriceExpsrPaymentAmount
QuotationCurrency QuotationCurrency Quotation Crcy
PaymentCurrency PaymentCurrency Payment Currency
OptionStrikePrice OptionStrikePrice Strike Price
OptionStrikeCurrency OptionStrikeCurrency
TradedDrvtvContrSpecification TradedDrvtvContrSpecification Traded DCS
ParDrvtvContractSpecification ParDrvtvContractSpecification Parent DCS ID
RiskViewIsNotRelevant RiskViewIsNotRelevant Ignore for Risk View
EndOfDayBusinessEntityKey EndOfDayBusinessEntityKey Node Key
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook Hedge Book
CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
ProfitCenter ProfitCenter Profit Center

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CmmdtyVersFinTransacDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_CmmdtyVersFinTransacDEX AS
SELECT
  CompanyCode,
  CommodityExposureCategory,
  CommodityPriceExposure,
  CommodityPriceExposureVersion,
  CommodityPriceSubExposure,
  SourceLogicalSystem,
  ValidityStartDateTime,
  ValidityEndDateTime,
  ValidityStartDate,
  ValidityStartTime,
  ValidityEndDate,
  ValidityEndTime,
  MaximumVersion,
  RiskAnalyzerVersionUUID,
  FinancialInstrProductCategory,
  FinancialAssetsMgmtProductType,
  FinInstrTransactionCategory,
  FinancialInstrumentProductType,
  FinancialInstrActivityCategory,
  TermStartDate,
  TermEndDate,
  FinancialObject,
  PnLEventType,
  HasError,
  IsNotRelevantForMTMRisk,
  CalculationPeriodEndDate,
  FinInstrExternalReference,
  CalculationPeriodStartDate,
  FinancialTransactionPortfolio,
  ExposureDueDate,
  ReportingDate,
  DeliveryDate,
  PricingCommodity,
  DirectionLongShort,
  TreasuryPositionLongShortCode,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  QuotationPriceType,
  TimeToMaturity,
  CmmdtyForwardIndexTiming,
  MaturityKeyDate,
  DerivativeContractMaturityCode,
  OptionPutCallCode,
  OptionExerciseType,
  PriceFixationStatus,
  TreasuryPositionAccount,
  DerivativeContract,
  NumberOfCommodityContracts,
  CommodityPriceExposureQuantity,
  CommodityPriceExposureUnit,
  CommodityPriceExposureBaseQty,
  CommodityPriceExposureBaseUnit,
  CmmdtyPriceExpsrQtyInMassUnit,
  CmmdtyPriceExpsrMassUnit,
  CmmdtyPriceExpsrQtyInVolUnit,
  CmmdtyPriceExpsrVolumeUnit,
  CmmdtyPriceExpsrPaymentAmount,
  QuotationCurrency,
  PaymentCurrency,
  OptionStrikePrice,
  OptionStrikeCurrency,
  TradedDrvtvContrSpecification,
  ParDrvtvContractSpecification,
  RiskViewIsNotRelevant,
  EndOfDayBusinessEntityKey,
  CmmdtyHdgPlanExposureHedgeBook,
  CommodityHedgePlanExposureID,
  ProfitCenter
FROM I_CmmdtyVersFinTransac
;

Learn More