I_COMMODITYHEDGETRANSACTION

CDS View

Financial Transaction Details

I_COMMODITYHEDGETRANSACTION is a CDS View in S/4HANA. Financial Transaction Details. It contains 12 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CmmdtyHdgCnstltnExtTrade view inner COMPOSITE Interface for the Ext Trade details
I_CmmdtyHdgCnstltnFrgnExchTrd view inner COMPOSITE Interface for the FX Trade details
P_CmmdtyCntrTransHdgSpecOrdDet view inner COMPOSITE Commodity Hedge Transactional Details
P_CmmdtyHdgTrdOrdTransFlwUnion view inner COMPOSITE Trans Flow details Fxd and Unfxd
P_CMMDTYTRANSTRADEORDERCOCKPIT view inner COMPOSITE Commodity Hedge Transactional Details

Fields (12)

KeyField CDS FieldsUsed in Views
KEY FinTransactionCompanyCode FinTransactionCompanyCode 2
CmmdtyHdgSpecificationID CmmdtyHdgSpecificationID,CmmdtyHdgTrdOrdTransHdgSpecID 2
CmmdtyHdgSpecQuotaOrderID CmmdtyHdgSpecQuotaOrderID,CmmdtyHdgTrdOrdTransSpecOrdID 2
ContractEndDate ContractEndDate 3
ContractStartDate ContractStartDate 3
FinancialInstrTransactionType FinancialInstrTransactionType 3
FinancialInstrumentActivity FinancialInstrumentActivity 1
FinTransactionDealIdentifier FinTransactionDealIdentifier 2
FinTransactionProductCategory FinTransactionProductCategory 3
FinTransactionProductType FinTransactionProductType 3
FinTransOnBehalfOfCompany FinTransOnBehalfOfCompany 1
HedgeRequestIdentifier HedgeRequestIdentifier 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.

-- Financial Transaction Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COMMODITYHEDGETRANSACTION (
    FINTRANSACTIONCOMPANYCODE,
    CMMDTYHDGSPECIFICATIONID,
    CMMDTYHDGSPECQUOTAORDERID,
    CONTRACTENDDATE,
    CONTRACTSTARTDATE,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTACTIVITY,
    FINTRANSACTIONDEALIDENTIFIER,
    FINTRANSACTIONPRODUCTCATEGORY,
    FINTRANSACTIONPRODUCTTYPE,
    FINTRANSONBEHALFOFCOMPANY,
    HEDGEREQUESTIDENTIFIER,
    PRIMARY KEY (FINTRANSACTIONCOMPANYCODE)
);