Real usefull Date or Time CDS as a Calendar- or Time- dimensions: I_CalendarDate
in S4, the very most tables, transactional documents or CDS are modelled with a date format, for example VBAK with the ERDAT
or I_SalesAnalyticsCube with a CalendarDate:
I need of haveing an KPI aggreagted over Year, Month, Week,…
neither you extend the CDS or You wrap it with a derivation of the Date Column one by one for the
desired date format and with the derivation and the group by of a calculated characteristics
more pitfalls are waiting for You with the CDS.
This is quite cumbersome, test intensive and never complete or flexible at all.
The solution would be to associate Your date in Your CDS ( with a CDS Extenesion) with a time dimension which has got most of the various Time types:
CDS I_CalendarDates is well suited for this:
…and You get all the date formats on one shot.
You find I_CalendarDate and much more usefull I_ <Time> CDS in Package ABA/ABA_TECH/VDM_CAL:
Also in some other Packages are spread some I_DATE* or I_TIME* CDS.