Routine in infopackage

[Former Member]

wat are the different ways of writing a routine in an infopackage??? and what is the advantage of writing a routine in an infopackage??

[Former Member]

Hi Mugdha,

We can write routines in 2 places in infopackage.

1) Data selection tab - Type column, choose ABAP routine.

Whendo we use this?

when we cannot extract data selectively by giving direct conditions in selection tab, eg: "list all the employees who joined on the current date". here current date value changes every day when we run the query. In such cases we cannot give direct condition, we need to write routine to get the current date

2) External data tab - create routine button.

When do we use this?

OLTP guys will give us a flat file with every day transactions and the file contents, file name changes everyday. Inorder to pickup the file name dynamically every day and to load the data every day from flat file , we need to write a routine.

Thanks,

Madhavi

[Former Member]

HI,

It depends on your requirment to write routine at info pack level. for ex: if you want to automate your flat file loading which comes to app.server every day with standard file name followed by date and month for this you can write routine at info pack level to pick up the file to load into BW.