RSTSODS SAP table for – Operational Data Store for the transfer structure

Here we would like to draw your attention to RSTSODS 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). RSTSODS is a SAP standard transp table used for storing Operational Data Store for the transfer structure related data in SAP. It comes under the package RSAR.

SAP RSTSODS table

Table RSTSODS technical data

TableRSTSODS
Data storingOperational Data Store for the transfer structure
ModuleBW
Sub ModuleBW-WHM-DST
SAP PackageRSAR
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP RSTSODS 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 RSTSODS 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
  • DATETO : Valid-to date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATEFROM : Valid-From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OBJSTAT : Object Status
    Its data type is CHAR (Character String) with field length 3
  • ODSNAME_TECH : Technical ODS name in the DB
    Its data type is CHAR (Character String) with field length 16
  • PROGNAME : ABAP Program Name
    Its data type is CHAR (Character String) with field length 40
  • MAINTPROG : Maintenance Program
    Its data type is CHAR (Character String) with field length 40
  • USERAPP : Name of the application using PSA Service
    Its data type is CHAR (Character String) with field length 10
  • USEROBJ : Object Name in Object Directory
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Include: Last changed by, time stamp in internal format
  • TSTPNM : Last changed by
    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
  • PARTNO : Partition number for PSA partitioning
    Its data type is NUMC (Character String with Digits Only) with field length 4