I_CmmdtyHedgeTransFlowActivity

DDL: I_CMMDTYHEDGETRANSFLOWACTIVITY SQL: ICMHDGTRANS Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_MANAGEMENT
33 Fields 7 Data Sources

Financial Transaction Flow

I_CmmdtyHedgeTransFlowActivity is a Composite CDS View that provides data about "Financial Transaction Flow" in SAP S/4HANA. It reads from 7 data sources and exposes 33 fields with key fields CmmdtyHedgeConstellationUUID, CmmdtyHedgeCnstltnRecordType, CmmdtyHedgeConstellationDeal, CmmdtyHdgConstellationDealType. Part of development package FIN_CMM_CMDTY_HEDGE_MANAGEMENT.

Data Sources (7)

SourceAliasJoin Type
I_CompanyCodeStdVH CompanyCode inner
I_CommodityHedgePlanExposure Exposures inner
I_FinTransActivity FinTransActivity inner
P_CmmdtyHdgExpsrRqdVersion P_CmmdtyHdgExpsrRqdVersion inner
vtbfha Transaction inner
I_CmmdtyHdgTransFlowDetails TransactionFlow inner
I_FinancialInstrProdTypeText TransProductType inner

Parameters (5)

NameTypeDefault
P_CmmdtyHdgUtilznPlnExposureID cmm_exposure_id
P_CmmdtyHdgUtilznEvalDate sydatum
P_CmmdtyHdgUtilznIsCnstltnData xfeld
P_CmmdtyHdgUtilznAreOverHedged xfeld
P_CmmdtyHdgPlanExposureVersion cmm_exposure_version

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICMHDGTRANS view
AbapCatalog.dataMaintenance #RESTRICTED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Financial Transaction Flow view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHedgeConstellationUUID HdgConstlnDeals CmmdtyHedgeConstellationUUID
KEY CmmdtyHedgeCnstltnRecordType HdgConstlnDeals CmmdtyHedgeCnstltnRecordType
KEY CmmdtyHedgeConstellationDeal HdgConstlnDeals CmmdtyHedgeConstellationDeal Transaction
KEY CmmdtyHdgConstellationDealType HdgConstlnDeals CmmdtyHdgConstellationDealType
CmmdtyHdgConstellationExposure HdgConstlnDeals CmmdtyHdgConstellationExposure
CmmdtyHdgCnstltnValdFrmDteTime HdgConstlnDeals CmmdtyHdgCnstltnValdFrmDteTime
CmmdtyHdgCnstltnExpsrVersion HdgConstlnDeals CmmdtyHdgCnstltnExpsrVersion
CmmdtyHdgCnstltnExposureItem HdgConstlnDeals CmmdtyHdgCnstltnExposureItem
CmmdtyHdgCnstltnFrgnExchHdgReq HdgConstlnDeals CmmdtyHdgCnstltnFrgnExchHdgReq
TermStartDate I_CmmdtyHdgTransFlowDetails FinTransactionPricingStartDate
TermEndDate I_CmmdtyHdgTransFlowDetails FinTransactionPricingEndDate
Counterparty vtbfha kontrh Partner
FinancialInstrumentProductType vtbfha sgsart Product Type
FinancialInstrProdTypeName I_FinancialInstrProdTypeText FinancialInstrProdTypeName
FinancialInstrProdTypeWithName
Quantity I_CmmdtyHdgTransFlowDetails Quantity Value
CmmdtyHdgSingleUnitOfQuantity
CmmdtyHedgePlnExposureQuantity
CmmdtyHdgPlnExpsrQuantityUnit I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrQuantityUnit Unit of Measure
UnitOfMeasure I_CmmdtyHdgTransFlowDetails UnitOfMeasure Unit Protected Qty
CommodityHedgePlanExposureUUID I_CommodityHedgePlanExposure CommodityHedgePlanExposureUUID UUID
CompanyCode HdgConstlnDeals CompanyCode Receiver Company Code
CompanyCodeName I_CompanyCodeStdVH CompanyCodeName Company Name
CmmdtyHdgCnstltnCoCodeWithName
CmmdtyHedgePlanExposureDCSID I_CommodityHedgePlanExposure CmmdtyHedgePlanExposureDCSID DCS ID
CmmdtyHdgPlanExpsrMktIDCode I_CommodityHedgePlanExposure CmmdtyHdgPlanExpsrMktIDCode MIC
CmmdtyHdgPlanExposureDirection I_CommodityHedgePlanExposure CmmdtyHdgPlanExposureDirection Buy or Sell
CmmdtyHdgPlanExposureHedgeBook I_CommodityHedgePlanExposure CmmdtyHdgPlanExposureHedgeBook Hedge Book
CmmdtyHdgPlnExpsrPerdStartDate I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrPerdStartDate Period Start
CmmdtyHdgPlnExpsrPeriodClass I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrPeriodClass Period Class
CmmdtyHdgIsPrcgInDelivPeriod I_CommodityHedgePlanExposure CmmdtyHdgIsPrcgInDelivPeriod
CmmdtyHdgPlnExpsrCompanyCode I_CommodityHedgePlanExposure CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHedgePlanExposureVersion I_CommodityHedgePlanExposure CmmdtyHedgePlanExposureVersion Exposure Version No.

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 I_CmmdtyHedgeTransFlowActivity.
-- 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: ICMHDGTRANS
-- Parameters: P_CmmdtyHdgUtilznPlnExposureID : cmm_exposure_id, P_CmmdtyHdgUtilznEvalDate : sydatum, P_CmmdtyHdgUtilznIsCnstltnData : xfeld, P_CmmdtyHdgUtilznAreOverHedged : xfeld, P_CmmdtyHdgPlanExposureVersion : cmm_exposure_version

