I_CMMDTYHDGPLANEXPSRCOMPOSITE

CDS View
40 Fields 7 CDS Views

Composite for Plan Exposure

I_CMMDTYHDGPLANEXPSRCOMPOSITE is a CDS View in S/4HANA. Composite for Plan Exposure. It contains 40 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_CmmdtyHedgePlanExposureCube view from CONSUMPTION Commodity Hedge Plan Exposure - Cube
C_CmmdtyHedgePlanExposureIDVH view from CONSUMPTION Exposure ID
I_CmmdtyHdgPlnExposureUserText view_entity from COMPOSITE Commodity Plan Exposure User - Text
I_CmmdtyHdgPlnExpsrPrevVersQty view from COMPOSITE Previous versions
I_CmmdtyHedgeReleasedExposure view from COMPOSITE Commodity Hedge Reld Exposure
R_CmmdtyHdgPlnExpsrVersionTP view_entity from TRANSACTIONAL CMMDTY Hedge Plan Exposure Versions - TP
R_CommodityHedgePlanExposureTP view_entity from TRANSACTIONAL CMMDTY Hedge Plan Exposure BO - TP

Fields (40)

KeyField CDS FieldsUsed in Views
KEY CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID 1
CmmdtyHdgPlanExposureCategory CmmdtyHdgPlanExposureCategory 1
CmmdtyHdgPlanExposureDirection CmmdtyHdgPlanExposureDirection 1
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook 1
CmmdtyHdgPlanExposureLogHandle CmmdtyHdgPlanExposureLogHandle 1
CmmdtyHdgPlanExposurePortfolio CmmdtyHdgPlanExposurePortfolio 1
CmmdtyHdgPlanExpsrMktIDCode CmmdtyHdgPlanExpsrMktIDCode 1
CmmdtyHdgPlnExposureCostCenter CmmdtyHdgPlnExposureCostCenter 1
CmmdtyHdgPlnExposureParentUUID CmmdtyHdgPlnExposureParentUUID 1
CmmdtyHdgPlnExposureRemarkNote CmmdtyHdgPlnExposureRemarkNote 1
CmmdtyHdgPlnExpsrBusinessArea CmmdtyHdgPlnExpsrBusinessArea 1
CmmdtyHdgPlnExpsrChgDateTime CmmdtyHdgPlnExpsrChgDateTime 1
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode 1
CmmdtyHdgPlnExpsrCreatedByUser CmmdtyHdgPlnExpsrCreatedByUser 1
CmmdtyHdgPlnExpsrCrtnDateTime CmmdtyHdgPlnExpsrCrtnDateTime 1
CmmdtyHdgPlnExpsrDelivEndDate CmmdtyHdgPlnExpsrDelivEndDate 1
CmmdtyHdgPlnExpsrDelivPerdText CmmdtyHdgPlnExpsrDelivPerdText 1
CmmdtyHdgPlnExpsrDelivStrtDate CmmdtyHdgPlnExpsrDelivStrtDate 1
CmmdtyHdgPlnExpsrHedgingArea CmmdtyHdgPlnExpsrHedgingArea 1
CmmdtyHdgPlnExpsrIsAcctgRlvt CmmdtyHdgPlnExpsrIsAcctgRlvt 1
CmmdtyHdgPlnExpsrLastChgdByUsr CmmdtyHdgPlnExpsrLastChgdByUsr 1
CmmdtyHdgPlnExpsrPerdStartDate CmmdtyHdgPlnExpsrPerdStartDate 1
CmmdtyHdgPlnExpsrPeriodClass CmmdtyHdgPlnExpsrPeriodClass 1
CmmdtyHdgPlnExpsrPrcgEndDate CmmdtyHdgPlnExpsrPrcgEndDate 1
CmmdtyHdgPlnExpsrPrcgStartDate CmmdtyHdgPlnExpsrPrcgStartDate 1
CmmdtyHdgPlnExpsrProfitCenter CmmdtyHdgPlnExpsrProfitCenter 1
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit 1
CmmdtyHdgPlnExpsrStsChgReason CmmdtyHdgPlnExpsrStsChgReason 1
CmmdtyHdgPlnExpsrValidFromDate CmmdtyHdgPlnExpsrValidFromDate 1
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID 1
CmmdtyHedgePlanExposureHashKey CmmdtyHedgePlanExposureHashKey 1
CmmdtyHedgePlanExposureItemID CmmdtyHedgePlanExposureItemID 1
CmmdtyHedgePlanExposurePlant CmmdtyHedgePlanExposurePlant 1
CmmdtyHedgePlanExposureStatus CmmdtyHedgePlanExposureStatus 1
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion 1
CmmdtyHedgePlnExposureQuantity CmmdtyHedgePlnExposureQuantity 1
CommodityHedgePlanExposureID CommodityHedgePlanExposureID 1
ControllingArea ControllingArea 1
PhysicalCommodity PhysicalCommodity 1
PlanningDataUUID PlanningDataUUID 1

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.

