CMMT_EXPOSURE

Transparent Table Application Table
42 Fields 2 CDS Views

Commodity Hedge Planning Exposure

CMMT_EXPOSURE is an SAP database table in S/4HANA. Commodity Hedge Planning Exposure. It contains 42 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CommodityHedgeExposureDetail view from BASIC Basic for Commodity Hedge Plan Exposure
I_CommodityHedgePlanExposure view from BASIC Basic for Commodity Hedge Plan Exposure

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY commodityhedgeplanexposureuuid SYSUUID_X16 UUID
cmmdtyhdgplnexposureparentuuid SYSUUID_X16 UUID
cmmdtyhedgeplanexposurehashkey CMM_PLAN_HASH Semantic Hash Key
cmmdtyhdgplnexpsrcompanycode BUKRS Company Code
cmmdtyhedgeplanexposuredcsid TBA_DCSID DCS ID
cmmdtyhdgplanexpsrmktidcode TBA_MIC MIC
cmmdtyhdgplanexposuredirection CMM_PLAN_DIRECTION Buy or Sell
cmmdtyhdgplanexposurehedgebook CMM_HEDGE_BOOK Hedge Book
cmmdtyhdgplnexpsrperdstartdate TRBA_PERIOD_START_DATE Period Start
cmmdtyhdgplnexpsrperiodclass TRBA_PERIOD_CLASS Period Class
cmmdtyhdgplnexpsrhedgingarea CMM_HEDGING_AREA Hedging Area
cmmdtyhdgplnexpsrbusinessarea GSBER Business Area
cmmdtyhdgplnexpsrvalidfromdate CMM_PLAN_VALID_FROM Valid-From Date
cmmdtyhdgplanexposureportfolio RPORTB Portfolio
cmmdtyhdgplnexpsrprofitcenter PRCTR Profit Center
cmmdtyhdgplnexposurecostcenter KOSTL Cost Center
cmmdtyhedgeplanexposureplant WERKS_D Plant
cmmdtyhedgeplanexposureitemid CMM_EXPOSURE_ITEM_ID Exposure Item ID
cmmdtyhdgplnexpsrisacctgrlvt CMM_EXPOSURE_HACC_QUALIFIED Hedge Accounting Relevance
cmmdtyhdgplnexposureremarknote CMM_PLAN_REMARK Remark
commodityhedgeplanexposureid CMM_EXPOSURE_ID Plan Exposure ID
cmmdtyhdgplanexposurecategory CMM_EXPOSURE_CATEGORY Exposure Category
dummy1 CHAR1 Single-Character Flag
cmmdtyhdgplnexpsrdelivstrtdate CMM_PLAN_DELIVERY_PERIOD_START Delivery Start Date
cmmdtyhdgplnexpsrdelivenddate CMM_PLAN_DELIVERY_PERIOD_END Delivery End Date
cmmdtyhdgplnexpsrprcgstartdate CMM_PLAN_PRICING_PERIOD_START Pricing Start Date
cmmdtyhdgplnexpsrprcgenddate CMM_PLAN_PRICING_PERIOD_END Pricing End Date
cmmdtyhdgplnexpsrdelivperdtext CMM_PLAN_DELIVERY_PERIOD_TXT Del. Period Descr.
cmmdtyhdgplnexpsrdelivperdtype CMM_PLAN_DELIVERY_PERIOD_CTGRY Delivery Period Cat.
cmmdtyhdgplnexpsrdelivperdyear CMM_EXPOSURE_DELIVERY_YEAR Exposure Deliv. Year
planningdatauuid SYSUUID_X16 UUID
cmmdtyhedgeplnexposurequantity FTR_QUAN Qty
cmmdtyhdgplnexpsrquantityunit TPM_CTY_UOM Unit of Measure
cmmdtyhdgplanexposureloghandle CMM_APL_LOG_HANDLE Log Handle
cmmdtyhedgeplanexposurestatus CMM_EXPOSURE_STATUS Status
cmmdtyhedgeplanexposureversion CMM_EXPOSURE_VERSION Exposure Version No.
cmmdtyhdgplnexpsrstschgreason CMM_PLAN_STSCHNG_REASON Status Change Reason
cmmdtyhdgplnexpsrcreatedbyuser SYUNAME User Name
cmmdtyhdgplnexpsrcrtndatetime TIMESTAMPL Time Stamp
cmmdtyhdgplnexpsrlastchgdbyusr SYUNAME User Name
cmmdtyhdgplnexpsrchgdatetime TIMESTAMPL Time Stamp

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.

