I_CMMDTYFINTRANSFLOWUNFIXED

CDS View

Cmdty Fin Transaction Flows Unfixed

I_CMMDTYFINTRANSFLOWUNFIXED is a CDS View in S/4HANA. Cmdty Fin Transaction Flows Unfixed. It contains 18 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CmmdtyHdgTransFlowDetails view inner COMPOSITE Constellation Deals flow details
P_CmmdtyFinTransactFlowUnion view inner COMPOSITE
P_CmmdtyFinTransactFlowUnion view union_all COMPOSITE
P_CMMDTYHDGTRDORDTRANSFLW view_entity union_all COMPOSITE Trans Flow details Fxd and Unfxd

Fields (18)

KeyField CDS FieldsUsed in Views
KEY FinancialInstrumentActivity FinancialInstrumentActivity 2
KEY FinancialTransaction CmmdtyHedgeConstellationDeal,FinancialTransaction 3
KEY FinTransFlowNumber FinTransFlowNumber 1
CommodityPriceExposureUnit CommodityPriceExposureUnit 1
DerivativeContrSpecification DerivativeContrSpecification 1
FinancialTransactionAmount FinancialTransactionAmount 1
FinancialTransactionDirection FinancialTransactionDirection 1
FinTransactionPricingEndDate FinTransactionPricingEndDate 1
FinTransactionPricingStartDate dbervon,FinTransactionPricingStartDate 2
FinTransacTradedPriceAmount FinTransacTradedPriceAmount 1
FinTransFlowIntrstRateFixDate dzfest,FinTransFlowIntrstRateFixDate 2
FinTransFlowPaymentDate FinTransFlowPaymentDate 1
FinTransFlowPaytAmtCrcy FinTransFlowPaytAmtCrcy 1
FinTransPositionCrcyCnvrsnRate FinTransPositionCrcyCnvrsnRate 1
FinTransTradedPriceCrcyUnit FinTransTradedPriceCrcyUnit 1
MarketIdentifierCode MarketIdentifierCode 1
Quantity Quantity 1
UnitOfMeasure UnitOfMeasure 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.

-- Cmdty Fin Transaction Flows Unfixed
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYFINTRANSFLOWUNFIXED (
    FINANCIALINSTRUMENTACTIVITY,
    FINANCIALTRANSACTION,
    FINTRANSFLOWNUMBER,
    COMMODITYPRICEEXPOSUREUNIT,
    DERIVATIVECONTRSPECIFICATION,
    FINANCIALTRANSACTIONAMOUNT,
    FINANCIALTRANSACTIONDIRECTION,
    FINTRANSACTIONPRICINGENDDATE,
    FINTRANSACTIONPRICINGSTARTDATE,
    FINTRANSACTRADEDPRICEAMOUNT,
    FINTRANSFLOWINTRSTRATEFIXDATE,
    FINTRANSFLOWPAYMENTDATE,
    FINTRANSFLOWPAYTAMTCRCY,
    FINTRANSPOSITIONCRCYCNVRSNRATE,
    FINTRANSTRADEDPRICECRCYUNIT,
    MARKETIDENTIFIERCODE,
    QUANTITY,
    UNITOFMEASURE,
    PRIMARY KEY (FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION, FINTRANSFLOWNUMBER)
);