The Function Group SDB2 (Database catalog modifications) is a standard Function Group in SAP ERP and is part of the package SDIC. It contains the following embedded function modules and dictionary objects.
| Function Group | SDB2 |
| Short Text | Database catalog modifications |
| Package | SDIC |
Function Group SDB2 contains 69 function modules.
| DB_ADD_TABLE_FIELDS | Fügt Felder an eine bestehende Tabelle an |
|---|---|
| DB_ALTER_INDEX_STORAGE | Verändert die Speicherparameter eines Index |
| DB_ALTER_INDSTORAGE | Verändert die Speicherparameter eines Index |
| DB_ALTER_TABLE | Alter Table für DB-Tabellen (Mächtigkeit DBS-abhängig) |
| DB_ALTER_TABLE_S | As DB_ALTER_TABLE, also returns the generated statements |
| DB_ALTER_TABLE_STORAGE | Verändert die Speicherparameter einer Tabelle |
| DB_ALTER_TABSTORAGE | Verändert die Speicherparameter einer Tabelle |
| DB_CLEAR_INDEX_PARAMETER | Loescht die Index-Speicherparameter aus DD12dbs |
| DB_CLEAR_TABLE_PARAMETER | Loescht die Tabellen-Speicherparameter aus DD02dbs |
| DB_COMPARE_DBFIELD | Vergleicht zwei Tabellen vom Typ DBFIELD |
| DB_CREATE_INDEX | Legt einen Index auf der Datenbank an |
| DB_CREATE_INDEX_S | As DB_CREATE_INDEX, also returns the generated statements |
| DB_CREATE_PRIMARY_INDEX | Lege zu einer transparenten Tabelle den Primärindex an |
| DB_CREATE_QCM8TABLE | |
| DB_CREATE_QCM8TABLE_S | |
| DB_CREATE_TABLE | Legt eine Tabelle auf der Datenbank an |
| DB_CREATE_TABLE_AS_SELECT | |
| DB_CREATE_TABLE_AS_SELECT_S | |
| DB_CREATE_TABLE_S | As DB_CREATE_TABLE, also returns the generated statements |
| DB_CREATE_VIEW | Legt einen View auf der Datenbank an |
| DB_CREATE_VIEW_S | As DB_CREATE_VIEW, also returns generated statements. |
| DB_DATA_MOVE | DD: Copy data with Move Corresponding |
| DB_DATA_SCAN | |
| DB_DELETE_POOLTAB | Delete pooled tables |
| DB_DELETE_POOLTAB_S | Generates SQL code for deleting pooled tables from the table pool |
| DB_DROP_INDEX | Loescht einen Index auf der Datenbank |
| DB_DROP_INDEX_CNV | |
| DB_DROP_INDEX_CNV_S | |
| DB_DROP_INDEX_S | As DB_DROP_INDEX, basically returns the generated statements |
| DB_DROP_TABLE | Deletes a table in the database |
| DB_DROP_TABLE_S | As DB_DROP_TABLE, basically returns the generated statements |
| DB_DROP_VIEW | Deletes a view in the database |
| DB_DROP_VIEW_S | As DB_DROP_VIEW, basically returns the generated statements |
| DB_GET_INDEX_PARAMETER | Funtionsbaustein zum lesen der DB-Indexparameter |
| DB_GET_IPARAM_SOURCES | Liefert die vorhandenen Quellen für die Index-Speicherparameter |
| DB_GET_TABLE_PARAMETER | Funktionsbausteine zum lesen von DB-Speicherparametern |
| DB_GET_TABLE_SIZE | |
| DB_GET_TPARAM_SOURCES | Liefert die vorhandenen Quellen für die Tabellen-Speicherparameter |
| DB_INSERT_SELECT | |
| DB_INSERT_SELECT_S | |
| DB_MAP_DDFIELDS | Maps a table of DD fields onto the DB fields |
| DB_MAP_DDTYPE | Bildet einen DD-Typ auf einen DB-Typ ab |
| DB_MODIFY_FIELD_OK | Testet, ob eine Konvertierung zwischen 2 Typen mit Alter möglich ist |
| DB_RENAME_INDEX | |
| DB_RENAME_INDEX_S | |
| DB_RENAME_TABLE | Umbenennen einer Tabelle auf der Datenbank (Alter Name -> Neuer Name) |
| DB_RENAME_TABLE_S | like DB_RENAME_TABLE, but returns the statements to the calling program |
| DB_SET_DDLGEN_CODEPAGE_KIND | |
| DB_SET_INDEX_PARAMETER | Berechnen und Ablegen von Index-Speicherparametern in DD12dbs |
| DB_SET_TABLE_PARAMETER | Berechnen und Ablegen von Tabellen-Speicherparametern in DD02dbs |
| DB_STORAGE_CLEAR | Provides storage clause for tables and indexes |
| DB_STORAGE_GET | Provides storage clause for tables and indexes |
| DB_STORAGE_PUT | Provides storage clause for tables and indexes |
| DB_STORAGE_SAVE | Provides storage clause for tables and indexes |
| DB_TABLE_SET_LOCK | DD: Set an exclusive table lock with return of statement |
| DB_TRUNCATE_TABLE | |
| DD_ALTER_STRUC_ASCII_LC | |
| DD_CALL_DB_SQL | Fct. module which executes the SQL statements for an internal table |
| DD_CREATE_STRUC_WITH_KEY_LC | |
| DD_CREATE_TABLE_LC | |
| DD_DBNT_TO_SAPNT_MAP | Bildet aus der Datenbankbeschreibung eine SAP-NAMETAB |
| DD_DROP_INDEX | |
| DD_MX_MERGE | DD: Copy Back Dependencies of Multiplex Tables |
| DD_STOR_AFTER_IMP | After-Import-Methode des Transportobjekts SPAR |
| DD_STOR_BEFORE_EXP | Before-Export-Methode des Transportobjekts SPAR |
| DD_SUB_ROUT_POOL | DD: stored generation of subroutine pools |
| DD_TEMPNAME_GEN | DD: Computation of temporary names for tables and reports |
| DD_TGORA_IGORA_SETTING | DD: definition of TGOR and IGORA contents |
| WRITE_AND_CALL_DBPROG | Writes a program generated in Fgrp SDB2 and executes it |