ALLOCYCLEXLSX

Transparent Table Application Table
24 Fields 2 CDS Views

Allocation Cycle data from Excel upload

ALLOCYCLEXLSX is an SAP database table in S/4HANA. Allocation Cycle data from Excel upload. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocationCycleUpload view from BASIC Cycle data from Alloc. Excel upload
I_UnivAllocationCycleUpload view_entity from BASIC Cycle data from Allocation Excel upload

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY upload_guid fco_upload_guid Upload GUID
KEY row_guid fco_row_guid Row GUID
row_index fco_row_index Row index
allocationcycle cycle Cycle
allocationtype fco_allocation_context Allocation Context
ledger fis_rldnr Ledger
allocationcyclestartdate fco_alloc_valid_from Valid From
allocationcycleenddate fco_alloc_valid_to Valid To
allocationcyclenametext fco_alloc_cycle_name Cycle Description
companycode fis_bukrs Company Code
controllingarea fis_kokrs Controlling Area
allocationpostingtype fco_alloc_posting_type Allocation Type
allocationactualplanvariant fco_alloc_ipknz Actual/Plan
allocationcyclecategory fcom_category Plan Category
allocationcycleisiterative fco_alloc_iterative_excel_nox Iteration
cycleisparallelledgerenabled fco_allo_par_ledger_excel_nox Flex. Ledger
allocationiscumulative fco_alloc_cumulative_excel_nox Cumulative
msl fco_alloc_quantites_excel_nox Quantities
tsl fco_trans_curr_excel_nox Trans. Currency
cruser fco_alloc_created_by Created By
timestamp timestamp Time Stamp
allocationcyclerungroup kalc_procg Cycle Run Group
allocationcyclename fco_alloc_cycle Allocation Cycle

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 Cycle data from Excel upload
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ALLOCYCLEXLSX (
    MANDT,                         -- Client [mandt]
    UPLOAD_GUID,                   -- Upload GUID [fco_upload_guid]
    ROW_GUID,                      -- Row GUID [fco_row_guid]
    ROW_INDEX,                     -- Row index [fco_row_index]
    ALLOCATIONCYCLE,               -- Cycle [cycle]
    ALLOCATIONTYPE,                -- Allocation Context [fco_allocation_context]
    LEDGER,                        -- Ledger [fis_rldnr]
    ALLOCATIONCYCLESTARTDATE,      -- Valid From [fco_alloc_valid_from]
    ALLOCATIONCYCLEENDDATE,        -- Valid To [fco_alloc_valid_to]
    ALLOCATIONCYCLENAMETEXT,       -- Cycle Description [fco_alloc_cycle_name]
    COMPANYCODE,                   -- Company Code [fis_bukrs]
    CONTROLLINGAREA,               -- Controlling Area [fis_kokrs]
    ALLOCATIONPOSTINGTYPE,         -- Allocation Type [fco_alloc_posting_type]
    ALLOCATIONACTUALPLANVARIANT,   -- Actual/Plan [fco_alloc_ipknz]
    ALLOCATIONCYCLECATEGORY,       -- Plan Category [fcom_category]
    ALLOCATIONCYCLEISITERATIVE,    -- Iteration [fco_alloc_iterative_excel_nox]
    CYCLEISPARALLELLEDGERENABLED,  -- Flex. Ledger [fco_allo_par_ledger_excel_nox]
    ALLOCATIONISCUMULATIVE,        -- Cumulative [fco_alloc_cumulative_excel_nox]
    MSL,                           -- Quantities [fco_alloc_quantites_excel_nox]
    TSL,                           -- Trans. Currency [fco_trans_curr_excel_nox]
    CRUSER,                        -- Created By [fco_alloc_created_by]
    TIMESTAMP,                     -- Time Stamp [timestamp]
    ALLOCATIONCYCLERUNGROUP,       -- Cycle Run Group [kalc_procg]
    ALLOCATIONCYCLENAME,           -- Allocation Cycle [fco_alloc_cycle]
    PRIMARY KEY (MANDT, UPLOAD_GUID, ROW_GUID)
);

Learn More