I_CMMDTYHDGTRDORDTRANSFLOWDET

CDS View
12 Fields 3 CDS Views

Commodity Hedge Constellation Deal Flow Details

I_CMMDTYHDGTRDORDTRANSFLOWDET is a CDS View in S/4HANA. Commodity Hedge Constellation Deal Flow Details. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_CmmdtyHdgTrdOrdCkptFXTrans view inner COMPOSITE Interface for the FX Trade details
P_CmmdtyHdgTrdOrdTransFlwUnion view from COMPOSITE Trans Flow details Fxd and Unfxd
P_CmmdtyHdgTrdOrdTransFlwUnion view union COMPOSITE Trans Flow details Fxd and Unfxd

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CmmdtyHedgeConstellationDeal CmmdtyHedgeConstellationDeal 1
KEY CompanyCode CompanyCode 1
KEY FinancialInstrumentActivity FinancialInstrumentActivity 1
KEY FinTransCreationDate FinTransCreationDate 1
CmmdtyHdgCalcdTradeCurrency CmmdtyHdgCalcdTradeCurrency 1
FinancialTransactionDCSID FinancialTransactionDCSID 1
FinTransacTradedPriceAmount FinTransacTradedPriceAmount 1
FinTransFlowPaytAmt FinTransFlowPaytAmt 2
FinTransFlowPaytAmtCrcy FinTransFlowPaytAmtCrcy 2
FinTransPositionCrcyCnvrsnRate FinTransPositionCrcyCnvrsnRate 1
Quantity Quantity 1
UnitOfMeasure UnitOfMeasure 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.

-- Commodity Hedge Constellation Deal Flow Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYHDGTRDORDTRANSFLOWDET (
    CMMDTYHEDGECONSTELLATIONDEAL,
    COMPANYCODE,
    FINANCIALINSTRUMENTACTIVITY,
    FINTRANSCREATIONDATE,
    CMMDTYHDGCALCDTRADECURRENCY,
    FINANCIALTRANSACTIONDCSID,
    FINTRANSACTRADEDPRICEAMOUNT,
    FINTRANSFLOWPAYTAMT,
    FINTRANSFLOWPAYTAMTCRCY,
    FINTRANSPOSITIONCRCYCNVRSNRATE,
    QUANTITY,
    UNITOFMEASURE,
    PRIMARY KEY (CMMDTYHEDGECONSTELLATIONDEAL, COMPANYCODE, FINANCIALINSTRUMENTACTIVITY, FINTRANSCREATIONDATE)
);

Learn More