Number of days (current date-goods receipt date)

[former_member188325]

Hi All,

I have a requirement like this :

need to display no of days in Query which is CKF=current date-GR date. GR date is coming from r/3.We do not have current date field. and moreover no of days is in the selection screen.So we should have no of days calculated already in the cube.am i rght? calculation shold be done before data comes into the cube i.e in transfer rules or update rules...thats what i thought.Am i rght? can anybody come up with some code to calculte no of days in transfer rules or update rules?

pl correct me if i am wrong.

regards

Message was edited by: cmd

[ccc_ccc]

Question is not clear, can u explain clear,

U want find out the no of days between 2 dates in update rules and store this days in anohter kf.

i am not following u r question

Message was edited by: ANR

[former_member188325]

Yes ANR.U r correct.But calculation would be either in update or transfer rules which ever is better.

regards

Message was edited by: cmd

[former_member188325]

What i guess is i am gng to have 'no of days' filed included in the cube and it would be difference of current date and GR date.GR date is of type keyfigure in the cube.

regards

[ccc_ccc]

When your write code in transfer rules it will be global.

if u write code in update rules it will local to on data target.

Transfer rules----

---

InfoSource

Update reules----

---

data target.

here infosource is re-usable to other datatargets, so it will effect to all.

but update rules is only one data target.

i think u clar about this.

pls assgain poinst, if u satify.

by

ANR

[former_member188325]

Hi ANR,

Do u have any ABAP code for the same?

regards

[ccc_ccc]

Use this function module.

to find out no of days between two dates

DAYS_BETWEEN_TWO_DATES for syntax and all c help.

Message was edited by: ANR