2020年12月24日星期四

對物件的影響程度 Repair Chained Rows (蟾蜍) < Alter Table Move < Rebuild Table (蟾蜍)

對物件的影響程度

Rebuild Table (蟾蜍) > Alter Table Move (reorg) > Repair Chained Rows (蟾蜍)

1. Rebuild Table (蟾蜍) : Create Indexes, Compile Dependencies, Analyze Table

2. Alter Table Move (reorg): Rebuild Indexes, Analyze Table

3. Repair Chained Rows (蟾蜍): Analyze Table

SQL> create table tbl_1224 as select * from employees;

Table created.

SQL> desc tbl_1224;

Name Null? Type

----------------------------------------- -------- ----------------------------

EMPLOYEE_ID NUMBER(6)

FIRST_NAME VARCHAR2(20)

LAST_NAME NOT NULL VARCHAR2(25)

EMAIL NOT NULL VARCHAR2(25)

PHONE_NUMBER VARCHAR2(20)

HIRE_DATE NOT NULL DATE

JOB_ID NOT NULL VARCHAR2(10)

SALARY NUMBER(8,2)

COMMISSION_PCT NUMBER(2,2)

MANAGER_ID NUMBER(6)

DEPARTMENT_ID NUMBER(4)

SQL> CREATE INDEX idx_tbl_1224_01 ON tbl_1224

(EMPLOYEE_ID); 2

Index created.

SQL> select EMAIL from tbl_1224;

-------------------------

DOCONNEL

DGRANT

JWHALEN

MHARTSTE

PFAY

SMAVRIS

HBAER

SHIGGINS

WGIETZ

SKING

NKOCHHAR

SQL> CREATE OR REPLACE FORCE VIEW vw_1224

select EMAIL from tbl_1224; 2 3

View created.

SQL> select * from vw_1224;

-------------------------

DOCONNEL

DGRANT

JWHALEN

MHARTSTE

PFAY

SMAVRIS

HBAER

SHIGGINS

WGIETZ

SKING

NKOCHHAR

SQL> select OWNER, object_name, OBJECT_TYPE , status

from dba_objects

where owner = 'HR1' and object_type ='VIEW'; 2 3

OWNER

------------------------------

OBJECT_NAME

--------------------------------------------------------------------------------

OBJECT_TYPE STATUS

------------------- -------

HR1

VW_1224

VIEW VALID

SQL> select OWNER, object_name, OBJECT_TYPE , status

from dba_objects

where owner = 'HR1' and status <> 'VALID';

2 3

no rows selected

--Alter Table Move 不會讓 depenedncies 的狀態成為 INVALID

SQL> alter table tbl_1224 move;

Table altered.

SQL> select OWNER, object_name, OBJECT_TYPE , status

from dba_objects

where owner = 'HR1' and status <> 'VALID'; 2 3

no rows selected

SQL> select

a.owner OWNER,

a.INDEX_NAME NAME,

a.TABLE_NAME TABLE_NAME,

a.STATUS STATUS

from all_indexes a

where A.OWNER = 'HR1'

and A.STATUS <> 'VALID'; 2 3 4 5 6 7 8

OWNER NAME

------------------------------ ------------------------------

TABLE_NAME STATUS

------------------------------ --------

HR1 IDX_TBL_1224_01

TBL_1224 UNUSABLE

SQL> select * from vw_1224;

-------------------------

DOCONNEL

DGRANT

JWHALEN

MHARTSTE

PFAY

SMAVRIS

HBAER

SHIGGINS

WGIETZ

SKING

NKOCHHAR

SQL> ALTER INDEX IDX_TBL_1224_01 REBUILD;

Index altered.

-- TOAD Rebuild Table 會讓 depenedncies 的狀態成為 INVALID

SQL> SET LINESIZE 200

SQL> ALTER TABLE HR1.TBL_1224 RENAME TO TBL_1224_X;

Table altered.

SQL> CREATE TABLE HR1.TBL_1224

(

EMPLOYEE_ID NUMBER(6),

FIRST_NAME VARCHAR2(20 BYTE),

LAST_NAME VARCHAR2(25 BYTE) NOT NULL,

EMAIL VARCHAR2(25 BYTE) NOT NULL,

PHONE_NUMBER VARCHAR2(20 BYTE),

HIRE_DATE DATE NOT NULL,

JOB_ID VARCHAR2(10 BYTE) NOT NULL,

SALARY NUMBER(8,2),

COMMISSION_PCT NUMBER(2,2),

MANAGER_ID NUMBER(6),

DEPARTMENT_ID NUMBER(4)

) 2 3 4 5 6 7 8 9 10 11 12 13 14

15 ;

Table created.

SQL> INSERT /*+ APPEND */

2 INTO HR1.TBL_1224 INS_TBL

(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL,

PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY,

3 4 5 COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)

SELECT

EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL,

PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY,

COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID

FROM HR1.TBL_1224_X SEL_TBL;

6 7 8 9 10 COMMIT;

214 rows created.

SQL>

Commit complete.

SQL>

SQL> DROP INDEX HR1.IDX_TBL_1224_01;

Index dropped.

SQL> CREATE INDEX HR1.IDX_TBL_1224_01 ON HR1.TBL_1224

(EMPLOYEE_ID) 2 ;

Index created.

SQL> select

a.owner OWNER,

a.INDEX_NAME NAME,

a.TABLE_NAME TABLE_NAME,

a.STATUS STATUS

from all_indexes a

where A.OWNER = 'HR1'

and A.STATUS <> 'VALID'; 2 3 4 5 6 7 8

no rows selected

SQL> select OWNER, object_name, OBJECT_TYPE , status

from dba_objects

where owner = 'HR1' and status <> 'VALID'; 2 3

OWNER OBJECT_NAME OBJECT_TYPE STATUS

------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------- -------

HR1 VW_1224 VIEW INVALID

SQL> select * from vw_1224;

-------------------------

DOCONNEL

DGRANT

JWHALEN

MHARTSTE

PFAY

SMAVRIS

HBAER

SHIGGINS

WGIETZ

SKING

NKOCHHAR

-- 使用到 VIEW VW_1224 之後，則DB會自動COMPILE該物件

SQL> select OWNER, object_name, OBJECT_TYPE , status

from dba_objects

where owner = 'HR1' and status <> 'VALID'; 2 3

no rows selected

-- 這是手動COMPILE該物件

SQL> ALTER VIEW "HR1"."VW_1224" COMPILE;

View altered.

SQL> select OWNER, object_name, OBJECT_TYPE , status

from dba_objects

where owner = 'HR1' and status <> 'VALID'; 2 3

no rows selected

SQL> select

a.owner OWNER,

a.INDEX_NAME NAME,

a.TABLE_NAME TABLE_NAME,

a.STATUS STATUS

from all_indexes a

where A.OWNER = 'HR1'

and A.STATUS <> 'VALID'; 2 3 4 5 6 7 8

no rows selected

SQL>

Oracle database link and view status

結論:

1. view 裡面有使用到 database link

2. create view 之後，drop database link，view testdb88_hr1_usertables 還是顯示為 VALID

3. 但是 select from testdb88_hr1_usertables 顯示錯誤 ORA-04063: view "HR1.TESTDB88_HR1_USERTABLES" has errors

4. 重新compile TESTDB88_HR1_USERTABLES COMPILE 時，報錯 Warning: compiled but with compilation errors

5. 這時 view status 顯示為 INVALID

CREATE DATABASE LINK HR1_TESTDB88

CONNECT TO HR1

IDENTIFIED BY "password"

USING 'testdb88_DB11G';

CREATE OR REPLACE FORCE VIEW HR1.TESTDB88_HR1_USERTABLES

SELECT *

FROM user_tables@HR1_TESTDB88;

select * from HR1.TESTDB88_HR1_USERTABLES

select OWNER, object_name, OBJECT_TYPE , status

from dba_objects

where owner = 'HR1' and object_type ='VIEW';

DROP DATABASE LINK HR1_TESTDB88;

select OWNER, object_name, OBJECT_TYPE , status

from dba_objects

where owner = 'HR1' and object_type ='VIEW';

select * from HR1.TESTDB88_HR1_USERTABLES;

ORA-04063: view "HR1.TESTDB88_HR1_USERTABLES" has errors

SELECT *

FROM user_tables@HR1_TESTDB88;

Error at line 2

ORA-02019: connection description for remote database not found

ALTER VIEW TESTDB88_HR1_USERTABLES COMPILE;

Warning: compiled but with compilation errors

select OWNER, object_name, OBJECT_TYPE , status

from dba_objects

where owner = 'HR1' and object_type ='VIEW';

OWNER OBJECT_NAME OBJECT_TYPE STATUS

-------- ------------ ------------ -------

HR1 TESTDB88_HR1_USERTABLES VIEW INVALID

1 row selected.

2020年12月23日星期三

何時重建索引 When to Rebuild Indexes

http://www.dba-oracle.com/t_oracle_analyze_index.htm

Oracle ANALYZE INDEX

Oracle Database Tips by Donald Burleson

http://www.remote-dba.net/t_tuning_index_rebuilding.htm

Index Rebuilding Techniques

