Real usefull Date or Time CDS as a Calendar- or Time- dimensions: I_CalendarDate

[Martin_4]

Hi,

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:

I_DateFormatVH

I_Datefunction

I_Datefunctiontext

I_DateFunctionValue

I_Dates_F2200

I_CalendarDay

I_CalendarDayText

I_CalendarMonth

I_CalendarMonthName

I_CalendarMonthText

I_CalendarQuarter

I_CalendarQuarterText

I_CalendarYear

...

 

Also in some other Packages are spread some I_DATE* or I_TIME* CDS.

Best Martin