RSTRAN SAP table for – Transformation

Here we would like to draw your attention to RSTRAN 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). RSTRAN is a SAP standard transp table used for storing Transformation related data in SAP. It comes under the package RSAU_RSAA.

SAP RSTRAN table

Table RSTRAN technical data

TableRSTRAN
Data storingTransformation
ModuleBW
Sub ModuleBW-WHM-DST
SAP PackageRSAU_RSAA
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_BW
Table CategoryTRANSP

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

  • TRANID : Transformation ID
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • OBJVERS : Object version
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Properties TLOGO object (available in A and M versions)
  • .INCLUDE : Properties TLOGO object (only available in A version)
  • OBJSTAT : Object Status
    Its data type is CHAR (Character String) with field length 3
  • CONTREL : Content release
    Its data type is CHAR (Character String) with field length 6
  • CONTTIMESTMP : Content time stamp: Last modification to the object by SAP
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • OWNER : Owner (Person Responsible)
    Its data type is CHAR (Character String) with field length 12
  • BWAPPL : BW Application (Namespace)
    Its data type is CHAR (Character String) with field length 10
  • ACTIVFL : Active and revised version do not agree
    Its data type is CHAR (Character String) with field length 1
  • .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
  • SOURCETYPE : BW: Object Type (TLOGO)
    Its data type is CHAR (Character String) with field length 4
  • SOURCESUBTYPE : BW Metadata Repository: Subtype of TLOGO Type
    Its data type is CHAR (Character String) with field length 4
  • SOURCENAME : Object Name in Object Directory
    Its data type is CHAR (Character String) with field length 40
  • TARGETTYPE : BW: Object Type (TLOGO)
    Its data type is CHAR (Character String) with field length 4
  • TARGETSUBTYPE : BW Metadata Repository: Subtype of TLOGO Type
    Its data type is CHAR (Character String) with field length 4
  • TARGETNAME : Object Name in Object Directory
    Its data type is CHAR (Character String) with field length 40
  • STARTROUTINE : BW Generation tool: GUID in compressed form (CHAR25)
    Its data type is CHAR (Character String) with field length 25
  • ENDROUTINE : BW Generation tool: GUID in compressed form (CHAR25)
    Its data type is CHAR (Character String) with field length 25
  • EXPERT : BW Generation tool: GUID in compressed form (CHAR25)
    Its data type is CHAR (Character String) with field length 25
  • GLBCODE : BW Generation tool: GUID in compressed form (CHAR25)
    Its data type is CHAR (Character String) with field length 25
  • TRANPROG : Program ID for Transformation (Generated)
    Its data type is CHAR (Character String) with field length 25
  • VERSION_CUR : 2 byte integer (signed)
  • TARGET_TAB_TYPE : Table Type
    Its data type is CHAR (Character String) with field length 1
  • IS_SHADOW : Boolean
    Its data type is CHAR (Character String) with field length 1
  • SHADOW_TRANID : Transformation ID
    Its data type is CHAR (Character String) with field length 32
  • GLBCODE2 : BW Generation tool: GUID in compressed form (CHAR25)
    Its data type is CHAR (Character String) with field length 25
  • .INCLUDE : Parent TLOGO Object (which current object belongs to)
  • TLOGO_OWNED_BY : BW: Object Type (TLOGO)
    Its data type is CHAR (Character String) with field length 4
  • OBJNM_OWNED_BY : Object Name in Object Directory
    Its data type is CHAR (Character String) with field length 40
  • CURRUNIT_ALLOWED : Boolean
    Its data type is CHAR (Character String) with field length 1
  • GROUPING : Boolean
    Its data type is CHAR (Character String) with field length 1
  • ALL_FIELDS : Set Update Behavior for Fields of End Routine
    Its data type is CHAR (Character String) with field length 1
  • ORGTRANID : Transformation ID
    Its data type is CHAR (Character String) with field length 32
  • TUNNEL : Boolean
    Its data type is CHAR (Character String) with field length 1
  • STRUCTURE_TYPE : Table Name
    Its data type is CHAR (Character String) with field length 1
  • DOUBLE_RECORDS : Boolean
    Its data type is CHAR (Character String) with field length 1
  • UNIT_CHECK : Boolean
    Its data type is CHAR (Character String) with field length 1
  • HAAP_HINT : Hint for HAAP in Transformation
    Its data type is CHAR (Character String) with field length 1