Oracle Tips by Burleson Consulting

何時重建索引

如果每次訪問獲取的塊過多，則我們可能要重建索引，因為過多的塊獲取表示碎片化的B樹結構。另一個重建條件是刪除的葉子節點佔索引節點的20％以上的情況。重建的另一個原因是當任何索引顯示的深度為4或更大時。

When to Rebuild Indexes

Rebuild an Oracle index with the following command:

ALTER INDEX index_name REBUILD TABLESPACE tablespace_name;

We might want to rebuild an index if the block gets per access is excessive, since excessive block gets indicate a fragmented B-tree structure. Another rebuild condition would be cases where deleted leaf nodes comprise more than 20 percent of the index nodes. Another reason to rebuild is when any index shows a depth of 4 or greater.

使用alter index rebuild進行索引重建是非常安全的命令。如果出現任何問題，Oracle會中止該操作並將現有索引保留在原處。

Index rebuilding with the alter index rebuild is a very safe command. If anything goes wrong, Oracle aborts the operation and leaves the existing index in place.

2020年11月30日星期一

Oracle expdp impdp CONTENT=METADATA_ONLY testing

新增兩個USER，創建表，賦與權限。實驗看看哪個復原方式可以達到我要的效果。

CREATE USER HR3

IDENTIFIED BY VALUES 'S:78DE8200DFBDE7C8A683934A5AF43E2FE8614C357C0BBA8DBC7C7898D824;9F1BFB4526C62B14'

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

-- 3 Roles for HR3

GRANT CONNECT TO HR3;

GRANT RESOURCE TO HR3;

GRANT SELECT_CATALOG_ROLE TO HR3;

ALTER USER HR3 DEFAULT ROLE ALL;

-- 5 System Privileges for HR3

GRANT ALTER SYSTEM TO HR3;

GRANT CREATE DATABASE LINK TO HR3;

GRANT CREATE MATERIALIZED VIEW TO HR3;

GRANT ON COMMIT REFRESH TO HR3;

GRANT UNLIMITED TABLESPACE TO HR3;

CREATE USER HR4

IDENTIFIED BY VALUES 'S:78DE8200DFBDE7C8A683934A5AF43E2FE8614C357C0BBA8DBC7C7898D824;9F1BFB4526C62B14'

DEFAULT TABLESPACE TEST_TBS

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

-- 3 Roles for HR4

GRANT CONNECT TO HR4;

GRANT RESOURCE TO HR4;

GRANT SELECT_CATALOG_ROLE TO HR4;

ALTER USER HR4 DEFAULT ROLE ALL;

-- 5 System Privileges for HR4

GRANT ALTER SYSTEM TO HR4;

GRANT CREATE DATABASE LINK TO HR4;

GRANT CREATE MATERIALIZED VIEW TO HR4;

GRANT ON COMMIT REFRESH TO HR4;

GRANT UNLIMITED TABLESPACE TO HR4;

SQL> create table hr3.EMPLOYEES_TEST as select * from HR1.EMPLOYEES_TEST;

Table created.

SQL> grant select on hr3.EMPLOYEES_TEST to hr4;

Grant succeeded.

[oracle@testdb89 dpdump]$ expdp DIRECTORY=DATA_PUMP_DIR SCHEMAS=HR3 CONTENT=METADATA_ONLY EXCLUDE=statistics dumpfile=hr3_20201130.dmp

Export: Release 11.2.0.4.0 - Production on Mon Nov 30 12:42:39 2020

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** DIRECTORY=DATA_PUMP_DIR SCHEMAS=HR3 CONTENT=METADATA_ONLY EXCLUDE=statistics dumpfile=hr3_20201130.dmp

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled

Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:

/u01/app/oracle/admin/DB11G/dpdump/hr3_20201130.dmp

Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Nov 30 12:42:55 2020 elapsed 0 00:00:10

[oracle@testdb89 dpdump]$ expdp DIRECTORY=DATA_PUMP_DIR SCHEMAS=HR4 CONTENT=METADATA_ONLY EXCLUDE=statistics dumpfile=hr4_20201130.dmp

Export: Release 11.2.0.4.0 - Production on Mon Nov 30 12:44:47 2020

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** DIRECTORY=DATA_PUMP_DIR SCHEMAS=HR4 CONTENT=METADATA_ONLY EXCLUDE=statistics dumpfile=hr4_20201130.dmp

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled

Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:

/u01/app/oracle/admin/DB11G/dpdump/hr4_20201130.dmp

Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Nov 30 12:45:02 2020 elapsed 0 00:00:07

[oracle@testdb89 dpdump]$ expdp DIRECTORY=DATA_PUMP_DIR SCHEMAS=HR3,HR4 CONTENT=METADATA_ONLY EXCLUDE=statistics dumpfile=hr34_20201130.dmp

Export: Release 11.2.0.4.0 - Production on Mon Nov 30 12:45:17 2020

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** DIRECTORY=DATA_PUMP_DIR SCHEMAS=HR3,HR4 CONTENT=METADATA_ONLY EXCLUDE=statistics dumpfile=hr34_20201130.dmp

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled

Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:

/u01/app/oracle/admin/DB11G/dpdump/hr34_20201130.dmp

Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Nov 30 12:45:30 2020 elapsed 0 00:00:07

[oracle@testdb89 dpdump]$ expdp include=user SCHEMAS=HR4 DIRECTORY=DATA_PUMP_DIR dumpfile=userhr4_20201130.dmp

Export: Release 11.2.0.4.0 - Production on Mon Nov 30 13:36:29 2020

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** include=user SCHEMAS=HR4 DIRECTORY=DATA_PUMP_DIR dumpfile=userhr4_20201130.dmp

Estimate in progress using BLOCKS method...

Total estimation using BLOCKS method: 0 KB

Processing object type SCHEMA_EXPORT/USER

Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:

/u01/app/oracle/admin/DB11G/dpdump/userhr4_20201130.dmp

Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Nov 30 13:36:41 2020 elapsed 0 00:00:04

SQL> DROP USER HR4 CASCADE;

[oracle@testdb89 dpdump]$ impdp DIRECTORY=DATA_PUMP_DIR DUMPFILE=userhr4_20201130.dmp

Import: Release 11.2.0.4.0 - Production on Mon Nov 30 13:37:24 2020

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** DIRECTORY=DATA_PUMP_DIR DUMPFILE=userhr4_20201130.dmp

Processing object type SCHEMA_EXPORT/USER

Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Mon Nov 30 13:38:40 2020 elapsed 0 00:00:02

用expdp include=user 的export file 做impdp，只會create user。沒有相關system, object, role 等權限。

沒有權限，連登入資料庫都會失敗。

[oracle@testdb89 dpdump]$ sqlplus hr4/hr

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 30 13:41:44 2020

ERROR:

ORA-01045: user HR4 lacks CREATE SESSION privilege; logon denied

Enter user-name:

[oracle@testdb89 dpdump]$ sqlplus / as sysdba

SQL> DROP USER HR4 CASCADE;

[oracle@testdb89 dpdump]$ impdp DIRECTORY=DATA_PUMP_DIR DUMPFILE=hr4_20201130.dmp

缺 -- 1 Object Privilege for HR4

GRANT SELECT ON HR3.EMPLOYEES_TEST TO HR4;

[oracle@testdb89 dpdump]$ sqlplus / as sysdba

SQL> DROP USER HR4 CASCADE;

[oracle@testdb89 dpdump]$ impdp DIRECTORY=DATA_PUMP_DIR DUMPFILE=hr34_20201130.dmp

Import: Release 11.2.0.4.0 - Production on Mon Nov 30 12:47:47 2020

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** DIRECTORY=DATA_PUMP_DIR DUMPFILE=hr34_20201130.dmp

Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:"HR3" already exists

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39151: Table "HR3"."EMPLOYEES_TEST" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 2 error(s) at Mon Nov 30 12:47:56 2020 elapsed 0 00:00:02

缺 -- 1 Object Privilege for HR4

GRANT SELECT ON HR3.EMPLOYEES_TEST TO HR4;

因為 ORA-39151: Table "HR3"."EMPLOYEES_TEST" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

[oracle@testdb89 dpdump]$ sqlplus / as sysdba

SQL> DROP USER HR3 CASCADE;

SQL> DROP USER HR4 CASCADE;

[oracle@testdb89 dpdump]$ impdp DIRECTORY=DATA_PUMP_DIR DUMPFILE=hr34_20201130.dmp

Import: Release 11.2.0.4.0 - Production on Mon Nov 30 12:49:58 2020

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** DIRECTORY=DATA_PUMP_DIR DUMPFILE=hr34_20201130.dmp

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Mon Nov 30 12:50:09 2020 elapsed 0 00:00:02

將HR3, HR4 都完整drop，才會恢復的完整。 HR4 有 GRANT SELECT ON HR3.EMPLOYEES_TEST TO HR4;

SQL> set long 64000

SQL> select dbms_metadata.get_ddl('USER','HR3') from dual;

SQL> select dbms_metadata.get_ddl('USER','HR4') from dual;

DBMS_METADATA.GET_DDL('USER','HR4')

--------------------------------------------------------------------------------

