Q: We are running Win 2003, Oracle 9I, SAP 4.7. We are having
performance issues around Tx MIRO which updates table RBKP. Table RBKP
has five indexes in SAP, but only three of which exist in Oracle. Why is
this?
A: In SAP there are many predefined indexes. You can see these indexes via DB02->checks-> database ->ABAP dictionary ->display. Under optional indexes you see all indexes of which the definition is created in the dictionary, but not created at database level.
Q: Some transactions in SAP are seen as customizing, for instance OVRF (updating routes). In some systems this is set as master data and can be set open. Where do you do this?
A: That depends on each transaction. Sometimes it is determined by other configuration and sometimes it is set according to system function, production or test/develop/demo/etc.
Q: I have some housekeeping ABAPs that I have to create variants for. There are cases when I have
to specify a time interval for the ABAP in the variant. If I explicitly enter a start and end date they will remain at that current date continuously. Is there any way to dynamically enter dates in the variant?
A: In transaction SE38 enter the variant name and choose the attributes radio button. Here you can set the field to “selection variable.” Then, under selection variables button, you can define that it is SY -DATE+7.
Q: When I check transaction SM37 and I want to see the spool I get a message that says “no list available.” Why is this?
A: There are several possible reasons. The spool is sent to a printer and deleted. The spool is too old and the housekeeper deleted it. Also, some test reports simulate a calculation then rollback. It works fine online. When a background job does a rollback then it rolls back the spool as well.
Q: I have an ABAP+J2EE instance on XI 3.1. Is it necessary to stop WEB AS and J2EE to apply the support packs for J2EE?
A: Any J2EE patches are applied while system is up and running but no activities. The only patch applied while system is down are binaries (ABAP kernel).
Q: I have a Win NT/SQL7/R3 kernel -46D. I am missing one secondary index (Z0CPS0-1) while I run DB02. I tried recreating the index, but this gives me the error message “Index could not be setup in the DB.” Another index with the same name exists in the database, but it is unknown to the ABAP/ 4 Dictionary. How do I remove the error from the DB02 and resolve the problem?
A: It is possible that an individual created an index in the DB directly, which is not recommended. You must delete the index DB level first, and then create it in SAP.
Q: Will a client copy transfer the background job schedules and all client dependent data?
A: SAP_ALL will copy all client dependent data including schedules to the new client. Remember that ABAP programs are always client independent. Only the masterdata (variant) is client dependent.
Q: I am on SAP 4.7, 6.20 HP UX Oracle. When we complete our weekly offline backup, application is not coming up and the system goes down. Which log will give some input as to what is wrong with the system?
A: Start with the alert log. It is usually found in oracle/SID/saptrace/background/alertSID.log.
Q: What is meant by the terms L and F access methods?
A: An “L” access method refers to local printer. It is local to the SAP server, not the user. An “F” access method refers to front end printer. This uses the user’s Windows printer.
Q: We are currently running 4.7 enterprise on Oracle 9.2.0.6, on Solaris 9. I am in the process of upgrading production which has a central instance server and 3 Application servers where the Sapmnt directory is shared out from the central instance server. I upgraded the kernel on the central instance with no problems, but when I try to start SAP on the APP servers I receive an error message stating the database must be started from a remote server. I have changed all environment variables but I still receive the error message. What could be the issue?
A: Ensure that the Oracle client is properly installed on each of the application servers. Also, make certain that you are using the latest versions of all of the kernel, associated files (R3trans, tp, startdb, stopdb, etc.) and the DB library.
A: In SAP there are many predefined indexes. You can see these indexes via DB02->checks-> database ->ABAP dictionary ->display. Under optional indexes you see all indexes of which the definition is created in the dictionary, but not created at database level.
Q: Some transactions in SAP are seen as customizing, for instance OVRF (updating routes). In some systems this is set as master data and can be set open. Where do you do this?
A: That depends on each transaction. Sometimes it is determined by other configuration and sometimes it is set according to system function, production or test/develop/demo/etc.
Q: I have some housekeeping ABAPs that I have to create variants for. There are cases when I have
to specify a time interval for the ABAP in the variant. If I explicitly enter a start and end date they will remain at that current date continuously. Is there any way to dynamically enter dates in the variant?
A: In transaction SE38 enter the variant name and choose the attributes radio button. Here you can set the field to “selection variable.” Then, under selection variables button, you can define that it is SY -DATE+7.
Q: When I check transaction SM37 and I want to see the spool I get a message that says “no list available.” Why is this?
A: There are several possible reasons. The spool is sent to a printer and deleted. The spool is too old and the housekeeper deleted it. Also, some test reports simulate a calculation then rollback. It works fine online. When a background job does a rollback then it rolls back the spool as well.
Q: I have an ABAP+J2EE instance on XI 3.1. Is it necessary to stop WEB AS and J2EE to apply the support packs for J2EE?
A: Any J2EE patches are applied while system is up and running but no activities. The only patch applied while system is down are binaries (ABAP kernel).
Q: I have a Win NT/SQL7/R3 kernel -46D. I am missing one secondary index (Z0CPS0-1) while I run DB02. I tried recreating the index, but this gives me the error message “Index could not be setup in the DB.” Another index with the same name exists in the database, but it is unknown to the ABAP/ 4 Dictionary. How do I remove the error from the DB02 and resolve the problem?
A: It is possible that an individual created an index in the DB directly, which is not recommended. You must delete the index DB level first, and then create it in SAP.
Q: Will a client copy transfer the background job schedules and all client dependent data?
A: SAP_ALL will copy all client dependent data including schedules to the new client. Remember that ABAP programs are always client independent. Only the masterdata (variant) is client dependent.
Q: I am on SAP 4.7, 6.20 HP UX Oracle. When we complete our weekly offline backup, application is not coming up and the system goes down. Which log will give some input as to what is wrong with the system?
A: Start with the alert log. It is usually found in oracle/SID/saptrace/background/alertSID.log.
Q: What is meant by the terms L and F access methods?
A: An “L” access method refers to local printer. It is local to the SAP server, not the user. An “F” access method refers to front end printer. This uses the user’s Windows printer.
Q: We are currently running 4.7 enterprise on Oracle 9.2.0.6, on Solaris 9. I am in the process of upgrading production which has a central instance server and 3 Application servers where the Sapmnt directory is shared out from the central instance server. I upgraded the kernel on the central instance with no problems, but when I try to start SAP on the APP servers I receive an error message stating the database must be started from a remote server. I have changed all environment variables but I still receive the error message. What could be the issue?
A: Ensure that the Oracle client is properly installed on each of the application servers. Also, make certain that you are using the latest versions of all of the kernel, associated files (R3trans, tp, startdb, stopdb, etc.) and the DB library.
TO ADVANCE..
ReplyDeleteThanks for sharing the information of SAP BI/BW
ReplyDeletevery advanced questions.. i think not suitable for the beginners..
ReplyDelete