P_CMMDTYHDGCNSTLTNTRANSUNION

CDS View
14 Fields 3 CDS Views

P_CMMDTYHDGCNSTLTNTRANSUNION is a CDS View in S/4HANA. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CmmdtyHdgCnstltnNodeAggrgn view_entity from COMPOSITE Hedge Constellation Node Aggregation
I_CmmdtyHdgCnstltnTransOvw view_entity from COMPOSITE Commodity Hedge Constellation Overview
P_CmmdtyHdgCnstltnFinTrans view from COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY CmmdtyHdgCnstltnProductArea CmmdtyHdgCnstltnProductArea 2
KEY CmmdtyHdgConstellationDealRole CmmdtyHdgConstellationDealRole 2
KEY CmmdtyHedgeConstellationUUID CmmdtyHedgeConstellationUUID 2
KEY CommodityHedgePlanExposureID CommodityHedgePlanExposureID 2
KEY CompanyCode CompanyCode 2
KEY FinancialTransaction FinancialTransaction 2
CmmdtyHdgCnstltnExposureItem CmmdtyHdgCnstltnExposureItem 1
CmmdtyHdgCnstltnExpsrVersion CmmdtyHdgCnstltnExpsrVersion 1
CmmdtyHdgCnstltnFrgnExchHdgReq CmmdtyHdgCnstltnFrgnExchHdgReq 2
CmmdtyHdgCnstltnIsReversed CmmdtyHdgCnstltnIsReversed 2
CmmdtyHdgCnstltnValdFrmDteTime CmmdtyHdgCnstltnValdFrmDteTime 1
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode 1
CmmdtyHedgePlanExposureItemID CmmdtyHedgePlanExposureItemID 1
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion 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 P_CMMDTYHDGCNSTLTNTRANSUNION (
    CMMDTYHDGCNSTLTNPRODUCTAREA,
    CMMDTYHDGCONSTELLATIONDEALROLE,
    CMMDTYHEDGECONSTELLATIONUUID,
    COMMODITYHEDGEPLANEXPOSUREID,
    COMPANYCODE,
    FINANCIALTRANSACTION,
    CMMDTYHDGCNSTLTNEXPOSUREITEM,
    CMMDTYHDGCNSTLTNEXPSRVERSION,
    CMMDTYHDGCNSTLTNFRGNEXCHHDGREQ,
    CMMDTYHDGCNSTLTNISREVERSED,
    CMMDTYHDGCNSTLTNVALDFRMDTETIME,
    CMMDTYHDGPLNEXPSRCOMPANYCODE,
    CMMDTYHEDGEPLANEXPOSUREITEMID,
    CMMDTYHEDGEPLANEXPOSUREVERSION,
    PRIMARY KEY (CMMDTYHDGCNSTLTNPRODUCTAREA, CMMDTYHDGCONSTELLATIONDEALROLE, CMMDTYHEDGECONSTELLATIONUUID, COMMODITYHEDGEPLANEXPOSUREID, COMPANYCODE, FINANCIALTRANSACTION)
);

Learn More