topic Re: Custom Week - ABAP in Application Development and Automation Discussions

Custom Week - ABAP

f_allocca — Thu, 13 Oct 2022 11:17:14 GMT

Hi Experts,

Previously I asked for a way to derive Year and Week number respecting the following specifications:

The first week of the year is the one that starts on Sunday
The first day of the week is Sunday

Here is an example screen:

I was advised to use the following method and it works: (Number of week in 'v_week' variable)

Now I need a way to calculate the data (YYYYMMDD) starting from Year and Week (YYYYWW) respecting the same specifications above

Thanks

Francesco

Re: Custom Week - ABAP

Sandra_Rossi — Thu, 13 Oct 2022 12:15:02 GMT

If you know which day of the week is January 1st, as a number between 1 and 7 (not sure in your case which number is Sunday), then you can determine how many days are to be added to reach Sunday. Can't you? Is there any problem.

Re: Custom Week - ABAP

f_allocca — Thu, 13 Oct 2022 12:39:45 GMT

from 2021.02 (YYYY.WW) Wednesday I need to calculate what date corresponds, for example 13.01.2021 (DD.MM.YYYY)

How can I do it?

Re: Custom Week - ABAP

FredericGirod — Thu, 13 Oct 2022 14:04:26 GMT

number of week * 7

I win the price ??

Re: Custom Week - ABAP

swapan_sarkar1 — Thu, 13 Oct 2022 14:12:04 GMT

You may just want to create a custom table with Year, Week & date of first & last date of the week for next 100 years (you may write a script for that). There will be about 5200 - 5300 records in it. This will help with performance if you are using CDS views and want to use it in a JOIN.

Re: Custom Week - ABAP

Sandra_Rossi — Thu, 13 Oct 2022 16:59:29 GMT

So you know that first week in the year (2021.01) starts on 06.01.2021.

Week 2021.02 starts on 13.01.2021.

Week 2021.03 starts on 20.01.2021.

I think that frdric.girod won the price!