C_CmmdtyHdgSpecTrdCrcyQuery

DDL: C_CMMDTYHDGSPECTRDCRCYQUERY SQL: CCMMDTYHSTRDCUQ Type: view CONSUMPTION
25 Fields 1 Data Sources

Analyze Mismatch in Currencies - Query

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

Data Sources (1)

SourceAliasJoin Type
C_CmmdtyHdgSpecTrdCrcyCube C_CmmdtyHdgSpecTrdCrcyCube from

Parameters (3)

NameTypeDefault
P_CompanyCode bukrs
P_ContractEndDate datum
P_ContractStartDate datum

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCMMDTYHSTRDCUQ 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 #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Analyze Mismatch in Currencies - Query view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Analytics.query true view
VDM.viewType #CONSUMPTION view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHdgConstellationExposure CmmdtyHdgConstellationExposure
KEY CmmdtyHdgCnstltnExpsrVersion CmmdtyHdgCnstltnExpsrVersion
KEY CmmdtyHedgeConstellationUUID CmmdtyHedgeConstellationUUID
KEY CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Exposure Version No.
FinTransactionCompanyCode FinTransactionCompanyCode
FinTransactionDealIdentifier FinTransactionDealIdentifier
CmmdtyHdgSpecificationID CmmdtyHdgSpecificationID
CmmdtyHdgSpecQuotaOrderID CmmdtyHdgSpecQuotaOrderID
FinTransacTradedPriceAmount FinTransacTradedPriceAmount
TradingContractCurrency TradingContractCurrency
FinTransTradedPriceCrcyUnit FinTransTradedPriceCrcyUnit
CmmdtyHdgSpecLimitAmount CmmdtyHdgSpecLimitAmount
CmmdtyHdgSpecAmountCurrency CmmdtyHdgSpecAmountCurrency
ContractStartDate ContractStartDate Contract Start Date
ContractEndDate ContractEndDate Contract End Date
FinancialInstrTransactionType FinancialInstrTransactionType
FinTransactionProductType FinTransactionProductType
FinancialTransactionDCSID FinancialTransactionDCSID
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgFrgnExchTradeNumber CmmdtyHdgFrgnExchTradeNumber
CmmdtyHdgFrgnExchTradeRate CmmdtyHdgFrgnExchTradeRate
CmmdtyHdgCalculatedTradePrice CmmdtyHdgCalculatedTradePrice
CmmdtyHdgCalcdTradeCurrency CmmdtyHdgCalcdTradeCurrency

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_CmmdtyHdgSpecTrdCrcyQuery.
-- 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: CCMMDTYHSTRDCUQ
-- Parameters: P_CompanyCode : bukrs, P_ContractEndDate : datum, P_ContractStartDate : datum

CREATE VIEW C_CmmdtyHdgSpecTrdCrcyQuery 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,
  CmmdtyHdgCalculatedTradePrice,
  CmmdtyHdgCalcdTradeCurrency
FROM C_CmmdtyHdgSpecTrdCrcyCube
;

Learn More