Entering content frame

Syntax documentation column_id Locate the document in its SAP Library structure

Syntax Rules for Column Descriptions

Syntax

<column_id> ::= <valCOLUMN_NAME> | <valCOLUMN_ID>

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).

valCOLUMN_ID

Column ID

Use

In a command for unloading application data, use it to assign a column of the source table to a data field of the data stream.

Example

DATAEXTRACT cno, name, zip, place FROM customer
OUTFIELDS
  cno       01-04
  name    
06-12
  zip       
14-18
  place     
20-31
OUTFILE 'customer.data' FORMATTED

The column number valCOLUMN_ID indicates the position of the column in the SELECT statement.

Example

DATAEXTRACT cno, name, zip, place FROM customer
OUTFIELDS
  1  01-04
  2  06-12
  3  14-18
  4  20-31
OUTFILE 'customer.data' FORMATTED

Leaving content frame