to display latest value of 0calday

[former_member188325]

Hi all,

i have got requirement like this....i have plant,material,movement type and 0calday as chars.for a particular movemnt type,plant and material received dates(0calday) are more than one...i want to diaplay latest received date of material in the query.is it possible?pl treat it as urgent.

regards,

murali.

[Former Member · Accepted solution]

Hi Murali,

You can load data into ODS (with overwrite option for KFs) and then delta to cube. The last data will overwrite existing ones and you'll get the picture for last calday.

Best regards,

Eugene

Message was edited by: Eugene Khusainov

[former_member188325 · Accepted solution]

Hi Eugene,

Going for ODS is one otion but,client needs sometimes all received dates also....

any other ideas?

regards,

murali.

[Former Member · Accepted solution]

How about another ODS with 'Addition' option? Too resource consuming?

Best regards,

Eugene

[former_member188325 · Accepted solution]

Hi Eugene,

Then is it not same as Infocube?

regards

murali.

[Former Member · Accepted solution]

No, infocube updated from an ODS with overwrite option will keep only last data.

Best regards,

Eugene

[former_member188325 · Accepted solution]

Yes Eugene,

but they are interested in viewing old records also in other queries.

regards,

murali.

[Former Member · Accepted solution]

For old records you can use the 2nd ODS with all records (assuming that 0CALDAY) is an ODS key field.

Best regards,

Eugene

[Former Member · Accepted solution]

Another possibility - to include into cube another KF with exception aggregation 'Last Value' on 0CALDAY. In this case, having two KFs with different kind of summation you'll be able to produce both types of reports.

Best regards,

Eugene

[former_member188325 · Accepted solution]

yes Eugene this is ok...Will propose this option.

Thanks Eugene and mahantesh.

regards,

murali.

Message was edited by: Murali

[Former Member · Accepted solution]

Murali,

Take date field in the selection screen but not ready for input. fill up with current date (customer exit)and write abap code to populate latest date and other details.

mahantesh

[Former Member]

<u><i>plant and material received dates(0calday) are more than one</i></u>

take select option for date in selection screen..in this case whetever date if you enter in selection then based on that display the recent receieved materials.

am i right? if yes i will clear the points in next reply

bye

mahantesh\

[former_member188325]

Hi Mahantesh,

Query Should display only one i.e. latest record....

regards,

murali.

[former_member188325]

Hi,

is it not possible with a customer exit variable on 0calday?

murali.

Message was edited by: Murali

[Former Member]

IS THIS BASED ON THE INPUT DATES? IT IS POSSIBLE...

[former_member188325]

No mahantesh,

i do not have any variables in the query.i understand that input dates means variable on 0calday.am i rght?

Is there any way to restrict 0calday such that it should display only latest date?

regards,

murali.

Message was edited by: Murali

[Former Member]

Murali, If youn take 0calday as a input selection in report. Based on the input date you will get the records.

what are the input selection in your report/query.

mahantesh

[former_member188325]

Mahantesh,

i do not have any selection on 0calday.eventhough i have selection on it,if i do not know whats the latest date material received,then query displays dates based on selection.but i want to see only latest date of material received in the Query.

regards,

murali.