C_CmmdtyHdgSpecTrdCrcyCube

DDL: C_CMMDTYHDGSPECTRDCRCYCUBE SQL: CCMMDTYHSTRDCUR Type: view CONSUMPTION
25 Fields 1 Data Sources

Trade HdgSpec Curr Mismatch - Cube

C_CmmdtyHdgSpecTrdCrcyCube is a Consumption CDS View (Cube) that provides data about "Trade HdgSpec Curr Mismatch - Cube" in SAP S/4HANA. It reads from 1 data source (P_CmmdtyHdgSpecTrdCrcydiff) and exposes 25 fields with key fields CmmdtyHdgConstellationExposure, CmmdtyHdgCnstltnExpsrVersion, CmmdtyHedgeConstellationUUID, CmmdtyHdgPlnExpsrCompanyCode.

Data Sources (1)

SourceAliasJoin Type
P_CmmdtyHdgSpecTrdCrcydiff P_CmmdtyHdgSpecTrdCrcydiff from

Parameters (3)

NameTypeDefault
P_CompanyCode bukrs
P_ContractStartDate datum
P_ContractEndDate datum

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCMMDTYHSTRDCUR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
EndUserText.label Trade HdgSpec Curr Mismatch - Cube view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHdgConstellationExposure CmmdtyHdgConstellationExposure
KEY CmmdtyHdgCnstltnExpsrVersion CmmdtyHdgCnstltnExpsrVersion
KEY CmmdtyHedgeConstellationUUID CmmdtyHedgeConstellationUUID
KEY CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Exposure Company Code
CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Exposure Version No.
FinTransactionCompanyCode FinTransactionCompanyCode Trade Company Code
FinTransactionDealIdentifier FinTransactionDealIdentifier Trade ID
CmmdtyHdgSpecificationID CmmdtyHdgSpecificationID Hdg.Spec ID
CmmdtyHdgSpecQuotaOrderID CmmdtyHdgSpecQuotaOrderID Hdg.Spec.Order ID
FinTransacTradedPriceAmount FinTransacTradedPriceAmount Trade Price
TradingContractCurrency TradingContractCurrency Trade Currency
FinTransTradedPriceCrcyUnit FinTransTradedPriceCrcyUnit
CmmdtyHdgSpecLimitAmount CmmdtyHdgSpecLimitAmount Hedge Quota Price
CmmdtyHdgSpecAmountCurrency CmmdtyHdgSpecAmountCurrency Hedge Quota Price Currency
ContractStartDate Contractstartdate Contract Start Date
ContractEndDate Contractenddate Contract End Date
FinancialInstrTransactionType FinancialInstrTransactionType
FinTransactionProductType FinTransactionProductType
FinancialTransactionDCSID FinancialTransactionDCSID
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgFrgnExchTradeNumber CmmdtyHdgFrgnExchTradeNumber FX Trade ID
CmmdtyHdgFrgnExchTradeRate CmmdtyHdgFrgnExchTradeRate Trade FX Rate
CmmdtyHdgCalculatedTradePrice Calculated Trade Price
CmmdtyHdgCalcdTradeCurrency CmmdtyHdgCalcdTradeCurrency Calculated Trade Currency

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_CmmdtyHdgSpecTrdCrcyCube.
-- 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.
-- SQL view name: CCMMDTYHSTRDCUR
-- Parameters: P_CompanyCode : bukrs, P_ContractStartDate : datum, P_ContractEndDate : datum

CREATE VIEW C_CmmdtyHdgSpecTrdCrcyCube AS
SELECT
  CmmdtyHdgConstellationExposure,
  CmmdtyHdgCnstltnExpsrVersion,
  CmmdtyHedgeConstellationUUID,
  CmmdtyHdgPlnExpsrCompanyCode,
  CommodityHedgePlanExposureID,
  CmmdtyHedgePlanExposureVersion,
  FinTransactionCompanyCode,
  FinTransactionDealIdentifier,
  CmmdtyHdgSpecificationID,
  CmmdtyHdgSpecQuotaOrderID,
  FinTransacTradedPriceAmount,
  TradingContractCurrency,
  FinTransTradedPriceCrcyUnit,
  CmmdtyHdgSpecLimitAmount,
  CmmdtyHdgSpecAmountCurrency,
  ContractStartDate,
  ContractEndDate,
  FinancialInstrTransactionType,
  FinTransactionProductType,
  FinancialTransactionDCSID,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgFrgnExchTradeNumber,
  CmmdtyHdgFrgnExchTradeRate,
  fltp_to_dec(CmmdtyHdgCalculatedTradePrice as ftr_comprice ) AS CmmdtyHdgCalculatedTradePrice,
  CmmdtyHdgCalcdTradeCurrency
FROM P_CmmdtyHdgSpecTrdCrcydiff
;

Learn More