I_CMMDTYFINTRANSACTIONFLOW

CDS View
22 Fields 5 CDS Views

Commodity Financial Transaction Flows

I_CMMDTYFINTRANSACTIONFLOW is a CDS View in S/4HANA. Commodity Financial Transaction Flows. It contains 22 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CmmdtyHdgTransFlowDetails view inner COMPOSITE Constellation Deals flow details
P_CmmdtyFinTransactFlowUnion view from COMPOSITE
P_CmmdtyFinTransactFlowUnion view union_all COMPOSITE
P_CmmdtyFinTransFlowCount view from COMPOSITE
P_CmmdtyHdgFXFinTransFlow view inner COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FinancialInstrumentActivity FinancialInstrumentActivity 2
KEY FinancialTransaction CmmdtyHedgeConstellationDeal,FinancialTransaction 3
KEY FinTransCreationDate FinTransCreationDate 2
KEY FinTransFlowCreationTime FinTransFlowCreationTime 1
KEY FinTransFlowNumber FinTransFlowNumber 2
CommodityPriceExposureUnit CommodityPriceExposureUnit 2
DerivativeContrSpecification DerivativeContrSpecification 2
FinancialTransactionAmount FinancialTransactionAmount,FinTransFlowPaytAmt 3
FinancialTransactionDirection FinancialTransactionDirection 2
FinTransactionPricingEndDate FinTransactionPricingEndDate 2
FinTransactionPricingStartDate FinTransactionPricingStartDate 2
FinTransacTradedPriceAmount FinTransacTradedPriceAmount 2
FinTransFlowIntrstRateFixDate FinTransFlowIntrstRateFixDate 2
FinTransFlowPaymentDate FinTransFlowPaymentDate 2
FinTransFlowPaytAmtCrcy FinTransFlowPaytAmtCrcy 3
FinTransPositionCrcyCnvrsnRate FinTransPositionCrcyCnvrsnRate 1
FinTransTradedPriceCrcyUnit FinTransTradedPriceCrcyUnit 2
LastChangeDate LastChangeDate 1
MarketIdentifierCode MarketIdentifierCode 2
Quantity Quantity 2
UnitOfMeasure UnitOfMeasure 3

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 Financial Transaction Flows
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYFINTRANSACTIONFLOW (
    COMPANYCODE,
    FINANCIALINSTRUMENTACTIVITY,
    FINANCIALTRANSACTION,
    FINTRANSCREATIONDATE,
    FINTRANSFLOWCREATIONTIME,
    FINTRANSFLOWNUMBER,
    COMMODITYPRICEEXPOSUREUNIT,
    DERIVATIVECONTRSPECIFICATION,
    FINANCIALTRANSACTIONAMOUNT,
    FINANCIALTRANSACTIONDIRECTION,
    FINTRANSACTIONPRICINGENDDATE,
    FINTRANSACTIONPRICINGSTARTDATE,
    FINTRANSACTRADEDPRICEAMOUNT,
    FINTRANSFLOWINTRSTRATEFIXDATE,
    FINTRANSFLOWPAYMENTDATE,
    FINTRANSFLOWPAYTAMTCRCY,
    FINTRANSPOSITIONCRCYCNVRSNRATE,
    FINTRANSTRADEDPRICECRCYUNIT,
    LASTCHANGEDATE,
    MARKETIDENTIFIERCODE,
    QUANTITY,
    UNITOFMEASURE,
    PRIMARY KEY (COMPANYCODE, FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION, FINTRANSCREATIONDATE, FINTRANSFLOWCREATIONTIME, FINTRANSFLOWNUMBER)
);

Learn More