Menu

SAP Function Module DB_ALTER_TABLE_S

As DB_ALTER_TABLE, also returns the generated statements

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The Function Module DB_ALTER_TABLE_S (As DB_ALTER_TABLE, also returns the generated statements) is a standard Function Module in SAP ERP and is part of the function group SDB2 within the package SDIC.

Technical Information

Function Module DB_ALTER_TABLE_S
Short Text As DB_ALTER_TABLE, also returns the generated statements
Function Group SDB2
Package SDIC
Module Type Normal Module

Importing Parameters

These are the IMPORTING parameters of this function module.

Parameter Name Type Associated Type Default Value Short Text
DBSYS LIKE SY-DBSYS SY-DBSYS
NO_EXEC LIKE SPACE
NO_PROG LIKE SPACE
PRID LIKE SY-TABIX 0
PROGNAME LIKE TRDIR-NAME SPACE Name of gen. program
TABNAME LIKE DD02L-TABNAME

Exporting Parameters

These are the EXPORTING parameters of this function module.

Parameter Name Type Associated Type Default Value Short Text
GENPROG LIKE TRDIR-NAME

Changing Parameters

This function module does not define any CHANGING parameters.

Table Parameters

These are the TABLE parameters of this function module.

Parameter Name Type Associated Type Default Value Short Text
DDFIELDS_NEW LIKE DDFIELD Table of the new DD table fields
DDFIELDS_OLD LIKE DDFIELD Table of the old DD table fields
STATEMENTS LIKE Table of the generated statements

Exceptions

These are the Exceptions of this function module.

Exception Name Short Text
ALTER_NOT_NECESSARY No DB-relevant changes
ALTER_NOT_POSSIBLE Change not possible with Alter Table
PROGRAM_NOT_GENERATED Program could not be generated
PROGRAM_NOT_WRITTEN Program could not be written
TABLE_DOES_NOT_EXIST Table does not exist
TABLE_NOT_ALTERED Error changing the table