T811C

Transparent Table Customizing Table
52 Fields 2 CDS Views

Allocations: Cycles

T811C is an SAP database table in S/4HANA. Allocations: Cycles. It contains 52 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocationCycle view from BASIC Allocation Cycle
I_UniversalAllocationCycle view_entity from BASIC Universal Allocation Cycle

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tab DBNAM Table
KEY cycle CYCLE Cycle
KEY sdate SDATE Valid From
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
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
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

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.

-- Allocations: Cycles
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T811C (
    MANDT,                         -- Client [MANDT]
    TAB,                           -- Table [DBNAM]
    CYCLE,                         -- Cycle [CYCLE]
    SDATE,                         -- Valid From [SDATE]
    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]
    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]
    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]
    PRIMARY KEY (MANDT, TAB, CYCLE, SDATE)
);

Learn More