EXP

EXP is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CmmdtyHdgPlnExpsrCompanyCode CompanyCode 1
KEY CommodityHedgePlanExposureID CommodityHedgePlanExposureID 1
_CompanyCode _CompanyCode 1
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook 1
CmmdtyHdgPlanExposurePortfolio CmmdtyHdgPlanExposurePortfolio 1
CmmdtyHdgPlanExpsrMktIDCode MarketIdentifierCode 1
CmmdtyHdgPlnExpsrPrcgEndDate CalculationPeriodEndDate 1
CmmdtyHdgPlnExpsrPrcgStartDate CalculationPeriodStartDate 1
CmmdtyHdgPlnExpsrQuantityUnit CommodityPriceExposureUnit 1
CmmdtyHdgPlnExpsrValidFromDate ValidityStartDate 1
CmmdtyHedgePlanExposureDCSID DerivativeContrSpecification 1
PhysicalCommodity Commodity 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EXP (
    CMMDTYHDGPLNEXPSRCOMPANYCODE,
    COMMODITYHEDGEPLANEXPOSUREID,
    _COMPANYCODE,
    CMMDTYHDGPLANEXPOSUREHEDGEBOOK,
    CMMDTYHDGPLANEXPOSUREPORTFOLIO,
    CMMDTYHDGPLANEXPSRMKTIDCODE,
    CMMDTYHDGPLNEXPSRPRCGENDDATE,
    CMMDTYHDGPLNEXPSRPRCGSTARTDATE,
    CMMDTYHDGPLNEXPSRQUANTITYUNIT,
    CMMDTYHDGPLNEXPSRVALIDFROMDATE,
    CMMDTYHEDGEPLANEXPOSUREDCSID,
    PHYSICALCOMMODITY,
    PRIMARY KEY (CMMDTYHDGPLNEXPSRCOMPANYCODE, COMMODITYHEDGEPLANEXPOSUREID)
);