CREATE USER "HR4" IDENTIFIED BY VALUES 'S:78DE8200DFBDE7C8A683934A5AF43E2FE86

14C357C0BBA8DBC7C7898D824;9F1BFB4526C62B14'

DEFAULT TABLESPACE "TEST_TBS"

TEMPORARY TABLESPACE "TEMP"

如果是想在開發機，設定和正式機相同的密碼。

ALTER USER "HR4" IDENTIFIED BY VALUES 'S:78DE8200DFBDE7C8A683934A5AF43E2FE86

14C357C0BBA8DBC7C7898D824;9F1BFB4526C62B14'

2020年11月24日星期二

Oracle Row Chaining and Migration 圖示

The Secrets of Oracle Row Chaining and Migration

https://www.akadia.com/services/ora_chained_rows.html

Row Migration

We will migrate a row when an update to that row would cause it to not fit on the block anymore (with all of the other data that exists there currently). A migration means that the entire row will move and we just leave behind the «forwarding address». So, the original block just has the rowid of the new block and the entire row is moved.

Row Chaining

A row is too large to fit into a single database block. For example, if you use a 4KB blocksize for your database, and you need to insert a row of 8KB into it, Oracle will use 3 blocks and store the row in pieces. Some conditions that will cause row chaining are: Tables whose rowsize exceeds the blocksize. Tables with LONG and LONG RAW columns are prone to having chained rows. Tables with more then 255 columns will have chained rows as Oracle break wide tables up into pieces. So, instead of just having a forwarding address on one block and the data on another we have data on two or more blocks.

"alter table move tablespace" tips

http://www.dba-oracle.com/t_alter_table_move_index_constraint.htm

reorg

Identifying Oracle Tables with Migrated/Chained Rows

http://www.dba-oracle.com/t_identify_chained_rows.htm

資料鏈結（Chained Row）有兩種型態

http://dbtim.blogspot.com/2016/05/1-3.html

可用TOAD Rebuild Table 或是 Repair Chained Rows (好用)來做優化

analyze table TableName compute statistics;

2020年10月30日星期五

Oracle 11g Default Schemas

以下內容節錄自

http://www.oracle-wiki.net/premium:startdocsdefaultschemas

Oracle 11g Default Schemas

DEFAULT SCHEMA

USER NAME DEFAULT TABLESPACE TEMPORARY TABLESPACE LOCKED? DBA?

ANONYMOUS SYSAUX TEMP YES

APEX_030200 SYSAUX TEMP YES

APEX_PUBLIC_USER USERS TEMP YES

APPQOSSYS SYSAUX TEMP YES

BI USERS TEMP YES

CTXSYS SYSAUX TEMP YES

DBSNMP SYSTEM TEMP

DIP USERS TEMP YES

EXFSYS SYSAUX TEMP YES

FLOWS_FILES SYSAUX TEMP YES

HR USERS TEMP YES

IX USERS TEMP YES

MDDATA USERS TEMP YES

MDSYS SYSAUX TEMP YES

MGMT_VIEW SYSTEM TEMP

OE USERS TEMP YES

OLAPSYS SYSAUX TEMP YES

ORACLE_OCM USERS TEMP YES

ORDDATA SYSAUX TEMP YES

ORDPLUGINS SYSAUX TEMP YES

ORDSYS SYSAUX TEMP YES

OUTLN SYSTEM TEMP YES

OWBSYS SYSAUX TEMP YES

OWBSYS_AUDIT SYSAUX TEMP YES

PM USERS TEMP YES

SCOTT USERS TEMP YES

SH USERS TEMP YES

SI_INFORMTN_SCHEMA SYSAUX TEMP YES

SPATIAL_CSW_ADMIN_USR USERS TEMP YES

SPATIAL_WFS_ADMIN_USR USERS TEMP YES

SYS SYSTEM TEMP YES

SYSMAN SYSAUX TEMP

SYSTEM SYSTEM TEMP YES

WMSYS SYSAUX TEMP YES

XDB SYSAUX TEMP YES

XS$NULL USERS TEMP YES

SCHEMA OVERVIEW

ANONYMOUS

Purpose:Account that allows HTTP access to Oracle XML DB. It is used in place of the APEX_PUBLIC_USER account when the Embedded PL/SQL Gateway (EPG) is installed in the database. EPG is a Web server that can be used with Oracle Database. It provides the necessary infrastructure to create dynamic applications. See also XDB.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/rdbms/admin/catqm.sql

APEX_030200

