SAP ALLORECEIVERXLSX Allocation Receiver data from Excel upload Table

Overview

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

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

Techincal Settings of ALLORECEIVERXLSX

Below are technical details of the table ALLORECEIVERXLSX

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ALLORECEIVERXLSX Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
UPLOAD_GUIDGUID for Excel uploadFCO_UPLOAD_GUIDRAW16
ROW_GUIDGUID for row in Excel UploadFCO_ROW_GUIDRAW16
ROW_INDEXRow indexFCO_ROW_INDEXINT410
ALLOCATIONCYCLEAllocation/cycleCYCLECHAR10
ALLOCATIONTYPEAllocation ContextFCO_ALLOCATION_CONTEXTCHAR30
LEDGERLedgerFIS_RLDNRCHAR2
ALLOCATIONCYCLESTARTDATEValid FromFCO_ALLOC_VALID_FROMDATS8
ALLOCATIONCYCLESEGMENTSegment number within a cycleSQNRNUMC4
ALLOCATIONFIELDNAMEDB Field NameFDNAMCHAR30
ALLOCATIONFIELDTEXTLong TextLTEXTCHAR40
ALLOCATIONFIELDMINIMUMVALUEFrom ValueSETVALMINCHAR40
ALLOCATIONFIELDMAXIMUMVALUETo ValueSETVALMAXCHAR40
ALLOCATIONSETIDGroup IDFCO_ALLOC_GROUP_IDCHAR34
ALLOCATIONFIELDGROUPVariable Portion TypeFCO_ALLOC_VAR_PORTION_TYPECHAR30
ALLOCSCNGTVTRACINGFCTRIndicator: Scale Negative Tracing FactorsNEGTESTNUMC1
PLANNINGCATEGORYPlan CategoryFCOM_CATEGORYCHAR10
UNITOFMEASUREBase Unit of MeasureMEINSUNIT3
CRUSERCreated byFCO_ALLOC_CREATED_BYCHAR12
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC15

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 ALLORECEIVERXLSX

Other References