SAP ALLOSEGMENTXLSX Allocation Segment data from Excel upload Table
Overview
ALLOSEGMENTXLSX is a standard SAP S/4HANA table that stores Allocation Segment data from Excel upload data. There are total 24 fields in the ALLOSEGMENTXLSX table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ALLOSEGMENTXLSX belongs to Fiori FXU Cost Controlling CO-FIO (CA-GTF-FXU-FI-CO) module and is located in the package Excel artefacts for manage allocation app (MANAGE_ALLOCATION_EXCEL).
In addition, following links provide an overview of foreign key relationships, if any, that link ALLOSEGMENTXLSX to other SAP tables and standard CDS views available based on ALLOSEGMENTXLSX table in S/4HANA 2020.
Techincal Settings of ALLOSEGMENTXLSX
Below are technical details of the table ALLOSEGMENTXLSX
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ALLOSEGMENTXLSX Fields
The following table gives you an overview of the fields available in ALLOSEGMENTXLSX
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| UPLOAD_GUID | GUID for Excel upload | FCO_UPLOAD_GUID | RAW | 16 | |
| ROW_GUID | GUID for row in Excel Upload | FCO_ROW_GUID | RAW | 16 | |
| ROW_INDEX | Row index | FCO_ROW_INDEX | INT4 | 10 | |
| ALLOCATIONCYCLE | Allocation/cycle | CYCLE | CHAR | 10 | |
| ALLOCATIONTYPE | Allocation Context | FCO_ALLOCATION_CONTEXT | CHAR | 30 | |
| LEDGER | Ledger | FIS_RLDNR | CHAR | 2 | |
| ALLOCATIONCYCLESTARTDATE | Valid From | FCO_ALLOC_VALID_FROM | DATS | 8 | |
| ALLOCATIONCYCLESEGMENT | Segment number within a cycle | SQNR | NUMC | 4 | |
| SEGMENTNAME | Segment mame | FCO_SEGMENT_NAME | CHAR | 10 | |
| SEGMENTNAMEDESCRIPTION | Segment Description | FCO_ALLOC_SEGMENT_DECS | CHAR | 30 | |
| ASSESSMENTCOSTELEMENT | Overhead Allocation Account | FCO_ALLOC_ASACC | CHAR | 10 | |
| ALLOCATIONCURRENCY | Currency Key Allocations | FACUR | TCURC | CUKY | 5 |
| ALLOCATIONSENDERRULE | Assessment/Distribution Rule Sender | SRULE | CHAR | 1 | |
| ALLOCSEGMENTSHAREINPERCENT | Sender Percentage | SNDPERCENT | DEC | 5 | |
| ALLOCATIONRECEIVERRULE | Assessment/Distribution Rule Receiver | RRULE | CHAR | 1 | |
| ALLOCATIONFIELDGROUP | Variable Portion Type | FCO_ALLOC_VAR_PORTION_TYPE | CHAR | 30 | |
| ALLOCSCNGTVTRACINGFCTR | Indicator: Scale Negative Tracing Factors | NEGTEST | NUMC | 1 | |
| PLANNINGCATEGORY | Plan Category | FCOM_CATEGORY | CHAR | 10 | |
| STAGR | Statistical key figure | STAGR | CHAR | 6 | |
| RACCT | Account Number | RACCT | CHAR | 10 | |
| RTCUR | Currency Key | RTCUR | TCURC | CUKY | 5 |
| CRUSER | Created by | FCO_ALLOC_CREATED_BY | CHAR | 12 | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ALLOSEGMENTXLSX
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ALLOSEGMENTXLSX | ALLOCATIONCURRENCY | 1: CN | TCURC |
| ALLOSEGMENTXLSX | RTCUR | 1: CN | TCURC |