Entering content frame

Syntax documentation column_descriptor Locate the document in its SAP Library structure

Syntax Rules for Column Descriptions

Syntax

<column_descriptor> ::= <valCOLUMN_NAME> <field_pos> <format_spec>

valCOLUMN_NAME

Column name
Specify it according to the SQL conventions. It can also contain the table name as a prefix (such as, customer.cno).

Use

In a command to load application data, you can use this syntax rule to assign a data field of the data stream to a column of the target table. To do this, you specify the column name, the position, and the external data type of the data in the data stream.

Example

DATALOAD TABLE article
  ano         01-08 CHAR
  descr       09-39 CHAR
  stock      40-43 INTEGER
  min_ord     44-45 INTEGER
  ordered     46-49 INTEGER
  del_date 50-57 CHAR
  price       58-65 DECIMAL (2)
  weight      66-69 REAL
INFILE 'article.data' FORMATTED

Leaving content frame