CPED_TERMINPUT

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.

-- CPE Term - Changed Input for General Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPED_TERMINPUT (
    CLIENT,                      -- Client [MANDT]
    TERMINPUT_GUID,              -- Term Input GUID [CPET_TERMINPUT_GUID]
    TERMTYPE,                    -- Calculation Type [CPET_TERMTYPE]
    TERMRULE,                    -- Term Rule [CPET_TERMRULE]
    REFDOCCAT,                   -- Ref. Doc. Category [CPET_REFDOCCAT]
    REFDOC,                      -- Ref. Document No. [CPET_REFDOC]
    REFITEM,                     -- Ref. Item No. [CPET_REFITEM]
    REFGUID,                     -- Ref. Item GUID [CPET_REFGUID]
    REFCOND,                     -- Ref. Condition Type [CPET_REFCOND]
    FIXTERMRATE,                 -- Fixed Rate [CPET_FIXTERMRATE]
    FIXTERMCURR,                 -- Currency Fixed Rate [CPET_FIXCURR]
    FIXTERMPRUN,                 -- PrcUnit Fixed Value [CPET_FIXPRUN]
    FIXTERMUOM,                  -- UoM for Fixed Value [CPET_FIXUOM]
    USERVAL1,                    -- Free Field [CPET_USERVAL1]
    USERUOM1,                    -- Free UoM [CPET_USERUOM1]
    QUOTKEY,                     -- Quot. Key Type [CPET_QUOTKEY_ALL]
    DCSID,                       -- DCS ID [TBA_DCSID]
    MIC,                         -- MIC [TBA_MIC]
    TENOR,                       -- Time to Maturity [TBA_TENOR]
    PRICETYPE,                   -- Price Type [TBA_PRICETYPE]
    FORECAST_ROUTINE,            -- QuotForecast Routine [CPET_QUOTFORECASTROUT]
    CURVE_TYPE,                  -- Cty Curve Type [TBA_CURVETYPE]
    CURVE_DCSID,                 -- Alternative DCSID [CPET_CURVE_DCSID]
    CURVE_MIC,                   -- Alternative MIC [CPET_CURVE_MIC]
    DCS_SELECTION_TYPE,          -- Maturity Sel. Type [CPET_KEYDATE_SELECTION_TYPE]
    TIMING,                      -- Timing [TBA_TIMING]
    KEYDATE_REFDATE_ROUT,        -- Maturity Ref.Date [CPET_KEYDATE_REFDATE_ROUT]
    KEYDATE_SELECTION_ROUT,      -- Maturity Sel. Rt. [CPET_KEYDATE_SELECTION_ROUT]
    KEYDATE_OFFSET_ROUT,         -- Date Offset Routine [CPET_KEYDATE_OFFSET_ROUT]
    KEYDATE_OFFSET_UNITS,        -- No. Time Units [CPET_KEYDATE_OFFSETUNITS]
    DCS_PERIOD_TYPE,             -- Period Type [TBA_PERIODTYPE]
    BASIS_TYPE,                  -- Basis Type [TBAC_BASIS_TYPE]
    QUOTGROUP,                   -- Quotation Group [CPET_QUOTGROUP]
    QUOTATIONRULE,               -- Quotation Rule [CPET_QUOTATIONRULE]
    KEYDATE,                     -- Maturity Key Date [TBA_KEYDATE]
    CALCRULE,                    -- Calculation Rule [CPET_CALCRULE]
    SURCHARGERULE,               -- Surcharge Rule [CPET_SURCHARGERULE]
    PERDETRULE_Q,                -- Period Det.Rule [CPET_PERDETRULE_Q]
    PERDETRULE_C,                -- PerDetRule Curr [CPET_PERDETRULE_C]
    PRICEFIXRULE,                -- Price Fixation Rule [CPET_PRCFIXOPTDEFRULE]
    PERDTIN_GUID_Q,              -- PerDet.Inp GUID [CPET_PERIODDTIN_GUID]
    PERDTIN_GUID_C,              -- PerDet.Inp GUID [CPET_PERIODDTIN_GUID]
    CALCROUT,                    -- Calculation Routine [CPET_CALCROUT]
    CALCMIN,                     -- Minimum Rate [CPET_CALCMIN]
    CALCMAX,                     -- Maximum Rate [CPET_CALCMAX]
    CALCMMCURR,                  -- Curr. of Limits [CPET_CALCMMCURR]
    CALCMMPRUN,                  -- PUnit of Limits [CPET_CALCMMPRUN]
    CALCMMUOM,                   -- UoM:Rate Limits [CPET_CALCMMUOM]
    SURCHARGEROUT,               -- Surcharge Routine [CPET_SURCHARGEROUT]
    SURCHARGEABS,                -- Absolute Surcharge [CPET_SURCHARGEABS]
    SURCHARGEABS_DF34,           -- Absolute Surcharge [CPET_SURCHARGEABSO_DF34]
    SURCHARGECURR,               -- CurrAbsSurch [CPET_SURCHARGECURR]
    SURCHARGEPRUN,               -- PU AbsSurch [CPET_SURCHARGEPRUN]
    SURCHARGEUOM,                -- UoM AbsSurch. [CPET_SURCHARGEUOM]
    SURCHARGEFACTOR1,            -- Factor 1: Surch [CPET_SURCHARGEFACTOR1]
    SURCHARGEFACTOR2,            -- Factor 2: Surch [CPET_SURCHARGEFACTOR2]
    TERMTEXT,                    -- Description [BEZEI40]
    FORECAST_DATE_ROUTINE,       -- Latest Eval. Date R. [CPET_LATEST_EVAL_KEYDATE_ROUT]
    CALCMIN_DF34,                -- Minimum Rate [CPET_CALCMIN_DF34]
    CALCMAX_DF34,                -- Maximum Rate [CPET_CALCMAX_DF34]
    FIXTERMRATE_DF34,            -- Fixed Rate [CPET_FIXTERMRATE_DF34]
    RATE_CREATED_AT,             -- Created at [CPET_CREATED_AT]
    RATE_CREATED_BY,             -- Created by [CPET_CREATED_BY]
    RATE_CHANGED_AT,             -- Changed At [CPET_CHANGED_AT]
    RATE_CHANGED_BY,             -- Changed By [CPET_CHANGED_BY]
    PSMGUID,                     -- PSM GUID [CPET_PSMGUID]
    PSMETHOD,                    -- Price Setting Method [CPET_PSMETHOD]
    PSMSTATUS,                   -- PSM Status [CPET_PSMSTATUS]
    COMMODITYSUBACCOUNT,         -- Subaccount ID [CMMFSA_SUBACCOUNTID]
    NUMBER_OF_LOTS,              -- Lots [CPET_NUMBER_OF_LOTS]
    FILLPACKETUUID,              -- Fill Packet UUID [CPET_FILL_PACKET_UUID]
    PSM_SIMULATION_ERROR,        -- Indicator [FLAG]
    EXPRTNINSTRUCTION,           -- Expiry Instruction [CMMFDOR_ORDEREXPIRATIONINST]
    PRCGEXECINSTRN,              -- Prc/Exec Instruction [CMMFDOR_ORDERPRICINGEXECINST]
    LMTPRC,                      -- Limit Price [CPET_CMMDTYORDERREQLIMPRICE]
    LMTPRCCURRENCY,              -- Limit Price Crcy [CMMFDOR_ORDREQLIMITPRICECRCY]
    STOPPRICE,                   -- Stop Price [CPET_ORDREQSTOPPRICE]
    STOPPRICECRCY,               -- Stop Price Crcy [CMMFDOR_ORDREQSTOPPRICECRCY]
    STOPLMTPRC,                  -- Stop Limit Price [CPET_ORDREQSTOPLIMPRICE]
    STOPLMTPRCCURRENCY,          -- Stop Limit Prc Crcy [CMMFDOR_ORDERSTOPLIMITPRCCRCY]
    FXDPRC,                      -- Requested Price [CPET_ORDREQFIXEDPRICE]
    FXDPRCCRCY,                  -- Requested Price Crcy [CMMFDOR_ORDREQFIXEDPRICECRCY]
    LEEWAYPRC,                   -- Requested Price [CPET_ORDREQLEEWAYPRICE]
    LEEWAYPRCCRCY,               -- Requested Price Crcy [CMMFDOR_ORDREQLEEWAYPRICECRCY]
    LEEWAYRNGEPRC,               -- Leeway Price [CPET_ORDREQLEEWAYRNGEPRC]
    LEEWAYRNGEPRCCRCY,           -- Leeway Prc Crcy [CMMFDOR_ORDREQLEEWAYRNGEPRCCUR]
    EXPIRATIONDATE,              -- Expiration Date [CMMFDOR_ORDREQEXPIRATIONDATE]
    LMTSPREADPRC,                -- Limit Spread Value [CPET_ORDREQLMTSPREADPRICE]
    LMTSPREADPRCCRCY,            -- Lim Spread Prc Crcy [CMMFDOR_ORDREQLMTSPREADPRCCRCY]
    FXDSPREADPRC,                -- Requested Spread Prc [CPET_ORDREQFIXEDSPREADPRICE]
    FXDSPREADPRCCRCY,            -- Rqstd Spr Prc Crcy [CMMFDOR_ORDREQFXDSPREADPRCCRCY]
    TICKS,                       -- Order Request Ticks [CMMFDOR_ORDREQTICKS]
    CMMDTYORDREQCNTRPTYBROKER,   -- Counterparty Broker [CMMFSA_COUNTERPARTY_BROKER]
    CMMDTYORDREQCNTRPTYREFACCT,  -- Reference Account [CMMFSA_REFERENCEBROKERACCOUNT]
    SAVETERMRATE_DF34,           -- Fixed Rate [CPET_FIXTERMRATE_DF34]
    SAVETERMCURR,                -- Currency Fixed Rate [CPET_FIXCURR]
    PRIMARY KEY (CLIENT, TERMINPUT_GUID)
);