P_CmmdtyHdgExpsrVersionPeriod

DDL: P_CMMDTYHDGEXPSRVERSIONPERIOD SQL: PCMMDTYHDGVERPRD Type: view COMPOSITE
36 Fields 2 Data Sources

Exposure Version Period

P_CmmdtyHdgExpsrVersionPeriod is a Composite CDS View that provides data about "Exposure Version Period" in SAP S/4HANA. It reads from 2 data sources (I_CommodityHedgePlanExposure, I_CmmdtyHdgTgtQuotaPeriodicity) and exposes 36 fields with key field CommodityHedgePlanExposureUUID.

Data Sources (2)

SourceAliasJoin Type
I_CommodityHedgePlanExposure _Expsr inner
I_CmmdtyHdgTgtQuotaPeriodicity _periodcity inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PCMMDTYHDGVERPRD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Exposure Version Period view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey CommodityHedgePlanExposureUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureUUID I_CommodityHedgePlanExposure CommodityHedgePlanExposureUUID UUID
CmmdtyHdgPlnExpsrCompanyCode I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHedgePlanExposureDCSID I_CommodityHedgePlanExposure CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlanExpsrMktIDCode I_CommodityHedgePlanExposure CmmdtyHdgPlanExpsrMktIDCode MIC
CmmdtyHdgPlanExposureDirection I_CommodityHedgePlanExposure CmmdtyHdgPlanExposureDirection Buy or Sell
CmmdtyHdgPlanExposureHedgeBook I_CommodityHedgePlanExposure CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHdgPlnExpsrPeriodClass I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrPeriodClass Period Class
CommodityHedgePlanExposureID I_CommodityHedgePlanExposure CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHdgPlanExposureCategory I_CommodityHedgePlanExposure CmmdtyHdgPlanExposureCategory Exposure Category
CmmdtyHdgPlnExpsrPerdStartDate I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrPerdStartDate Period Start
CmmdtyHdgPlnExpsrHedgingArea I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrHedgingArea Hedging Area
CmmdtyHdgTgtQuotaPeriodClass I_CmmdtyHdgTgtQuotaPeriodicity CmmdtyHdgTgtQuotaPeriodClass Period Class
CmmdtyHdgTgtQuotaPeriodNumber I_CmmdtyHdgTgtQuotaPeriodicity CmmdtyHdgTgtQuotaPeriodNumber Period Number
CmmdtyHdgTgtQtaPosPerdCategory I_CmmdtyHdgTgtQuotaPeriodicity CmmdtyHdgTgtQtaPosPerdCategory Period Category
CmmdtyHdgTgtQtaPerdLengthValue I_CmmdtyHdgTgtQuotaPeriodicity CmmdtyHdgTgtQtaPerdLengthValue Period Length
CmmdtyHdgTgtQtaPerdStartValue I_CmmdtyHdgTgtQuotaPeriodicity CmmdtyHdgTgtQtaPerdStartValue Time Stamp
CmmdtyHdgPlnExpsrDelivStrtDate I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrDelivStrtDate Delivery Start Date
CmmdtyHdgPlnExpsrDelivEndDate I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrDelivEndDate Delivery End Date
CmmdtyHdgPlnExpsrDelivPerdText I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrDelivPerdText Del. Period Descr.
CmmdtyHdgPlnExpsrDelivPerdType I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivPerdYear I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
CmmdtyHdgPlnExpsrPrcgStartDate I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrPrcgStartDate Pricing Start Date
CmmdtyHdgPlnExpsrPrcgEndDate I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrPrcgEndDate Pricing End Date
CmmdtyHedgePlnExposureQuantity I_CommodityHedgePlanExposure CmmdtyHedgePlnExposureQuantity Qty
CmmdtyHdgPlnExpsrQuantityUnit I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
CmmdtyHdgPlanExposureLogHandle I_CommodityHedgePlanExposure CmmdtyHdgPlanExposureLogHandle Log Handle
CmmdtyHedgePlanExposureStatus I_CommodityHedgePlanExposure CmmdtyHedgePlanExposureStatus Status
CmmdtyHedgePlanExposureVersion I_CommodityHedgePlanExposure CmmdtyHedgePlanExposureVersion Exposure Version No.
CmmdtyHdgPlnExpsrStsChgReason I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrStsChgReason Status Change Reason
CmmdtyHdgPlnExpsrCreatedByUser I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrCreatedByUser User Name
CmmdtyHdgPlnExpsrCrtnDateTime I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrCrtnDateTime Time Stamp
CmmdtyHdgPlnExpsrLastChgdByUsr I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrLastChgdByUsr User Name
CmmdtyHdgPlnExpsrChgDateTime I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrChgDateTime Time Stamp
_DCSAttributes I_CommodityHedgePlanExposure _DCSAttributes
_CompanyCode I_CommodityHedgePlanExposure _CompanyCode
_HedgeBook I_CommodityHedgePlanExposure _HedgeBook

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_CmmdtyHdgExpsrVersionPeriod.
-- 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.
-- SQL view name: PCMMDTYHDGVERPRD