-- Composite for Plan Exposure
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYHDGPLANEXPSRCOMPOSITE (
    COMMODITYHEDGEPLANEXPOSUREUUID,
    CMMDTYHDGPLANEXPOSURECATEGORY,
    CMMDTYHDGPLANEXPOSUREDIRECTION,
    CMMDTYHDGPLANEXPOSUREHEDGEBOOK,
    CMMDTYHDGPLANEXPOSURELOGHANDLE,
    CMMDTYHDGPLANEXPOSUREPORTFOLIO,
    CMMDTYHDGPLANEXPSRMKTIDCODE,
    CMMDTYHDGPLNEXPOSURECOSTCENTER,
    CMMDTYHDGPLNEXPOSUREPARENTUUID,
    CMMDTYHDGPLNEXPOSUREREMARKNOTE,
    CMMDTYHDGPLNEXPSRBUSINESSAREA,
    CMMDTYHDGPLNEXPSRCHGDATETIME,
    CMMDTYHDGPLNEXPSRCOMPANYCODE,
    CMMDTYHDGPLNEXPSRCREATEDBYUSER,
    CMMDTYHDGPLNEXPSRCRTNDATETIME,
    CMMDTYHDGPLNEXPSRDELIVENDDATE,
    CMMDTYHDGPLNEXPSRDELIVPERDTEXT,
    CMMDTYHDGPLNEXPSRDELIVSTRTDATE,
    CMMDTYHDGPLNEXPSRHEDGINGAREA,
    CMMDTYHDGPLNEXPSRISACCTGRLVT,
    CMMDTYHDGPLNEXPSRLASTCHGDBYUSR,
    CMMDTYHDGPLNEXPSRPERDSTARTDATE,
    CMMDTYHDGPLNEXPSRPERIODCLASS,
    CMMDTYHDGPLNEXPSRPRCGENDDATE,
    CMMDTYHDGPLNEXPSRPRCGSTARTDATE,
    CMMDTYHDGPLNEXPSRPROFITCENTER,
    CMMDTYHDGPLNEXPSRQUANTITYUNIT,
    CMMDTYHDGPLNEXPSRSTSCHGREASON,
    CMMDTYHDGPLNEXPSRVALIDFROMDATE,
    CMMDTYHEDGEPLANEXPOSUREDCSID,
    CMMDTYHEDGEPLANEXPOSUREHASHKEY,
    CMMDTYHEDGEPLANEXPOSUREITEMID,
    CMMDTYHEDGEPLANEXPOSUREPLANT,
    CMMDTYHEDGEPLANEXPOSURESTATUS,
    CMMDTYHEDGEPLANEXPOSUREVERSION,
    CMMDTYHEDGEPLNEXPOSUREQUANTITY,
    COMMODITYHEDGEPLANEXPOSUREID,
    CONTROLLINGAREA,
    PHYSICALCOMMODITY,
    PLANNINGDATAUUID,
    PRIMARY KEY (COMMODITYHEDGEPLANEXPOSUREUUID)
);

Learn More