T811CV

Transparent Table Application Table
74 Fields 1 CDS Views

Versioning Allocation Cycles

T811CV is an SAP database table in S/4HANA. Versioning Allocation Cycles. It contains 74 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AllocationCycleVersion view_entity from BASIC Allocation Cycle Version

Fields (74)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY id SCHEDMAN_ID ID
KEY tab DBNAM Table
KEY cycle CYCLE Cycle
KEY sdate SDATE Valid From
usnam SYUNAME User Name
cpudt CO_CPUDT Created on
cputm CPUTM Entered at
del_user DELUSER User Deletion
del_dat DELDAT Deletion Date
del_time DELZEIT Deleted At
id_t811s SCHEDMAN_ID ID
id_t811k SCHEDMAN_ID ID
id_t811f SCHEDMAN_ID ID
id_t811g SCHEDMAN_ID ID
id_t811l SCHEDMAN_ID ID
id_t811r SCHEDMAN_ID ID
id_t811set SCHEDMAN_ID ID
id_t811_tagged SCHEDMAN_ID ID
id_t811km SCHEDMAN_ID ID
id_t811derive SCHEDMAN_ID ID
id_cycle_note SCHEDMAN_ID ID
id_segment_note SCHEDMAN_ID ID
id_tdd_template SCHEDMAN_ID ID
testrun FLAG Indicator
source FCOUA_VERSION_SOURCE Version Source
edate EDATE To-Date
rstatus RSTATUS Status
freq FREQ Frequency
crdate ERFDT Entered On
puser ERFNM Created By
moddate AENDT Changed On
moduser KALC_AENNM Changed By
lastexec EXDAT Executed on
lexecby EXNAM Executed By
timeexec EXTIM Time
iterflag ALABLAUF Processing
astatus RSTATUS Status
cycleset SETNR Set ID
negtest NEGTEST Scale Neg. Factors
alart ALART Allocation Type
ipknz IPKNZ Actual/Plan
job CHAR4 Undefined range (can be used for patch levels)
kumuflag KUMUFLAG Cumulative
xxkumuflag XXKUMUFLAG Cumulative Opt.
rckumuflag RCKUMUFLAG Agg.Trac.Factor
proc_group KALC_PROCG Cycle Run Group
substid SUBST_ID Substitution
rke_split RKE_SPLIT Sender Select. Type
fm_derive PS_DERIVE Der.Fund/FuncAr
gl_xbilk GL_XBILK Balance Sheet Accts
fm_derive_fonds PS_DERIVE_FONDS Derive Funds
fm_derive_fkber PS_DERIVE_FKBER Derive Func.Ar
fm_derive_grant PS_DERIVE_GRANT Derive Grant
fm_derive_budpd PS_DERIVE_BUDGET_PERIOD Derive Budg.Per
gl_ldgrp FAGL_LDGRP_ALLOC Ledger Group
period_lag PERIOD_LAG Read Preperiod
period_delta PERIOD_DELTA Per. Delta
kalc_prodper KALC_PRODPER Production Month
variabel KALC_VARIABEL Variable Quantity
valutyp_alloc VALUTYP_ALLOC Valuation
no_src_ce KEPSL_NO_SOURCE_COSTELEMENT Summ. Srce Cst Elmnt
rbukrs BUKRS Company Code
kokrs KOKRS CO Area
rldnr FINS_LEDGER Ledger
cyclename FCO_ALLOC_CYCLE Allocation Cycle
category FCOM_CATEGORY Plan Category
erkrs ERKRS Operating concern
cyclename_co KSCYC Cycle
modtime FCO_ALLOC_MODIFICATION_TIME Last Mod. Time
can_exec_for_other_ledger FINS_ALLOC_EXEC_OTHER_LEDGER Exec for any Ledger
enable_attributed_line_items FINS_ALLOC_ENABLE_ATTR_LINES Attributed Line item
enable_delta_process FINS_ALLOC_ENABLE_DELTA_RUN Delta Processing
co_rldnr_only CO_RLDNR_ONLY Only CO Ledger

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.

