SAP Reports / Programs | Basis Components | ABAP Workbench, Java IDE and Infrastructure | Activation Program, Conversion Program, DB Utility, MC, SPDD(BC-DWB-DIC-AC) SAP BC
SDBXTEST SAP ABAP Report - Test of SDBx - Function Groups, Generating DDL
SDBXTEST is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter SDBXTEST into the relevant SAP transactions such as SE38 or SE80
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT SDBXTEST. "Basic submit
SUBMIT SDBXTEST AND RETURN. "Return to original report after report execution complete
SUBMIT SDBXTEST VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: TABNAME = Table Name
Selection Text: PROG = Name of generated program
Selection Text: NO_EXEC = Do not execute program
Selection Text: KAT = Category (create)
Selection Text: INDNAME = Index identifier
Selection Text: FUNC2 = Drop/create/alter/stor. par.
Selection Text: FUNC1 = Exist./Field def./Field names
Selection Text: DBSYS = Database system
Selection Text: ART = Data type (create)
Selection Text: ALTNULLA = New fields nullable (alter)
Selection Text: ALTERMOD = Modify every nth field (alter)
Selection Text: ALTERADD = Add every nth field (alter)
Title: Test of SDBx - Function Groups, Generating DDL
Text Symbol: B02 = not found
Text Symbol: B01 = ERROR: program
Text Symbol: A03 = and executed
Text Symbol: A02 = stored
Text Symbol: A01 = Program in
Text Symbol: 100 = No fields for
Text Symbol: 030 = Statements passed on to STMT_TAB
Text Symbol: 011 = Function not allowed
Text Symbol: 010 = No fields for
Text Symbol: 009 = does not exist
Text Symbol: 008 = can only be tested on underlying DBSYS
Text Symbol: 007 = Unanticipated RC
Text Symbol: 005 = exists
Text Symbol: 003 = does not exist
Text Symbol: 002 = During test execute DB operations only for INTTABS
Text Symbol: 001 = Table not active
INCLUDES used within this REPORT SDBXTEST
No INCLUDES are used within this REPORT code!
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
DD_INDEX_NAME CALL FUNCTION 'DD_INDEX_NAME' EXPORTING TABNAME = TABNAME INDEXNAME = INDNAME IMPORTING DBINDEX = DBINDEX.
DB_SET_TABLE_PARAMETER CALL FUNCTION 'DB_SET_TABLE_PARAMETER' EXPORTING TABNAME = TABNAME SOURCE = 'TST' USEFLAG = 'X' TABKAT = KAT TABART = ART DBSYS = DBSYS.
DD_INDEX_NAME CALL FUNCTION 'DD_INDEX_NAME' EXPORTING TABNAME = TABNAME INDEXNAME = '0' IMPORTING DBINDEX = DBINDEX.
DB_SET_INDEX_PARAMETER CALL FUNCTION 'DB_SET_INDEX_PARAMETER' EXPORTING DBINDEX = DBINDEX TABNAME = TABNAME SOURCE = 'TST' USEFLAG = 'X' TABKAT = KAT TABART = ART DBSYS = DBSYS.
DB_DROP_TABLE_S CALL FUNCTION 'DB_DROP_TABLE_S' EXPORTING TABNAME = TABNAME NO_EXEC = NO_EXEC DBSYS = DBSYS IMPORTING GENPROG = GENPROG SUBRC = RC TABLES STATEMENTS = STMT_TAB.
DB_CREATE_TABLE_S CALL FUNCTION 'DB_CREATE_TABLE_S' EXPORTING TABNAME = TABNAME NO_EXEC = NO_EXEC DBSYS = DBSYS PROGNAME = PROG IMPORTING GENPROG = GENPROG TABLES DDFIELDS = DDFIELDS STATEMENTS = STMT_TAB.
DB_ALTER_TABLE_S CALL FUNCTION 'DB_ALTER_TABLE_S' EXPORTING DBSYS = DBSYS NO_EXEC = 'X' "nie ausführen! PROGNAME = PROG TABNAME = TABNAME IMPORTING GENPROG = GENPROG TABLES DDFIELDS_NEW = DDFIELDS DDFIELDS_OLD = DDFIELD_OLD STATEMENTS = STMT_TAB EXCEPTIONS ALTER_NOT_NECESSARY = 01 ALTER_NOT_POSSIBLE = 02.
DB_ALTER_TABLE_STORAGE CALL FUNCTION 'DB_ALTER_TABLE_STORAGE' EXPORTING TABNAME = TABNAME NO_EXEC = NO_EXEC DBSYS = DBSYS IMPORTING GENPROG = GENPROG.
DB_EXISTS_TABLE CALL FUNCTION 'DB_EXISTS_TABLE' EXPORTING TABNAME = TABNAME IMPORTING SUBRC = RC.
DB_GET_TABFIELDS
DB_GET_TABLE_FIELDS * CALL FUNCTION 'DB_GET_TABFIELDS' "KUGL, 220894, replaced CALL FUNCTION 'DB_GET_TABLE_FIELDS' EXPORTING TABNAME = TABNAME FIELD_INFO = 'N' "get only names IMPORTING SUBRC = RC TABLES DBFIELDS = DBFIELDS.
DB_GET_TABLE_FIELDS CALL FUNCTION 'DB_GET_TABLE_FIELDS' EXPORTING TABNAME = TABNAME FIELD_INFO = 'A' IMPORTING SUBRC = RC TABLES DBFIELDS = DBFIELDS.
DB_SET_INDEX_PARAMETER CALL FUNCTION 'DB_SET_INDEX_PARAMETER' EXPORTING DBINDEX = DBINDEX TABNAME = TABNAME SOURCE = 'TST' USEFLAG = 'X' TABKAT = KAT TABART = ART DBSYS = DBSYS.
DB_DROP_INDEX_S CALL FUNCTION 'DB_DROP_INDEX_S' EXPORTING TABNAME = TABNAME DBINDEX = DBINDEX NO_EXEC = NO_EXEC DBSYS = DBSYS IMPORTING GENPROG = GENPROG SUBRC = RC TABLES STATEMENTS = STMT_TAB.
DB_CREATE_INDEX_S CALL FUNCTION 'DB_CREATE_INDEX_S' EXPORTING TABNAME = TABNAME DBINDEX = DBINDEX UNIQUE = DD12V-UNIQUEFLAG NO_EXEC = NO_EXEC PROGNAME = PROG DBSYS = DBSYS IMPORTING GENPROG = GENPROG TABLES DDFLDNAMES = DDFLDNAMES STATEMENTS = STMT_TAB.
DB_ALTER_INDEX_STORAGE CALL FUNCTION 'DB_ALTER_INDEX_STORAGE' EXPORTING DBINDEX = DBINDEX TABNAME = TABNAME NO_EXEC = NO_EXEC DBSYS = DBSYS IMPORTING GENPROG = GENPROG.
DB_EXISTS_INDEX CALL FUNCTION 'DB_EXISTS_INDEX' EXPORTING DBINDEX = DBINDEX IMPORTING SUBRC = RC.
DB_GET_INDEX_FIELDS CALL FUNCTION 'DB_GET_INDEX_FIELDS' EXPORTING DBINDEX = DBINDEX IMPORTING SUBRC = RC TABLES DBFLDNAMES = DBFLDNAMES.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name SDBXTEST or its description.
SDBXTEST - Test of SDBx - Function Groups, Generating DDL SDBXTEST - Test of SDBx - Function Groups, Generating DDL SDBUPDEXCL_MAINTAIN - Maintain SDBUPDEXCL SDBUPDEXCL_MAINTAIN - Maintain SDBUPDEXCL SDBSYSINFO - documentation and ABAP source code SDBON_CHECK_IM - Check Report for Comparison of SD Index / Selection Using Appl. Tables