I_CmmdtyHedgeMigrationItemDeal

DDL: I_CMMDTYHEDGEMIGRATIONITEMDEAL SQL: ICMMMGRITMDL Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_REQUESTS
36 Fields 1 Data Sources 1 Associations 1 OData Services

Migration Item Deal

I_CmmdtyHedgeMigrationItemDeal is a Composite CDS View that provides data about "Migration Item Deal" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgMigrtnRlvtCandRslt) and exposes 36 fields with key fields FinTransactionObjectNumber, ReltdFinTransObjectNumber. It has 1 association to related views. It is exposed through 1 OData service (UI_CMMDTYHDGMIGRATIONREQ). Part of development package FIN_CMM_CMDTY_HEDGE_REQUESTS.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgMigrtnRlvtCandRslt I_CmmdtyHdgMigrtnRlvtCandRslt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CmmdtyHdgMigrtnFinTransCmpst _CmmdtyHdgFinTransaction $projection.ReltdFinTransObjectNumber = _CmmdtyHdgFinTransaction.FinTransactionObjectNumber

Annotations (11)

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_CMMDTYHDGMIGRATIONREQ UI_CMMDTYHDGMIGRATIONREQ V2 C1 NOT_RELEASED

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY FinTransactionObjectNumber FinTransactionObjectNumber
KEY ReltdFinTransObjectNumber ReltdFinTransObjectNumber
FinTransactionCompanyCode _CmmdtyHdgFinTransaction FinTransactionCompanyCode
FinTransactionProductCategory _CmmdtyHdgFinTransaction FinTransactionProductCategory
FinTransactionDealIdentifier _CmmdtyHdgFinTransaction FinTransactionDealIdentifier
FinTransactionProductType _CmmdtyHdgFinTransaction FinTransactionProductType
FinTransContractStartDate _CmmdtyHdgFinTransaction FinTransContractStartDate
FinTransContractStartTime _CmmdtyHdgFinTransaction FinTransContractStartTime
FinTransactionCounterparty _CmmdtyHdgFinTransaction FinTransactionCounterparty
FinancialInstrTransactionType _CmmdtyHdgFinTransaction FinancialInstrTransactionType
FinTransHedgingClassification _CmmdtyHdgFinTransaction FinTransHedgingClassification
FinTransOnBehalfOfCompany _CmmdtyHdgFinTransaction FinTransOnBehalfOfCompany
FinancialTransactionQuantity _CmmdtyHdgFinTransaction FinancialTransactionQuantity
FinTransactionQuantityUnit _CmmdtyHdgFinTransaction FinTransactionQuantityUnit
FinTransFlowPaymentDate _CmmdtyHdgFinTransaction FinTransFlowPaymentDate
FinancialTransactionDCSID _CmmdtyHdgFinTransaction FinancialTransactionDCSID
FinancialTransactionDirection _CmmdtyHdgFinTransaction FinancialTransactionDirection
FinTransactionPricingStartDate _CmmdtyHdgFinTransaction FinTransactionPricingStartDate
FinTransactionPricingEndDate _CmmdtyHdgFinTransaction FinTransactionPricingEndDate
FinancialTransactionHedgeBook _CmmdtyHdgFinTransaction FinancialTransactionHedgeBook
FinTransactionTermEndDate _CmmdtyHdgFinTransaction TermEndDate
CommodityPriceExposureUnit _CmmdtyHdgFinTransaction CommodityPriceExposureUnit
FinTransTradedPriceCrcyUnit _CmmdtyHdgFinTransaction FinTransTradedPriceCrcyUnit
FinTransactionDirectionName _CmmdtyHdgFinTransaction FinTransactionDirectionName
FinTransacTradedPriceAmount _CmmdtyHdgFinTransaction FinTransacTradedPriceAmount
FinancialTransactionPortfolio _CmmdtyHdgFinTransaction FinancialTransactionPortfolio
FinTransGeneralValuationClass _CmmdtyHdgFinTransaction FinTransGeneralValuationClass
FinancialTransactionAssignment _CmmdtyHdgFinTransaction FinancialTransactionAssignment
FinTransInternalReference _CmmdtyHdgFinTransaction FinTransInternalReference
FinTransactionCharacteristic _CmmdtyHdgFinTransaction FinTransactionCharacteristic
_CompanyCode _CmmdtyHdgFinTransaction _CompanyCode
_ProdTypeText _CmmdtyHdgFinTransaction _ProdTypeText
_CmmdtyHdgPlngDataDirectionT _CmmdtyHdgFinTransaction _CmmdtyHdgPlngDataDirectionT
_DerivativeContractSpecText _CmmdtyHdgFinTransaction _DerivativeContractSpecText
_BusinessPartner _CmmdtyHdgFinTransaction _BusinessPartner
_CmmdtyHdgFinTransaction _CmmdtyHdgFinTransaction

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_CmmdtyHedgeMigrationItemDeal.
-- 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: ICMMMGRITMDL

