05-13-2006 11:01 AM
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.
05-13-2006 11:14 AM
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
05-13-2006 11:14 AM
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
05-30-2006 11:05 AM
05-13-2006 12:00 PM
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
05-13-2006 12:57 PM
HI
GOOD
ANS 1->RSTXSCRP Transport SAPscript files across systems
ANS 2-> I HOPE CLIENT DEPENDENT
ANS 3-> CLIENT DEPENDENT
ANS 4-> I HOPE IT IS NOT POSSIBLE
go through the following links
http://sap.niraj.tripod.com/id19.html
http://www.planetsap.com/Userexit_List.htm
http://www.allsaplinks.com/material.html
http://www.sap-img.com/abap-function.htm
SLDB-To find out the logical database details
http://de.geocities.com/rafaelreichle/abapkeywords.html
STMS-Transport Management System
http://www.kabai.com/abaps/q.htm
thanks
mrutyun