-- Versioning Allocation Cycles
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T811CV (
    MANDT,                         -- Client [MANDT]
    ID,                            -- ID [SCHEDMAN_ID]
    TAB,                           -- Table [DBNAM]
    CYCLE,                         -- Cycle [CYCLE]
    SDATE,                         -- Valid From [SDATE]
    USNAM,                         -- User Name [SYUNAME]
    CPUDT,                         -- Created on [CO_CPUDT]
    CPUTM,                         -- Entered at [CPUTM]
    DEL_USER,                      -- User Deletion [DELUSER]
    DEL_DAT,                       -- Deletion Date [DELDAT]
    DEL_TIME,                      -- Deleted At [DELZEIT]
    ID_T811S,                      -- ID [SCHEDMAN_ID]
    ID_T811K,                      -- ID [SCHEDMAN_ID]
    ID_T811F,                      -- ID [SCHEDMAN_ID]
    ID_T811G,                      -- ID [SCHEDMAN_ID]
    ID_T811L,                      -- ID [SCHEDMAN_ID]
    ID_T811R,                      -- ID [SCHEDMAN_ID]
    ID_T811SET,                    -- ID [SCHEDMAN_ID]
    ID_T811_TAGGED,                -- ID [SCHEDMAN_ID]
    ID_T811KM,                     -- ID [SCHEDMAN_ID]
    ID_T811DERIVE,                 -- ID [SCHEDMAN_ID]
    ID_CYCLE_NOTE,                 -- ID [SCHEDMAN_ID]
    ID_SEGMENT_NOTE,               -- ID [SCHEDMAN_ID]
    ID_TDD_TEMPLATE,               -- ID [SCHEDMAN_ID]
    TESTRUN,                       -- Indicator [FLAG]
    SOURCE,                        -- Version Source [FCOUA_VERSION_SOURCE]
    EDATE,                         -- To-Date [EDATE]
    RSTATUS,                       -- Status [RSTATUS]
    FREQ,                          -- Frequency [FREQ]
    CRDATE,                        -- Entered On [ERFDT]
    PUSER,                         -- Created By [ERFNM]
    MODDATE,                       -- Changed On [AENDT]
    MODUSER,                       -- Changed By [KALC_AENNM]
    LASTEXEC,                      -- Executed on [EXDAT]
    LEXECBY,                       -- Executed By [EXNAM]
    TIMEEXEC,                      -- Time [EXTIM]
    ITERFLAG,                      -- Processing [ALABLAUF]
    ASTATUS,                       -- Status [RSTATUS]
    CYCLESET,                      -- Set ID [SETNR]
    NEGTEST,                       -- Scale Neg. Factors [NEGTEST]
    ALART,                         -- Allocation Type [ALART]
    IPKNZ,                         -- Actual/Plan [IPKNZ]
    JOB,                           -- Undefined range (can be used for patch levels) [CHAR4]
    KUMUFLAG,                      -- Cumulative [KUMUFLAG]
    XXKUMUFLAG,                    -- Cumulative Opt. [XXKUMUFLAG]
    RCKUMUFLAG,                    -- Agg.Trac.Factor [RCKUMUFLAG]
    PROC_GROUP,                    -- Cycle Run Group [KALC_PROCG]
    SUBSTID,                       -- Substitution [SUBST_ID]
    RKE_SPLIT,                     -- Sender Select. Type [RKE_SPLIT]
    FM_DERIVE,                     -- Der.Fund/FuncAr [PS_DERIVE]
    GL_XBILK,                      -- Balance Sheet Accts [GL_XBILK]
    FM_DERIVE_FONDS,               -- Derive Funds [PS_DERIVE_FONDS]
    FM_DERIVE_FKBER,               -- Derive Func.Ar [PS_DERIVE_FKBER]
    FM_DERIVE_GRANT,               -- Derive Grant [PS_DERIVE_GRANT]
    FM_DERIVE_BUDPD,               -- Derive Budg.Per [PS_DERIVE_BUDGET_PERIOD]
    GL_LDGRP,                      -- Ledger Group [FAGL_LDGRP_ALLOC]
    PERIOD_LAG,                    -- Read Preperiod [PERIOD_LAG]
    PERIOD_DELTA,                  -- Per. Delta [PERIOD_DELTA]
    KALC_PRODPER,                  -- Production Month [KALC_PRODPER]
    VARIABEL,                      -- Variable Quantity [KALC_VARIABEL]
    VALUTYP_ALLOC,                 -- Valuation [VALUTYP_ALLOC]
    NO_SRC_CE,                     -- Summ. Srce Cst Elmnt [KEPSL_NO_SOURCE_COSTELEMENT]
    RBUKRS,                        -- Company Code [BUKRS]
    KOKRS,                         -- CO Area [KOKRS]
    RLDNR,                         -- Ledger [FINS_LEDGER]
    CYCLENAME,                     -- Allocation Cycle [FCO_ALLOC_CYCLE]
    CATEGORY,                      -- Plan Category [FCOM_CATEGORY]
    ERKRS,                         -- Operating concern [ERKRS]
    CYCLENAME_CO,                  -- Cycle [KSCYC]
    MODTIME,                       -- Last Mod. Time [FCO_ALLOC_MODIFICATION_TIME]
    CAN_EXEC_FOR_OTHER_LEDGER,     -- Exec for any Ledger [FINS_ALLOC_EXEC_OTHER_LEDGER]
    ENABLE_ATTRIBUTED_LINE_ITEMS,  -- Attributed Line item [FINS_ALLOC_ENABLE_ATTR_LINES]
    ENABLE_DELTA_PROCESS,          -- Delta Processing [FINS_ALLOC_ENABLE_DELTA_RUN]
    CO_RLDNR_ONLY,                 -- Only CO Ledger [CO_RLDNR_ONLY]
    PRIMARY KEY (MANDT, ID, TAB, CYCLE, SDATE)
);

Learn More