C_CmmdtyHdgRclassfctnRequestTP

DDL: C_CMMDTYHDGRCLASSFCTNREQUESTTP Type: view_entity CONSUMPTION
46 Fields 1 Data Sources 1 Associations

Reclassification Request Consumption

C_CmmdtyHdgRclassfctnRequestTP is a Consumption CDS View that provides data about "Reclassification Request Consumption" in SAP S/4HANA. It reads from 1 data source (R_CmmdtyHdgRclassfctnRequestTP) and exposes 46 fields with key field ReclassificationRequestUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CmmdtyHdgRclassfctnRequestTP R_CmmdtyHdgRclassfctnRequestTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_CmmdtyHdgRclassfctnReqChgDoc _RclassfctnReqChgDoc $projection.RclassfctnReqChangeDocumentID = _RclassfctnReqChgDoc.ChangeDocObject

Annotations (7)

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

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY ReclassificationRequestUUID ReclassificationRequestUUID
RclassfctnRequestIdentifier RclassfctnRequestIdentifier
CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID UUID
ReclassificationRequestDate ReclassificationRequestDate
RclassfctnRequestCategory RclassfctnRequestCategory
RclassfctnRequestRemarkNote RclassfctnRequestRemarkNote
RclassfctnRequestLogHandle RclassfctnRequestLogHandle
ReclassificationRequestStatus ReclassificationRequestStatus
RclassfctnReqStsChangeReason RclassfctnReqStsChangeReason
RclassfctnReqStatusCriticality RclassfctnReqStatusCriticality
RclassfctnRequestCreatedByUser RclassfctnRequestCreatedByUser
RclassfctnReqCreatedByUserText _RclassfctnReqUserText RclassfctnReqCreatedByUserText
RclassfctnReqCreationDateTime RclassfctnReqCreationDateTime
RclassfctnReqLastChangedByUser RclassfctnReqLastChangedByUser
RclassfctnReqLastChgdByUsrText _RclassfctnReqUserText RclassfctnReqLastChgdByUsrText
RclassfctnReqLastChgdDateTime RclassfctnReqLastChgdDateTime
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
RclassfctnReqChangeDocumentID RclassfctnReqChangeDocumentID
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHdgPlnExpsrCoCodeText _CompanyCode CompanyCodeName Company Name
CommodityHedgePlanExposureID CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHedgePlnExposureQuantity CmmdtyHedgePlnExposureQuantity Qty
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
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
CmmdtyHdgPlnExpsrValidFromDate CmmdtyHdgPlnExpsrValidFromDate Valid-From Date
PhysicalCommodity PhysicalCommodity
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup
CmmdtyHdgPlnExposureRemarkNote CmmdtyHdgPlnExposureRemarkNote Remark
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion Exposure Version No.
char132
int1
_RclassfctnReqChgDoc _RclassfctnReqChgDoc
_CompanyCode _CompanyCode
RclassfctnRequestCategoryTextlocalized
RclassfctnRequestStatusTextlocalized
DerivativeContrSpecNamelocalized
PlngDataDeliveryCategoryTextlocalized
CmmdtyHedgeBookDescriptionlocalized
_Exposure _Exposure

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_CmmdtyHdgRclassfctnRequestTP.
-- 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_CmmdtyHdgRclassfctnRequestTP AS
SELECT
  ReclassificationRequestUUID,
  RclassfctnRequestIdentifier,
  CommodityHedgePlanExposureUUID,
  ReclassificationRequestDate,
  RclassfctnRequestCategory,
  RclassfctnRequestRemarkNote,
  RclassfctnRequestLogHandle,
  ReclassificationRequestStatus,
  RclassfctnReqStsChangeReason,
  RclassfctnReqStatusCriticality,
  RclassfctnRequestCreatedByUser,
  _RclassfctnReqUserText.RclassfctnReqCreatedByUserText AS RclassfctnReqCreatedByUserText,
  RclassfctnReqCreationDateTime,
  RclassfctnReqLastChangedByUser,
  _RclassfctnReqUserText.RclassfctnReqLastChgdByUsrText AS RclassfctnReqLastChgdByUsrText,
  RclassfctnReqLastChgdDateTime,
  LocalLastChangeDateTime,
  RclassfctnReqChangeDocumentID,
  CmmdtyHdgPlnExpsrCompanyCode,
  _CompanyCode.CompanyCodeName AS CmmdtyHdgPlnExpsrCoCodeText,
  CommodityHedgePlanExposureID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlnExpsrValidFromDate,
  PhysicalCommodity,
  CmmdtyHdgBookAuthznGroup,
  CmmdtyHdgPlnExposureRemarkNote,
  CmmdtyHedgePlanExposureVersion,
  virtual RclassfctnReqExceededQtyText : abap.char( 132 ) AS char132,
  virtual RclassfctnReqExcdQtyCritlty : abap.int1 AS int1,
  _RclassfctnReqCategory._Text.RclassfctnRequestCategoryText : localized AS RclassfctnRequestCategoryTextlocalized,
  _RclassfctnReqStatus._SystemStatusText.RclassfctnRequestStatusText : localized AS RclassfctnRequestStatusTextlocalized,
  _DrvtvContrSpec._Text.DerivativeContrSpecName : localized AS DerivativeContrSpecNamelocalized,
  _DeliveryCategory._Text.PlngDataDeliveryCategoryText : localized AS PlngDataDeliveryCategoryTextlocalized,
  _Exposure._HedgeBook._CmmdtyHdgBookText.CmmdtyHedgeBookDescription : localized AS CmmdtyHedgeBookDescriptionlocalized
FROM R_CmmdtyHdgRclassfctnRequestTP
LEFT OUTER JOIN C_CmmdtyHdgRclassfctnReqChgDoc AS _RclassfctnReqChgDoc ON RclassfctnReqChangeDocumentID = _RclassfctnReqChgDoc.ChangeDocObject  -- association [0..*]
;

Learn More