_CMMDTYHDGFINTRANSACTION

_CMMDTYHDGFINTRANSACTION is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
_BusinessPartner _BusinessPartner 1
_CmmdtyHdgPlngDataDirectionT _CmmdtyHdgPlngDataDirectionT 1
_CompanyCode _CompanyCode 1
_DerivativeContractSpecText _DerivativeContractSpecText 1
_ProdTypeText _ProdTypeText 1
CommodityPriceExposureUnit CommodityPriceExposureUnit 1
FinancialInstrTransactionType FinancialInstrTransactionType 1
FinancialTransactionAssignment FinancialTransactionAssignment 1
FinancialTransactionDCSID FinancialTransactionDCSID 1
FinancialTransactionDirection FinancialTransactionDirection 1
FinancialTransactionHedgeBook FinancialTransactionHedgeBook 2
FinancialTransactionPortfolio FinancialTransactionPortfolio 1
FinancialTransactionQuantity FinancialTransactionQuantity 1
FinTransactionCharacteristic FinancialInstrCharacteristic,FinTransactionCharacteristic 2
FinTransactionCompanyCode FinTransactionCompanyCode 1
FinTransactionCounterparty FinTransactionCounterparty 2
FinTransactionDealIdentifier FinTransactionDealIdentifier 1
FinTransactionDirectionName FinTransactionDirectionName 1
FinTransactionPricingEndDate FinTransactionPricingEndDate 1
FinTransactionPricingStartDate FinTransactionPricingStartDate 1
FinTransactionProductCategory FinTransactionProductCategory 1
FinTransactionProductType FinTransactionProductType 1
FinTransactionQuantityUnit FinTransactionQuantityUnit 1
FinTransacTradedPriceAmount FinTransacTradedPriceAmount 1
FinTransContractStartDate FinTransContractStartDate 1
FinTransContractStartTime FinTransContractStartTime 1
FinTransFlowPaymentDate FinTransFlowPaymentDate 1
FinTransGeneralValuationClass FinTransGeneralValuationClass 1
FinTransHedgingClassification FinTransHedgingClassification 1
FinTransInternalReference FinTransInternalReference 1
FinTransOnBehalfOfCompany FinTransOnBehalfOfCompany 1
FinTransTradedPriceCrcyUnit FinTransTradedPriceCrcyUnit 1
TermEndDate FinTransactionTermEndDate 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 _CMMDTYHDGFINTRANSACTION (
    _BUSINESSPARTNER,
    _CMMDTYHDGPLNGDATADIRECTIONT,
    _COMPANYCODE,
    _DERIVATIVECONTRACTSPECTEXT,
    _PRODTYPETEXT,
    COMMODITYPRICEEXPOSUREUNIT,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALTRANSACTIONASSIGNMENT,
    FINANCIALTRANSACTIONDCSID,
    FINANCIALTRANSACTIONDIRECTION,
    FINANCIALTRANSACTIONHEDGEBOOK,
    FINANCIALTRANSACTIONPORTFOLIO,
    FINANCIALTRANSACTIONQUANTITY,
    FINTRANSACTIONCHARACTERISTIC,
    FINTRANSACTIONCOMPANYCODE,
    FINTRANSACTIONCOUNTERPARTY,
    FINTRANSACTIONDEALIDENTIFIER,
    FINTRANSACTIONDIRECTIONNAME,
    FINTRANSACTIONPRICINGENDDATE,
    FINTRANSACTIONPRICINGSTARTDATE,
    FINTRANSACTIONPRODUCTCATEGORY,
    FINTRANSACTIONPRODUCTTYPE,
    FINTRANSACTIONQUANTITYUNIT,
    FINTRANSACTRADEDPRICEAMOUNT,
    FINTRANSCONTRACTSTARTDATE,
    FINTRANSCONTRACTSTARTTIME,
    FINTRANSFLOWPAYMENTDATE,
    FINTRANSGENERALVALUATIONCLASS,
    FINTRANSHEDGINGCLASSIFICATION,
    FINTRANSINTERNALREFERENCE,
    FINTRANSONBEHALFOFCOMPANY,
    FINTRANSTRADEDPRICECRCYUNIT,
    TERMENDDATE
);