Ans -: Using the SAP Netweaver 7.3 installation DVDs we can install the following software:
- Process integration
- Enterprise Portal
- Netweaver Mobile.
- SAP Master Data Management (MDM)
- SAP BI
Q-:
how to check the user login log including date ,userid,terminal?
Run the "last" command to find out all previous logins.
Ans-:
Activate user audit in sm19 and display user audit log in sm20.
In this log you find all things you want related user login.
Configure the Fiscal printer in SAP. Is this configuration the same as the normal printer configuration or is there something different for this?
Problem-: Problem That can you face in your work
Best Method to Create Index For Large Tables
System information: SunOS 5.9; R/3 4.7; Oracle 10.2.0.4;
Question: What is the best method to create indexes for very large tables?
Such as BSIS, 100 GB.
For example: Create an index named Z09 with fields: MANDT, BUKRS, HKONT
I know the normal answer is to use SE11 (create index, Z09) and then SE14 (build index, Z09). But this is where the problem lies. SE14 will LOCK the table until the index is created. Since the BSIS table is heavily used 24/7 in the system, this is not desirable. With little downtime available (2 hours a week maximum), this process will not work.
In SQL*Plus using the 'create index' command. But once this index is created, how is this index then linked to the table in the SAP database?
My attempt at this process shows:
- SE11 the index is listed and status is Active
- SQL*Plus created index using command of:
create index SAPR3.BSIS______Z09 on SAPR3.BSIS (MANDT, BUKRS, HKONT) nologging tablespace PSAPLARGEI parallel (degree 2) online;
- DB02 the index is listed with correct ownership and locations
But here is the issue:
- SE14 listed the index name, shows status as Active/Saved, BUT states "Does not exist in the database" and the DB Index Name shows as: "Not defined as DB index in the ABAP Dictionary". (Side note: All the Create/Delete/Activate buttons are greyed out). The Storage Parameters button shows no entry for the Z09 index.
Is there a missing step after the index is manually created to make it seen in the SAP system?
Is there a general steps procedure to use if creating index outside of the SAP transaction SE14?
Try to sort it such procedure-:
Two hours is more than enough to create that Z index.
Test this in a non-prod system and you will see that this should take less than 30 minutes.
