how to calculate week number from system date

[Former Member]

Hi experts,

how to calculate week number from system date ?

thanks.

SK

[former_member188080]

Hi,

Check following thread as well

Thanks and regards

Kiran

[Former Member]

hi,

Use FM DATE_GET_WEEK. Pass on the system date as input and the value of the week will be returned by this FM

regards,

Arvind.

[Former Member]

hi,

thanx for your quick reply...couldn't i use formula in transformation rule ? if not, as you stated that FM how can i write the rutin?

thnx in advance..

[Former Member]

hi,

The above FM can be used for BADI or customer exit, if it is design level then you can use formula as well, under formula date functions you can use DATE_TO_WEEK.

regards,

Arvind.

[Former Member]

hi,

i will load from ODS to ICube..i added 0calweek io to IC..so what exactly will i write in formula ?

is DATE_TO_WEEK( SYST-DATUM ) enough without mapping any IO ?

[Former Member]

hi,

yes that's correct. This will populate the records with the loading week.

regards,

Arvind.