I_COMMODITYHEDGEPLANEXPOSURE

CDS View
38 Fields 14 CDS Views

Basic for Commodity Hedge Plan Exposure

I_COMMODITYHEDGEPLANEXPOSURE is a CDS View in S/4HANA. Basic for Commodity Hedge Plan Exposure. It contains 38 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_CmHdgPlnExpsrHdggArReldBfr view from COMPOSITE Hedging Area Before Exposure
I_CmmdtyHdgPlanExpsrComposite view from COMPOSITE Composite for Plan Exposure
I_CmmdtyHdgPlnExpsrIDDimension view from COMPOSITE Exposure Id Dimension
I_CmmdtyHdgTrdOrdCkptExposure view inner COMPOSITE Exposure for Trader Order Cockpit
I_CmmdtyHdgTrdOrdExpsrRqdVers view from COMPOSITE Active Version of Exposure Details
I_CmmdtyHedgeTransFlowActivity view inner COMPOSITE Financial Transaction Flow
P_CmmdtyHdgDealTgtQtaUtilzn view inner COMPOSITE
P_CmmdtyHdgExposureMaxVersion view from COMPOSITE Active Version of ExposureID
P_CmmdtyHdgExpsrDtePosSelect view from COMPOSITE Number of Plan Exposure Position
P_CmmdtyHdgExpsrTgtQuotaHeader view inner COMPOSITE
P_CmmdtyHdgExpsrVersionPeriod view inner COMPOSITE Exposure Version Period
P_CmmdtyHdgFinTransQuantitySum view inner COMPOSITE
P_CmmdtyHedgeExposureVersion view from COMPOSITE Active Version of ExposureID
P_CommodityHedgePlanExposure view from COMPOSITE

Fields (38)

