how to pick last resuest from dso to cube

[venkatesh_veera2]

Dear Gurus,

I had 10 requests in DSO but I have to pick only the last request from DSO to cube not all.

Is there any chance to do it??

Please help me out on this doubt..

Thank you all in advance.

Kind Regards,

Venkatesh

[Former Member]

You can pick the last request, but why do you want to do that?

You can use the standard method p_r_request->GET_UPDMODE  in the start routine to get the request details, based on that you can filter the request you want to load.

regards,

Anupama

[venkatesh_veera2]

can you please explain me in detail

[former_member241863]

Hello

Write a Code in Start Routine of Transformation between DSO_01 -> DSO_02.

Read the Latest Request from Table RSMONICDP.

Enter the DSO Name in the Filter and sort the data (descending) to get the latest request.Active Request is where QM status is Green.

You can use this to restrict the Source Package data.

Thanks

Pratyaksh Jeet

[former_member241863]

Hello Venkatesh Veera,

I think your flow is DSO_01 -> DSO_02. Right.

Well if you have Multiple Delta Request in DSO_01 and these request are not loaded in DSO_02. Then Use Delta DTP to load Data from DSO_01 to DSO_02.

If you still want to read only last request from DSO_01, Then you can do below solution.

1) Delete the latest request from DSO.

2) Now Run the DTP (Delta Init Without Data). It will set the Delta Pointer in DSO_01.

3) Load the Delta request in DSO_01 and Same in DSO_02. It will load the latest request in DSO_02.

Hope this will help you.

but this is not the good design.

Please reward if helpfull

Thanks

Pratyaksh Jeet

[former_member186445]

what kind of loads do you have in your dso? full or delta?

M.

[venkatesh_veera2]

delta

Venkatesh

[former_member186445]

then it makes no sense to get only the last request. if all other requests are already in the upper target just run the delta dtp to load the last delta from the dso. if no request is yet in the upper target, you need to load them all... this can be done with the delta dtp as well.

what is the reason why you would like to load only the last request in the upper target?

M.

[venkatesh_veera2]

so you mean to say we can't pick a single record alone??

[former_member186445]

of course you can... you can add a filter in the dtp in order to select specific lines from the source.

if you really want to load the last request from dso (and you still have it in the psa):

delete the last request from dso.

run dtp with option 'no data transfer, mark all request fetched'.

load request from source to dso

run dtp from dso to cube.

this will transfer only the last request from the dso to the cube.

M.

[Anand71]

Hi,

What is your SAP Version?

Regards,

Anand

[venkatesh_veera2]

7.0