CREATE VIEW I_CmmdtyHedgeTransFlowActivity AS
SELECT
  HdgConstlnDeals.CmmdtyHedgeConstellationUUID AS CmmdtyHedgeConstellationUUID,
  HdgConstlnDeals.CmmdtyHedgeCnstltnRecordType AS CmmdtyHedgeCnstltnRecordType,
  HdgConstlnDeals.CmmdtyHedgeConstellationDeal AS CmmdtyHedgeConstellationDeal,
  HdgConstlnDeals.CmmdtyHdgConstellationDealType AS CmmdtyHdgConstellationDealType,
  HdgConstlnDeals.CmmdtyHdgConstellationExposure AS CmmdtyHdgConstellationExposure,
  HdgConstlnDeals.CmmdtyHdgCnstltnValdFrmDteTime AS CmmdtyHdgCnstltnValdFrmDteTime,
  HdgConstlnDeals.CmmdtyHdgCnstltnExpsrVersion AS CmmdtyHdgCnstltnExpsrVersion,
  HdgConstlnDeals.CmmdtyHdgCnstltnExposureItem AS CmmdtyHdgCnstltnExposureItem,
  HdgConstlnDeals.CmmdtyHdgCnstltnFrgnExchHdgReq AS CmmdtyHdgCnstltnFrgnExchHdgReq,
  TransactionFlow.FinTransactionPricingStartDate AS TermStartDate,
  TransactionFlow.FinTransactionPricingEndDate AS TermEndDate,
  Transaction.kontrh AS Counterparty,
  Transaction.sgsart AS FinancialInstrumentProductType,
  TransProductType.FinancialInstrProdTypeName AS FinancialInstrProdTypeName,
  concat(concat(concat( TransProductType.FinancialInstrProdTypeName, '('), Transaction.sgsart), ')') AS FinancialInstrProdTypeWithName,
  TransactionFlow.Quantity AS Quantity,
  cast( 1 as ftr_quan) AS CmmdtyHdgSingleUnitOfQuantity,
  cast(Exposures.CmmdtyHedgePlnExposureQuantity as abap.fltp) AS CmmdtyHedgePlnExposureQuantity,
  Exposures.CmmdtyHdgPlnExpsrQuantityUnit AS CmmdtyHdgPlnExpsrQuantityUnit,
  TransactionFlow.UnitOfMeasure AS UnitOfMeasure,
  Exposures.CommodityHedgePlanExposureUUID AS CommodityHedgePlanExposureUUID,
  HdgConstlnDeals.CompanyCode AS CompanyCode,
  CompanyCode.CompanyCodeName AS CompanyCodeName,
  concat(concat(concat( CompanyCode.CompanyCodeName, '('), HdgConstlnDeals.CompanyCode), ')') AS CmmdtyHdgCnstltnCoCodeWithName,
  Exposures.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  Exposures.CmmdtyHdgPlanExpsrMktIDCode AS CmmdtyHdgPlanExpsrMktIDCode,
  Exposures.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  Exposures.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  Exposures.CmmdtyHdgPlnExpsrPerdStartDate AS CmmdtyHdgPlnExpsrPerdStartDate,
  Exposures.CmmdtyHdgPlnExpsrPeriodClass AS CmmdtyHdgPlnExpsrPeriodClass,
  Exposures.CmmdtyHdgIsPrcgInDelivPeriod AS CmmdtyHdgIsPrcgInDelivPeriod,
  Exposures.CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCompanyCode,
  Exposures.CmmdtyHedgePlanExposureVersion AS CmmdtyHedgePlanExposureVersion
INNER JOIN P_CmmdtyHdgExpsrRqdVersion ON /* join condition not captured in parsed metadata */
INNER JOIN I_CommodityHedgePlanExposure AS Exposures ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyHdgTransFlowDetails AS TransactionFlow ON /* join condition not captured in parsed metadata */
INNER JOIN vtbfha AS Transaction ON /* join condition not captured in parsed metadata */
INNER JOIN I_FinTransActivity AS FinTransActivity ON /* join condition not captured in parsed metadata */
INNER JOIN I_FinancialInstrProdTypeText AS TransProductType ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCodeStdVH AS CompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More