R_CmmdtyHdgMigrtnItmRefTP

DDL: R_CMMDTYHDGMIGRTNITMREFTP Type: view_entity TRANSACTIONAL Package: FIN_CMM_CMDTY_HEDGE_REQUESTS
38 Fields 1 Data Sources 2 Associations

Migration Item Reference BO - TP

R_CmmdtyHdgMigrtnItmRefTP is a Transactional CDS View that provides data about "Migration Item Reference BO - TP" in SAP S/4HANA. It reads from 1 data source (I_CommodityHedgeMigrationItem) and exposes 38 fields with key field MigrationItemUUID. It has 2 associations to related views. Part of development package FIN_CMM_CMDTY_HEDGE_REQUESTS.

Data Sources (1)

SourceAliasJoin Type
I_CommodityHedgeMigrationItem I_CommodityHedgeMigrationItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_CmmdtyHdgMigrationRequestTP _MigrationRequestTP $projection.MigrationRequestUUID = _MigrationRequestTP.MigrationRequestUUID
[1..1] I_CmmdtyHdgMigrtnItmDealCmpst _CmmdtyMigrtnRelatedDealComp $projection.MigrationObjectNumber = _CmmdtyMigrtnRelatedDealComp.FinTransactionObjectNumber

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Migration Item Reference BO - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY MigrationItemUUID MigrationItemUUID UUID
MigrationRequestUUID MigrationRequestUUID UUID
MigrationItemParentUUID MigrationItemParentUUID UUID
MigrationItemCompanyCode MigrationItemCompanyCode Company Code
MigrationItemDealIdentifier MigrationItemDealIdentifier Transaction
MigrationItemIsMigrated MigrationItemIsMigrated TRUE
MigrationItemPortfolio MigrationItemPortfolio Portfolio
MigrtnItmHedgingClassification MigrtnItmHedgingClassification Hedging Classificatn
MigrationItemHedgeBook MigrationItemHedgeBook Hedge Book
MigrationItemOnBehalfOfCompany MigrationItemOnBehalfOfCompany On Behalf of CoCode
MigrationObjectNumber MigrationObjectNumber Val. Obj. No.
FinTransactionDealIdentifier _CmmdtyMigrtnRelatedDealComp FinTransactionDealIdentifier
FinTransactionProductType _CmmdtyMigrtnRelatedDealComp FinTransactionProductType
FinTransContractStartDate _CmmdtyMigrtnRelatedDealComp FinTransContractStartDate
FinTransContractStartTime _CmmdtyMigrtnRelatedDealComp FinTransContractStartTime
FinTransactionCounterparty _CmmdtyMigrtnRelatedDealComp FinTransactionCounterparty
FinancialInstrTransactionType _CmmdtyMigrtnRelatedDealComp FinancialInstrTransactionType
FinancialTransactionTypeText _CmmdtyMigrtnRelatedDealComp FinancialTransactionTypeText
FinancialTransactionQuantity _CmmdtyMigrtnRelatedDealComp FinancialTransactionQuantity
FinTransactionQuantityUnit _CmmdtyMigrtnRelatedDealComp FinTransactionQuantityUnit
FinancialTransactionDCSID _CmmdtyMigrtnRelatedDealComp FinancialTransactionDCSID
FinTransactionPricingStartDate _CmmdtyMigrtnRelatedDealComp FinTransactionPricingStartDate
FinTransactionPricingEndDate _CmmdtyMigrtnRelatedDealComp FinTransactionPricingEndDate
FinTransactionProductTypeText _CmmdtyMigrtnRelatedDealComp FinTransactionProductTypeText
FinTransactionObjectNumber _CmmdtyMigrtnRelatedDealComp FinTransactionObjectNumber
FinancialTransactionPortfolio _CmmdtyMigrtnRelatedDealComp FinancialTransactionPortfolio
FinTransInternalReference _CmmdtyMigrtnRelatedDealComp FinTransInternalReference
FinTransactionTermEndDate _CmmdtyMigrtnRelatedDealComp FinTransactionTermEndDate
MigrationTradedPriceText _CmmdtyMigrtnRelatedDealComp MigrationTradedPriceText
FinTransacTradedPriceAmount _CmmdtyMigrtnRelatedDealComp FinTransacTradedPriceAmount
FinTransTradedPriceCrcyUnit _CmmdtyMigrtnRelatedDealComp FinTransTradedPriceCrcyUnit
PlanningDataDirectionText _CmmdtyMigrtnRelatedDealComp PlanningDataDirectionText
DerivativeContrSpecName _CmmdtyMigrtnRelatedDealComp DerivativeContrSpecName
CompanyCodeName _CmmdtyMigrtnRelatedDealComp CompanyCodeName Company Name
BusinessPartnerName _CmmdtyMigrtnRelatedDealComp BusinessPartnerName Extracted Customer Name
_CmmdtyMigrtnRelatedDealComp _CmmdtyMigrtnRelatedDealComp
_MigrationRequestItemTP _MigrationRequestItemTP
_MigrationRequestTP _MigrationRequestTP

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 R_CmmdtyHdgMigrtnItmRefTP.
-- 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 R_CmmdtyHdgMigrtnItmRefTP AS
SELECT
  MigrationItemUUID,
  MigrationRequestUUID,
  MigrationItemParentUUID,
  MigrationItemCompanyCode,
  MigrationItemDealIdentifier,
  MigrationItemIsMigrated,
  MigrationItemPortfolio,
  MigrtnItmHedgingClassification,
  MigrationItemHedgeBook,
  MigrationItemOnBehalfOfCompany,
  MigrationObjectNumber,
  _CmmdtyMigrtnRelatedDealComp.FinTransactionDealIdentifier AS FinTransactionDealIdentifier,
  _CmmdtyMigrtnRelatedDealComp.FinTransactionProductType AS FinTransactionProductType,
  _CmmdtyMigrtnRelatedDealComp.FinTransContractStartDate AS FinTransContractStartDate,
  _CmmdtyMigrtnRelatedDealComp.FinTransContractStartTime AS FinTransContractStartTime,
  _CmmdtyMigrtnRelatedDealComp.FinTransactionCounterparty AS FinTransactionCounterparty,
  _CmmdtyMigrtnRelatedDealComp.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  _CmmdtyMigrtnRelatedDealComp.FinancialTransactionTypeText AS FinancialTransactionTypeText,
  _CmmdtyMigrtnRelatedDealComp.FinancialTransactionQuantity AS FinancialTransactionQuantity,
  _CmmdtyMigrtnRelatedDealComp.FinTransactionQuantityUnit AS FinTransactionQuantityUnit,
  _CmmdtyMigrtnRelatedDealComp.FinancialTransactionDCSID AS FinancialTransactionDCSID,
  _CmmdtyMigrtnRelatedDealComp.FinTransactionPricingStartDate AS FinTransactionPricingStartDate,
  _CmmdtyMigrtnRelatedDealComp.FinTransactionPricingEndDate AS FinTransactionPricingEndDate,
  _CmmdtyMigrtnRelatedDealComp.FinTransactionProductTypeText AS FinTransactionProductTypeText,
  _CmmdtyMigrtnRelatedDealComp.FinTransactionObjectNumber AS FinTransactionObjectNumber,
  _CmmdtyMigrtnRelatedDealComp.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  _CmmdtyMigrtnRelatedDealComp.FinTransInternalReference AS FinTransInternalReference,
  _CmmdtyMigrtnRelatedDealComp.FinTransactionTermEndDate AS FinTransactionTermEndDate,
  _CmmdtyMigrtnRelatedDealComp.MigrationTradedPriceText AS MigrationTradedPriceText,
  _CmmdtyMigrtnRelatedDealComp.FinTransacTradedPriceAmount AS FinTransacTradedPriceAmount,
  _CmmdtyMigrtnRelatedDealComp.FinTransTradedPriceCrcyUnit AS FinTransTradedPriceCrcyUnit,
  _CmmdtyMigrtnRelatedDealComp.PlanningDataDirectionText AS PlanningDataDirectionText,
  _CmmdtyMigrtnRelatedDealComp.DerivativeContrSpecName AS DerivativeContrSpecName,
  _CmmdtyMigrtnRelatedDealComp.CompanyCodeName AS CompanyCodeName,
  _CmmdtyMigrtnRelatedDealComp.BusinessPartnerName AS BusinessPartnerName
FROM I_CommodityHedgeMigrationItem
LEFT OUTER JOIN R_CmmdtyHdgMigrationRequestTP AS _MigrationRequestTP ON MigrationRequestUUID = _MigrationRequestTP.MigrationRequestUUID  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyHdgMigrtnItmDealCmpst AS _CmmdtyMigrtnRelatedDealComp ON MigrationObjectNumber = _CmmdtyMigrtnRelatedDealComp.FinTransactionObjectNumber  -- association [1..1]
;

Learn More