CREATE VIEW I_CmmdtyHedgeMigrationItemDeal AS
SELECT
  FinTransactionObjectNumber,
  ReltdFinTransObjectNumber,
  _CmmdtyHdgFinTransaction.FinTransactionCompanyCode AS FinTransactionCompanyCode,
  _CmmdtyHdgFinTransaction.FinTransactionProductCategory AS FinTransactionProductCategory,
  _CmmdtyHdgFinTransaction.FinTransactionDealIdentifier AS FinTransactionDealIdentifier,
  _CmmdtyHdgFinTransaction.FinTransactionProductType AS FinTransactionProductType,
  _CmmdtyHdgFinTransaction.FinTransContractStartDate AS FinTransContractStartDate,
  _CmmdtyHdgFinTransaction.FinTransContractStartTime AS FinTransContractStartTime,
  _CmmdtyHdgFinTransaction.FinTransactionCounterparty AS FinTransactionCounterparty,
  _CmmdtyHdgFinTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  _CmmdtyHdgFinTransaction.FinTransHedgingClassification AS FinTransHedgingClassification,
  _CmmdtyHdgFinTransaction.FinTransOnBehalfOfCompany AS FinTransOnBehalfOfCompany,
  _CmmdtyHdgFinTransaction.FinancialTransactionQuantity AS FinancialTransactionQuantity,
  _CmmdtyHdgFinTransaction.FinTransactionQuantityUnit AS FinTransactionQuantityUnit,
  _CmmdtyHdgFinTransaction.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  _CmmdtyHdgFinTransaction.FinancialTransactionDCSID AS FinancialTransactionDCSID,
  _CmmdtyHdgFinTransaction.FinancialTransactionDirection AS FinancialTransactionDirection,
  _CmmdtyHdgFinTransaction.FinTransactionPricingStartDate AS FinTransactionPricingStartDate,
  _CmmdtyHdgFinTransaction.FinTransactionPricingEndDate AS FinTransactionPricingEndDate,
  _CmmdtyHdgFinTransaction.FinancialTransactionHedgeBook AS FinancialTransactionHedgeBook,
  _CmmdtyHdgFinTransaction.TermEndDate AS FinTransactionTermEndDate,
  _CmmdtyHdgFinTransaction.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  _CmmdtyHdgFinTransaction.FinTransTradedPriceCrcyUnit AS FinTransTradedPriceCrcyUnit,
  _CmmdtyHdgFinTransaction.FinTransactionDirectionName AS FinTransactionDirectionName,
  _CmmdtyHdgFinTransaction.FinTransacTradedPriceAmount AS FinTransacTradedPriceAmount,
  _CmmdtyHdgFinTransaction.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  _CmmdtyHdgFinTransaction.FinTransGeneralValuationClass AS FinTransGeneralValuationClass,
  _CmmdtyHdgFinTransaction.FinancialTransactionAssignment AS FinancialTransactionAssignment,
  _CmmdtyHdgFinTransaction.FinTransInternalReference AS FinTransInternalReference,
  _CmmdtyHdgFinTransaction.FinTransactionCharacteristic AS FinTransactionCharacteristic,
  _CmmdtyHdgFinTransaction._CompanyCode AS _CompanyCode,
  _CmmdtyHdgFinTransaction._ProdTypeText AS _ProdTypeText,
  _CmmdtyHdgFinTransaction._CmmdtyHdgPlngDataDirectionT AS _CmmdtyHdgPlngDataDirectionT,
  _CmmdtyHdgFinTransaction._DerivativeContractSpecText AS _DerivativeContractSpecText,
  _CmmdtyHdgFinTransaction._BusinessPartner AS _BusinessPartner
FROM I_CmmdtyHdgMigrtnRlvtCandRslt
LEFT OUTER JOIN I_CmmdtyHdgMigrtnFinTransCmpst AS _CmmdtyHdgFinTransaction ON ReltdFinTransObjectNumber = _CmmdtyHdgFinTransaction.FinTransactionObjectNumber  -- association [1..1]
;

Learn More