I_CommodityHedgeBookPeriod

DDL: I_COMMODITYHEDGEBOOKPERIOD SQL: ICMMHEDGBKPERIOD Type: view COMPOSITE
2 Fields 3 Data Sources

Commodity Hedge Book Periods F4 Help

I_CommodityHedgeBookPeriod is a Composite CDS View that provides data about "Commodity Hedge Book Periods F4 Help" in SAP S/4HANA. It reads from 3 data sources (P_CmmdtyHdgBookDelPeriod, I_CmmdtyHdgBookCompleteDetail, P_CmmdtyHdgBookShiftDelPeriod) and exposes 2 fields with key field CommodityHedgeBookIdentifier.

Data Sources (3)

SourceAliasJoin Type
P_CmmdtyHdgBookDelPeriod CmmdtyDelPeriod inner
I_CmmdtyHdgBookCompleteDetail CmmdtyHdgBook from
P_CmmdtyHdgBookShiftDelPeriod CmmdtyShiftDelPeriod inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMHEDGBKPERIOD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Commodity Hedge Book Periods F4 Help view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgeBookIdentifier I_CmmdtyHdgBookCompleteDetail CommodityHedgeBookIdentifier Hedge Book
char3endasCmmdtyHdgBookClusterPeriodName

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_CommodityHedgeBookPeriod.
-- 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: ICMMHEDGBKPERIOD

CREATE VIEW I_CommodityHedgeBookPeriod AS
SELECT
  CmmdtyHdgBook.CommodityHedgeBookIdentifier AS CommodityHedgeBookIdentifier,
  case CmmdtyDelPeriod.CommodityHedgeDeliveryPeriod when '12' then concat( cast(CmmdtyHdgBook.CommodityHedgePricingPeriod as abap.char(3)), concat('-', concat(cast(CmmdtyShiftDelPeriod.CmmdtyHdgShftDelivPeriodText as abap.char(10)), concat('-', cast(CmmdtyDelPeriod.CommodityHedgeDeliveryPeriod as abap.char(3)) )))) else concat( cast(CmmdtyHdgBook.CommodityHedgePricingPeriod as abap.char(3)), concat('-', concat(cast(CmmdtyShiftDelPeriod.CmmdtyHdgShftDelivPeriodText as abap.char(10)), concat('-', cast(substring(CmmdtyDelPeriod.CommodityHedgeDeliveryPeriod,2,1) as abap.char(3)) )))) end as CmmdtyHdgBookClusterPeriodName AS char3endasCmmdtyHdgBookClusterPeriodName
FROM I_CmmdtyHdgBookCompleteDetail AS CmmdtyHdgBook
INNER JOIN P_CmmdtyHdgBookDelPeriod AS CmmdtyDelPeriod ON /* join condition not captured in parsed metadata */
INNER JOIN P_CmmdtyHdgBookShiftDelPeriod AS CmmdtyShiftDelPeriod ON /* join condition not captured in parsed metadata */
;

Learn More