P_CmmdtyHdgCnstltnFinTrans

DDL: P_CMMDTYHDGCNSTLTNFINTRANS Type: view COMPOSITE
62 Fields 3 Data Sources 2 Associations

P_CmmdtyHdgCnstltnFinTrans is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (P_CmmdtyHdgFinTransUntCnvrsn, P_CmmdtyHdgCnstltnTransUnion, I_CmmdtyHdgExpsrRelByDteCmpst) and exposes 62 fields with key fields CommodityHedgePlanExposureID, CmmdtyHdgPlnExpsrCompanyCode, CmmdtyHedgeConstellationUUID, CmmdtyHdgCnstltnProductArea, CmmdtyHdgConstellationDealRole. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
P_CmmdtyHdgFinTransUntCnvrsn FTR_deal inner
P_CmmdtyHdgCnstltnTransUnion HConstDealUnion from
I_CmmdtyHdgExpsrRelByDteCmpst I_CmmdtyHdgExpsrRelByDteCmpst inner

Parameters (1)

NameTypeDefault
P_EvalDate dats

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_CompanyCode _ExposureCompanyCode $projection.CmmdtyHdgPlnExpsrCompanyCode = _ExposureCompanyCode.CompanyCode

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCMMFTRANSLIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureID P_CmmdtyHdgCnstltnTransUnion CommodityHedgePlanExposureID Plan Exposure ID
KEY CmmdtyHdgPlnExpsrCompanyCode _CM_Exposure CmmdtyHdgPlnExpsrCompanyCode Company Code
KEY CmmdtyHedgeConstellationUUID P_CmmdtyHdgCnstltnTransUnion CmmdtyHedgeConstellationUUID
KEY CmmdtyHdgCnstltnProductArea P_CmmdtyHdgCnstltnTransUnion CmmdtyHdgCnstltnProductArea
KEY CmmdtyHdgConstellationDealRole P_CmmdtyHdgCnstltnTransUnion CmmdtyHdgConstellationDealRole
KEY CompanyCode P_CmmdtyHdgCnstltnTransUnion CompanyCode Receiver Company Code
KEY FinancialTransaction P_CmmdtyHdgCnstltnTransUnion FinancialTransaction Transaction
KEY TreasuryValuationArea HRel TreasuryValuationArea
KEY HedgingRelationship HRel HedgingRelationship
KEY HedgingRelationshipFiscalYear HRel HedgingRelationshipFiscalYear
HedgingRelationshipStatus HRel HedgingRelationshipStatus
CmmdtyHdgCnstltnExpsrVersion P_CmmdtyHdgCnstltnTransUnion CmmdtyHdgCnstltnExpsrVersion
CmmdtyHedgePlanExposureVersion P_CmmdtyHdgCnstltnTransUnion CmmdtyHedgePlanExposureVersion Exposure Version No.
CmmdtyHdgCnstltnExposureItem P_CmmdtyHdgCnstltnTransUnion CmmdtyHdgCnstltnExposureItem
CmmdtyHedgePlanExposureItemID P_CmmdtyHdgCnstltnTransUnion CmmdtyHedgePlanExposureItemID Exposure Item ID
CmmdtyHdgCnstltnFrgnExchHdgReq P_CmmdtyHdgCnstltnTransUnion CmmdtyHdgCnstltnFrgnExchHdgReq
CmmdtyHdgCnstltnIsReversed P_CmmdtyHdgCnstltnTransUnion CmmdtyHdgCnstltnIsReversed
CreatedByUser P_CmmdtyHdgFinTransUntCnvrsn CreatedByUser User Name
CmmdtyHdgCnstltnValdFrmDteTime P_CmmdtyHdgCnstltnTransUnion CmmdtyHdgCnstltnValdFrmDteTime
FinTransCreationDate P_CmmdtyHdgFinTransUntCnvrsn FinTransCreationDate
FinTransContractDate P_CmmdtyHdgFinTransUntCnvrsn FinTransContractDate
TermStartDate P_CmmdtyHdgFinTransUntCnvrsn TermStartDate
TermEndDate P_CmmdtyHdgFinTransUntCnvrsn TermEndDate
FinTransFlowPaymentDate P_CmmdtyHdgFinTransUntCnvrsn FinTransFlowPaymentDate
FinTransactionPricingStartDate P_CmmdtyHdgFinTransUntCnvrsn FinTransactionPricingStartDate
FinTransactionPricingEndDate P_CmmdtyHdgFinTransUntCnvrsn FinTransactionPricingEndDate
FinTransTermRiskStartDate P_CmmdtyHdgFinTransUntCnvrsn FinTransTermRiskStartDate
FinTransactionTermRiskEndDate P_CmmdtyHdgFinTransUntCnvrsn FinTransactionTermRiskEndDate
FinTransActyConclusionDate P_CmmdtyHdgFinTransUntCnvrsn FinTransActyConclusionDate
FinTransActyConclusionTime P_CmmdtyHdgFinTransUntCnvrsn FinTransActyConclusionTime
FinTransActyConclusionTimeZone P_CmmdtyHdgFinTransUntCnvrsn FinTransActyConclusionTimeZone
FinancialInstrProductCategory P_CmmdtyHdgFinTransUntCnvrsn FinancialInstrProductCategory
FinInstrTransactionCategory P_CmmdtyHdgFinTransUntCnvrsn FinInstrTransactionCategory
FinancialInstrumentProductType P_CmmdtyHdgFinTransUntCnvrsn FinancialInstrumentProductType
FinancialInstrTransactionType P_CmmdtyHdgFinTransUntCnvrsn FinancialInstrTransactionType
Counterparty P_CmmdtyHdgFinTransUntCnvrsn Counterparty Supplier
FinancialTransactionHedgeBook P_CmmdtyHdgFinTransUntCnvrsn FinancialTransactionHedgeBook
DerivativeContrSpecification P_CmmdtyHdgFinTransUntCnvrsn DerivativeContrSpecification DCS ID
MarketIdentifierCode P_CmmdtyHdgFinTransUntCnvrsn MarketIdentifierCode MIC
FinancialInstrumentStatus P_CmmdtyHdgFinTransUntCnvrsn FinancialInstrumentStatus
FinancialTransactionDirection P_CmmdtyHdgFinTransUntCnvrsn FinancialTransactionDirection
FinTransacTradedPriceAmount P_CmmdtyHdgFinTransUntCnvrsn FinTransacTradedPriceAmount
FinTransTradedPriceCurrency P_CmmdtyHdgFinTransUntCnvrsn FinTransTradedPriceCurrency
Quantity P_CmmdtyHdgFinTransUntCnvrsn CmmdtyDealQtyInDCSUoM
UnitOfMeasure P_CmmdtyHdgFinTransUntCnvrsn DCSUnitOfMeasure Unit Protected Qty
_ProductType P_CmmdtyHdgFinTransUntCnvrsn _ProductType
_TimeZone P_CmmdtyHdgFinTransUntCnvrsn _TimeZone
_DCS P_CmmdtyHdgFinTransUntCnvrsn _DCS
CmmdtyHedgePlanExposureDCSID _CM_Exposure CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlanExposureHedgeBook _CM_Exposure CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHdgPlanExposureDirection _CM_Exposure CmmdtyHdgPlanExposureDirection Buy or Sell
CmmdtyHdgPlnExpsrPeriodClass _CM_Exposure CmmdtyHdgPlnExpsrPeriodClass Period Class
CmmdtyHdgIsPrcgInDelivPeriod _CM_Exposure CmmdtyHdgIsPrcgInDelivPeriod
CmmdtyHdgPlnExpsrDelivPerdYear _CM_Exposure CmmdtyHdgPlnExpsrDelivPerdYear Exposure Deliv. Year
CmmdtyHdgPlnExpsrDelivPerdType _CM_Exposure CmmdtyHdgPlnExpsrDelivPerdType Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivEndDate _CM_Exposure CmmdtyHdgPlnExpsrDelivEndDate Delivery End Date
CmmdtyHdgPlnExpsrPrcgEndDate _CM_Exposure CmmdtyHdgPlnExpsrPrcgEndDate Pricing End Date
CmmdtyHdgPlanExpsrMktIDCode _CM_Exposure CmmdtyHdgPlanExpsrMktIDCode MIC
CmmdtyHdgPlnExpsrQuantityUnit _CM_Exposure CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
_ExposureCompanyCode _ExposureCompanyCode
_CompanyCode _CompanyCode
_Counterparty P_CmmdtyHdgFinTransUntCnvrsn _Counterparty

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_CmmdtyHdgCnstltnFinTrans.
-- 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.
-- Parameters: P_EvalDate : dats

