P_CmmdtyHdgMigrtnTransaction

DDL: P_CMMDTYHDGMIGRTNTRANSACTION Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_REQUESTS
16 Fields 1 Data Sources 1 Associations

Basic for Migration Transaction

P_CmmdtyHdgMigrtnTransaction is a Composite CDS View that provides data about "Basic for Migration Transaction" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgFinTransaction) and exposes 16 fields with key fields MigrationItemCompanyCode, MigrationItemDealIdentifier. It has 1 association to related views. Part of development package FIN_CMM_CMDTY_HEDGE_REQUESTS.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgFinTransaction I_CmmdtyHdgFinTransaction from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CommodityHedgePlanExposure _Exposure _Exposure.CommodityHedgePlanExposureUUID = _Exposure.CommodityHedgePlanExposureUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCMMHDGMGRTRANS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MigrationItemCompanyCode FinTransactionCompanyCode
KEY MigrationItemDealIdentifier FinTransactionDealIdentifier
FinTransactionObjectNumber FinTransactionObjectNumber
FinTransactionProductType FinTransactionProductType
FinTransactionCounterparty FinTransactionCounterparty
FinancialInstrTransactionType FinancialInstrTransactionType
FinancialTransactionHedgeBook FinancialTransactionHedgeBook
FinancialTransactionPortfolio FinancialTransactionPortfolio
FinTransGeneralValuationClass FinTransGeneralValuationClass
FinancialTransactionAssignment FinancialTransactionAssignment
FinTransInternalReference FinTransInternalReference
FinTransactionCharacteristic FinTransactionCharacteristic
FinTransHedgingClassification FinTransHedgingClassification
CmmdtyHedgePlanExposureDCSID _Exposure CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlnExpsrDelivPerdType _Exposure CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivPerdYear _Exposure CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year

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 P_CmmdtyHdgMigrtnTransaction.
-- 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 P_CmmdtyHdgMigrtnTransaction AS
SELECT
  FinTransactionCompanyCode AS MigrationItemCompanyCode,
  FinTransactionDealIdentifier AS MigrationItemDealIdentifier,
  FinTransactionObjectNumber,
  FinTransactionProductType,
  FinTransactionCounterparty,
  FinancialInstrTransactionType,
  FinancialTransactionHedgeBook,
  FinancialTransactionPortfolio,
  FinTransGeneralValuationClass,
  FinancialTransactionAssignment,
  FinTransInternalReference,
  FinTransactionCharacteristic,
  FinTransHedgingClassification,
  _Exposure.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  _Exposure.CmmdtyHdgPlnExpsrDelivPerdType AS CmmdtyHdgPlnExpsrDelivPerdType,
  _Exposure.CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDelivPerdYear
FROM I_CmmdtyHdgFinTransaction
LEFT OUTER JOIN I_CommodityHedgePlanExposure AS _Exposure ON _Exposure.CommodityHedgePlanExposureUUID = _Exposure.CommodityHedgePlanExposureUUID  -- association [1..1]
;

Learn More