SAP ABAP Data Element TBNAME (iSeries: SQL Name of Table or View)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Data Element	TBNAME
Short Description	iSeries: SQL Name of Table or View

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	AS4TAB
Data Type	CHAR	Character String
Length	30
Decimal Places	0
Output Length	30
Value Table	DD02L

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	11	SQL Name
Medium	21	SQL Name of Tab/View
Long	41	SQL Name of Table or View
Heading	55	SQL Name of Table or View

Documentation

Definition

Name of the table or view. This is the SQL name as specified in the CREATE statement.
An SQL table or view name can be up to 128 characters long (the ABAP Dictionary allows up to 30 characters), but an iSeries object name can have only 10 characters. If a name longer than 10 characters is specified with the CREATE statement, automatic mapping is done using the first five characters of the SQL name specified and a generated 5 digit number for the iSeries system name of the object created.
For SQL statements both the SQL name and the iSeries system name can be used.

Example

The statement
        CREATE TABLE CUSTOMER_ORDER
            (ORDER_NO CHAR (10) NOT NULL WITH DEFAULT,
            POSITION_NO CHAR (10) NOT NULL WITH DEFAULT
            ...)
creates a table with SQL name CUSTOMER_ORDER and iSeries system name CUSTO00001. (If the name CUSTO0001 is already used for another object in the library, the iSeries system name is different).

History

Last changed by/on	SAP	20070813
SAP Release Created in