Purpose:Part of the Oracle Application Express Suite - (Oracle APEX, previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. The account owns the Application Express schema and metadata. See also APEX_PUBLIC_USER and FLOW_FILES.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/apex/apexins.sql

APEX_PUBLIC_USER

Purpose:Part of the Oracle Application Express Suite - (Oracle APEX, previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. This minimally privileged account is used for Application Express configuration with Oracle HTTP Server and mod_plsql. See also APEX_030200 and FLOW_FILES.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/apex/apexins.sql

APPQOSSYS

Purpose:Used for storing/managing all data and metadata required by Oracle Quality of Service Management.

Safe To Remove:Yes

Recreation Script:$ORACLE_ADMIN/rdbms/admin/catqos.sql

Purpose:The account that owns the Business Intelligence schema included in the Oracle Sample Schemas. See also HR, OE, SH, IX and PM.

Safe To Remove:Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql

Recreation Script:$ORACLE_HOME/demo/schema/bus_intelligence/bi_main.sql

CTXSYS

Purpose:The account used to administer Oracle Text. Oracle Text enables the building of text query applications and document classification applications. It provides indexing, word and theme searching, and viewing capabilities for text.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/ctx/admin/ctxsys.sql

DBSNMP

Purpose:The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database. Password is created at installation or database creation time.

Safe To Remove:Yes – run $ORACLE_HOME/rdbms/admin/catnsnmp.sql

Recreation Script:$ORACLE_HOME/rdbms/admin/catsnmp.sql

DIP

Purpose:The account used by the Directory Integration Platform (DIP) to synchronize the changes in Oracle Internet Directory with the applications in the database.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/rdbms/admin/catdip.sql

EXFSYS

Purpose:The account used internally to access the EXFSYS schema, which is associated with the Rules Manager and Expression Filter feature. This feature enables the building of complex PL/SQL rules and expressions. The EXFSYS schema contains the Rules Manager and Expression Filter DDL, DML, and associated metadata.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/rdbms/admin/exfsys.sql

FLOW_FILES

Purpose:Part of the Oracle Application Express Suite - (Oracle APEX, previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. This account owns the Application Express uploaded files. See also APEX_030200 and APEX_PUBLIC_USER.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/apex/apexins.sql

Purpose:The account that owns the Human Resources schema included in the Oracle Sample Schemas. See also BI, OE, SH, IX and PM.

Safe To Remove:Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql

Recreation Script:$ORACLE_HOME/demo/schema/human_resources/hr_main.sql

Purpose:The account that owns the Information Transport schema included in the Oracle Sample Schemas. See also BI, HR, OE, SH and PM.

Safe To Remove:Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql

Recreation Script:$ORACLE_HOME/demo/schema/info_exchange/ix_main.sql

MDDATA

Purpose:The schema used by Oracle Spatial for storing Geocoder and router data. See also SPATIAL_CSW_ADMIN_USR , SPATIAL_WFS_ADMIN_USR and MDSYS.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/md/admin/catmd.sql

MDSYS

Purpose:The Oracle Spatial and Oracle Multimedia Locator administrator account. See also SPATIAL_CSW_ADMIN_USR , MDDATA and SPATIAL_WFS_ADMIN_USR.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/ord/admin/ordinst.sql

MGMT_VIEW

Purpose:An account used by Oracle Enterprise Manager Database Control. Password is randomly generated at installation or database creation time. Users do not need to know this password.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/sysman/admin/emdrep/bin/RepManager

Purpose:The account that owns the Order Entry schema included in the Oracle Sample Schemas. See also BI, HR, SH, IX and PM.

Safe To Remove:Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql

Recreation Script:$ORACLE_HOME/ demo/schema/order_entry/oe_main.sql

OLAPSYS

Purpose:The account that owns the OLAP Catalog (CWMLite). This account has been deprecated, but is retained for backward compatibility.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/olap/admin/amdsys.sql

ORACLE_OCM

Purpose:This account contains the instrumentation for configuration collection used by the Oracle Configuration Manager.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/rdbms/admin/catocm.sql

ORDDATA

Purpose:This account contains the Oracle Multimedia DICOM data model.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/ord/admin/ordisysc.sql

ORDPLUGINS

Purpose:The Oracle Multimedia user. Plug-ins supplied by Oracle and third-party, format plug-ins are installed in this schema. Oracle Multimedia enables Oracle Database to store, manage, and retrieve images, audio, video, DICOM format medical images and other objects, or other heterogeneous media data integrated with other enterprise information. See also ORDSYS and SI_INFORMTN_SCHEMA.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/ord/admin/ordinst.sql

ORDSYS

Purpose:The Oracle Multimedia administrator account. See also ORDPLUGINS and SI_INFORMTN_SCHEMA.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/ord/admin/ordinst.sql

OUTLN

Purpose:The account that supports plan stability. Plan stability prevents certain database environment changes from affecting the performance characteristics of applications by preserving execution plans in stored outlines. OUTLN acts as a role to centrally manage metadata associated with stored outlines.

Safe To Remove:No

Recreation Script:$ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.

OWBSYS

Purpose:The account for administrating the Oracle Warehouse Builder repository. Access this account during the installation process to define the base language of the repository and to define Warehouse Builder workspaces and users. A data warehouse is a relational or multidimensional database that is designed for query and analysis. See also OWBSYS_AUDIT.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql

OWBSYS_AUDIT

Purpose:This account is used by the Warehouse Builder Control Center Agent to access the heterogeneous execution audit tables in the OWBSYS schema.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql

Purpose:The account that owns the Product Media schema included in the Oracle Sample Schemas. See also BI, HR, OE, SH and IX.

Safe To Remove:Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql

Recreation Script:$ORACLE_HOME/demo/schema/product_media/pm_main.sql

SCOTT

Purpose:An account used by Oracle sample programs and examples.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/rdbms/admin/utlsampl.sql

Purpose:The account that owns the Sales History schema included in the Oracle Sample Schemas and is only available for Enterprise Edition installations. See also BI, HR, OE, IX and PM.

Safe To Remove:Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql

Recreation Script:$ORACLE_HOME/demo/schema/sales_history/sh_main.sql

SI_INFORMTN_SCHEMA

Purpose:The account that stores the information views for the SQL/MM Still Image Standard. See also ORDPLUGINS and ORDSYS.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/ord/admin/ordinst.sql

SPATIAL_CSW_ADMIN_USR

Purpose:The Catalog Services for the Web (CSW) account. It is used by the Oracle Spatial CSW cache manager to load all record type metadata, and record instances from the database into the main memory for the record types that are cached. See also SPATIAL_WFS_ADMIN_USR, MDDATA and MDSYS.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/md/admin/sdocswpv.sql

SPATIAL_WFS_ADMIN_USR

Purpose:The Web Feature Service (WFS) account. It is used by the Oracle Spatial WFS cache manager to load all feature type metadata, and feature instances from the database into main memory for the feature types that are cached. See also SPATIAL_CSW_ADMIN_USR , MDDATA and MDSYS.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/md/admin/sdowfspv.sql

SYS

Purpose:An account used to perform database administration tasks. Password is created at installation or database creation time.

Safe To Remove:No

Recreation Script:$ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.

SYSMAN

Purpose:The account used to perform Oracle Enterprise Manager database administration tasks. The SYS and SYSTEM accounts can also perform these tasks. Password is created at installation or database creation time.

Safe To Remove:Yes

Recreation Script:Created as part of the dbconsole or Enterprise Manager build.

SYSTEM

Purpose:A default generic database administrator account for Oracle databases. For production systems, Oracle recommends creating individual database administrator accounts and not using the generic SYSTEM account for database administration operations. Password is created at installation or database creation time.

Safe To Remove:No

Recreation Script:$ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.

WMSYS

Purpose:The account used to store the metadata information for Oracle Workspace Manager.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/rdbms/admin/owmctab.plb

XDB

Purpose:The account used for storing Oracle XML DB data and metadata. See also ANONYMOUS.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/rdbms/admin/catqm.sql

XS$NULL

Purpose:An internal account that represents the absence of a user in a session. Because XS$NULL is not a user, this account can only be accessed by the Oracle Database instance. XS$NULL has no privileges and no one can authenticate as XS$NULL, nor can authentication credentials ever be assigned to XS$NULL.

Safe To Remove:No

Recreation Script:$ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.

OTHER ADMINISTRATIVE SCHEMA

The schema listed below are not installed by default, but can be built using the creation script(s) cited and any necessary additional steps as prescribed by the appropriate Oracle manual.

LBACSYS

Purpose:The account used to administer Oracle Label Security (OLS). It is created only when the Label Security custom option is installed.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/rdbms/admin/catlbacs.sql

WK_TEST

Purpose:The instance administrator for the default instance, WK_INST. After unlocking this account and assigning this user a password, then the cached schema password must also be updated using the administration tool Edit Instance Page. Ultra Search provides uniform search-and-location capabilities over multiple repositories, such as Oracle databases, other ODBC compliant databases, IMAP mail servers, HTML documents managed by a Web server, files on disk, and more. See also WKSYS

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/ultrasearch/admin/wk0csys.sql

WKSYS

Purpose:An Ultra Search database super-user. WKSYS can grant super-user privileges to other users, such as WK_TEST. All Oracle Ultra Search database objects are installed in the WKSYS schema. See also WK_TEST

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/ultrasearch/admin/wk0csys.sql

WKPROXY

Purpose:An administrative account of Application Server Ultra Search.

Safe To Remove:Yes

Recreation Script:$ORACLE_HOME/ultrasearch/admin/wk0csys.sql

2020年10月28日星期三

常用的SAP TCODE 收錄一些網路文章之後再整理

請問各位大俠﹐哪個TCODE能查詢SAP中所有TCODE?

http://www.itpub.net/thread-1048255-1-1.html

xinre310

发表于 2008-9-1 14:44 | 只看该作者

se93

lgp100_ren

发表于 2008-9-1 14:49 | 只看该作者

table: tstc

se16 display

How to find Transaction codes in SAP?

https://blogs.sap.com/2018/08/30/how-to-find-transaction-codes-in-sap/#

It is available in S4 HANA 1709 onwards, and for version 1511 and 1610, you need to apply the note : 2329987 – CO-OM tools: Generic search of transactions.

SAP has more than 1,00,000+ transaction codes in all, and it is increasingly difficult to keep track or remember these transaction codes.

So what is the solution?

Should we keep excel list of these codes?

Or should we remember it? which is definitely a herculean task and almost impossible feat to achieve.

Well, SAP has come out with a solution for it, It’s simple and easy and searching T-Codes and Almost everyone has seen GOOGLE search engine, so taking a cue from that, SAP has devised it’s very own search engine for finding transaction codes.

The transaction code is : KTRAN ( find transaction )

Process :

Step 1 : Type Transaction code KTRAN in the search bar.

Step 2 : Press enter and you will be guided to a new screen and as marked in blue pen, press EXECUTE as shown below :

Step 3 : As soon as you press EXECUTE, you will be guided to a screen just adjacent to this button as shown below :

Step 4 : Now type any word (or if you know the T-Code) related to your process and SAP will auto-populate all the T-CODES which match that word entered in the Transaction Search Term. You can filter the search as per the various options mentioned in the screen and the beauty of this T-Code is it gives you the Description of the transaction code, Program, Package, Component ID, Authorization, Language, Favorite (check box i.e. whether the T-Code is already favorite in your list or not) and Add Favorite Button ( to make it as Favorite )

When i typed “PUR”, it gave me 400 hits

When I typed the exact word “PURCHASE”, SAP zeroed it down exactly to 152 hits

When I click on a particular T-Code called J1IPUR – Purchase Register – India, it will redirect the screen to the SAP standard purchase register as shown below :

So keep using the T-Code and keep exploring the immense possibility SAP has to offer.

SAP:常用的T-code

https://www.twblogs.net/a/5b89c6882b71775d1ce3bc73

2018-09-01 06:51

如下是蒐集的一些T-Code，還沒有做進一步分析測試。

======================================================

11個模塊較常用的一些T-Code,希望對大家有所幫助！

http://www.sapforum.net/archiver/?tid-4437.html

大家可以在SAP中查詢T-Code,當然前提是你有足夠的權限。

具體方法是：使用T-Code:TSTC 進入T-Code表查詢。

以下是11個模塊較常用的一些T-Code,希望對大家有所幫助！

Plant Maintenance (PM)

Production Planning

BASIS/ABAP

Human Resources

Sales and Distribution (SD)

SAP Office

FI Financial Management

Material Management (MM)

MM configuration transactions

Config Related

Plant Maintenance (PM)

IW32 Change Plant Maintenance Order

IW33 Display Plant Maintenance Order

IW34 Create Notification Order

IW51 Create Service Notification

IW52 Change Service Notification

IW53 Display Service Notification

IW54 Create Service Notification :Problem notification

IW55 Create Service Notification :Activity Request

IW56 Create Service Notification :Service Request

IW57 Assign deletion Flag to Completed Service Notifications

IW58 Change Service Notifications: Selection of Notification

IW59 Display Service Notifications: Selection of Notification

Production Planning

C005N Collective Release

C011N Time Ticket

C012 Confirmation - Collective

C013 Confirmation - Cancel

C00IS Production order information system

C0GI Reprocess Goods Movements

C223 Maintain production version

USMM Pressing F8 will display all hotpacks applied.

SEARCH_SAP_MENU Show the menu path to use to execute a given tcode. You can search

by transaction code or menu text.

DI02 ABAP/4 Repository Information System: Tables.

LSMW Legacy System Migration Workbench. An addon available from SAP that can make

data converstion a lot easier.

OSS1 SAP Online Service System

OY19 Compare Tables

SM13 Update monitor. Will show update tasks status. Very useful to determine why an

update failed.

S001 ABAP Development Workbench

S001 ABAP/4 Development Weorkbench.

S002 System Administration.

SA38 Execute a program.

SCAT Computer Aided Test Tool

SCU0 Compare Tables

SE01 Old Transport & Corrections screen

SE03 Groups together most of the tools that you need for doing transports. In total,

more than 20 tools can be reached from this one transaction.

SE09 Workbench Organizer

SE10 New Transport & Correction screen

SE11 ABAP/4 Dictionary Maintenance SE12 ABAP/4 Dictionary Display SE13 Maintain

Technical Settings (Tables)

SE12 Dictionary: Initial Screen - enter object name.

SE13 Access tables in ABAP/4 Dictionary.

SE14 Utilities for Dictionary Tables

SE15 ABAP/4 Repository Information System

SE16 Data Browser: Initial Screen.

SE16N Table Browser (the N stands for New, it replaces SE16).

SE17 General Table Display

SE24 Class Builder

SE30 ABAP/4 Runtime Analysis

SE32 ABAP/4 Text Element Maintenance

SE35 ABAP/4 Dialog Modules

SE36 ABAP/4: Logical Databases

SE37 ABAP/4 Function Modules

SE38 ABAP Editor

SE39 Splitscreen Editor: Program Compare

SE41 Menu Painter

SE43 Maintain Area Menu

SE48 Show program call hierarchy. Very useful to see the overall structure of a

program.

SE49 Table manipulation. Show what tables are behind a transaction code.

SE51 Screen Painter: Initial Screen.

SE54 Generate View Maintenance Module

SE61 R/3 Documentation

SE62 Industry utilities

SE63 Translation

SE64 Terminology

SE65 R/3 document. short text statistics SE66 R/3 Documentation Statistics (Test!)

SE68 Translation Administration

SE71 SAPscript layout set

SE71 SAPScript Layouts Create/Change

SE72 SAPscript styles

SE73 SAPscript font maintenance (revised)

SE74 SAPscript format conversion

SE75 SAPscript Settings

SE76 SAPscript Translation Layout Sets

SE77 SAPscript Translation Styles

SE80 ABAP/4 Development Workbench

SE81 SAP Application Hierarchy

SE82 Customer Application Hierarchy

SE83 Reuse Library. Provided by Smiho Mathew.

SE84 ABAP/4 Repository Information System

SE85 ABAP/4 Dictionary Information System

SE86 ABAP/4 Repository Information System

SE87 Data Modeler Information System

SE88 Development Coordination Info System

SE91 Maintain Messages

SE92 Maintain system log messages

SE93 Maintain Transaction.

SEARCH_SAP_MENU From the SAP Easy Access screen, type it in the command field and

you will be able to search the standard SAP menu for transaction codes / keywords.

It will return the nodes to follow for you.

SEU Object Browser

SHD0 Transaction variant maintenance

SM04 Overview of Users (cancel/delete sessions)

SM12 Lock table entries (unlock locked tables)

SM21 View the system log, very useful when you get a short dump. Provides much more

info than short dump

SM30 Maintain Table Views.

SM31 Table Maintenance

SM32 Table maintenance

SM35 View Batch Input Sessions

SM37 View background jobs

SM50 Process Overview.

SM51 Delete jobs from system (BDC)

SM62 Display/Maintain events in SAP, also use function BP_EVENT_RAISE

SMEN Display the menu path to get to a transaction

SMOD/CMOD Transactions for processing/editing/activating new customer enhancements.

SNRO Object browser for number range maintenance.

SPRO Start SAP IMG (Implementation Guide).

SQ00 ABAP/4 Query: Start Queries

SQ01 ABAP/4 Query: Maintain Queries

SQ02 ABAP/4 Query: Maintain Funct. Areas

SQ03 ABAP/4 Query: Maintain User Groups

SQ07 ABAP/4 Query: Language Comparison

ST05 Trace SQL Database Requests.

ST22 ABAP Dump analysis

SU53 Display Authorization Values for User.

WEDI EDI Menu. IDOC and EDI base.

WE02 Display an IDOC

WE07 IDOC Statistics

Human Resources

PA03 Change Payroll control record

PA20 Display PA Infotypes

PA30 Create/Change PA Infotypes

PP02 Quick Entry for PD object creation

PU00 Delete PA infotypes for an employee. Will not be able to delete an infotype if

there is cluster data assigned to the employee.

Sales and Distribution (SD)

OLSD Config for SD. Use Tools-Data Transfer-Conditions to setup SAP supplied BDC to

load pricing data

VA01 Create Sales/Returns Order:Initial Screen

VB21 Transaction for Volume Lease Purchases (done as a sales deal)

VK15 Transaction used to enter multiple sales conditions (most will be entered here)

SAP Office

SO00 send a note through SAP, can be sent to internet, X400, etc

FI Financial Management

FGRP Report Writer screen

FM12 View blocked documents by user

FST2 Insert language specific name for G/L account.

FST3 Display G/L account name.

KEA0 Maintain operating concern.

KEKE Activate CO-PA.

KEKK Assign operating concern.

KL04 Delete activity type.

KS04 Delete a cost centre.

KSH2 Change cost centre group - delete.

OBR2 Deletion program for customers, vendors, G/L accounts.

OKC5 Cost element/cost element group deletion.

OKE1 Delete transaction data.

OKE2 Delete a profit centre.

OKI1 Determine Activity Number: Activity Types (Assignment of material

number/service to activity type)

OMZ1 Definition of partner roles.

OMZ2 Language dependent key reassignment for partner roles.

Material Management (MM)

MM06 Flag material for deletion.

OLMS- materials management configuration menu, most of the stuff under this menu is

not under the implementation guide

MM configuration transactions

OLMB- Inventory management/Physical Inventory

OLMD- MM Consumption-Based Planning

OLME- MM Purchasing

OLML- Warehouse Management

OLMR- Invoice Verification

OLMS Material Master data

OLMW- MM Valuation/Account Assignment

Config Related

OLE OLE demo transaction

OLI0 C Plant Maintenance Master Data

OLI1 Set Up INVCO for Material Movements

OLI8 Set Up SIS for Deliveries

OLIA C Maintenance Processing

OLIP C Plant Maintenance Planning

OLIQ New set-up of QM info system

OLIX Set Up Copying/Deleting of Versions

OLIY Set Up Deletion of SIS/Inter.Storage

OLIZ Stat Set Up INVCO: Invoice Verif

OLM2 Customizing: Volume-Based Rebates

OLMB C RM-MAT Inventory Management Menu

OLMD C RM-MAT MRP Menu

OLME C MM Menu: Purchasing

OLML C MM Menu for Warehouse Management

OLMR C RM-MAT Menu: Invoice Verification

OLMS C RM-MAT Master Data Menu

OLMW C RM-MAT Valuation/Acct. Assgt. Menu

OLPA SOP Configuration

OLPE Sales order value

OLPK Customizing for capacity planning

OLPR Project System Options

OLPS Customizing Basic Data

OLPV Customizing: Std. Value Calculation

OLQB C QM QM in Procurement

OLQI Analysis

OLQM Customizing QM Quality Notifications

OLQS C QM Menu Basic Data

OLQW C QM Inspection Management

OLQZ Quality Certificates

OLS1 Customizing for Rebates

OLSD Customizing: SD

OLVA C SD Sales Menu

OLVD C SD Shipping Menu

OLVF C SD Billing Menu

OLVS C SD Menu for Master Data

SPRO Start SAP IMG

=======================================================

http://blog.csdn.net/SAPLIFE/archive/2007/11/15/1886222.aspx

ABAP T-Code

事務碼描述(中英文)

SM01 Lock transactions 鎖定事務

BCHK DE example (SAP tournaments) DE舉例(SAP競賽)

FAX1 BC sample SAP DE 2.1 BC 示例 SAP DE 2.1

FAX2 BC sample 2 SAP DE 2.1 BC樣品 2SAP DE 2.1

SFAX BC Sales BC銷售

ST01 System Trace 系統軌跡

ST11 Display Developer Traces 開發軌跡顯示

STDA Debugger display/control (server) 調試顯示/控制 (服務器)

STDC Debugger output/control 調試輸出/控制

STDU Debugger display/control (user) 調試顯示/控制 (用戶)

@@D Debugger -> Documentation 調試程序 -> 文檔

@@E Debugger -> ABAP Editor 調試程序 -> ABAP 編輯器

@@O Debugger -> Repository Browser 調試程序 -> 倉庫瀏覽器

@@S Debugger -> Screen Painter 調試程序 -> 屏幕製作器

ICON Display Icons 顯示圖標

SAMT ABAP Program Set Processing ABAP 程序集處理

SICK Installation Check 安裝檢查

SLIN ABAP: Extended Program Check ABAP: 擴展程序檢查

SM28 Installation Check 安裝檢查

SM58 Asynchronous RFC Error Log 異步 RFC 錯誤日誌

SM59 RFC Destinations (Display/Maintain) RFC終點(顯示/維護)

SMT1 Trusted Systems (Display <-> Maint.) 信賴系統 (顯示 <-> 維護)

SMT2 Trusting systems (Display <->Maint.) 信任系統 (顯示 <->維護)

SSMT Modification 2.2 --> 3.0 修改 2.2 --> 3.0

ST22 ABAP/4 Runtime Error Analysis ABAP/4 運行時錯誤分析

SUB% Internal call: Submit via commnd fld 內部調用: 通過命令 fld 提交

SYNT Display Syntax Trace Output 顯示語法跟蹤輸出

SE33 Context Builder 環境生成程序

SE30 ABAP Runtime Analysis ABAP 實時分析

LOPI LOOP AT internal ABAP table 內部 ABAP/4 表格中的循環

LOPJ LOOP AT internal ABAP table 內部 ABAP/4 表格中的循環

RJ10 Test Batch Input (large) 測試批輸入（大量）

RJ11 Test Batch Input (large) 測試批輸入（大量）

SHDB Record batch input 記錄批輸入

SM35 Batch Input Monitoring 批輸入監控

CLJP Specify Japanese calender 指定日語日曆

SE73 SAPscript font maintenance (revised) SAPscript 字體維護(修訂的)

SE74 SAPscript format conversion SAPscript 格式轉化

SE75 SAPscript Settings SAPscript 設置

SE76 SAPscript: Form Translation SAPscript: 翻譯格式

SE77 SAPscript Translation Styles SAPscript 翻譯樣式

SO10 SAPscript: Standard Texts SAPscript:標準文本

SE71 SAPscript form SAP腳本格式

SE72 SAPscript styles SAPscript 樣式

SARP Reporting (Tree Structure): Execute 報表(樹結構)：執行

SART Display Report Tree 顯示報表樹

SERP Reporting: Change Tree Structure 報表：修改樹結構

SA38 ABAP reporting ABAP 報表

SA39 SA38 for Parameter Transaction SA38爲參數傳送

SAR0 Display Standard Reporting Tree 顯示標準報告樹

SC38 Start Report (Remote) 啓動報表程序（遠程）

SE32 ABAP/4 Text Element Maintenance ABAP/4 文本元素維護

SM38 Queue Maintenance Transaction 隊列維護事務

SRCN Delete country-specific reports 刪除指定國家報表

SQ00 ABAP/4 Query: Start Queries ABAP/4 詢問: 開始詢問

SQ01 ABAP/4 Query: Maintain Queries ABAP/4 詢問: 維護詢問

SQ02 ABAP/4 Query: Maintain Funct. Areas ABAP/4 查詢: 維護功能區

SQ03 ABAP/4 Query: Maintain User Groups ABAP/4 查詢: 維護用戶組

SQ07 ABAP/4 Query: Language Comparison ABAP/4 查詢：語言比較

SE11 ABAP/4 Dictionary Maintenance ABAP/4 字典維護

SE12 ABAP/4 Dictionary Display ABAP/4 字典顯示

SE80 Repository Browser 資源庫瀏覽器

SE81 Application Hierarchy 應用層次

SE82 Application Hierarchy 應用層次

SEU Repository Browser 資源庫瀏覽器

SE39 Splitscreen Editor: Program Compare 分屏編輯器: 程序比較

SE38 ABAP Editor ABAP 編輯器

SE40 MP: Standards Maint. and Translation MP：標準維護和翻譯

SE41 Menu Painter 菜單製作

SE43 Maintain Area Menu 保持區域菜單

==============================================================

http://blog.chinaunix.net/u1/33519/showart_316006.html

SAP 開發T---CODE

AL11 SAP directories

BUSP Regenerate screens during BDT development

CMOD Project management

FILE Logical file paths

OAOR Business document navigator (edit ENJOYSAP_LOGO etc for ALV Tree)

OLE Examples for OLE Processing

PFTC Workflow

SA38 Execute program

SCC1 Client Copy, copy transport

SCDO Change Document / Change History

SCOT SAPconnect Administration.

SHD0 Create Transaction Variant. Enter name of transaction plus name of new/existing variant.

SE01 Transport Organizer (extended view)

SE03 Transport Organizer Tools (change package/dev class etc..)

SE09 Workbench organiser

SE11 ABAP Dictionary

SE14 Database utility: Adjust after change to definition, delete??

SE16 Data browser, view/add table data

SE18 Business Add-ins(BADI): Definition transaction

SE19 Business Add-ins(BADI): Implementation transaction

SE24 Class builder

SE38 Program Editor

SE39 Split screen editor

SE61 Document maintenance

SE71 Form painter (SAPscript)

SE80 Authority objects

SE81 Application Hierarchy (leads to SE84 for desired area)

SE84 Repository info system

SE91 Message Maintenance

SE93 Maintain Transaction code

SHDB Batch input recorder

SHD0 Transaction variants

SLIN ABAP program extended syntax check (full check of programs syntax)

SM04 User overview

SM12 Lock entries

SM13 Update Requests

SM21 Online system log analysis

SM30 Maintain table views

SM31 Table maintenance

SM35 Batch input i.e. Recording

SM36 Create background job

SM37 Background job monitor, Select background jobs

SM49 External Commands

SM50 Process overview (within current server)

SM51 Server overview

SM59 Display and Maintain RFC destination

SM64 Display/maintain Events

SM66 Process(session) overview across all servers

SM69 External commands(Maintain)

SMW0 SAP WEB Repository(binary data) - add/ mod images(used to put in screen containers)

SMX View background jobs

SNOTE SAP note assistant (if installed)

SNRO Maintain number ranges (use FM 'NUMBER_GET_NEXT' to retrieve next number in range.)

SO10 Standard text editor

SP01 Spool list

SP02 Own spool list

SPAD Spool Administrator

SPAM Support package manager

SPAU Modification adjustment

SPRO IMG

SQ01 Sap Query

ST02 Database Tune Summary

ST04 DB Performance Monitor

STMS Transport Manager

ST22 ABAP Dump Analysis

SU01 User Maintenance

SU53 Retrieve authorisation data for object, execute after error message is displayed(/nsu53)

SUIM User info system (New user, Roles, Authorisations, User tcodes etc..)

SXDA Data transfer workbench

SALE IDoc and ALE development

VOK2 Output determination by functional area / output type (Output programs).

WEDI IDoc and EDI Basis

===============================================================

http://blog.chinaunix.net/u2/63389/showart_495619.html

MM模塊常用T-code MM模塊常用T-code

MM01 - 創建物料主數據

XK01 - 創建供應商主數據

ME11 - 創建採購信息記錄

ME01 - 維護貨源清單

ME51N- 創建採購申請

ME5A - 顯示採購申請清單

ME55 - 批准採購申請（批准組：YH）

ME57 - 分配並處理採購申請

MB21 - 預留

MB24 - 顯示預留清單

ME21N- 創建採購訂單

ME28 - 批准採購訂單（批准組：YS）

ME9F - 採購訂單發送確認

ME2L - 查詢供應商的採購憑證

ME31 - 創建採購協議

MD03 - 手動MRP

MD04 - 庫存需求清單（MD05 - MRP清單）

MRKO - 寄售結算

MELB - 採購申請列表（需求跟蹤號）

ME41 - 創建詢價單

ME47 - 維護報價

ME49 - 價格比較清單

MI31 - 建立庫存盤點憑證

MI21 - 打印盤點憑證

MI22 - 顯示實際盤點憑證內容

MI24 - 顯示實際盤點憑證清單

MI03 - 顯示實際盤點清單

MI04 - 根據盤點憑證輸入庫存計數

MI20 - 庫存差異清單

MI07 - 庫存差額總覽記帳

MI02 - 更改盤點憑證

MB03 - 顯示物料憑證

ME2O - 查詢供應商貨源庫存

MB03 - 顯示物料憑證

MMBE - 庫存總覽

MB5L - 查詢庫存價值餘額清單

MCBR - 庫存批次分析

MB5B - 查詢每一天的庫存

MB58 - 查詢客戶代保管庫存

MB25 - 查詢預留和發貨情況MB51

MB5S - 查詢採購訂單的收貨和發票差異

MB51 - 物料憑證查詢（可以按移動類型查詢）

ME2L - 確認採購單/轉儲單正確

MCSJ - 信息結構S911 採購信息查詢（採購數量/價值、收貨數量/價值、發票數量/價值）

MCBA - 覈對庫存數量,金額

MM04 - 顯示物料改變

MMSC - 集中創建庫存地點

MIGO_GR根據單據收貨:

MB1C - 其它收貨

MB1A - 輸入發貨

MB1B - 轉儲

MB31 - 生產收貨

MB01 - 採購收貨)

MBST - 取消物料憑證

MM60 - 商品清單

ME31L- 創建計劃協議

ME38 - 維護交貨計劃

ME9A - 消息輸出

MB04 - 分包合同事後調整

MB52 - 顯示現有的倉庫物料庫存

MB90 - 來自貨物移動的輸出

CO03 - 顯示生產訂單

IW13 - 物料反查訂單（清單）

IW33 - 顯示維修訂單

VA01 -創建銷售訂單

VL01N - 參照銷售訂單創建外向交貨單

VL02N - 修改外向交貨單（揀配、發貨過帳）

VL09 - 沖銷銷售的貨物移動

VF01 - 出具銷售發票

VF04 - 處理出具發票到期清單

VF11 - 取消出具銷售發票

MVT for MIGO_GR

101 : 一步收貨

103＋105 : 兩步收貨

MVT for MB1A

201 : 發料到成本中心

241 : 從倉庫發貨到資產（在建工程）

261 : 發貨到內部訂單

551 : 爲報廢提取

555 : 自凍結庫報廢

601 : 銷售發貨

653 : 銷售退貨

Z41 : 維修工單發貨

MVT for MB1B

344 : 欲報廢物資先移庫到凍結庫存

411K: 從代銷到本公司的轉帳

541 : 從非限制庫存到分包商庫存的轉儲記帳（委託加工）

555 : 自凍結庫報廢

MTV for MI07（盤點記帳）

701 : 實際盤點－盤盈

702 : 實際盤點－盤虧

================================================================

http://www.sapclub.org/blog/hoarej/archive/2007/11/06/65432.html

SAP ABAP T-code

SM01 Lock transactions 鎖定事務

BCHK DE example (SAP tournaments) DE舉例(SAP競賽)

FAX1 BC sample SAP DE 2.1 BC 示例 SAP DE 2.1

FAX2 BC sample 2 SAP DE 2.1 BC樣品 2SAP DE 2.1

SFAX BC Sales BC銷售

ST01 System Trace 系統軌跡

ST11 Display Developer Traces 開發軌跡顯示

STDA Debugger display/control (server) 調試顯示/控制 (服務器)

STDC Debugger output/control 調試輸出/控制

STDU Debugger display/control (user) 調試顯示/控制 (用戶)

@@D Debugger -> Documentation 調試程序 -> 文檔

@@E Debugger -> ABAP Editor 調試程序 -> ABAP 編輯器

@@O Debugger -> Repository Browser 調試程序 -> 倉庫瀏覽器

@@S Debugger -> Screen Painter 調試程序 -> 屏幕製作器

ICON Display Icons 顯示圖標

SAMT ABAP Program Set Processing ABAP 程序集處理

SICK Installation Check 安裝檢查

SLIN ABAP: Extended Program Check ABAP: 擴展程序檢查

SM28 Installation Check 安裝檢查

SM58 Asynchronous RFC Error Log 異步 RFC 錯誤日誌

SM59 RFC Destinations (Display/Maintain) RFC終點(顯示/維護)

SMT1 Trusted Systems (Display <-> Maint.) 信賴系統 (顯示 <-> 維護)

SMT2 Trusting systems (Display <->Maint.) 信任系統 (顯示 <->維護)

SSMT Modification 2.2 --> 3.0 修改 2.2 --> 3.0

ST22 ABAP/4 Runtime Error Analysis ABAP/4 運行時錯誤分析

SUB% Internal call: Submit via commnd fld 內部調用: 通過命令 fld 提交

SYNT Display Syntax Trace Output 顯示語法跟蹤輸出

SE33 Context Builder 環境生成程序

SE30 ABAP Runtime Analysis ABAP 實時分析

LOPI LOOP AT internal ABAP table 內部 ABAP/4 表格中的循環

LOPJ LOOP AT internal ABAP table 內部 ABAP/4 表格中的循環

RJ10 Test Batch Input (large) 測試批輸入（大量）

RJ11 Test Batch Input (large) 測試批輸入（大量）

SHDB Record batch input 記錄批輸入

SM35 Batch Input Monitoring 批輸入監控

CLJP Specify Japanese calender 指定日語日曆

SE73 SAPscript font maintenance (revised) SAPscript 字體維護(修訂的)

SE74 SAPscript format conversion SAPscript 格式轉化

SE75 SAPscript Settings SAPscript 設置

SE76 SAPscript: Form Translation SAPscript: 翻譯格式

SE77 SAPscript Translation Styles SAPscript 翻譯樣式

SO10 SAPscript: Standard Texts SAPscript:標準文本

SE71 SAPscript form SAP腳本格式

SE72 SAPscript styles SAPscript 樣式

SARP Reporting (Tree Structure): Execute 報表(樹結構)：執行

SART Display Report Tree 顯示報表樹

SERP Reporting: Change Tree Structure 報表：修改樹結構

SA38 ABAP reporting ABAP 報表

SA39 SA38 for Parameter Transaction SA38爲參數傳送

SAR0 Display Standard Reporting Tree 顯示標準報告樹

SC38 Start Report (Remote) 啓動報表程序（遠程）

SE32 ABAP/4 Text Element Maintenance ABAP/4 文本元素維護

SM38 Queue Maintenance Transaction 隊列維護事務

SRCN Delete country-specific reports 刪除指定國家報表

SQ00 ABAP/4 Query: Start Queries ABAP/4 詢問: 開始詢問

SQ01 ABAP/4 Query: Maintain Queries ABAP/4 詢問: 維護詢問

SQ02 ABAP/4 Query: Maintain Funct. Areas ABAP/4 查詢: 維護功能區

SQ03 ABAP/4 Query: Maintain User Groups ABAP/4 查詢: 維護用戶組

SQ07 ABAP/4 Query: Language Comparison ABAP/4 查詢：語言比較

SE11 ABAP/4 Dictionary Maintenance ABAP/4 字典維護

SE12 ABAP/4 Dictionary Display ABAP/4 字典顯示

SE80 Repository Browser 資源庫瀏覽器

SE81 Application Hierarchy 應用層次

SE82 Application Hierarchy 應用層次

SEU Repository Browser 資源庫瀏覽器

SE39 Splitscreen Editor: Program Compare 分屏編輯器: 程序比較

SE38 ABAP Editor ABAP 編輯器

SE40 MP: Standards Maint. and Translation MP：標準維護和翻譯

SE41 Menu Painter 菜單製作

SE43 Maintain Area Menu 保持區域菜單

============================================================

SAP各模快報表T-code大全

http://www.sapsh.com/bbsxp/ShowPost.asp?id=4896 [SAP屠夫]

喜歡研究報表的注意了, 還寫什麼報表? SAP一堆東西可研究的,IS, Drilldown…隨便搞出個change一下就可.

For Customer :

FDI0 Execute Drilldown report

FDI0 Execute Report

FDI1 Create Report

FDI2 Change Report

FDI3 Display Report

FDI4 Create Form

FDI5 Change Form

FDI6 Display Form

FDIB Background Processing

FDIC Maintain Currency Translation Type

FDIK Maintain Key Figures

FDIM Report Monitor

FDIO Transport Reports

FDIP Transport Forms

FDIQ Import Reports

FDIR Import Forms

FDIT Translation Tool - Drilldown Report

FDIV Maintain Global Variable

FDIX Reorganize Drilldown Reports

FDIY Reorganize Report Data

FDIZ Reorganize Forms

For Vendor :

FKI0 Execute Report

FKI1 Create Report

FKI2 Change Report

FKI3 Display Report

FKI4 Create Form

FKI5 Formular 鋘dern

FKI6 Display Form

FKIB Background Processing

FKIC Maintain Currency Translation Type

FKIK Maintain Key Figures

FKIM Report Monitor

FKIO Transport Reports

FKIP Transport Forms

FKIQ Import Reports

FKIR Import Forms

FKIT Translation Tool - Drilldown Report.

FKIV Maintain Global Variable

FKIX Reorganize Drilldown Reports

FKIY Reorganize Report Data

FKIZ Reorganize Forms

For GL:

FSI0 Execute report

FSI1 Create Report

FSI2 Change Report

FSI3 Display Report

FSI4 Create Form

FSI5 Change Form

FSI6 Display Form

FSIB Background processing

FSIC Maintain Currency Translation Type

FSIG Balance Sheet Reports Criteria Group

FSIK Maintain Key Figures

FSIM Report Monitor

FSIO Transport reports

FSIP Transport forms

FSIQ Import reports from client 000

FSIR Import forms from client 000

FSIT Translation Tool - Drilldown Report.

FSIV Maintain Global Variable

FSIX Reorganize Drilldown Reports

FSIY Reorganize report data

FSIZ Reorganize forms

FGI0 Execute Report

FGI1 Create Report

FGI2 Change Report

FGI3 Display Report

FGI4 Create Form

FGI5 Change Form

FGI6 Display Form

FGIB Background Processing

FGIC Maintain Currency Translation Type

FGIK Maintain Key Figures

FGIM Report Monitor

FGIO Transport Reports

FGIP Transport Forms

FGIQ Import Reports

FGIR Import Forms

FGIT Translation Tool - Drilldown Report.

FGIV Maintain Global Variable

FGIX Reorganize Drilldown Reports

FGIY Reorganize Report Data

FGIZ Reorganize Forms

For PS :

CJE0 Run Hierarchy Report

CJE1 Create Hierarchy Report

CJE2 Change Hierarchy Report

CJE3 Display Hierarchy Report

CJE4 Create Project Report Layout

CJE5 Change Project Report Layout

CJE6 Display Project Report Layout

CJEA Call Hierarchy Report

CJEB 'Background Processing, Hier.Reports'

CJEC Maintain Project Crcy Trans.Type

CJEK Copy Interfaces/Reports

CJEM Project Reports: Test Monitor

CJEN Reconstruct: Summarized Proj.Data

CJEO Transport Reports

CJEP Tranport Forms

CJEQ Import Reports from Client

CJET Translation Tool - Drilldown

CJEV Maintain Global Variable

CJEX Reorganize Drilldown Reports

CJEY Reorganize Report Data

CJEZ Reorganize Forms

For Org. Unit

CXR0 Run drilldown report

CXR1 Create drilldown report

CXR2 Change drilldown report

CXR3 Display drilldown report

CXR4 Form for creating reports

CXR5 Form for changing reports

CXR6 Form for displaying reports

CXRA Maintain Variant Groups

CXRB Maintain Variants

CXRC Schedule Variant Groups

CXRD Create Variant Groups

CXRE Reorganization of Variant Groups

CXRF Characteristic Group Maintenance

CXRH Hierarchy Maintenance

CXRI Overview of Reports

CXRK Maintain Key Figures

CXRM Test monitor - drilldown reports

CXRO Transport reports

CXRP Transport forms

CXRQ Import Reports

CXRR Import Layouts

CXRT Translation Tool - Drilldown Reports

CXRU Cross-table translation keys

CXRV Maintain global variables

CXRW Convert Drilldown Reports

CXRX Reorganize Drilldown Reports

CXRY Reorganize report data

CXRZ Reorganize Forms

For Real estate

FOE6 Run drilldown report

FOE7 Create drilldown report

FOE8 Change drilldown report

FOE9 Display drilldown report

For FM

FME1 Import Forms

FME2 Import Reports

FME3 Transport Forms

FME4 Transport Reports

FME5 Reorganize Forms

FME6 Reorganize Drilldown Reports

FME7 Reorganize Report Data

FME8 Maintain Batch Variants

FME9 Translation Tool - Drilldown

FMEB Structure Report Backgrnd Processing

FMEH SAP-EIS: Hierarchy Maintenance

FMEK FMCA: Create Drilldown Report

FMEL FMCA: Change Drilldown Report

FMEM FMCA: Display Drilldown Report

FMEN FMCA: Create Form

FMEO FMCA: Change Form

FMEP FMCA: Display Form

FMEQ FMCA: Run Drilldown Report

FMER FMCA: Drilldown Tool Test Monitor

For Treasure模塊

TRMO Transport reports

TRMP Transport forms

TRMQ Import reports

TRMR Import forms

TRMS Display Structure

TRMS_ALL Display Structures

TRMS_SINGLE Display Structures

TRMT Translation Tool - Drilldown Report.

TRMT_TEXTS_GENERATE Generates the Text Reader

TRMU Convert Drill Down Reports

TRMV Maintain Global Variable

TRMW Maintain currency exchange type TRM

TRMX Reorganize Drilldown Reports

TRMY Reorganize report data

TRMZ Reorganize Forms

For LIS系統

REL0 Run Drilldown Report

REL1 Create Drilldown Report

REL2 Change drilldown report

REL3 Display Drilldown Report

REL4 Create form

REL5 Change form

REL6 Display form

REL7 Maintain Key Figures

REL8 Overview of Reports

RELH Data-Mining: Create form

RELI Data-Mining: Change form

RELJ Data-Mining: Display form

RELK Print and actualize reports

RELL Maintain batch variants

RELM Test monitor drill-down reports

RELN Maintain characteristic values

RELO Transport reports

RELP Transport

RELQ Import reports

RELR Import forms

RELS reorganize forms

RELT Translation tools - drill-down

RELU EIS/BP: Transfer generation

RELV Maintain global variable

RELW Maintain currency translation key

RELX Reorganize drill-down reports

RELY Reorganize report data

RELZ Convert drilldown reports

For Production

KKO0 Run Drilldown Report

KKO1 Create Drilldown Report

KKO2 Change Drilldown Report

KKO3 Display Drilldown Report

KKO4 Create Form

KKO5 Change Form

KKO6 Display Form

KKO7 Maintain Key Figures

KKO8 Background Processing of Reports

KKOB Basic Functions of Cost Object Contr

KKOG Characteristic Groups for Costing

KKOH Transport of Reports

KKOI Transport of Forms

KKOJ Client Copy of Reports

KKOK Client Copy of Forms

KKOM Test Monitor Object Record Reports

KKON Reorganization of Report Data

KKOO Reorganization of Reports

KKOP Reorganize Forms

KKOR Report Selection

KKOT Split Report

For Cost object Hierarchy :

KKML0 Run Drilldown Report

KKML1 Create Drilldown Report

KKML2 Change Drilldown Report

KKML3 Display Drilldown Report

KKML4 Create Form

KKML5 Change Form

KKML6 Display Form

KKML7 Maintain Key Figures

KKML8 Background Processing of Reports

KKMLH Transport of Reports

KKMLI Transport of FormsFor CO-PAKCR0 Run Drilldown Report

KCR1 Create Drilldown Report

KCR2 Change drilldown report

KCR3 Display Drilldown Report

KCR4 Create form

KCR5 Change form

KCR6 Display form

KCRA Maintain variant table

KCRB Maintain variable groups

KCRC Print/actualize reports

KCRD Maintain Variants RKCBATCH

KCRE Maintain Global Variables

KCRF Maintain Char.Grps for SAP-EIS Rep.

KCRG Maint.view for curr.transl./fld cat.

KCRH Maint.view for curr.transl./key fig.

KCRP Maintain variant groups

KCRQ Maintain variants

KCRR Report selection

KCRS Schedule Variant Group

KCRT Define Variant Group

KCRU Convert drilldown reports

For IM模塊

IME0 Execute Inv. Program Report

IME1 Create cap.inv.program report

IME2 Change cap.inv.program report

IME3 Display cap.inv.prog. report

IME4 Create layout set for inv.prog. rep.

IME5 Change layout set for inv.prog. rep.

IME6 Display layout set for inv.prog.rep.

IME8 Client transport-inv. prog.reports

IME9 Client transport of forms

IMEB Background processing of reports

IMEC Maint. of currcy.conv. type inv.prg.

IMEG Generate User-Defined Characteristic

IMEK Maintain Key Figures

IMEM Test monitor - inv. prog. reports

IMEO Transport inv. prog. reports

IMEO1 Create Inv.Program in Enterprise Org

IMEO2 Change Inv.Program in Enterp. Org.

IMEO3 Display Inv.Program in Enterp. Org.

IMEO_GEN Generate Inv.Program frm Ent.Organiz

IMEP Transport forms for inv. program

IMEQ Import inv.prog. rep.

IMER Import forms

IMET Transl. tool - Dr.-down rep. inv.prg

IMEU Euro conversion: IM postproces.prog.

IMEV Maintain global variables

IMEX Reorganize invest. program reports

IMEY Reorganize inv. prog. report data

IMEZ Reorganize forms for inv.prog.report

For IM Summarization .

IMC0 Execute Report

IMC1 Create report

IMC2 Change report

IMC3 Display report

IMC4 Create form

IMC5 Change form

IMC6 Create form

IMC8 Client copy report

IMC9 Client copy form

IMCAOV Budget Carryfwd for Inv.Programs

IMCB Background report

IMCC Curr. transl. type

IMCK IM Summariz: Calculated key figures

IMCM IM Summariz: Test monitor f. reports

IMCO Transport reports

IMCP Transport forms

IMCT IM Summar: Translation of drilldowns

IMCTST IMC Test Monitor

IMCTX Intermode Communication

IMCU Config. menu Investment Management

IMCV Global variables

IMCX Reorg. reports

IMCY Reorg. report data

IMCZ Reorg. forms

For AppropriationIMD0 Execute report

IMD1 Create report

IMD2 Change report

IMD3 Display report

IMD4 Create form

IMD5 Change form

IMD6 Display form

IMD8 Client copy report

IMD9 Client copy form

IMDB Execute report in backgrnd

IMDC App. req: Currency translation key

IMDG Generate User-Defined Characteristic

IMDK Calculated key figures

IMDM Test monitor report

IMDO App. req: Transport reports

IMDP App. req: Transport forms

IMDT App. req: Translate drilldown

IMDV App. req: Global variables

IMDX App. req: Reorganization reports

IMDY App. req: Reorganization report data

IMDZ App. req: Reorganization of forms

For UnknownFXI0 Execute Report

FXI1 Create Report

FXI2 Change Report

FXI3 Display Report

FXI4 Create Form

FXI5 Change Form

FXI6 Display Form

FXIB Background Processing

FXIC Maintain Currency Translation Type

FXIK Maintain Key Figures

FXIM Report Monitor

FXIO Transport Reports

FXIP Transport Forms

FXIQ Import Reports

FXIR Import Forms

FXIT Translation Tool - Drilldown Report.

FXIV Maintain Global Variable

FXIX Reorganize Drilldown Reports

FXIY Reorganize Report Data

FXIZ Reorganize Forms This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

訂閱：文章 (Atom)

2020年12月24日 星期四

2020年12月23日 星期三

2020年11月30日 星期一

2020年11月24日 星期二

"alter table move tablespace" tips

Identifying Oracle Tables with Migrated/Chained Rows

2020年10月30日 星期五

2020年10月28日 星期三

2020年12月24日星期四

2020年12月23日星期三

2020年11月30日星期一

2020年11月24日星期二

2020年10月30日星期五

2020年10月28日星期三