RSR_TIME_REL SAP table for – Time Relations for Planning

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

SAP RSR_TIME_REL table

Table RSR_TIME_REL technical data

TableRSR_TIME_REL
Data storingTime Relations for Planning
ModuleBW
Sub ModuleBW-WHM-DBA
SAP PackageRSR_CORE
Delivery ClassL – Table for storing temporary data
ComponentSAP_BW
Table CategoryTRANSP

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

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • CALDAY
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CALWEEK : Calendar year / week
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • CALMONTH : Conversion Exit: Date in the Format MM.YYYY
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • CALQUARTER : Calendar year/quarter
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • CALYEAR : Calendar year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • WEEKDAY1 : Weekday
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CALMONTH2 : Calendar month
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • CALQUART1 : Quarter
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • HALFYEAR1 : Halfyear
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CALDAY_SID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CALWEEK_SID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CALMONTH_SID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CALQUARTER_SID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CALYEAR_SID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • WEEKDAY1_SID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CALMONTH2_SID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CALQUART1_SID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • HALFYEAR1_SID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10