ALLODERRULESXLSX

Transparent Table Application Table
14 Fields 2 CDS Views

Derivation Rules for Manage Allocation Excel Upload

ALLODERRULESXLSX is an SAP database table in S/4HANA. Derivation Rules for Manage Allocation Excel Upload. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocFieldDerivationUpload view from BASIC Allocation Field Derivation for Excel
I_UnivAllocFldDerivationUpload view_entity from BASIC Allocation Field Derivation for Excel

Fields (14)

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
allocationsettype SETKIND Type of Set
allocationfieldname FDNAM Field
allocationfieldlabel LTEXT Long Text
allocationfieldisderived DERIVE Derive Value
cruser FCO_ALLOC_CREATED_BY Created By
timestamp TIMESTAMP Time Stamp

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.

-- Derivation Rules for Manage Allocation Excel Upload
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ALLODERRULESXLSX (
    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]
    ALLOCATIONSETTYPE,         -- Type of Set [SETKIND]
    ALLOCATIONFIELDNAME,       -- Field [FDNAM]
    ALLOCATIONFIELDLABEL,      -- Long Text [LTEXT]
    ALLOCATIONFIELDISDERIVED,  -- Derive Value [DERIVE]
    CRUSER,                    -- Created By [FCO_ALLOC_CREATED_BY]
    TIMESTAMP,                 -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (MANDT, UPLOAD_GUID, ROW_GUID)
);

Learn More