A_CmmdtyHdgCnstltnTaskList

DDL: A_CMMDTYHDGCNSTLTNTASKLIST Type: view_entity CONSUMPTION

Hedge Constellation Task List

A_CmmdtyHdgCnstltnTaskList is a Consumption CDS View that provides data about "Hedge Constellation Task List" in SAP S/4HANA. It reads from 1 data source (R_CmmdtyHdgCnstltnTaskListTP) and exposes 28 fields with key field ConstellationTaskListUUID.

Data Sources (1)

SourceAliasJoin Type
R_CmmdtyHdgCnstltnTaskListTP R_CmmdtyHdgCnstltnTaskListTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Hedge Constellation Task List view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
OData.entityType.name A_CmmdtyHdgCnstltnTaskList_Type view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ConstellationTaskListUUID ConstellationTaskListUUID
CnstltnTaskListIdentifier CnstltnTaskListIdentifier
CmmdtyHedgeConstellationUUID CmmdtyHedgeConstellationUUID
CnstltnTskListReprocgReason CnstltnTskListReprocgReason
CnstltnTskListReprocgStatus CnstltnTskListReprocgStatus
CnstltnTskListReprocgStsChgRsn CnstltnTskListReprocgStsChgRsn
CnstltnTaskListRemarkNote CnstltnTaskListRemarkNote
ConstellationTaskListOrigin ConstellationTaskListOrigin
CnstltnTskListIsProcRequired CnstltnTskListIsProcRequired
CnstltnTaskListCompanyCode CnstltnTaskListCompanyCode
CnstltnTskListCmmdtyTrdCoCode CnstltnTskListCmmdtyTrdCoCode
CnstltnTskListCommodityTradeID CnstltnTskListCommodityTradeID
CmmdtyHdgConstellationExposure CmmdtyHdgConstellationExposure
CmmdtyHdgCnstltnExpsrVersion CmmdtyHdgCnstltnExpsrVersion
CnstltnTaskListDealIdentifier CnstltnTaskListDealIdentifier
CompanyCode CompanyCode Receiver Company Code
CmmdtyHedgeConstellationDeal CmmdtyHedgeConstellationDeal
ConstellationTaskListAmount ConstellationTaskListAmount
ConstellationTaskListCurrency ConstellationTaskListCurrency
CnstltnTaskListCounterparty CnstltnTaskListCounterparty
CnstltnTaskListCreatedByUser CnstltnTaskListCreatedByUser
CnstltnTskListCreationDateTime CnstltnTskListCreationDateTime
CnstltnTskListLastChgdByUser CnstltnTskListLastChgdByUser
CnstltnTskListLastChgdDateTime CnstltnTskListLastChgdDateTime
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CnstltnTskListHdggClassfctn CnstltnTskListHdggClassfctn
ConstellationTaskListPortfolio ConstellationTaskListPortfolio
CnstltnTskListLateDsgntnDate CnstltnTskListLateDsgntnDate

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_CmmdtyHdgCnstltnTaskList.
-- 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_CmmdtyHdgCnstltnTaskList AS
SELECT
  ConstellationTaskListUUID,
  CnstltnTaskListIdentifier,
  CmmdtyHedgeConstellationUUID,
  CnstltnTskListReprocgReason,
  CnstltnTskListReprocgStatus,
  CnstltnTskListReprocgStsChgRsn,
  CnstltnTaskListRemarkNote,
  ConstellationTaskListOrigin,
  CnstltnTskListIsProcRequired,
  CnstltnTaskListCompanyCode,
  CnstltnTskListCmmdtyTrdCoCode,
  CnstltnTskListCommodityTradeID,
  CmmdtyHdgConstellationExposure,
  CmmdtyHdgCnstltnExpsrVersion,
  CnstltnTaskListDealIdentifier,
  CompanyCode,
  CmmdtyHedgeConstellationDeal,
  ConstellationTaskListAmount,
  ConstellationTaskListCurrency,
  CnstltnTaskListCounterparty,
  CnstltnTaskListCreatedByUser,
  CnstltnTskListCreationDateTime,
  CnstltnTskListLastChgdByUser,
  CnstltnTskListLastChgdDateTime,
  CmmdtyHdgPlnExpsrCompanyCode,
  CnstltnTskListHdggClassfctn,
  ConstellationTaskListPortfolio,
  CnstltnTskListLateDsgntnDate
FROM R_CmmdtyHdgCnstltnTaskListTP
;