VICDCFOBJ

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.

-- Object-Related Cash Flow
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICDCFOBJ (
    MANDT,            -- Client [MANDT]
    CFOBJGUID,        -- GUID [RECDCFOBJGUID]
    CONDGUID,         -- Condition [RECDCONDGUID]
    CONDVALIDFROM,    -- Valid From [RECDVALIDFROM]
    REFGUID,          -- GUID [RECDREFGUID]
    INTRENO,          -- RE Key [RECAINTRENO]
    RERF,             -- Entered By [RERF]
    DERF,             -- First Enterd On [DERF]
    TERF,             -- Time [TERF]
    REHER,            -- Source.In.Entry [REHER]
    RBEAR,            -- Last Changed By [RBEAR]
    DBEAR,            -- Last Edited On [DBEAR]
    TBEAR,            -- Last Edited At [TBEAR]
    RBHER,            -- Editing Source [RBHER]
    BBWHR,            -- Posit.-changing amnt [TFM_BBWHR]
    BNWHR,            -- Nominal amount [TFM_BNWHR]
    DBERVON,          -- CalculationFrom [DBERVON]
    SEXCLVON,         -- Exclusive Start [VVSEXCLVON]
    SULTVON,          -- Mth-End StartDt [VVSULTVON]
    DBERBIS,          -- Calculation To [DBERBIS]
    SINCLBIS,         -- Incl. End Date [VVSINCLBIS]
    SULTBIS,          -- Month-End EndDt [VVSULTBIS]
    DVALUT,           -- Calculat. date [DVALUT]
    SINCL,            -- Inclusive Ind. [VVSINCL]
    SVINCL,           -- Inclusive_valDt [VVSVINCL]
    SVULT,            -- Mon-End Val.Dte [VVSVULT]
    DFAELL,           -- Due Date [DFAELL]
    SFINCL,           -- Incl. Due Date [VVSFINCL]
    SFULT,            -- Month-End DueDt [SFULT]
    DDISPO,           -- Payment date [DDISPO]
    SINCLVERR,        -- Incl. Clrg Date [VVSINCLVER]
    SULTVERR,         -- MnthEndClearing [VVSULTVERR]
    ATAGE,            -- Number of Days [TFMATAGE]
    ABASTAGE,         -- Amnt internal field [BITER]
    APERTAGE,         -- No.Days in Per. [VVAPERTAGE]
    STGMETH,          -- Daily Method [VVSTGMETH]
    STGBASIS,         -- Base Days Meth. [VVSTGBASIS]
    SZBMETH,          -- Int.calc.method [SZBMETH]
    DBPERIOD,         -- Period start [VVDBPERIOD]
    SPAEXCL,          -- Exclusive Start [TFMSPAEXCL]
    SPAULT,           -- MonEndIndStPer [TFMSPAULT]
    DEPERIOD,         -- Period end [VVDEPERIOD]
    SPEINCL,          -- InclusiveEndPer [TFMSPEINCL]
    SPEULT,           -- MthEndPerEnd [TFMSPEULT]
    SWHRKOND,         -- Currency [TFMWHRKOND]
    BKOND,            -- Condition amnt [TFM_BKOND]
    SSTAFF,           -- Scaled Calc. [TFMSSTAFF]
    SBASIS,           -- Basis reference [TFM_SBASIS]
    JSOFVERR,         -- Immed.Settlemnt [TFMSOFVERR]
    AMMRHY,           -- Freq. in months [AMMRHY]
    ATTRHY,           -- Freq.in days [ATTRHY]
    SSORTZIT,         -- Sort indicator [TFM_SORT]
    SZEITANT,         -- Pro Rata Temp. [VVSZEITANT]
    SSALBAS,          -- Indicator for debit position/incoming pmnt (internal FiMa) [TFMSSALBAS]
    SKONDGRP,         -- Cond. group [SKONDGRP]
    LCNETAMOUNT,      -- Net local curr. [RECDCFLCVALUENET]
    LCGROSSAMOUNT,    -- LC amount [RECDCFLCVALUEGROSS]
    LCTAXAMOUNT,      -- Sls/Prch.Tax LC [RECDCFLCTAXVALUE]
    LOCALCURR,        -- Local Currency [RECDCFLCCURR]
    CCNETAMOUNT,      -- Net CndCrcy [RECDCFVALUENET]
    CCGROSSAMOUNT,    -- Gross CndCrcy [RECDCFVALUEGROSS]
    CCTAXAMOUNT,      -- Tax in CndCrcy [RECDCFTAXVALUE]
    CONDCURR,         -- Cond. currency [RECDCFCURR]
    TAXTYPE,          -- Tax Type [RERATAXTYPE]
    TAXGROUP,         -- Tax Group [RERATAXGROUP]
    TXJCD,            -- Tax Jur. [TXJCD]
    ISGROSS,          -- Gross [RECDISGROSS]
    TAXCOUNTRY,       -- Alt. Tax Ctry/Region [RERATAXCOUNTRY]
    OBJNR,            -- Object Number [RECAOBJNR]
    WHEREFROM,        -- Origin [RECDWHEREFROM]
    FLOWTYPE,         -- Flow Type [RECDFLOWTYPE]
    ORIGFLOWTYPE,     -- Orig. Flow Type [RECDORIGFLOWTYPE]
    REFFLOWREL,       -- Relatnshp Type [RECDREFFLOWREL]
    CFSTATUS,         -- Status [RECDCFSTATUS]
    FDLEV,            -- Planning Level [FDLEV]
    FDUPD,            -- CMF flag [FDUPD]
    FDELETE,          -- Deletion Indic. [RECAARDELETEIND]
    ORIGDUEDATE,      -- Orig. Due Date [RECDORIGDUEDATE]
    CONDTYPE,         -- Condition Type [RECDCONDTYPE]
    TERMNOPY,         -- Posting Term [RECDTERMNOPY]
    TERMNORH,         -- Frequency Term [RECDTERMNORH]
    TERMNOAJ,         -- Adjust. Term [RECDTERMNOAJ]
    TERMNOOA,         -- Org. Term [RECDTERMNOOA]
    TERMNOSR,         -- Sales Term [RECDTERMNOSR]
    TERMNOMR,         -- Peak Sales Term [RECDTERMNOMR]
    TERMNOWT,         -- WT Term [RECDTERMNOWT]
    ORIGEXDUEDATE,    -- Orig. Due Date [RECDORIGDUEDATE]
    SEAPSTATUS,       -- AP Status [RERASEAPSTATUS]
    POSTINGDATE,      -- Posting Date [RECDPOSTINGDATE]
    DOCUMENTDATE,     -- Document Date [RECDDOCUMENTDATE]
    VALUATIONDATE,    -- Valuation Date [RECDVALUATIONDATE]
    REVERSAL_FOR,     -- Reversal GUID [RECDREVERSALFORGUID]
    REVERSAL_BY,      -- Revrsd by GUID [RECDREVERSALBYGUID]
    FOLLOWUP_FOR,     -- FUP GUID [RECDFOLLOWUPFORGUID]
    BOOK_FLOWTYPE,    -- Flow Type [RECDFLOWTYPE]
    BOOK_REFFLOWREL,  -- Relatnshp Type [RECDREFFLOWREL]
    TAXDATE,          -- Sales Tax Date [RECDTAXDATE]
    MODDUEDATE,       -- Modif. Due Date [RECDMODDUEDATE]
    CALCDUEDATE,      -- Calc. Due Date [RECDCALCDUEDATE]
    CTRULE,           -- CrcyTranslRule [RECACTRULE]
    CTLCNETAMOUNT,    -- Net in LC [RECACTLCNETAMOUNT]
    CTLCGROSSAMOUNT,  -- Gross in LC [RECACTLCGROSSAMOUNT]
    CTLCTAXAMOUNT,    -- LC Tax Amount [RECACTLCTAXAMOUNT]
    CTRATE,           -- Exchange Rate [RECACTRATE]
    CTRATEORIG,       -- Exchange Rate [RECACTRATE]
    CTPOSTCDCURR,     -- Post in CndCrcy [RECACTPOSTCDCURR]
    CTDATEREQ,        -- Plan.Trsl.Date [RECACTDATEREQ]
    CTDATEACT,        -- Actual TrslDate [RECACTDATEACT]
    CTDATEACTORIG,    -- Actual TrslDate [RECACTDATEACT]
    CTDATEFROMCFPOS,  -- From Cash Flow [RECDCTDATEFROMCFPOS]
    PRIMARY KEY (MANDT, CFOBJGUID)
);