CREATE VIEW P_CmmdtyHdgExpsrVersionPeriod AS
SELECT
  _Expsr.CommodityHedgePlanExposureUUID AS CommodityHedgePlanExposureUUID,
  _Expsr.CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCompanyCode,
  _Expsr.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  _Expsr.CmmdtyHdgPlanExpsrMktIDCode AS CmmdtyHdgPlanExpsrMktIDCode,
  _Expsr.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  _Expsr.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  _Expsr.CmmdtyHdgPlnExpsrPeriodClass AS CmmdtyHdgPlnExpsrPeriodClass,
  _Expsr.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  _Expsr.CmmdtyHdgPlanExposureCategory AS CmmdtyHdgPlanExposureCategory,
  _Expsr.CmmdtyHdgPlnExpsrPerdStartDate AS CmmdtyHdgPlnExpsrPerdStartDate,
  _Expsr.CmmdtyHdgPlnExpsrHedgingArea AS CmmdtyHdgPlnExpsrHedgingArea,
  _periodcity.CmmdtyHdgTgtQuotaPeriodClass AS CmmdtyHdgTgtQuotaPeriodClass,
  _periodcity.CmmdtyHdgTgtQuotaPeriodNumber AS CmmdtyHdgTgtQuotaPeriodNumber,
  _periodcity.CmmdtyHdgTgtQtaPosPerdCategory AS CmmdtyHdgTgtQtaPosPerdCategory,
  _periodcity.CmmdtyHdgTgtQtaPerdLengthValue AS CmmdtyHdgTgtQtaPerdLengthValue,
  _periodcity.CmmdtyHdgTgtQtaPerdStartValue AS CmmdtyHdgTgtQtaPerdStartValue,
  _Expsr.CmmdtyHdgPlnExpsrDelivStrtDate AS CmmdtyHdgPlnExpsrDelivStrtDate,
  _Expsr.CmmdtyHdgPlnExpsrDelivEndDate AS CmmdtyHdgPlnExpsrDelivEndDate,
  _Expsr.CmmdtyHdgPlnExpsrDelivPerdText AS CmmdtyHdgPlnExpsrDelivPerdText,
  _Expsr.CmmdtyHdgPlnExpsrDelivPerdType AS CmmdtyHdgPlnExpsrDelivPerdType,
  _Expsr.CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDelivPerdYear,
  _Expsr.CmmdtyHdgPlnExpsrPrcgStartDate AS CmmdtyHdgPlnExpsrPrcgStartDate,
  _Expsr.CmmdtyHdgPlnExpsrPrcgEndDate AS CmmdtyHdgPlnExpsrPrcgEndDate,
  _Expsr.CmmdtyHedgePlnExposureQuantity AS CmmdtyHedgePlnExposureQuantity,
  _Expsr.CmmdtyHdgPlnExpsrQuantityUnit AS CmmdtyHdgPlnExpsrQuantityUnit,
  _Expsr.CmmdtyHdgPlanExposureLogHandle AS CmmdtyHdgPlanExposureLogHandle,
  _Expsr.CmmdtyHedgePlanExposureStatus AS CmmdtyHedgePlanExposureStatus,
  _Expsr.CmmdtyHedgePlanExposureVersion AS CmmdtyHedgePlanExposureVersion,
  _Expsr.CmmdtyHdgPlnExpsrStsChgReason AS CmmdtyHdgPlnExpsrStsChgReason,
  _Expsr.CmmdtyHdgPlnExpsrCreatedByUser AS CmmdtyHdgPlnExpsrCreatedByUser,
  _Expsr.CmmdtyHdgPlnExpsrCrtnDateTime AS CmmdtyHdgPlnExpsrCrtnDateTime,
  _Expsr.CmmdtyHdgPlnExpsrLastChgdByUsr AS CmmdtyHdgPlnExpsrLastChgdByUsr,
  _Expsr.CmmdtyHdgPlnExpsrChgDateTime AS CmmdtyHdgPlnExpsrChgDateTime,
  _Expsr._DCSAttributes AS _DCSAttributes,
  _Expsr._CompanyCode AS _CompanyCode,
  _Expsr._HedgeBook AS _HedgeBook
INNER JOIN I_CommodityHedgePlanExposure AS _Expsr ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyHdgTgtQuotaPeriodicity AS _periodcity ON /* join condition not captured in parsed metadata */
;

Learn More