RSXAFILES SAP table for – xsA File overview

Here we would like to draw your attention to RSXAFILES table in SAP. As we know it is being mainly used with the SAP BW-BCT (Business Content and Extractors in BW) component which is coming under BW module (Business Warehouse). RSXAFILES is a SAP standard transp table used for storing xsA File overview related data in SAP. It comes under the package RS_BCT_XA_ABAP.

SAP RSXAFILES table

Table RSXAFILES technical data

TableRSXAFILES
Data storingxsA File overview
ModuleBW
Sub ModuleBW-BCT-EPM
SAP PackageRS_BCT_XA_ABAP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentBI_CONT
Table CategoryTRANSP

SAP RSXAFILES Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in RSXAFILES table.

  • XASYSTEM_ID : System Landscape ID
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • CYCLE_ID : Cycle ID
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • ALIASCOUNT : Counter for Alias
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • SUBFILE_COUNT : xA Counter for Subfiles
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • FILETYPE : File Type
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • FILENAME : xA Filename
    Its data type is CHAR (Character String) with field length 200
  • FILENAME_CONV : xA Filename of converted file
    Its data type is CHAR (Character String) with field length 255
  • FILENAME_ORIG : xA Filename
    Its data type is CHAR (Character String) with field length 200
  • FILEID : File ID
    Its data type is CHAR (Character String) with field length 210
  • DATE_FORMAT : xA Date Format
    Its data type is CHAR (Character String) with field length 1
  • DECIMAL_MARKER : Decimal Marker
    Its data type is CHAR (Character String) with field length 1
  • OWNER : Owner (Person Responsible)
    Its data type is CHAR (Character String) with field length 12
  • TIMESTMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LOAD_DATE : System Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LOAD_TIME : System Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PC_LOGID : Log-ID of a Process Chain Run
    Its data type is CHAR (Character String) with field length 25
  • ACTIVE : Boolean
    Its data type is CHAR (Character String) with field length 1
  • FINISHED : Boolean
    Its data type is CHAR (Character String) with field length 1
  • UPLOADID : Upload ID
    Its data type is CHAR (Character String) with field length 60
  • XASYSTEM : Logical XA System
    Its data type is CHAR (Character String) with field length 10
  • DATASOURCE : DataSource (OSOA/OSOD)
    Its data type is CHAR (Character String) with field length 30
  • CHAIN_ID : Process Chain
    Its data type is CHAR (Character String) with field length 25
  • LOGSYS : Source system
    Its data type is CHAR (Character String) with field length 10
  • LANGU_ID : Language key
    Its data type is CHAR (Character String) with field length 2
  • DELIMITER : Delimiter for a CSV-File
    Its data type is CHAR (Character String) with field length 1
  • TEMPLATEID : File Template ID
    Its data type is CHAR (Character String) with field length 40
  • LOAD_VARIANT : Load Variant
    Its data type is CHAR (Character String) with field length 4
  • UPLOAD_DESCR : Description of Uploads
    Its data type is CHAR (Character String) with field length 60
  • JOBNAME : Background job name
    Its data type is CHAR (Character String) with field length 32
  • JOBCOUNT : Job ID
    Its data type is CHAR (Character String) with field length 8
  • IS_SCHEDULED : Upload has been scheduled
    Its data type is CHAR (Character String) with field length 1
  • FI_DOC_TYPE : Document Type for Invoices
    Its data type is CHAR (Character String) with field length 3