Thursday 1 July 2010

Infopackage dynamic selection routine

This will explain , how to give dynamic selection for periodic loading using infopackages.
After creating an infopackage go to "Data Selection" tab. Give Type - 6 Abap Routine for the required selection criteria. Here I am loading the data with selection "Previous Month" (0calmonth).

Give a description and click enter. It will move to the Scheduler routine screen.


Enter the code as below (highlighted).

*$*$ begin of routine - insert your code only below this line *-*
data: l_idx like sy-tabix.
read table l_t_range with key
fieldname = 'CALMONTH'.
l_idx = sy-tabix.
*....
l_t_range-low = sy-datum(6) - 1.
l_t_range-high = sy-datum(6) - 1.
modify l_t_range index l_idx.

p_subrc = 0.

*$*$ end of routine - insert your code only before this line *-*

Save this.

This will make the month range to previous month . "l_t_range" table is of type structure RSSDLRANGE (contains Sign, Option, Low, High). We need to populate these fields to pass range dynamically.

8 comments:

bababhai said...

www.SAPpass.com - SAP professionals -- Good News for all of us. There is a niche job board for us to find better opportunities. I heard that they have more than 1000 recruiters and 10000 Job-seekers registered with them. They have opportunity listed for Australia, Canada, Singapore, USA and India as well. It is worth registering with this website.
www.SAPpass.com is an excellent website as far as SAP job search in India is concerned. I observed that leading organizations across different verticals have used this website.

Anonymous said...

Woah! I'm really enjoying the template/theme of this site. It's simple,
yet effective. A lot of times it's difficult to get that "perfect balance" between superb usability and visual appeal. I must say you've done a amazing job with
this. Also, the blog loads extremely quick for me on Internet explorer.
Excellent Blog!

Here is my blog Order Xtrasize

Anonymous said...

WOW just what I was looking for. Came here by searching for body workout bodybuilding

Feel free to visit my blog post Beta Force Muscle Building Matrix

Anonymous said...

It's the best time to make some plans for the future and it's time to be
happy. I have read this post and if I could I wish to suggest you few interesting things or tips.
Maybe you could write next articles referring to this article.
I want to read even more things about it!

my blog Pure GCE REview

Anonymous said...

These are truly enormous ideas in about blogging.
You have touched some nice things here. Any way keep up wrinting.



My web page :: make money from home

Anonymous said...

My brother recommended I would possibly like this web site.

He was totally right. This publish truly made my day. You can not believe just how a lot time I had spent for this information!
Thank you!

Feel free to visit my blog: anti aging face cream

Anonymous said...

I like the helpful info you provide in your articles. I'll bookmark your blog and check again here regularly. I am quite sure I will learn plenty of new stuff right here! Good luck for the next!

Feel free to surf to my webpage ... Buy Test Force Xtreme

Anonymous said...

Good day! I could have sworn I've been to this site before but after looking at some of the posts I realized it's new
to me. Nonetheless, I'm definitely delighted I discovered it and I'll be book-marking it and checking back
often!

Here is my blog Pay day loan lenders