SAP ALLOCYCLEXLSX Allocation Cycle data from Excel upload Table

Overview

ALLOCYCLEXLSX is a standard SAP S/4HANA table that stores Allocation Cycle data from Excel upload data. There are total 18 fields in the ALLOCYCLEXLSX table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ALLOCYCLEXLSX 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 ALLOCYCLEXLSX to other SAP tables and standard CDS views available based on ALLOCYCLEXLSX table in S/4HANA 2020.

Techincal Settings of ALLOCYCLEXLSX

Below are technical details of the table ALLOCYCLEXLSX

Buffering not allowed
No buffering
Storage type is Column Store

List of ALLOCYCLEXLSX Fields

The following table gives you an overview of the fields available in ALLOCYCLEXLSX

Field	Description	Data Element	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
ALLOCATIONCYCLEENDDATE	Valid To	FCO_ALLOC_VALID_TO	DATS	8
ALLOCATIONCYCLENAMETEXT	Allocation Cycle Description	FCO_ALLOC_CYCLE_NAME	CHAR	30
COMPANYCODE	Company Code	FIS_BUKRS	CHAR	4
ALLOCATIONPOSTINGTYPE	Allocation Type	FCO_ALLOC_POSTING_TYPE	CHAR	1
ALLOCATIONACTUALPLANVARIANT	Actual/Planned Indicator	FCO_ALLOC_IPKNZ	CHAR	1
ALLOCATIONCYCLECATEGORY	Plan Category	FCOM_CATEGORY	CHAR	10
MSL	Quantities ('X')	FCO_ALLOC_QUANTITES	CHAR	1
TSL	Trans. Currency ( 'X' )	FCO_TRANS_CURR	CHAR	1
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 ALLOCYCLEXLSX

SAP ALLOCYCLEXLSX Allocation Cycle data from Excel upload Table

Overview

Techincal Settings of ALLOCYCLEXLSX

List of ALLOCYCLEXLSX Fields

Foreign Key Relationships

Other References