I_CommodityHedgeExposureDetail

DDL: I_COMMODITYHEDGEEXPOSUREDETAIL SQL: ICMMDTYHDGPLEXP Type: view BASIC
40 Fields 1 Data Sources

Basic for Commodity Hedge Plan Exposure

I_CommodityHedgeExposureDetail is a Basic CDS View that provides data about "Basic for Commodity Hedge Plan Exposure" in SAP S/4HANA. It reads from 1 data source (cmmt_exposure) and exposes 40 fields with key field CommodityHedgePlanExposureUUID.

Data Sources (1)

SourceAliasJoin Type
cmmt_exposure cmmt_exposure from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYHDGPLEXP view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic for Commodity Hedge Plan Exposure view
VDM.viewType #BASIC view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureUUID commodityhedgeplanexposureuuid UUID
CmmdtyHdgPlnExposureParentUUID cmmdtyhdgplnexposureparentuuid UUID
CmmdtyHedgePlanExposureHashKey cmmdtyhedgeplanexposurehashkey Semantic Hash Key
CmmdtyHdgPlnExpsrCompanyCode cmmdtyhdgplnexpsrcompanycode Company Code
CmmdtyHedgePlanExposureDCSID cmmdtyhedgeplanexposuredcsid DCS ID
CmmdtyHdgPlanExpsrMktIDCode cmmdtyhdgplanexpsrmktidcode MIC
CmmdtyHdgPlanExposureDirection cmmdtyhdgplanexposuredirection Buy or Sell
CmmdtyHdgPlnExpsrHedgingArea cmmdtyhdgplnexpsrhedgingarea Hedging Area
CmmdtyHdgPlanExposureHedgeBook cmmdtyhdgplanexposurehedgebook Hedge Book
CmmdtyHdgPlnExpsrPerdStartDate cmmdtyhdgplnexpsrperdstartdate Period Start
CmmdtyHdgPlnExpsrPeriodClass cmmdtyhdgplnexpsrperiodclass Period Class
CmmdtyHdgPlnExpsrBusinessArea cmmdtyhdgplnexpsrbusinessarea Business Area
CmmdtyHdgPlnExpsrValidFromDate cmmdtyhdgplnexpsrvalidfromdate Valid-From Date
CmmdtyHdgPlanExposurePortfolio cmmdtyhdgplanexposureportfolio Portfolio
CmmdtyHdgPlnExpsrProfitCenter cmmdtyhdgplnexpsrprofitcenter Profit Center
CmmdtyHdgPlnExposureCostCenter cmmdtyhdgplnexposurecostcenter Cost Center
CmmdtyHedgePlanExposurePlant cmmdtyhedgeplanexposureplant Plant
CmmdtyHedgePlanExposureItemID cmmdtyhedgeplanexposureitemid Exposure Item ID
CmmdtyHdgPlnExpsrIsAcctgRlvt cmmdtyhdgplnexpsrisacctgrlvt Hedge Accounting Relevance
CmmdtyHdgPlnExposureRemarkNote cmmdtyhdgplnexposureremarknote Remark
CommodityHedgePlanExposureID commodityhedgeplanexposureid Plan Exposure ID
CmmdtyHdgPlanExposureCategory cmmdtyhdgplanexposurecategory Exposure Category
CmmdtyHdgPlnExpsrDelivStrtDate cmmdtyhdgplnexpsrdelivstrtdate Delivery Start Date
CmmdtyHdgPlnExpsrDelivEndDate cmmdtyhdgplnexpsrdelivenddate Delivery End Date
CmmdtyHdgPlnExpsrDelivPerdText cmmdtyhdgplnexpsrdelivperdtext Del. Period Descr.
CmmdtyHdgPlnExpsrDelivPerdType cmmdtyhdgplnexpsrdelivperdtype Delivery Period Cat.
CmmdtyHdgPlnExpsrDelivPerdYear cmmdtyhdgplnexpsrdelivperdyear Exposure Deliv. Year
CmmdtyHdgPlnExpsrPrcgStartDate cmmdtyhdgplnexpsrprcgstartdate Pricing Start Date
CmmdtyHdgPlnExpsrPrcgEndDate cmmdtyhdgplnexpsrprcgenddate Pricing End Date
PlanningDataUUID planningdatauuid UUID
CmmdtyHedgePlnExposureQuantity cmmdtyhedgeplnexposurequantity Qty
CmmdtyHdgPlnExpsrQuantityUnit cmmdtyhdgplnexpsrquantityunit Unit of Measure
CmmdtyHdgPlanExposureLogHandle cmmdtyhdgplanexposureloghandle Log Handle
CmmdtyHedgePlanExposureStatus cmmdtyhedgeplanexposurestatus Status
CmmdtyHedgePlanExposureVersion cmmdtyhedgeplanexposureversion Exposure Version No.
CmmdtyHdgPlnExpsrStsChgReason cmmdtyhdgplnexpsrstschgreason Status Change Reason
CmmdtyHdgPlnExpsrCreatedByUser cmmdtyhdgplnexpsrcreatedbyuser User Name
CmmdtyHdgPlnExpsrCrtnDateTime cmmdtyhdgplnexpsrcrtndatetime Time Stamp
CmmdtyHdgPlnExpsrLastChgdByUsr cmmdtyhdgplnexpsrlastchgdbyusr User Name
CmmdtyHdgPlnExpsrChgDateTime cmmdtyhdgplnexpsrchgdatetime 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 I_CommodityHedgeExposureDetail.
-- 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: ICMMDTYHDGPLEXP

CREATE VIEW I_CommodityHedgeExposureDetail AS
SELECT
  CommodityHedgePlanExposureUUID,
  CmmdtyHdgPlnExposureParentUUID,
  CmmdtyHedgePlanExposureHashKey,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHedgePlanExposureDCSID,
  CmmdtyHdgPlanExpsrMktIDCode,
  CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHdgPlnExpsrPerdStartDate,
  CmmdtyHdgPlnExpsrPeriodClass,
  CmmdtyHdgPlnExpsrBusinessArea,
  CmmdtyHdgPlnExpsrValidFromDate,
  CmmdtyHdgPlanExposurePortfolio,
  CmmdtyHdgPlnExpsrProfitCenter,
  CmmdtyHdgPlnExposureCostCenter,
  CmmdtyHedgePlanExposurePlant,
  CmmdtyHedgePlanExposureItemID,
  CmmdtyHdgPlnExpsrIsAcctgRlvt,
  CmmdtyHdgPlnExposureRemarkNote,
  CommodityHedgePlanExposureID,
  CmmdtyHdgPlanExposureCategory,
  CmmdtyHdgPlnExpsrDelivStrtDate,
  CmmdtyHdgPlnExpsrDelivEndDate,
  CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  PlanningDataUUID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureLogHandle,
  CmmdtyHedgePlanExposureStatus,
  CmmdtyHedgePlanExposureVersion,
  CmmdtyHdgPlnExpsrStsChgReason,
  CmmdtyHdgPlnExpsrCreatedByUser,
  CmmdtyHdgPlnExpsrCrtnDateTime,
  CmmdtyHdgPlnExpsrLastChgdByUsr,
  CmmdtyHdgPlnExpsrChgDateTime
FROM cmmt_exposure
;

Learn More