-- Commodity Hedge Planning Exposure
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMT_EXPOSURE (
    CLIENT,                          -- Client [MANDT]
    COMMODITYHEDGEPLANEXPOSUREUUID,  -- UUID [SYSUUID_X16]
    CMMDTYHDGPLNEXPOSUREPARENTUUID,  -- UUID [SYSUUID_X16]
    CMMDTYHEDGEPLANEXPOSUREHASHKEY,  -- Semantic Hash Key [CMM_PLAN_HASH]
    CMMDTYHDGPLNEXPSRCOMPANYCODE,    -- Company Code [BUKRS]
    CMMDTYHEDGEPLANEXPOSUREDCSID,    -- DCS ID [TBA_DCSID]
    CMMDTYHDGPLANEXPSRMKTIDCODE,     -- MIC [TBA_MIC]
    CMMDTYHDGPLANEXPOSUREDIRECTION,  -- Buy or Sell [CMM_PLAN_DIRECTION]
    CMMDTYHDGPLANEXPOSUREHEDGEBOOK,  -- Hedge Book [CMM_HEDGE_BOOK]
    CMMDTYHDGPLNEXPSRPERDSTARTDATE,  -- Period Start [TRBA_PERIOD_START_DATE]
    CMMDTYHDGPLNEXPSRPERIODCLASS,    -- Period Class [TRBA_PERIOD_CLASS]
    CMMDTYHDGPLNEXPSRHEDGINGAREA,    -- Hedging Area [CMM_HEDGING_AREA]
    CMMDTYHDGPLNEXPSRBUSINESSAREA,   -- Business Area [GSBER]
    CMMDTYHDGPLNEXPSRVALIDFROMDATE,  -- Valid-From Date [CMM_PLAN_VALID_FROM]
    CMMDTYHDGPLANEXPOSUREPORTFOLIO,  -- Portfolio [RPORTB]
    CMMDTYHDGPLNEXPSRPROFITCENTER,   -- Profit Center [PRCTR]
    CMMDTYHDGPLNEXPOSURECOSTCENTER,  -- Cost Center [KOSTL]
    CMMDTYHEDGEPLANEXPOSUREPLANT,    -- Plant [WERKS_D]
    CMMDTYHEDGEPLANEXPOSUREITEMID,   -- Exposure Item ID [CMM_EXPOSURE_ITEM_ID]
    CMMDTYHDGPLNEXPSRISACCTGRLVT,    -- Hedge Accounting Relevance [CMM_EXPOSURE_HACC_QUALIFIED]
    CMMDTYHDGPLNEXPOSUREREMARKNOTE,  -- Remark [CMM_PLAN_REMARK]
    COMMODITYHEDGEPLANEXPOSUREID,    -- Plan Exposure ID [CMM_EXPOSURE_ID]
    CMMDTYHDGPLANEXPOSURECATEGORY,   -- Exposure Category [CMM_EXPOSURE_CATEGORY]
    DUMMY1,                          -- Single-Character Flag [CHAR1]
    CMMDTYHDGPLNEXPSRDELIVSTRTDATE,  -- Delivery Start Date [CMM_PLAN_DELIVERY_PERIOD_START]
    CMMDTYHDGPLNEXPSRDELIVENDDATE,   -- Delivery End Date [CMM_PLAN_DELIVERY_PERIOD_END]
    CMMDTYHDGPLNEXPSRPRCGSTARTDATE,  -- Pricing Start Date [CMM_PLAN_PRICING_PERIOD_START]
    CMMDTYHDGPLNEXPSRPRCGENDDATE,    -- Pricing End Date [CMM_PLAN_PRICING_PERIOD_END]
    CMMDTYHDGPLNEXPSRDELIVPERDTEXT,  -- Del. Period Descr. [CMM_PLAN_DELIVERY_PERIOD_TXT]
    CMMDTYHDGPLNEXPSRDELIVPERDTYPE,  -- Delivery Period Cat. [CMM_PLAN_DELIVERY_PERIOD_CTGRY]
    CMMDTYHDGPLNEXPSRDELIVPERDYEAR,  -- Exposure Deliv. Year [CMM_EXPOSURE_DELIVERY_YEAR]
    PLANNINGDATAUUID,                -- UUID [SYSUUID_X16]
    CMMDTYHEDGEPLNEXPOSUREQUANTITY,  -- Qty [FTR_QUAN]
    CMMDTYHDGPLNEXPSRQUANTITYUNIT,   -- Unit of Measure [TPM_CTY_UOM]
    CMMDTYHDGPLANEXPOSURELOGHANDLE,  -- Log Handle [CMM_APL_LOG_HANDLE]
    CMMDTYHEDGEPLANEXPOSURESTATUS,   -- Status [CMM_EXPOSURE_STATUS]
    CMMDTYHEDGEPLANEXPOSUREVERSION,  -- Exposure Version No. [CMM_EXPOSURE_VERSION]
    CMMDTYHDGPLNEXPSRSTSCHGREASON,   -- Status Change Reason [CMM_PLAN_STSCHNG_REASON]
    CMMDTYHDGPLNEXPSRCREATEDBYUSER,  -- User Name [SYUNAME]
    CMMDTYHDGPLNEXPSRCRTNDATETIME,   -- Time Stamp [TIMESTAMPL]
    CMMDTYHDGPLNEXPSRLASTCHGDBYUSR,  -- User Name [SYUNAME]
    CMMDTYHDGPLNEXPSRCHGDATETIME,    -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (CLIENT, COMMODITYHEDGEPLANEXPOSUREUUID)
);

Learn More