How to create hierarchy for 0calyear(Calendar year)

[former_member210724]

Hi,

How to create hierarchy for CALENDER YEAR? Hierarchy should automatically update when year changes. Do we have any way to do this,without loading from flat file

Below is the sample image of my requirement .

I tried Virtual Time Hierarchies in RSRHIERARCHYVIRT tcode using below link, but no clear idea of it.

Gone thru these links,

https://help.sap.com/saphelp_nw04/helpdata/en/1f/83813ec8d3fe3ee10000000a114084/content.htm

Anand Tiragati

[anshu_lilhori]

Hi,

You can achieve the same with the Tcode you mentioned in your question itself.

I believe you need hierarchy based on calyear further divided into calquarter.

For that you need to activate 0QUA_MON hierarchy in that Tcode and at bex level--Drag and drop calyear in Rows--Select it--On the right hand side pane--Hit the hierarchy tab--Select the above hierarchy.

Check the output.Hopefully this should work.

Regards,

AL

[former_member210724]

Hi,

Thank you for swift reply.

As u said, I tried with 0YEA_QUA_MON instead of 0QUA_MON. It seems my requirement is fulfilled but not yet implemented.I will update you once it is done.