Solved: Report ,sap-script,sreen painter,DDIC

Former Member · ‎05-13-2006

Hi all ,

I have some query to ask.

1)How to transport sap-script.

2) print program of sap script are client-dependent or client-independent.

3)Database tables ( on se11) are client-dependent or client-independent. ( is sy-mandt will make dependent or independent)

4) how to create select-option on screen painter or with module pool programming.

5)performance tips while creating ABAP report.

6) How to generate new number whenever a new report is created.(e.g. when we create a customer or materia one new number ro name will be generated for customer or material).

points for all answers assured.

thanks.

athavanraja · ‎05-13-2006

1. use program RSTXR3TR & RSTXTRAN

2. client independent

3. sy-mandt makes it client dependent.

4. create selection screen include and call it in dialog program or use FM COMPLEX_SELECTIONS_DIALOG

5. use all keys when making select

avoid select end select .

avoid repetetive selects

6. define number ranges for objects and use NUMBER_GET_NEXT FM to get new number

Regards

Raja

athavanraja · ‎05-13-2006

1. use program RSTXR3TR & RSTXTRAN

2. client independent

3. sy-mandt makes it client dependent.

4. create selection screen include and call it in dialog program or use FM COMPLEX_SELECTIONS_DIALOG

5. use all keys when making select

avoid select end select .

avoid repetetive selects

6. define number ranges for objects and use NUMBER_GET_NEXT FM to get new number

Regards

Raja

Former Member · ‎05-30-2006

Thanx,,Sorry for delay in rewarding points.

Former Member · ‎05-13-2006

Hi Pillac,

Here is answers..

1)How to transport sap-script.

While creating sap-script form it will ask you for abap package (class), if you assign standard package then it will ask you for change request. After completing your development you need to release your request and transport across system.

2) print program of sap script are client-dependent or client-independent.

Print program is client independent.

3)Database tables ( on se11) are client-dependent or client-independent. ( is sy-mandt will make dependent or independent)

MANDT field indicates it is client dependent table.

4) how to create select-option on screen painter or with module pool programming.

Check out following link...

http://help.sap.com/saphelp_erp2005/helpdata/en/fc/eb2d81358411d1829f0000e829fbfe/frameset.htm

5)performance tips while creating ABAP report.

1. Do not use nested select statement.

2. Use joins if possible ( But with limited number of tables)

3. If you have more than 100-200 records do not use for all entries which degrades the performance.

4. Try to use primary keys while selecting data from tables.

5. If number of records too high in DB table and select is not on primary key...create secondary index with where clause..will imrpove performance.

6) How to generate new number whenever a new report is created.(e.g. when we create a customer or materia one new number ro name will be generated for customer or material).

Create Number Range. You can use function module GET_NEXT_NUMBER which will give you next number everytime whenever you execute it.

Cheers,

Nilesh

Message was edited by: Nilesh Kshirsagar