C_CmmdtyHdgMigrtnItmRefTP

DDL: C_CMMDTYHDGMIGRTNITMREFTP Type: view_entity CONSUMPTION Package: FIN_CMM_CMDTY_HEDGE_REQUESTS
34 Fields 1 Data Sources 1 OData Services

Migration Item Reference Consumption

C_CmmdtyHdgMigrtnItmRefTP is a Consumption CDS View that provides data about "Migration Item Reference Consumption" in SAP S/4HANA. It reads from 1 data source (R_CmmdtyHdgMigrtnItmRefTP) and exposes 34 fields with key field MigrationItemUUID. It is exposed through 1 OData service (UI_CMMDTYHDGMIGRATIONREQ). Part of development package FIN_CMM_CMDTY_HEDGE_REQUESTS.

Data Sources (1)

SourceAliasJoin Type
R_CmmdtyHdgMigrtnItmRefTP R_CmmdtyHdgMigrtnItmRefTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Migration Item Reference Consumption view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CMMDTYHDGMIGRATIONREQ UI_CMMDTYHDGMIGRATIONREQ V2 C1 NOT_RELEASED

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY MigrationItemUUID MigrationItemUUID
MigrationRequestUUID MigrationRequestUUID
MigrationItemParentUUID MigrationItemParentUUID
MigrationItemCompanyCode MigrationItemCompanyCode
MigrationItemDealIdentifier MigrationItemDealIdentifier
MigrationItemIsMigrated MigrationItemIsMigrated
MigrationItemPortfolio MigrationItemPortfolio
MigrtnItmHedgingClassification MigrtnItmHedgingClassification
MigrationItemHedgeBook MigrationItemHedgeBook
MigrationItemOnBehalfOfCompany MigrationItemOnBehalfOfCompany
MigrationObjectNumber MigrationObjectNumber
FinTransactionDealIdentifier FinTransactionDealIdentifier
FinTransactionProductType FinTransactionProductType
FinTransContractStartDate FinTransContractStartDate
FinTransContractStartTime FinTransContractStartTime
FinTransactionCounterparty FinTransactionCounterparty
FinancialInstrTransactionType FinancialInstrTransactionType
FinancialTransactionTypeText FinancialTransactionTypeText
FinancialTransactionQuantity FinancialTransactionQuantity
FinTransactionQuantityUnit FinTransactionQuantityUnit
FinancialTransactionDCSID FinancialTransactionDCSID
FinTransactionPricingStartDate FinTransactionPricingStartDate
FinTransactionPricingEndDate FinTransactionPricingEndDate
FinTransactionProductTypeText FinTransactionProductTypeText
FinTransactionObjectNumber FinTransactionObjectNumber
FinancialTransactionPortfolio FinancialTransactionPortfolio
FinTransInternalReference FinTransInternalReference
FinTransactionTermEndDate FinTransactionTermEndDate
MigrationTradedPriceText MigrationTradedPriceText
PlanningDataDirectionText PlanningDataDirectionText
DerivativeContrSpecName DerivativeContrSpecName
CompanyCodeName CompanyCodeName Company Name
BusinessPartnerName BusinessPartnerName Extracted Customer Name
_CmmdtyMigrtnRelatedDealComp _CmmdtyMigrtnRelatedDealComp

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_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 C_CmmdtyHdgMigrtnItmRefTP AS
SELECT
  MigrationItemUUID,
  MigrationRequestUUID,
  MigrationItemParentUUID,
  MigrationItemCompanyCode,
  MigrationItemDealIdentifier,
  MigrationItemIsMigrated,
  MigrationItemPortfolio,
  MigrtnItmHedgingClassification,
  MigrationItemHedgeBook,
  MigrationItemOnBehalfOfCompany,
  MigrationObjectNumber,
  FinTransactionDealIdentifier,
  FinTransactionProductType,
  FinTransContractStartDate,
  FinTransContractStartTime,
  FinTransactionCounterparty,
  FinancialInstrTransactionType,
  FinancialTransactionTypeText,
  FinancialTransactionQuantity,
  FinTransactionQuantityUnit,
  FinancialTransactionDCSID,
  FinTransactionPricingStartDate,
  FinTransactionPricingEndDate,
  FinTransactionProductTypeText,
  FinTransactionObjectNumber,
  FinancialTransactionPortfolio,
  FinTransInternalReference,
  FinTransactionTermEndDate,
  MigrationTradedPriceText,
  PlanningDataDirectionText,
  DerivativeContrSpecName,
  CompanyCodeName,
  BusinessPartnerName
FROM R_CmmdtyHdgMigrtnItmRefTP
;

Learn More