P_CmmdtyHdgTgtQtaExpsrPerdMap

DDL: P_CMMDTYHDGTGTQTAEXPSRPERDMAP SQL: PCMDTYTQEXPSRPRD Type: view COMPOSITE
12 Fields 3 Data Sources

Map Target Quota to Exposure Period

P_CmmdtyHdgTgtQtaExpsrPerdMap is a Composite CDS View that provides data about "Map Target Quota to Exposure Period" in SAP S/4HANA. It reads from 3 data sources (P_CmmdtyHdgExpsrVersionPeriod, I_CmmdtyHdgTgtQuotaPeriodicity, P_CmmdtyHdgTgtQtaMaxVersion) and exposes 12 fields with key fields CmmdtyHedgeTargetQuotaUUID, CmmdtyHdgPlnExpsrCompanyCode, CmmdtyHedgePlanExposureDCSID, CmmdtyHdgPlanExposureDirection.

Data Sources (3)

SourceAliasJoin Type
P_CmmdtyHdgExpsrVersionPeriod _Expsr inner
I_CmmdtyHdgTgtQuotaPeriodicity _periodcity inner
P_CmmdtyHdgTgtQtaMaxVersion P_CmmdtyHdgTgtQtaMaxVersion inner

Parameters (1)

NameTypeDefault
P_ValidFrom cmm_plan_valid_from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PCMDTYTQEXPSRPRD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Map Target Quota to Exposure Period view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHedgeTargetQuotaUUID _TargetQuota CmmdtyHedgeTargetQuotaUUID
KEY CmmdtyHdgPlnExpsrCompanyCode P_CmmdtyHdgExpsrVersionPeriod CmmdtyHdgPlnExpsrCompanyCode Company Code
KEY CmmdtyHedgePlanExposureDCSID P_CmmdtyHdgExpsrVersionPeriod CmmdtyHedgePlanExposureDCSID DCS ID
KEY CmmdtyHdgPlanExposureDirection P_CmmdtyHdgExpsrVersionPeriod CmmdtyHdgPlanExposureDirection Buy or Sell
CmmdtyHdgPlanExposureHedgeBook P_CmmdtyHdgExpsrVersionPeriod CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHdgTgtQuotaIsFullyHedged _TargetQuota CmmdtyHdgTgtQuotaIsFullyHedged
CommodityHedgePlanExposureID P_CmmdtyHdgExpsrVersionPeriod CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHedgePlanExposureVersion P_CmmdtyHdgExpsrVersionPeriod CmmdtyHedgePlanExposureVersion Exposure Version No.
CmmdtyHdgPlnExpsrDelivPerdYear P_CmmdtyHdgExpsrVersionPeriod CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
CmmdtyHedgeTargetQuotaVersion _TargetQuota CmmdtyHedgeTargetQuotaVersion
CmmdtyHdgTgtQtaPerdStartValue I_CmmdtyHdgTgtQuotaPeriodicity CmmdtyHdgTgtQtaPerdStartValue Time Stamp
CmmdtyHdgTgtQuotaPeriodClass _TargetQuota CmmdtyHdgTgtQuotaPeriodClass Period Class

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_CmmdtyHdgTgtQtaExpsrPerdMap.
-- 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: PCMDTYTQEXPSRPRD
-- Parameters: P_ValidFrom : cmm_plan_valid_from

CREATE VIEW P_CmmdtyHdgTgtQtaExpsrPerdMap AS
SELECT
  _TargetQuota.CmmdtyHedgeTargetQuotaUUID AS CmmdtyHedgeTargetQuotaUUID,
  _Expsr.CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCompanyCode,
  _Expsr.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  _Expsr.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  _Expsr.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  _TargetQuota.CmmdtyHdgTgtQuotaIsFullyHedged AS CmmdtyHdgTgtQuotaIsFullyHedged,
  _Expsr.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  _Expsr.CmmdtyHedgePlanExposureVersion AS CmmdtyHedgePlanExposureVersion,
  _Expsr.CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDelivPerdYear,
  _TargetQuota.CmmdtyHedgeTargetQuotaVersion AS CmmdtyHedgeTargetQuotaVersion,
  _periodcity.CmmdtyHdgTgtQtaPerdStartValue AS CmmdtyHdgTgtQtaPerdStartValue,
  _TargetQuota.CmmdtyHdgTgtQuotaPeriodClass AS CmmdtyHdgTgtQuotaPeriodClass
INNER JOIN P_CmmdtyHdgTgtQtaMaxVersion ON /* join condition not captured in parsed metadata */
INNER JOIN P_CmmdtyHdgExpsrVersionPeriod 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