ALLOC_RUN_CYCLE

Transparent Table Application Table
31 Fields 1 CDS Views

Allocation run cycles

ALLOC_RUN_CYCLE is an SAP database table in S/4HANA. Allocation run cycles. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AllocationRunCycle view from BASIC Allocation Run Cycle

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY run_id ALLOC_RUN_ID Run ID
KEY cycle_seq ALLOC_RUN_SEQNR Seq. number
cycle CYCLE Cycle
sdate SDATE Valid From
cycle_name FCO_ALLOC_CYCLE_NAME Cycle Description
reads_count FCO_ALLOC_RUN_READ_CNT Lines Read
used_count FCO_ALLOC_RUN_USED_CNT Lines Used
writes_count FCO_ALLOC_RUN_WRITE_CNT Lines Written
start_time FCO_ALLOC_RUN_START_TIME Start Date On
start_dur FCO_ALLOC_RUN_START_DUR Duration Start
init_time FCO_ALLOC_RUN_INIT_TIME Init.Time
init_dur FCO_ALLOC_RUN_INIT_DUR Init.Duration
doc_sel_time FCO_ALLOC_RUN_DOC_SEL_TIME Doc.Sel.Time
doc_sel_dur FCO_ALLOC_RUN_DOC_SEL_DUR Doc.Sel.Duration
db_sel_time FCO_ALLOC_RUN_DB_SEL_TIME DB Select Time
db_sel_dur FCO_ALLOC_RUN_DB_SEL_DUR DB Sel.Duration
usertables_time FCO_ALLOC_RUN_USERTAB_TIME Usertables Time
usertables_dur FCO_ALLOC_RUN_USERTAB_DUR Usertables Duration
fill_iter_time FCO_ALLOC_RUN_FILLITER_TIME Init Iter.Time
fill_iter_dur FCO_ALLOC_RUN_FILLITER_DUR Init Iter.Duration
iteration_time FCO_ALLOC_RUN_ITER_TIME Iteration Time
iteration_dur FCO_ALLOC_RUN_ITER_DUR Iteration Duration
results_time FCO_ALLOC_RUN_RESULTS_TIME Results Time
results_dur FCO_ALLOC_RUN_RESULTS_DUR Results Duration
release_time FCO_ALLOC_RUN_RELEASE_TIME Release Time
release_dur FCO_ALLOC_RUN_RELEASE_DUR Release Duration
end_time FCO_ALLOC_RUN_END_TIME End Time
end_dur FCO_ALLOC_RUN_END_DUR Duration End
booking_time FCO_ALLOC_RUN_BOOK_TIME Booking Time
booking_dur FCO_ALLOC_RUN_BOOK_DUR Booking Duration

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.

-- Allocation run cycles
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ALLOC_RUN_CYCLE (
    MANDT,            -- Client [MANDT]
    RUN_ID,           -- Run ID [ALLOC_RUN_ID]
    CYCLE_SEQ,        -- Seq. number [ALLOC_RUN_SEQNR]
    CYCLE,            -- Cycle [CYCLE]
    SDATE,            -- Valid From [SDATE]
    CYCLE_NAME,       -- Cycle Description [FCO_ALLOC_CYCLE_NAME]
    READS_COUNT,      -- Lines Read [FCO_ALLOC_RUN_READ_CNT]
    USED_COUNT,       -- Lines Used [FCO_ALLOC_RUN_USED_CNT]
    WRITES_COUNT,     -- Lines Written [FCO_ALLOC_RUN_WRITE_CNT]
    START_TIME,       -- Start Date On [FCO_ALLOC_RUN_START_TIME]
    START_DUR,        -- Duration Start [FCO_ALLOC_RUN_START_DUR]
    INIT_TIME,        -- Init.Time [FCO_ALLOC_RUN_INIT_TIME]
    INIT_DUR,         -- Init.Duration [FCO_ALLOC_RUN_INIT_DUR]
    DOC_SEL_TIME,     -- Doc.Sel.Time [FCO_ALLOC_RUN_DOC_SEL_TIME]
    DOC_SEL_DUR,      -- Doc.Sel.Duration [FCO_ALLOC_RUN_DOC_SEL_DUR]
    DB_SEL_TIME,      -- DB Select Time [FCO_ALLOC_RUN_DB_SEL_TIME]
    DB_SEL_DUR,       -- DB Sel.Duration [FCO_ALLOC_RUN_DB_SEL_DUR]
    USERTABLES_TIME,  -- Usertables Time [FCO_ALLOC_RUN_USERTAB_TIME]
    USERTABLES_DUR,   -- Usertables Duration [FCO_ALLOC_RUN_USERTAB_DUR]
    FILL_ITER_TIME,   -- Init Iter.Time [FCO_ALLOC_RUN_FILLITER_TIME]
    FILL_ITER_DUR,    -- Init Iter.Duration [FCO_ALLOC_RUN_FILLITER_DUR]
    ITERATION_TIME,   -- Iteration Time [FCO_ALLOC_RUN_ITER_TIME]
    ITERATION_DUR,    -- Iteration Duration [FCO_ALLOC_RUN_ITER_DUR]
    RESULTS_TIME,     -- Results Time [FCO_ALLOC_RUN_RESULTS_TIME]
    RESULTS_DUR,      -- Results Duration [FCO_ALLOC_RUN_RESULTS_DUR]
    RELEASE_TIME,     -- Release Time [FCO_ALLOC_RUN_RELEASE_TIME]
    RELEASE_DUR,      -- Release Duration [FCO_ALLOC_RUN_RELEASE_DUR]
    END_TIME,         -- End Time [FCO_ALLOC_RUN_END_TIME]
    END_DUR,          -- Duration End [FCO_ALLOC_RUN_END_DUR]
    BOOKING_TIME,     -- Booking Time [FCO_ALLOC_RUN_BOOK_TIME]
    BOOKING_DUR,      -- Booking Duration [FCO_ALLOC_RUN_BOOK_DUR]
    PRIMARY KEY (MANDT, RUN_ID, CYCLE_SEQ)
);

Learn More