TABLES ( SAP ABAP Keyword)

TABLES

Basic form

TABLES dbtab.

Effect

Makes the database table ,
view or structure dbtab
known to the program. These objects are created by selecting
Development -> ABAP/4 Dictionary . This transaction
automatically defines an identical field string - the table work
area - in the program. The names and the sequence of the fields of
the table work area dbtab correspond exactly to the names and
the sequence of the fields when declaring the database table or view in
the ABAP/4 Dictionary . The ABAP/4 data type (see
DATA ) and the length of the fields are
derived from the data types in the ABAP/4 Dictionary as follows:

Dict. data type	ABAP/4 data type
ACCP	-> N(6)
CHAR n	-> C(n)
CLNT	-> C(3)
CUKY	-> C(5)
CURR n, m, s	-> P((n + 2) / 2) DECIMALS m [NO-SIGN]
DEC n, m, s	-> P((n + 2) / 2) DECIMALS m [NO-SIGN]
DATS	-> D
FLTP	-> F
INT1	-> No correspondence
INT2	-> No correspondence
INT4	-> I
LCHR n	-> C(n)
LRAW n	-> X(n)
LANG	-> C(1)
NUMC n	-> N(n)
PREC	-> X(2)
QUAN n, m, s	-> P((n + 2) / 2) DECIMALS m [NO-SIGN]
RAW n	-> X(n)
TIMS	-> T
UNIT n	-> C(n)
VARC n	-> C(n)

The fields of the table work area are set to the initial values for
their ABAP/4 data types (see DATA ). For
the ABAP/4 Dictionary data types INT1 and INT2 ,
whole number fields of length 1 or 2 are created with the initial value
0 in the table work area.

The length of the table work area is not just the sum of the lengths
of the individual fields. Depending on how different fields have to be
aligned (Alignment ), the structure can contain
nameless "holes".

Example

TABLES SPFLI.

SELECT * FROM SPFLI.
 WRITE: / SPFLI-CARRID, SPFLI-CONNID.
ENDSELECT.

Notes

You can display the structure of the table work area in
the ABAP/4 Editor by double-clicking on the table name.



The divisions for determining ABAP/4 field lengths are whole
number divisions without rounding. The field of the table work area can
accept numbers which contain one digit more than the ABAP/4
Dictionary data type allows. Such a situation results in a runtime
error when writing to the database.



The table work area always has a global validity area. Even if the
TABLES statement is specified in a FORM or
FUNCTION , the work area is known when the subroutine has been
defined. However, changes to the work area in a subroutine remain local
to the FORM or FUNCTION . Therefore, it is advisable to
specify the TABLES statement globally. You can keep changes to
the table work area local to the subroutine with LOCAL .

Related 10 ABAP Syntax Tutorials

• RECEIVE (ABAP Keyword)
• FREE (ABAP keyword)
• WINDOW ( SAP ABAP keyword)
• WRITE - Output as icon ( SAP ABAP Keyword)
• SUMMARY ( SAP ABAP Keyword)
• ENDWHILE (ABAP Keyword)
• REPLACE (ABAP Keyword)
• PERFORM (ABAP Keyword)
• STATICS ( SAP ABAP Keyword)
• RESERVE (ABAP Keyword)

Most readed SAP Tutorials

• List of SAP HR TABLES and Infotypes tables
  Detailed full list of tables and infotypes used in SAP HR module.
• WRITE - Output to a list ( SAP ABAP Keyword)
  WRITE ( Output to a list ) is a keyword used in SAP ABAP programming.This tutorial covers its introduction & syntax details.
• List of SAP MM Transaction codes
  This documentation covers the details of SAP MM Transaction codes
• SELECT-OPTIONS ( SAP ABAP Keyword)
  SELECT-OPTIONS is a keyword used in SAP ABAP programming.This tutorial covers its introduction & syntax details.
• SAP MM Process Flow
  The typical procurement cycle for a service or material consists of the following phases:
• FI Accounts Receivable and Accounts Payable | SAP FI PDF manual
  The following topics are an introduction to the Accounts Receivable and Accounts Payable application components.
• SELECT clause ( SAP ABAP Keyword)
  SELECT clause is a keyword used in SAP ABAP programming.This tutorial covers its introduction & syntax details.

Latest Added SAP documents

• 9KE9 Transaction code
  Details about SAP transaction code 9KE9
• 9KE8 Transaction code
  Details about SAP transaction code 9KE8
• 9KE7 Transaction code
  Details about SAP transaction code 9KE7
• 9KE6 Transaction code
  Details about SAP transaction code 9KE6
• 9KE5 Transaction code
  Details about SAP transaction code 9KE5
• 9KE4 Transaction code
  Details about SAP transaction code 9KE4
• 9KE3 Transaction code
  Details about SAP transaction code 9KE3
• 9KE2 Transaction code
  Details about SAP transaction code 9KE2
• 9KE1 Transaction code
  Details about SAP transaction code 9KE1
• 9KE0 Transaction code
  Details about SAP transaction code 9KE0