R_CmmdtyHdgMigrationRequestTP

DDL: R_CMMDTYHDGMIGRATIONREQUESTTP Type: view_entity TRANSACTIONAL
48 Fields 1 Data Sources 1 Associations

Migration Request BO - TP

R_CmmdtyHdgMigrationRequestTP is a Transactional CDS View that provides data about "Migration Request BO - TP" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgMigrtnReqComposite) and exposes 48 fields with key field MigrationRequestUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgMigrtnReqComposite I_CmmdtyHdgMigrtnReqComposite from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_CmmdtyHedgeMigrationItemTP _MigrationItemTP

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Migration Request BO - TP view
ObjectModel.representativeKey MigrationRequestUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name CommodityMigrationRequest view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY MigrationRequestUUID MigrationRequestUUID
MigrationRequestIdentifier MigrationRequestIdentifier
CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID UUID
MigrationRequestDate MigrationRequestDate
MigrationRequestRemarkNote MigrationRequestRemarkNote
MigrationRequestStatus MigrationRequestStatus
MigrtnReqStatusChangeReason MigrtnReqStatusChangeReason
MigrationRequestPortfolio MigrationRequestPortfolio
MigrtnReqHedgingClassification MigrtnReqHedgingClassification
CmmdtyHdgSpecificationID CmmdtyHdgSpecificationID
MigrationRequestLogHandle MigrationRequestLogHandle
MigrationRequestCreatedByUser MigrationRequestCreatedByUser
MigrtnRequestCreationDateTime MigrtnRequestCreationDateTime
MigrtnRequestLastChangedByUser MigrtnRequestLastChangedByUser
MigrtnReqLastChangedDateTime MigrtnReqLastChangedDateTime
MigrtnRequestStatusCriticality MigrtnRequestStatusCriticality
MigrtnRequestChangeDocumentID MigrtnRequestChangeDocumentID
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHedgePlnExposureQuantity CmmdtyHedgePlnExposureQuantity Qty
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlanExpsrMktIDCode CmmdtyHdgPlanExpsrMktIDCode MIC
CmmdtyHdgPlanExposureDirection CmmdtyHdgPlanExposureDirection Buy or Sell
CmmdtyHdgPlnExpsrHedgingArea CmmdtyHdgPlnExpsrHedgingArea Hedging Area
CmmdtyHdgPlnExpsrPrcgStartDate CmmdtyHdgPlnExpsrPrcgStartDate Pricing Start Date
CmmdtyHdgPlnExpsrPrcgEndDate CmmdtyHdgPlnExpsrPrcgEndDate Pricing End Date
CmmdtyHdgPlnExpsrDelivPerdText CmmdtyHdgPlnExpsrDelivPerdText Del. Period Descr.
CmmdtyHdgPlnExpsrDelivPerdType CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivPerdYear CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
CmmdtyHdgPlnExpsrPerdStartDate CmmdtyHdgPlnExpsrPerdStartDate Period Start
CmmdtyHdgPlnExpsrValidFromDate CmmdtyHdgPlnExpsrValidFromDate Valid-From Date
CmmdtyHdgPlnExpsrPeriodClass CmmdtyHdgPlnExpsrPeriodClass Period Class
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Exposure Version No.
PhysicalCommodity PhysicalCommodity
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup
_CompanyCode _CompanyCode
_Exposure _Exposure
_MigrationItemTP _MigrationItemTP
_CmmdtyHdgMigrtnReqStatus _CmmdtyHdgMigrtnReqStatus
_MigrtnReqUserText _MigrtnReqUserText
_DeliveryCategory _DeliveryCategory
_DrvtvContrSpec _DrvtvContrSpec
_TreasuryPortfolio _TreasuryPortfolio
_TreasuryHedgingClassfctn _TreasuryHedgingClassfctn
_CmmdtyHdgPlngDataDirection _CmmdtyHdgPlngDataDirection

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_CmmdtyHdgMigrationRequestTP.
-- 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_CmmdtyHdgMigrationRequestTP AS
SELECT
  MigrationRequestUUID,
  MigrationRequestIdentifier,
  CommodityHedgePlanExposureUUID,
  MigrationRequestDate,
  MigrationRequestRemarkNote,
  MigrationRequestStatus,
  MigrtnReqStatusChangeReason,
  MigrationRequestPortfolio,
  MigrtnReqHedgingClassification,
  CmmdtyHdgSpecificationID,
  MigrationRequestLogHandle,
  MigrationRequestCreatedByUser,
  MigrtnRequestCreationDateTime,
  MigrtnRequestLastChangedByUser,
  MigrtnReqLastChangedDateTime,
  MigrtnRequestStatusCriticality,
  MigrtnRequestChangeDocumentID,
  LocalLastChangeDateTime,
  CmmdtyHdgPlnExpsrCompanyCode,
  CommodityHedgePlanExposureID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlanExpsrMktIDCode,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlnExpsrPerdStartDate,
  CmmdtyHdgPlnExpsrValidFromDate,
  CmmdtyHdgPlnExpsrPeriodClass,
  CmmdtyHedgePlanExposureVersion,
  PhysicalCommodity,
  CmmdtyHdgBookAuthznGroup
FROM I_CmmdtyHdgMigrtnReqComposite
LEFT OUTER JOIN R_CmmdtyHedgeMigrationItemTP AS _MigrationItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More