KeyField CDS FieldsUsed in Views
KEY CmmdtyHdgPlanExpsrMktIDCode CmmdtyHdgPlanExpsrMktIDCode 3
KEY CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode 5
KEY CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion 4
KEY CommodityHedgePlanExposureID CommodityHedgePlanExposureID 3
KEY CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID 3
_CompanyCode _CompanyCode 4
_ControllingArea _ControllingArea 1
_DCSAttributes _DCSAttributes 2
_HedgeBook _HedgeBook 3
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup 1
CmmdtyHdgIsPrcgInDelivPeriod CmmdtyHdgIsPrcgInDelivPeriod 3
CmmdtyHdgPlanExposureCategory CmmdtyHdgPlanExposureCategory 1
CmmdtyHdgPlanExposureDirection CmmdtyHdgPlanExposureDirection 4
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook 5
CmmdtyHdgPlanExposureLogHandle CmmdtyHdgPlanExposureLogHandle 1
CmmdtyHdgPlanExposurePortfolio CmmdtyHdgPlanExposurePortfolio 1
CmmdtyHdgPlnExpsrChgDateTime CmmdtyHdgPlnExpsrChgDateTime 1
CmmdtyHdgPlnExpsrCreatedByUser CmmdtyHdgPlnExpsrCreatedByUser 1
CmmdtyHdgPlnExpsrCrtnDateTime CmmdtyHdgPlnExpsrCrtnDateTime 1
CmmdtyHdgPlnExpsrDelivEndDate CmmdtyHdgPlnExpsrDelivEndDate 1
CmmdtyHdgPlnExpsrDelivPerdText CmmdtyHdgPlnExpsrDelivPerdText 1
CmmdtyHdgPlnExpsrDelivPerdType CmmdtyHdgPlnExpsrDelivPerdType 2
CmmdtyHdgPlnExpsrDelivPerdYear CmmdtyHdgPlnExpsrDelivPerdYear 2
CmmdtyHdgPlnExpsrDelivStrtDate CmmdtyHdgPlnExpsrDelivStrtDate 1
CmmdtyHdgPlnExpsrHedgingArea CmmdtyHdgPlnExpsrHedgingArea 1
CmmdtyHdgPlnExpsrLastChgdByUsr CmmdtyHdgPlnExpsrLastChgdByUsr 1
CmmdtyHdgPlnExpsrPerdStartDate CmmdtyHdgPlnExpsrPerdStartDate 3
CmmdtyHdgPlnExpsrPeriodClass CmmdtyHdgPlnExpsrPeriodClass 2
CmmdtyHdgPlnExpsrPrcgEndDate CmmdtyHdgPlnExpsrPrcgEndDate 2
CmmdtyHdgPlnExpsrPrcgStartDate CmmdtyHdgPlnExpsrPrcgStartDate 2
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit 4
CmmdtyHdgPlnExpsrStsChgReason CmmdtyHdgPlnExpsrStsChgReason 1
CmmdtyHdgPlnExpsrValidFromDate CmmdtyHdgPlnExpsrValidFromDate 2
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID 4
CmmdtyHedgePlanExposureStatus CmmdtyHedgePlanExposureStatus 2
CmmdtyHedgePlnExposureQuantity CmmdtyHedgePlnExposureQuantity 3
ControllingArea ControllingArea 1
PhysicalCommodity PhysicalCommodity 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Basic for Commodity Hedge Plan Exposure
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COMMODITYHEDGEPLANEXPOSURE (
    CMMDTYHDGPLANEXPSRMKTIDCODE,
    CMMDTYHDGPLNEXPSRCOMPANYCODE,
    CMMDTYHEDGEPLANEXPOSUREVERSION,
    COMMODITYHEDGEPLANEXPOSUREID,
    COMMODITYHEDGEPLANEXPOSUREUUID,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _DCSATTRIBUTES,
    _HEDGEBOOK,
    CMMDTYHDGBOOKAUTHZNGROUP,
    CMMDTYHDGISPRCGINDELIVPERIOD,
    CMMDTYHDGPLANEXPOSURECATEGORY,
    CMMDTYHDGPLANEXPOSUREDIRECTION,
    CMMDTYHDGPLANEXPOSUREHEDGEBOOK,
    CMMDTYHDGPLANEXPOSURELOGHANDLE,
    CMMDTYHDGPLANEXPOSUREPORTFOLIO,
    CMMDTYHDGPLNEXPSRCHGDATETIME,
    CMMDTYHDGPLNEXPSRCREATEDBYUSER,
    CMMDTYHDGPLNEXPSRCRTNDATETIME,
    CMMDTYHDGPLNEXPSRDELIVENDDATE,
    CMMDTYHDGPLNEXPSRDELIVPERDTEXT,
    CMMDTYHDGPLNEXPSRDELIVPERDTYPE,
    CMMDTYHDGPLNEXPSRDELIVPERDYEAR,
    CMMDTYHDGPLNEXPSRDELIVSTRTDATE,
    CMMDTYHDGPLNEXPSRHEDGINGAREA,
    CMMDTYHDGPLNEXPSRLASTCHGDBYUSR,
    CMMDTYHDGPLNEXPSRPERDSTARTDATE,
    CMMDTYHDGPLNEXPSRPERIODCLASS,
    CMMDTYHDGPLNEXPSRPRCGENDDATE,
    CMMDTYHDGPLNEXPSRPRCGSTARTDATE,
    CMMDTYHDGPLNEXPSRQUANTITYUNIT,
    CMMDTYHDGPLNEXPSRSTSCHGREASON,
    CMMDTYHDGPLNEXPSRVALIDFROMDATE,
    CMMDTYHEDGEPLANEXPOSUREDCSID,
    CMMDTYHEDGEPLANEXPOSURESTATUS,
    CMMDTYHEDGEPLNEXPOSUREQUANTITY,
    CONTROLLINGAREA,
    PHYSICALCOMMODITY,
    PRIMARY KEY (CMMDTYHDGPLANEXPSRMKTIDCODE, CMMDTYHDGPLNEXPSRCOMPANYCODE, CMMDTYHEDGEPLANEXPOSUREVERSION, COMMODITYHEDGEPLANEXPOSUREID, COMMODITYHEDGEPLANEXPOSUREUUID)
);

Learn More