FMCCFLOT

Transparent Table Application Table

Commitment Carryforward of Held Documents (Approval Proc.)

FMCCFLOT is an SAP database table in S/4HANA. Commitment Carryforward of Held Documents (Approval Proc.). It contains 56 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CmtmtCarryForwardLotItem view from EXTENSION Commitment Carry Forward Lot Item - Extn
I_CmtmtCarryForwardLotItem view from BASIC Commitment Carry Forward Lot Item

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fikrs FIKRS FM Area
KEY syear FM_CCF_SYEAR Sender FY
KEY cflotnr FM_CFLOTNR Lot Number
KEY indexcnt FM_CCF_INDEXCNT Counter
refbn CO_REFBN Ref.document no
refbt FM_REFBTYP Reference Doc. Cat.
rforg AWORG Refer. Org.Unit
rfpos CC_RFPOS Ref Item
rfknt CC_RFKNT Acct Assnmt No.
rfete CC_RFETE Schedule Line
rcond RCOND Counter
rftyp AWTYP Ref. procedure
rfsys LOGSYSTEM Logical System
fmbelnr FM_BELNR FM Doc. No.
fmbuzei FM_BUZEI Item
bukrs BUKRS Company Code
kngjahr FM_KNGJAHR Fiscal year
sledger FM_CCF_SLDNR Sender Ledger
wrttp FM_WRTTP Value Type
cfstat FM_CFST FYC Status
cfcnt FM_CFCNT CarryfwdPrevYr
rgrant FM_CCF_RGRANT Receiver Grant
rfonds FM_CCF_RFONDS Receiver Fund
rfistl FM_CCF_RFISTL Receiver FdsCtr
rfipex FM_CCF_RFIPEX R Cmmt Item
rfarea FM_CCF_RFAREA R FuncArea
rmeasure FM_CCF_RMEASURE Receiver FProg
ccf_option FM_CCF_OPTION_CHAIN Adjustment Type
rbudget_pd FM_EBUDGET_PERIOD Rec BudPer
sgrant FM_CCF_SGRANT Sender Grant
sfonds FM_CCF_SFONDS Sender Fund
sfistl FM_CCF_SFISTL Sndr Funds Ctr
sfipex FM_CCF_SFIPEX Sndr Cmmt Item
sfarea FM_CCF_SFAREA Sender FnArea
smeasure FM_CCF_SMEASURE Sender Funded Prog
sbudget_pd FM_SBUDGET_PERIOD Sender BudPer
cfdocnr FM_CFBELNR FYC Doc No.
cfdocnr_pred FM_ITEM_PREC_CHAIN Item Predecessor
cfdocnr_root FM_ITEM_ROOT_CHAIN Root Item
chain_vt_level FM_CCF_LEVEL_CHAIN Value Type L
flg_root FMCHAIN_FLG_ROOT Root
flg_tail FMCHAIN_FLG_TAIL Tail
flg_error FMCHAIN_FLG_ERROR Error
fkbtr FM_FKBTR FMAC amount
trbtr FM_TRBTR TC amount
fktbtr FM_TOTAL_AMOUNT_FK Total Amt FMA Crry
trtbtr FM_TOTAL_AMOUNT_TR T Amnt in Tr. Crry
fkrbtr FM_FKBTR FMAC amount
trrbtr FM_TRBTR TC amount
twaer TWAER Trans. Currency
erlkz ERLKZ Item Completed
stats FM_STATS Statisticl.Indicator
suserdim FM_CCF_SUSERDIM Sender Cstr Fld
ruserdim FM_CCF_RUSERDIM Rec.Cstr-Spc Fd
dummy_fmccflot_incl_eew_ps CFD_DUMMY Dummy

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.

