RSTSODSFIELD SAP table for – Fields for the Operational Data Store

Here we would like to draw your attention to RSTSODSFIELD table in SAP. As we know it is being mainly used with the SAP BW-WHM (Warehouse Management in BW) component which is coming under BW module (Business Warehouse). RSTSODSFIELD is a SAP standard transp table used for storing Fields for the Operational Data Store related data in SAP. It comes under the package RSAR.

SAP RSTSODSFIELD table

Table RSTSODSFIELD technical data

TableRSTSODSFIELD
Data storingFields for the Operational Data Store
ModuleBW
Sub ModuleBW-WHM-DST
SAP PackageRSAR
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP RSTSODSFIELD 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 RSTSODSFIELD table.

  • ODSNAME : Name of the Persistant Staging Area
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • VERSION : Version
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • POSIT : Position of the Field in the Structure / Table
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • IOBJNM : InfoObject
    Its data type is CHAR (Character String) with field length 30
  • KEYFLAG : Identifies a key field of a table
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Include: Field name with DDIC attributes and unit fields
  • FIELDNM : Field name
    Its data type is CHAR (Character String) with field length 30
  • DTELNM : Data Element
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Include: DDIC attributes
  • DATATYPE : Data type
    Its data type is CHAR (Character String) with field length 4
  • INTLEN : Internal Length in Bytes
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • LENG : Length (No. of Characters)
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • INTTYPE : ABAP data type (C,D,N,…)
    Its data type is CHAR (Character String) with field length 1
  • CONVEXIT : Conversion Routine
    Its data type is CHAR (Character String) with field length 5
  • DECIMALS : Number of Decimal Places
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • UNIFIELDNM : Name of the relevant unit field
    Its data type is CHAR (Character String) with field length 30
  • REFTABLE : Table for reference field
    Its data type is CHAR (Character String) with field length 30
  • LOWERCASE : Lowercase letters allowed/not allowed
    Its data type is CHAR (Character String) with field length 1