ALLOSEGMENTXLSX

Transparent Table Application Table
32 Fields 2 CDS Views

Allocation Segment data from Excel upload

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocationSegmentUpload view from BASIC Segment data from Alloc. Excel Upload
I_UnivAllocationSegmentUpload view_entity from BASIC Segment data from Alloc Excel Upload

Fields (32)

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
segmentname fco_segment_name Segment Name
segmentnamedescription fco_alloc_segment_decs Segment Description
assessmentcostelement fco_alloc_asacc Overhead Allocation Account
allocationstructure brgabsch Alloc.Structure
allocationcurrency facur Currency
allocationsenderrule srule Sender Rule
allocsegmentshareinpercent sndpercent Share in %
manipulationruleforcyclicmaint fco_alloc_manipulation_rule Manipulation Rule
allocationreceiverrule rrule Receiver Rule
allocationfieldgroup fco_alloc_var_portion_type Var. Portion Type
allocscngtvtracingfctr negtest Scale Neg. Factors
planningcategory fcom_category Plan Category
unitofmeasure fco_unit_of_measure Base Unit
stagr stagr Stat. key fig.
allocstatisticalkeyfiguregroup fco_alloc_stagr_group Stat. key fig. Group
racct alloc_racct_from GL Account From
receivergeneralledgeraccountto alloc_racct_to GL Account To
receiverglaccountgroup alloc_racct_group GL Account Group
rtcur rtcur Currency
cruser fco_alloc_created_by Created By
timestamp timestamp Time Stamp
allocationsegmentislocked seqblk Lock indicator
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 Segment data from Excel upload
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ALLOSEGMENTXLSX (
    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]
    SEGMENTNAME,                     -- Segment Name [fco_segment_name]
    SEGMENTNAMEDESCRIPTION,          -- Segment Description [fco_alloc_segment_decs]
    ASSESSMENTCOSTELEMENT,           -- Overhead Allocation Account [fco_alloc_asacc]
    ALLOCATIONSTRUCTURE,             -- Alloc.Structure [brgabsch]
    ALLOCATIONCURRENCY,              -- Currency [facur]
    ALLOCATIONSENDERRULE,            -- Sender Rule [srule]
    ALLOCSEGMENTSHAREINPERCENT,      -- Share in % [sndpercent]
    MANIPULATIONRULEFORCYCLICMAINT,  -- Manipulation Rule [fco_alloc_manipulation_rule]
    ALLOCATIONRECEIVERRULE,          -- Receiver Rule [rrule]
    ALLOCATIONFIELDGROUP,            -- Var. Portion Type [fco_alloc_var_portion_type]
    ALLOCSCNGTVTRACINGFCTR,          -- Scale Neg. Factors [negtest]
    PLANNINGCATEGORY,                -- Plan Category [fcom_category]
    UNITOFMEASURE,                   -- Base Unit [fco_unit_of_measure]
    STAGR,                           -- Stat. key fig. [stagr]
    ALLOCSTATISTICALKEYFIGUREGROUP,  -- Stat. key fig. Group [fco_alloc_stagr_group]
    RACCT,                           -- GL Account From [alloc_racct_from]
    RECEIVERGENERALLEDGERACCOUNTTO,  -- GL Account To [alloc_racct_to]
    RECEIVERGLACCOUNTGROUP,          -- GL Account Group [alloc_racct_group]
    RTCUR,                           -- Currency [rtcur]
    CRUSER,                          -- Created By [fco_alloc_created_by]
    TIMESTAMP,                       -- Time Stamp [timestamp]
    ALLOCATIONSEGMENTISLOCKED,       -- Lock indicator [seqblk]
    ALLOCATIONCYCLENAME,             -- Allocation Cycle [fco_alloc_cycle]
    PRIMARY KEY (MANDT, UPLOAD_GUID, ROW_GUID)
);

Learn More