P_CmmdtyHdgTgtQtaExpsrMapPerd

DDL: P_CMMDTYHDGTGTQTAEXPSRMAPPERD SQL: PCMDTYTQEXPSMPRD Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_TQ
18 Fields 4 Data Sources

TgtQta to Expsr Period mapping

P_CmmdtyHdgTgtQtaExpsrMapPerd is a Composite CDS View that provides data about "TgtQta to Expsr Period mapping" in SAP S/4HANA. It reads from 4 data sources (P_CmmdtyHdgExpsrVersionPeriod, I_CmmdtyHdgTgtQuotaPeriodicity, I_CmmdtyHdgTargetQuotaPosition, I_CmmdtyHdgTrdOrdTgtQtaRqdVers) and exposes 18 fields with key fields CmmdtyHedgeTargetQuotaUUID, CmmdtyHdgPlnExpsrCompanyCode, CmmdtyHedgePlanExposureDCSID, CmmdtyHdgPlanExposureDirection. Part of development package FIN_CMM_CMDTY_HEDGE_TQ.

Data Sources (4)

SourceAliasJoin Type
P_CmmdtyHdgExpsrVersionPeriod _Expsr inner
I_CmmdtyHdgTgtQuotaPeriodicity _periodcity inner
I_CmmdtyHdgTargetQuotaPosition _Tqpositions inner
I_CmmdtyHdgTrdOrdTgtQtaRqdVers I_CmmdtyHdgTrdOrdTgtQtaRqdVers inner

Parameters (2)

NameTypeDefault
P_CompanyCode bukrs
P_ValidFrom cmm_plan_valid_from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PCMDTYTQEXPSMPRD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label TgtQta to Expsr Period mapping 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 (18)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHedgeTargetQuotaUUID _TargetQuota CmmdtyHedgeTargetQuotaUUID UUID
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
CmmdtyHedgeTargetQuotaVersion _TargetQuota CmmdtyHedgeTargetQuotaVersion
CmmdtyHdgTgtQuotaIsFullyHedged _TargetQuota CmmdtyHdgTgtQuotaIsFullyHedged
IsActive _TargetQuota IsActive Object active?
CommodityHedgePlanExposureID P_CmmdtyHdgExpsrVersionPeriod CommodityHedgePlanExposureID Plan Exposure ID
CmmdtyHedgePlanExposureVersion P_CmmdtyHdgExpsrVersionPeriod CmmdtyHedgePlanExposureVersion Exposure Version No.
CmmdtyHdgPlnExpsrDelivPerdYear P_CmmdtyHdgExpsrVersionPeriod CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
CmmdtyHdgPlnExpsrDelivStrtDate P_CmmdtyHdgExpsrVersionPeriod CmmdtyHdgPlnExpsrDelivStrtDate Delivery Start Date
CmmdtyHdgPlnExpsrDelivEndDate P_CmmdtyHdgExpsrVersionPeriod CmmdtyHdgPlnExpsrDelivEndDate Delivery End Date
CmmdtyHdgPlnExpsrPeriodClass P_CmmdtyHdgExpsrVersionPeriod CmmdtyHdgPlnExpsrPeriodClass Period Class
CmmdtyHdgPlnExpsrDelivPerdType P_CmmdtyHdgExpsrVersionPeriod CmmdtyHdgTgtQuotaPeriodNumber Period Number
CmmdtyHdgTgtQuotaPeriodClass _TargetQuota CmmdtyHdgTgtQuotaPeriodClass Period Class
CmmdtyHdgTgtQuotaPeriodNumber I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQuotaPeriodNumber Period Number
CmmdtyHdgTgtQtaPerdStartValue I_CmmdtyHdgTgtQuotaPeriodicity CmmdtyHdgTgtQtaPerdStartValue Time Stamp

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_CmmdtyHdgTgtQtaExpsrMapPerd.
-- 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: PCMDTYTQEXPSMPRD
-- Parameters: P_CompanyCode : bukrs, P_ValidFrom : cmm_plan_valid_from

CREATE VIEW P_CmmdtyHdgTgtQtaExpsrMapPerd AS
SELECT
  _TargetQuota.CmmdtyHedgeTargetQuotaUUID AS CmmdtyHedgeTargetQuotaUUID,
  _Expsr.CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCompanyCode,
  _Expsr.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  _Expsr.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  _Expsr.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  _TargetQuota.CmmdtyHedgeTargetQuotaVersion AS CmmdtyHedgeTargetQuotaVersion,
  _TargetQuota.CmmdtyHdgTgtQuotaIsFullyHedged AS CmmdtyHdgTgtQuotaIsFullyHedged,
  _TargetQuota.IsActive AS IsActive,
  _Expsr.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  _Expsr.CmmdtyHedgePlanExposureVersion AS CmmdtyHedgePlanExposureVersion,
  _Expsr.CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDelivPerdYear,
  _Expsr.CmmdtyHdgPlnExpsrDelivStrtDate AS CmmdtyHdgPlnExpsrDelivStrtDate,
  _Expsr.CmmdtyHdgPlnExpsrDelivEndDate AS CmmdtyHdgPlnExpsrDelivEndDate,
  _Expsr.CmmdtyHdgPlnExpsrPeriodClass AS CmmdtyHdgPlnExpsrPeriodClass,
  _Expsr.CmmdtyHdgTgtQuotaPeriodNumber AS CmmdtyHdgPlnExpsrDelivPerdType,
  _TargetQuota.CmmdtyHdgTgtQuotaPeriodClass AS CmmdtyHdgTgtQuotaPeriodClass,
  _Tqpositions.CmmdtyHdgTgtQuotaPeriodNumber AS CmmdtyHdgTgtQuotaPeriodNumber,
  _periodcity.CmmdtyHdgTgtQtaPerdStartValue AS CmmdtyHdgTgtQtaPerdStartValue
INNER JOIN I_CmmdtyHdgTrdOrdTgtQtaRqdVers 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_CmmdtyHdgTargetQuotaPosition AS _Tqpositions ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyHdgTgtQuotaPeriodicity AS _periodcity ON /* join condition not captured in parsed metadata */
;

Learn More