I_CmmdtyHdgMigrtnItmDealCmpst

DDL: I_CMMDTYHDGMIGRTNITMDEALCMPST SQL: ICMMMGRITMDLC Type: view COMPOSITE
36 Fields 1 Data Sources 2 Associations

Composite for Migration Item Deal

I_CmmdtyHdgMigrtnItmDealCmpst is a Composite CDS View that provides data about "Composite for Migration Item Deal" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgMigrtnFinTransCmpst) and exposes 36 fields with key field FinTransactionObjectNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgMigrtnFinTransCmpst I_CmmdtyHdgMigrtnFinTransCmpst from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_CmmdtyHedgeMigrationItemDeal _CmmdtyHdgMigrtnRlvtCandRslt $projection.FinTransactionObjectNumber = _CmmdtyHdgMigrtnRlvtCandRslt.FinTransactionObjectNumber
[0..1] I_CmmdtyHdgCnstltnDealUnion _HedgeConstellation $projection.FinTransactionCompanyCode = _HedgeConstellation.CompanyCode and $projection.FinTransactionDealIdentifier = _HedgeConstellation.CmmdtyHedgeConstellationDeal

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICMMMGRITMDLC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Composite for Migration Item Deal view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY FinTransactionObjectNumber I_CmmdtyHdgMigrtnFinTransCmpst FinTransactionObjectNumber
FinTransactionCompanyCode I_CmmdtyHdgMigrtnFinTransCmpst FinTransactionCompanyCode
FinTransactionDealIdentifier I_CmmdtyHdgMigrtnFinTransCmpst FinTransactionDealIdentifier
FinTransactionProductType I_CmmdtyHdgMigrtnFinTransCmpst FinTransactionProductType
FinTransContractStartDate I_CmmdtyHdgMigrtnFinTransCmpst FinTransContractStartDate
FinTransContractStartTime I_CmmdtyHdgMigrtnFinTransCmpst FinTransContractStartTime
FinTransactionCounterparty I_CmmdtyHdgMigrtnFinTransCmpst FinTransactionCounterparty
FinancialInstrTransactionType I_CmmdtyHdgMigrtnFinTransCmpst FinancialInstrTransactionType
FinTransHedgingClassification I_CmmdtyHdgMigrtnFinTransCmpst FinTransHedgingClassification
FinTransOnBehalfOfCompany I_CmmdtyHdgMigrtnFinTransCmpst FinTransOnBehalfOfCompany
FinancialTransactionQuantity I_CmmdtyHdgMigrtnFinTransCmpst FinancialTransactionQuantity
FinTransactionQuantityUnit I_CmmdtyHdgMigrtnFinTransCmpst FinTransactionQuantityUnit
FinTransFlowPaymentDate I_CmmdtyHdgMigrtnFinTransCmpst FinTransFlowPaymentDate
FinancialTransactionDCSID I_CmmdtyHdgMigrtnFinTransCmpst FinancialTransactionDCSID
FinTransactionPricingStartDate I_CmmdtyHdgMigrtnFinTransCmpst FinTransactionPricingStartDate
FinTransactionPricingEndDate I_CmmdtyHdgMigrtnFinTransCmpst FinTransactionPricingEndDate
FinancialTransactionHedgeBook I_CmmdtyHdgMigrtnFinTransCmpst FinancialTransactionHedgeBook
FinTransInternalReference I_CmmdtyHdgMigrtnFinTransCmpst FinTransInternalReference
FinancialTransactionPortfolio I_CmmdtyHdgMigrtnFinTransCmpst FinancialTransactionPortfolio
FinTransGeneralValuationClass I_CmmdtyHdgMigrtnFinTransCmpst FinTransGeneralValuationClass
FinTransactionTermEndDate I_CmmdtyHdgMigrtnFinTransCmpst TermEndDate
FinancialTransactionAssignment I_CmmdtyHdgMigrtnFinTransCmpst FinancialTransactionAssignment
FinTransactionCharacteristic I_CmmdtyHdgMigrtnFinTransCmpst FinTransactionCharacteristic
CommodityPriceExposureUnit I_CmmdtyHdgMigrtnFinTransCmpst CommodityPriceExposureUnit
FinTransTradedPriceCrcyUnit I_CmmdtyHdgMigrtnFinTransCmpst FinTransTradedPriceCrcyUnit
FinTransacTradedPriceAmount I_CmmdtyHdgMigrtnFinTransCmpst FinTransacTradedPriceAmount
CompanyCodeName
FinTransactionProductTypeText
FinancialTransactionTypeText
PlanningDataDirectionText
DerivativeContrSpecName
BusinessPartnerName
_CmmdtyHdgMigrtnRlvtCandRslt _CmmdtyHdgMigrtnRlvtCandRslt
_BusinessPartner _BusinessPartner
CompanyCode _HedgeConstellation CompanyCode Receiver Company Code
CmmdtyHedgeConstellationDeal _HedgeConstellation CmmdtyHedgeConstellationDeal

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 I_CmmdtyHdgMigrtnItmDealCmpst.
-- 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: ICMMMGRITMDLC

