1. SAP Tutorial
  2. Business Warehouse

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

    • RSR_TIME_REL related tables

    • RSR_PE_LOOKUP : Test Table for TREX_EXT_PE_LOOKUP
    • RSR_REL_TIME_FIS : Time Relations for Planning
    • RSR_TIME_REL : Time Relations for Planning
    • RSR_REL_TIME : Time Relations for Planning
    • RRBANRIV : Client-independent number range intervals
    • RSR_PE_LOG_CS : Log for Planning Engine (Extract of Call Stack)
    • RSR_PE_COPY : Test Table for TREX_EXT_PE_COPY
    • RSR_PE_LOG : Log for Planning Engine
    • RSR_REL_STATUS : Status of Generation of Time Relations
    • RSR_TIME_STATUS : Status of Generation of Time Relations
    • RSR_TIME_REL_FIS : Time Relations for Planning

    Related References

    Related Tutorials

    RSR_REL_TIME SAP table for – Time Relations for Planning

    RSR_REL_TIME table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Time Relations...

    RSR_REL_TIME_FIS SAP table for – Time Relations for Planning

    RSR_REL_TIME_FIS table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Time Relations...

    RSR_TIME_REL_FIS SAP table for – Time Relations for Planning

    RSR_TIME_REL_FIS table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Time Relations...

    RSR_PE_LOG SAP table for – Log for Planning Engine

    RSR_PE_LOG table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Log for...

    RSR_PE_LOG_CS SAP table for – Log for Planning Engine (Extract of Call Stack)

    RSR_PE_LOG_CS table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Log for...

    RSREQARCHMON SAP table for – Totals Record of Monitor Tables after Archiving

    RSREQARCHMON table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Totals Record...

    UPC_STATISTIC3 SAP table for – Statistic for Executing Planning Functions

    UPC_STATISTIC3 table in SAP BW (Planning in BW) module. This table is used for storing data of Statistic for Executing...

    «
    »