ALLOC_RUN_INFO

Transparent Table Application Table

Allocation run

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AllocationRun view from BASIC Allocation Run

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY run_id alloc_run_id Run ID
name alloc_run_name Run Name
start_date alloc_run_sdate Run Date
start_time alloc_run_stime Start Time
duration alloc_run_proc_time Processing Time
run_user uname User Name
ledger fins_ledger Ledger
alloc_context fco_allocation_context Allocation Context
alloc_type fco_alloc_posting_type Allocation Type
actual_plan ipknz Actual/Plan
fiscal_year fis_gjahr Fiscal Year
start_period alloc_run_period_from Fiscal Period From
end_period alloc_run_period_to Fiscal Period To
test_run alloc_run_test Test Run
status alloc_run_status Status
reversed alloc_run_is_reversed Is Reversed
creation_date alloc_run_crdate Creation date
ref_start_period alloc_run_ref_period_from Ref. Period From
ref_end_period alloc_run_ref_period_to Ref. Period To
ref_fiscal_year alloc_run_ref_fis_gjahr Ref. Fiscal Year
cumulative alloc_run_cumulative_proc Cumulate Ref. Periods
ref_to_fiscal_year alloc_run_to_ref_fis_gjahr Ref. to Fiscal Year
fiscal_year_variant periv FY Variant
end_date alloc_run_edate Run End Date
end_time alloc_run_etime Run End Time
book_date alloc_run_bdate Booking Date
book_time alloc_run_btime Booking Time
book_duration alloc_run_bduration Booking Duration
run_timezone alloc_run_timezone Timezone
run_duration fco_alloc_run_duration Processing Time
document_type fis_blart Journal Entry Type
jobname btcjob Job Name
jobcount btcjobcnt Job No.
stored_ref_data fco_alloc_run_store_ref_data Stored Ref. Data
run_type fco_alloc_run_type Run Type
note_exists fco_alloc_run_note_flag Has Note
cumulative_run fco_alloc_run_is_cumulative Cumulative
incremental_processing fco_alloc_run_incremental_proc Incremental
sender_count alloc_run_sender_count Senders
receiver_count alloc_run_receiver_count Receivers
trigger_source fco_alloc_run_trigger_source Run Source

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ALLOC_RUN_INFO (
    MANDT,                   -- Client [mandt]
    RUN_ID,                  -- Run ID [alloc_run_id]
    NAME,                    -- Run Name [alloc_run_name]
    START_DATE,              -- Run Date [alloc_run_sdate]
    START_TIME,              -- Start Time [alloc_run_stime]
    DURATION,                -- Processing Time [alloc_run_proc_time]
    RUN_USER,                -- User Name [uname]
    LEDGER,                  -- Ledger [fins_ledger]
    ALLOC_CONTEXT,           -- Allocation Context [fco_allocation_context]
    ALLOC_TYPE,              -- Allocation Type [fco_alloc_posting_type]
    ACTUAL_PLAN,             -- Actual/Plan [ipknz]
    FISCAL_YEAR,             -- Fiscal Year [fis_gjahr]
    START_PERIOD,            -- Fiscal Period From [alloc_run_period_from]
    END_PERIOD,              -- Fiscal Period To [alloc_run_period_to]
    TEST_RUN,                -- Test Run [alloc_run_test]
    STATUS,                  -- Status [alloc_run_status]
    REVERSED,                -- Is Reversed [alloc_run_is_reversed]
    CREATION_DATE,           -- Creation date [alloc_run_crdate]
    REF_START_PERIOD,        -- Ref. Period From [alloc_run_ref_period_from]
    REF_END_PERIOD,          -- Ref. Period To [alloc_run_ref_period_to]
    REF_FISCAL_YEAR,         -- Ref. Fiscal Year [alloc_run_ref_fis_gjahr]
    CUMULATIVE,              -- Cumulate Ref. Periods [alloc_run_cumulative_proc]
    REF_TO_FISCAL_YEAR,      -- Ref. to Fiscal Year [alloc_run_to_ref_fis_gjahr]
    FISCAL_YEAR_VARIANT,     -- FY Variant [periv]
    END_DATE,                -- Run End Date [alloc_run_edate]
    END_TIME,                -- Run End Time [alloc_run_etime]
    BOOK_DATE,               -- Booking Date [alloc_run_bdate]
    BOOK_TIME,               -- Booking Time [alloc_run_btime]
    BOOK_DURATION,           -- Booking Duration [alloc_run_bduration]
    RUN_TIMEZONE,            -- Timezone [alloc_run_timezone]
    RUN_DURATION,            -- Processing Time [fco_alloc_run_duration]
    DOCUMENT_TYPE,           -- Journal Entry Type [fis_blart]
    JOBNAME,                 -- Job Name [btcjob]
    JOBCOUNT,                -- Job No. [btcjobcnt]
    STORED_REF_DATA,         -- Stored Ref. Data [fco_alloc_run_store_ref_data]
    RUN_TYPE,                -- Run Type [fco_alloc_run_type]
    NOTE_EXISTS,             -- Has Note [fco_alloc_run_note_flag]
    CUMULATIVE_RUN,          -- Cumulative [fco_alloc_run_is_cumulative]
    INCREMENTAL_PROCESSING,  -- Incremental [fco_alloc_run_incremental_proc]
    SENDER_COUNT,            -- Senders [alloc_run_sender_count]
    RECEIVER_COUNT,          -- Receivers [alloc_run_receiver_count]
    TRIGGER_SOURCE,          -- Run Source [fco_alloc_run_trigger_source]
    PRIMARY KEY (MANDT, RUN_ID)
);