CREATE VIEW P_CmmdtyHdgCnstltnFinTrans AS
SELECT
  HConstDealUnion.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  _CM_Exposure.CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCompanyCode,
  HConstDealUnion.CmmdtyHedgeConstellationUUID AS CmmdtyHedgeConstellationUUID,
  HConstDealUnion.CmmdtyHdgCnstltnProductArea AS CmmdtyHdgCnstltnProductArea,
  HConstDealUnion.CmmdtyHdgConstellationDealRole AS CmmdtyHdgConstellationDealRole,
  HConstDealUnion.CompanyCode AS CompanyCode,
  HConstDealUnion.FinancialTransaction AS FinancialTransaction,
  HRel.TreasuryValuationArea AS TreasuryValuationArea,
  HRel.HedgingRelationship AS HedgingRelationship,
  HRel.HedgingRelationshipFiscalYear AS HedgingRelationshipFiscalYear,
  HRel.HedgingRelationshipStatus AS HedgingRelationshipStatus,
  HConstDealUnion.CmmdtyHdgCnstltnExpsrVersion AS CmmdtyHdgCnstltnExpsrVersion,
  HConstDealUnion.CmmdtyHedgePlanExposureVersion AS CmmdtyHedgePlanExposureVersion,
  HConstDealUnion.CmmdtyHdgCnstltnExposureItem AS CmmdtyHdgCnstltnExposureItem,
  HConstDealUnion.CmmdtyHedgePlanExposureItemID AS CmmdtyHedgePlanExposureItemID,
  HConstDealUnion.CmmdtyHdgCnstltnFrgnExchHdgReq AS CmmdtyHdgCnstltnFrgnExchHdgReq,
  HConstDealUnion.CmmdtyHdgCnstltnIsReversed AS CmmdtyHdgCnstltnIsReversed,
  FTR_deal.CreatedByUser AS CreatedByUser,
  HConstDealUnion.CmmdtyHdgCnstltnValdFrmDteTime AS CmmdtyHdgCnstltnValdFrmDteTime,
  FTR_deal.FinTransCreationDate AS FinTransCreationDate,
  FTR_deal.FinTransContractDate AS FinTransContractDate,
  FTR_deal.TermStartDate AS TermStartDate,
  FTR_deal.TermEndDate AS TermEndDate,
  FTR_deal.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  FTR_deal.FinTransactionPricingStartDate AS FinTransactionPricingStartDate,
  FTR_deal.FinTransactionPricingEndDate AS FinTransactionPricingEndDate,
  FTR_deal.FinTransTermRiskStartDate AS FinTransTermRiskStartDate,
  FTR_deal.FinTransactionTermRiskEndDate AS FinTransactionTermRiskEndDate,
  FTR_deal.FinTransActyConclusionDate AS FinTransActyConclusionDate,
  FTR_deal.FinTransActyConclusionTime AS FinTransActyConclusionTime,
  FTR_deal.FinTransActyConclusionTimeZone AS FinTransActyConclusionTimeZone,
  FTR_deal.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  FTR_deal.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  FTR_deal.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  FTR_deal.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  FTR_deal.Counterparty AS Counterparty,
  FTR_deal.FinancialTransactionHedgeBook AS FinancialTransactionHedgeBook,
  FTR_deal.DerivativeContrSpecification AS DerivativeContrSpecification,
  FTR_deal.MarketIdentifierCode AS MarketIdentifierCode,
  FTR_deal.FinancialInstrumentStatus AS FinancialInstrumentStatus,
  FTR_deal.FinancialTransactionDirection AS FinancialTransactionDirection,
  FTR_deal.FinTransacTradedPriceAmount AS FinTransacTradedPriceAmount,
  FTR_deal.FinTransTradedPriceCurrency AS FinTransTradedPriceCurrency,
  FTR_deal.CmmdtyDealQtyInDCSUoM AS Quantity,
  FTR_deal.DCSUnitOfMeasure AS UnitOfMeasure,
  FTR_deal._ProductType AS _ProductType,
  FTR_deal._TimeZone AS _TimeZone,
  FTR_deal._DCS AS _DCS,
  _CM_Exposure.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  _CM_Exposure.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  _CM_Exposure.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  _CM_Exposure.CmmdtyHdgPlnExpsrPeriodClass AS CmmdtyHdgPlnExpsrPeriodClass,
  _CM_Exposure.CmmdtyHdgIsPrcgInDelivPeriod AS CmmdtyHdgIsPrcgInDelivPeriod,
  _CM_Exposure.CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDelivPerdYear,
  _CM_Exposure.CmmdtyHdgPlnExpsrDelivPerdType AS CmmdtyHdgPlnExpsrDelivPerdType,
  _CM_Exposure.CmmdtyHdgPlnExpsrDelivEndDate AS CmmdtyHdgPlnExpsrDelivEndDate,
  _CM_Exposure.CmmdtyHdgPlnExpsrPrcgEndDate AS CmmdtyHdgPlnExpsrPrcgEndDate,
  _CM_Exposure.CmmdtyHdgPlanExpsrMktIDCode AS CmmdtyHdgPlanExpsrMktIDCode,
  _CM_Exposure.CmmdtyHdgPlnExpsrQuantityUnit AS CmmdtyHdgPlnExpsrQuantityUnit,
  FTR_deal._Counterparty AS _Counterparty
FROM P_CmmdtyHdgCnstltnTransUnion AS HConstDealUnion
INNER JOIN P_CmmdtyHdgFinTransUntCnvrsn AS FTR_deal ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyHdgExpsrRelByDteCmpst ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _ExposureCompanyCode ON CmmdtyHdgPlnExpsrCompanyCode = _ExposureCompanyCode.CompanyCode  -- association [0..1]
;

Learn More