Getting the last posting date

[Former Member]

Hi everybody,

I need some help. I want to create a Bex Variable with Customer Exit, and i need to modify the ABAP code in order to get the last posting date of Data in my request. I'll like to create to create with BEx Query Designer a request that allows me to make my report on the most recent data only.

Eg. Let's say today before leaving the work I launch a routine that provides me during the night data for my R/3 system and I'm wonking in a BW environment. Tomorrow, i'll like to compose any request guiving me informations only on what i loaded yesterday without typing the date. I'm oblige to use a variable, but I need the corresponding Abap code. Can some one help me please ?

Thanks.

[Former Member · Accepted solution]

You want your query to return results from only the most recently loaded request. Is that right? You don't need a variable for that. Just bring in "Request ID" (from Data Package dimension) into Filter area and use "Last Request Loaded" variable delivered by SAP.

[Former Member · Accepted solution]

Thanks Sudhi ! IOt works Perfectly ! I didn't know about the "Last Request Loaded" variable. I've just tried it and it's marvelous. thanks again