P_CMMDTYHDGEXPSRVERSIONPERIOD

CDS View
12 Fields 3 CDS Views

Exposure Version Period

P_CMMDTYHDGEXPSRVERSIONPERIOD is a CDS View in S/4HANA. Exposure Version Period. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_CmmdtyHdgTgtQtaExpsrMapPerd view inner COMPOSITE TgtQta to Expsr Period mapping
P_CmmdtyHdgTgtQtaExpsrPerdMap view inner COMPOSITE Map Target Quota to Exposure Period
P_CmmdtyHedgeCalcExpsrDealQuan view inner COMPOSITE Commodity hedge calculated exposure deal quantity

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CmmdtyHdgPlanExposureDirection CmmdtyHdgPlanExposureDirection 2
KEY CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode 2
KEY CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID 2
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook 2
CmmdtyHdgPlnExpsrDelivEndDate CmmdtyHdgPlnExpsrDelivEndDate 1
CmmdtyHdgPlnExpsrDelivPerdType CmmdtyHdgPlnExpsrDelivPerdType 1
CmmdtyHdgPlnExpsrDelivPerdYear CmmdtyHdgPlnExpsrDelivPerdYear 3
CmmdtyHdgPlnExpsrDelivStrtDate CmmdtyHdgPlnExpsrDelivStrtDate 1
CmmdtyHdgPlnExpsrPeriodClass CmmdtyHdgPlnExpsrPeriodClass 1
CmmdtyHdgTgtQuotaPeriodNumber CmmdtyHdgPlnExpsrDelivPerdType 1
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion 2
CommodityHedgePlanExposureID CommodityHedgePlanExposureID 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.

-- Exposure Version Period
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CMMDTYHDGEXPSRVERSIONPERIOD (
    CMMDTYHDGPLANEXPOSUREDIRECTION,
    CMMDTYHDGPLNEXPSRCOMPANYCODE,
    CMMDTYHEDGEPLANEXPOSUREDCSID,
    CMMDTYHDGPLANEXPOSUREHEDGEBOOK,
    CMMDTYHDGPLNEXPSRDELIVENDDATE,
    CMMDTYHDGPLNEXPSRDELIVPERDTYPE,
    CMMDTYHDGPLNEXPSRDELIVPERDYEAR,
    CMMDTYHDGPLNEXPSRDELIVSTRTDATE,
    CMMDTYHDGPLNEXPSRPERIODCLASS,
    CMMDTYHDGTGTQUOTAPERIODNUMBER,
    CMMDTYHEDGEPLANEXPOSUREVERSION,
    COMMODITYHEDGEPLANEXPOSUREID,
    PRIMARY KEY (CMMDTYHDGPLANEXPOSUREDIRECTION, CMMDTYHDGPLNEXPSRCOMPANYCODE, CMMDTYHEDGEPLANEXPOSUREDCSID)
);

Learn More