Skip to end of metadata
Go to start of metadata

Overview

As discussed in Time and Technical Characteristics, a master data read class is assigned to such a special InfoObject which handles the master data retrieval. The values for display attributes are derived(by this class) from the week of the data record. It is not allowed to display attributes to navigation attributes.

The responsible class of 0CALWEEK is CL_RSMD_RS_0CALWEEK(see note 1387166). 

As explained in notes 2194279 and 2074801, it is important to use the current content version of this characteristic. It is not recommended to change the delivered version of the object, however, it is possible to create your own hierarchies. It is not allowed to set the display attributes as navigation attributes.

Transaction RSRHIERARCHYVIRT

Transaction RSRHIERARCHYVIRT can be used to define a time interval which is the basis for the F4 help of time characteristics. In case of inconsistencies, this transaction also offers an option to refill the corresponding master data tables(more precisely, the SID, P, and X tables) for the characteristics 0DATE, 0CALMONTH, 0QUARTER and 0FISCPER(since the new content versions of these objects contain navigation attributes). So, the button 'Execute Recreate' has no effect for the time characteristic 0CALWEEK.

2608688 New Rebuild Option for Time Characteristics Master Data

Hierarchies

For time characteristics so called Virtual Time Hierarchies can be used in order to get a hierarchical display of the periods in query results. See Virtual Time Hierarchies for further details. However, there are no virtual hierarchies for 0CALWEEK.

Texts

0CALWEEK isn't delivered with Texts. See also 4 below.

Transaction RSRV

There is a check called "Consistency of SID and X table for relevant Time Characteristics" in RSRV you can use to check whether the records in the SID, P and X tables are consistent. But for 0CALWEEK will be considered as invalid parameter.

F4 HELP

The mode (F4 Modes) being passed to the value help processor dictates where (which database table) the data is to be fetched from. For more information on F4 Help behaviour in BW75 and BW/4 systems can be found under "Examples" section.

BW75 Content Version

0CALWEEK contain only attributes(display), it does not have any navigational attributes.

 

Since there are only display attributes, the P and X tables are not needed. Hence the P table only contains the initial value(and the X table does not exist at all):

SID Table

As the system is new, all the master data tables(/BI0/SCALMONTH, /BI0/PCALMONTH) of 0CALWEEK are empty

BW/4Hana Content Version

The content version in BW/4Hana is the same as in BW75.

 

Examples

BW75 Example: Tables

We check the impact of the definition of the time interval in transaction RSRHIERARCHYVIRT. When the system is new, all the master data tables(/BI0/SDATE, /BI0/PDATE, ) of 0CALWEEK are empty. As 0CALWEEK does not contain any navigational attributes, there won't be any X table generated for this type. We start with the interval 01.01.2019 to 31.12.2019 and save it:

P and SID Table

Since there are only display attributes, the P and X tables are not needed. Hence the P table only contains the initial value(and the X table does not exist at all):

In case e.g. a new data record is loaded where 0CALWEEK is equal to 07.2019(into a provider), the corresponding records will get a X for the flag DATAFL. 

BW/4Hana Example: Tables

We check the impact of the definition of the time interval in transaction RSRHIERARCHYVIRT. When the system is new, all the master data tables(/BI0/SDATE, /BI0/PDATE, /BI0/XDATE) of 0CALDAY are empty. We start with the interval 01.01.2009 to 31.12.2019 and save it. Then press 'Execute Recreate'

SID Table

This table is filled with values from 01.01.2009 up to 31.12.2019 in contrast to BW75 system:

BW75 Example: Texts for 0CALWEEK

0CALWEEK is not delivered with texts. Therefore, during query runtime, IF_RSMD_RS_ACCESS~GET_TEXT method of class CL_RSMD_RS_0CALWEEK will not retrieve any texts. The table /BI0/TCALWEEK does not exist.

BW75 Example: F4 Help for 0CALWEEK

In this section the F4 behaviour of 0CALWEEK will be discussed. If you remember from the previous step, we just loaded one data record to 0CALWEEK, which was 07.2019. 
Keeping this information in mind, let's execute a query where 0CALWEEK is used in variable selection. If the query is executed where 0CALWEEK is selected as 'D-Mode' (F4 Modes), below value(s) is returned:

 If the query is executed where 0CALWEEK is selected as 'M-Mode' (F4 Modes), below value(s) is returned:

The date range created via RSRHIERARCHYVIRT will be shown in M-Mode. If you ask how the F4 help reads the master data? The answer of the question is hidden in _VALUE_GENERATE method of a CL_RSMD_RS_0CALWEEK. Here the class cl_rsr_hierarchy_virt will be called and the values will be filled accordingly.

Related Documents

Related SAP Notes/KBAs

  • 1387166 - Master Data Read Class
  • 1565809 - Settings for BW query F4 help

 

  • No labels