ALLORECEIVERXLSX

Transparent Table Application Table
20 Fields 2 CDS Views

Allocation Receiver data from Excel upload

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocationReceiverUpload view from BASIC Receiver data from Alloc. Excel Upload
I_UnivAllocationReceiverUpload view_entity from BASIC Receiver data from Alloc Excel Upload

Fields (20)

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
allocationcyclesegment SQNR Segment number
allocationfieldname FDNAM Field
allocationfieldtext LTEXT Long Text
allocationfieldminimumvalue SETVALMIN From Value
allocationfieldmaximumvalue SETVALMAX To Value
allocationsetid FCO_ALLOC_GROUP_ID Group ID
allocationfieldgroup FCO_ALLOC_VAR_PORTION_TYPE Var. Portion Type
allocscngtvtracingfctr NEGTEST Scale Neg. Factors
planningcategory FCOM_CATEGORY Plan Category
unitofmeasure MEINS Base Unit
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.

-- Allocation Receiver data from Excel upload
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ALLORECEIVERXLSX (
    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]
    ALLOCATIONCYCLESEGMENT,       -- Segment number [SQNR]
    ALLOCATIONFIELDNAME,          -- Field [FDNAM]
    ALLOCATIONFIELDTEXT,          -- Long Text [LTEXT]
    ALLOCATIONFIELDMINIMUMVALUE,  -- From Value [SETVALMIN]
    ALLOCATIONFIELDMAXIMUMVALUE,  -- To Value [SETVALMAX]
    ALLOCATIONSETID,              -- Group ID [FCO_ALLOC_GROUP_ID]
    ALLOCATIONFIELDGROUP,         -- Var. Portion Type [FCO_ALLOC_VAR_PORTION_TYPE]
    ALLOCSCNGTVTRACINGFCTR,       -- Scale Neg. Factors [NEGTEST]
    PLANNINGCATEGORY,             -- Plan Category [FCOM_CATEGORY]
    UNITOFMEASURE,                -- Base Unit [MEINS]
    CRUSER,                       -- Created By [FCO_ALLOC_CREATED_BY]
    TIMESTAMP,                    -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (MANDT, UPLOAD_GUID, ROW_GUID)
);

Learn More