A_CmmdtyHdgRclassfctnRequest

DDL: A_CMMDTYHDGRCLASSFCTNREQUEST Type: view_entity CONSUMPTION Package: FIN_CMM_CMDTY_HEDGE_REQUESTS
18 Fields 1 Data Sources 1 OData Services

Reclassification Request

A_CmmdtyHdgRclassfctnRequest is a Consumption CDS View that provides data about "Reclassification Request" in SAP S/4HANA. It reads from 1 data source (R_CmmdtyHdgRclassfctnRequestTP) and exposes 18 fields with key field ReclassificationRequestUUID. It is exposed through 1 OData service (API_CMMDTYHDGRCLASSFCTNREQ). Part of development package FIN_CMM_CMDTY_HEDGE_REQUESTS.

Data Sources (1)

SourceAliasJoin Type
R_CmmdtyHdgRclassfctnRequestTP R_CmmdtyHdgRclassfctnRequestTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
OData.entityType.name A_CmmdtyHdgRclassfctnRequest_Type view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey ReclassificationRequestUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Reclassification Request view

OData Services (1)

ServiceBindingVersionContractRelease
API_CMMDTYHDGRCLASSFCTNREQ API_CMMDTYHDGRCLASSFCTNREQ V4 C2 C1

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ReclassificationRequestUUID ReclassificationRequestUUID
RclassfctnRequestIdentifier RclassfctnRequestIdentifier
CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID UUID
ReclassificationRequestDate ReclassificationRequestDate
RclassfctnRequestCategory RclassfctnRequestCategory
RclassfctnRequestRemarkNote RclassfctnRequestRemarkNote
RclassfctnRequestLogHandle RclassfctnRequestLogHandle
ReclassificationRequestStatus ReclassificationRequestStatus
RclassfctnReqStsChangeReason RclassfctnReqStsChangeReason
RclassfctnRequestCreatedByUser RclassfctnRequestCreatedByUser
RclassfctnReqCreationDateTime RclassfctnReqCreationDateTime
RclassfctnReqLastChangedByUser RclassfctnReqLastChangedByUser
RclassfctnReqLastChgdDateTime RclassfctnReqLastChgdDateTime
RclassfctnReqChangeDocumentID RclassfctnReqChangeDocumentID
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
PhysicalCommodity PhysicalCommodity
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup

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 A_CmmdtyHdgRclassfctnRequest.
-- 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 A_CmmdtyHdgRclassfctnRequest AS
SELECT
  ReclassificationRequestUUID,
  RclassfctnRequestIdentifier,
  CommodityHedgePlanExposureUUID,
  ReclassificationRequestDate,
  RclassfctnRequestCategory,
  RclassfctnRequestRemarkNote,
  RclassfctnRequestLogHandle,
  ReclassificationRequestStatus,
  RclassfctnReqStsChangeReason,
  RclassfctnRequestCreatedByUser,
  RclassfctnReqCreationDateTime,
  RclassfctnReqLastChangedByUser,
  RclassfctnReqLastChgdDateTime,
  RclassfctnReqChangeDocumentID,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  PhysicalCommodity,
  CmmdtyHdgBookAuthznGroup
FROM R_CmmdtyHdgRclassfctnRequestTP
;

Learn More