-- Commitment Carryforward of Held Documents (Approval Proc.)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMCCFLOT (
    MANDT,                       -- Client [MANDT]
    FIKRS,                       -- FM Area [FIKRS]
    SYEAR,                       -- Sender FY [FM_CCF_SYEAR]
    CFLOTNR,                     -- Lot Number [FM_CFLOTNR]
    INDEXCNT,                    -- Counter [FM_CCF_INDEXCNT]
    REFBN,                       -- Ref.document no [CO_REFBN]
    REFBT,                       -- Reference Doc. Cat. [FM_REFBTYP]
    RFORG,                       -- Refer. Org.Unit [AWORG]
    RFPOS,                       -- Ref Item [CC_RFPOS]
    RFKNT,                       -- Acct Assnmt No. [CC_RFKNT]
    RFETE,                       -- Schedule Line [CC_RFETE]
    RCOND,                       -- Counter [RCOND]
    RFTYP,                       -- Ref. procedure [AWTYP]
    RFSYS,                       -- Logical System [LOGSYSTEM]
    FMBELNR,                     -- FM Doc. No. [FM_BELNR]
    FMBUZEI,                     -- Item [FM_BUZEI]
    BUKRS,                       -- Company Code [BUKRS]
    KNGJAHR,                     -- Fiscal year [FM_KNGJAHR]
    SLEDGER,                     -- Sender Ledger [FM_CCF_SLDNR]
    WRTTP,                       -- Value Type [FM_WRTTP]
    CFSTAT,                      -- FYC Status [FM_CFST]
    CFCNT,                       -- CarryfwdPrevYr [FM_CFCNT]
    RGRANT,                      -- Receiver Grant [FM_CCF_RGRANT]
    RFONDS,                      -- Receiver Fund [FM_CCF_RFONDS]
    RFISTL,                      -- Receiver FdsCtr [FM_CCF_RFISTL]
    RFIPEX,                      -- R Cmmt Item [FM_CCF_RFIPEX]
    RFAREA,                      -- R FuncArea [FM_CCF_RFAREA]
    RMEASURE,                    -- Receiver FProg [FM_CCF_RMEASURE]
    CCF_OPTION,                  -- Adjustment Type [FM_CCF_OPTION_CHAIN]
    RBUDGET_PD,                  -- Rec BudPer [FM_EBUDGET_PERIOD]
    SGRANT,                      -- Sender Grant [FM_CCF_SGRANT]
    SFONDS,                      -- Sender Fund [FM_CCF_SFONDS]
    SFISTL,                      -- Sndr Funds Ctr [FM_CCF_SFISTL]
    SFIPEX,                      -- Sndr Cmmt Item [FM_CCF_SFIPEX]
    SFAREA,                      -- Sender FnArea [FM_CCF_SFAREA]
    SMEASURE,                    -- Sender Funded Prog [FM_CCF_SMEASURE]
    SBUDGET_PD,                  -- Sender BudPer [FM_SBUDGET_PERIOD]
    CFDOCNR,                     -- FYC Doc No. [FM_CFBELNR]
    CFDOCNR_PRED,                -- Item Predecessor [FM_ITEM_PREC_CHAIN]
    CFDOCNR_ROOT,                -- Root Item [FM_ITEM_ROOT_CHAIN]
    CHAIN_VT_LEVEL,              -- Value Type L [FM_CCF_LEVEL_CHAIN]
    FLG_ROOT,                    -- Root [FMCHAIN_FLG_ROOT]
    FLG_TAIL,                    -- Tail [FMCHAIN_FLG_TAIL]
    FLG_ERROR,                   -- Error [FMCHAIN_FLG_ERROR]
    FKBTR,                       -- FMAC amount [FM_FKBTR]
    TRBTR,                       -- TC amount [FM_TRBTR]
    FKTBTR,                      -- Total Amt FMA Crry [FM_TOTAL_AMOUNT_FK]
    TRTBTR,                      -- T Amnt in Tr. Crry [FM_TOTAL_AMOUNT_TR]
    FKRBTR,                      -- FMAC amount [FM_FKBTR]
    TRRBTR,                      -- TC amount [FM_TRBTR]
    TWAER,                       -- Trans. Currency [TWAER]
    ERLKZ,                       -- Item Completed [ERLKZ]
    STATS,                       -- Statisticl.Indicator [FM_STATS]
    SUSERDIM,                    -- Sender Cstr Fld [FM_CCF_SUSERDIM]
    RUSERDIM,                    -- Rec.Cstr-Spc Fd [FM_CCF_RUSERDIM]
    DUMMY_FMCCFLOT_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, FIKRS, SYEAR, CFLOTNR, INDEXCNT)
);