PageOutline {{{#!comment -------------------- 以上的部份是固定的，不要變動 ----- --------------------------------------- 在建立連結時，請標明連結的頁面類型，例如：wiki:WikiStart，而不要只用 WikiStart ----- }}}

SE11Table

• Dictionary/ Display Table
• 管理 Table
• 通常由 SE11 進入

建立Index

• 當建立 table 時就會建立主鍵的 index
• 在 ABAP 中可用 「table名稱~index名稱」的方式來指定使用那個 index
• index 的名稱是三個英數字組成，「0」開頭是系統所建立的預設 index。自訂的以 「Y] 及 「Z」開頭。
• Indexes...
• Non-unique index
• Index in all database systems * The index is always created in the database.(會在DB中建立實體index table)
• In selected database systems * The index is created depending on the database system used. In this option, you must specify the databases in which the indexes are to be created. You can do this either on an inclusive (list of systems on which it should be created) or an exclusinve (list of systems on which it should not be created) basis. In either case, you can list up to four different database systems.
• No database index * The index is not created in the database. If you set this option for an index that already exists in the database, it is deleted when you activate the table in the ABAP Dictionary.
• Unique index(database index required)
• Unique indexes have an extra function, and must therefore always be created in the database. The database system prevents entries or index fields being duplicated. Since programs may rely on this database function, you cannot delete unique indexes from the database. (建立時FIELD NAME中必須填mandt)

Table Maintain

1. Delivery and Maintenance -> Data Browser/Table View Maint.

• 設成 ： X Display/Maintenance Allowed

1. Utilities -> Table Maintenance Generator

• 建立 Table Maintain，會連至 wiki:SE55

1. 可透過 SM30 使用 Table Maintain

• 請見 Table Maintenance

Table Enhancement

• 可參考 Enhancement
• Append Structure

Customer Documentation

• 可參考 Enhancement
• 進入 Data Element 的修改視窗 -> Supplementary Documentation
• 在此新增的文件是多加一份，而非取代。可在按下「F1」後用「上一頁」或「下一頁」來切換不同的文件。

{{{#!comment -------------------- 以下的部份是固定的，不要變動 ----- }}}

• wiki:tagDataIndex