CREATE VIEW I_CmmdtyHdgMigrtnItmDealCmpst AS
SELECT
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransactionObjectNumber AS FinTransactionObjectNumber,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransactionCompanyCode AS FinTransactionCompanyCode,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransactionDealIdentifier AS FinTransactionDealIdentifier,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransactionProductType AS FinTransactionProductType,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransContractStartDate AS FinTransContractStartDate,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransContractStartTime AS FinTransContractStartTime,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransactionCounterparty AS FinTransactionCounterparty,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransHedgingClassification AS FinTransHedgingClassification,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransOnBehalfOfCompany AS FinTransOnBehalfOfCompany,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinancialTransactionQuantity AS FinancialTransactionQuantity,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransactionQuantityUnit AS FinTransactionQuantityUnit,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinancialTransactionDCSID AS FinancialTransactionDCSID,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransactionPricingStartDate AS FinTransactionPricingStartDate,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransactionPricingEndDate AS FinTransactionPricingEndDate,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinancialTransactionHedgeBook AS FinancialTransactionHedgeBook,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransInternalReference AS FinTransInternalReference,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransGeneralValuationClass AS FinTransGeneralValuationClass,
  I_CmmdtyHdgMigrtnFinTransCmpst.TermEndDate AS FinTransactionTermEndDate,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinancialTransactionAssignment AS FinancialTransactionAssignment,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransactionCharacteristic AS FinTransactionCharacteristic,
  I_CmmdtyHdgMigrtnFinTransCmpst.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransTradedPriceCrcyUnit AS FinTransTradedPriceCrcyUnit,
  I_CmmdtyHdgMigrtnFinTransCmpst.FinTransacTradedPriceAmount AS FinTransacTradedPriceAmount,
  I_CmmdtyHdgMigrtnFinTransCmpst._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_CmmdtyHdgMigrtnFinTransCmpst._ProdTypeText.FinancialInstrProdTypeName AS FinTransactionProductTypeText,
  I_CmmdtyHdgMigrtnFinTransCmpst._TransactionTypeText.FinancialInstrTransTypeName AS FinancialTransactionTypeText,
  I_CmmdtyHdgMigrtnFinTransCmpst._CmmdtyHdgPlngDataDirectionT.PlanningDataDirectionText AS PlanningDataDirectionText,
  I_CmmdtyHdgMigrtnFinTransCmpst._DerivativeContractSpecText.DerivativeContrSpecName AS DerivativeContrSpecName,
  I_CmmdtyHdgMigrtnFinTransCmpst._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _HedgeConstellation.CompanyCode AS CompanyCode,
  _HedgeConstellation.CmmdtyHedgeConstellationDeal AS CmmdtyHedgeConstellationDeal
FROM I_CmmdtyHdgMigrtnFinTransCmpst
LEFT OUTER JOIN I_CmmdtyHedgeMigrationItemDeal AS _CmmdtyHdgMigrtnRlvtCandRslt ON FinTransactionObjectNumber = _CmmdtyHdgMigrtnRlvtCandRslt.FinTransactionObjectNumber  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyHdgCnstltnDealUnion AS _HedgeConstellation ON FinTransactionCompanyCode = _HedgeConstellation.CompanyCode AND FinTransactionDealIdentifier = _HedgeConstellation.CmmdtyHedgeConstellationDeal  -- association [0..1]
;

Learn More