Entering content frame

Background documentation Table Description Locate the document in its SAP Library structure

The syntax rules listed here are components of the table description in the commands for loading and unloading application data.

Note

If you want to use keywords as table or user names, you must place them in double quotation marks.

Syntax

<table_spec> ::= <table_name> <if_condition>

<table_name> ::= <valTABLE_NAME> | <valTABLE_OWNER>.<valTABLE_NAME>

<if_condition> ::= IF <condition> | OTHERWISE

valTABLE_NAME

Name of the table

Specify the table name in accordance with the SQL conventions. You can also define a user name as a prefix.

valTABLE_OWNER

Owner of the table

Explanation

<table_spec>, <table_name>

You use the syntax rule table_spec to specify the name(s) of the target table(s) in commands for unloading or loading data.

Example

FASTLOAD TABLE hotel 
INSTREAM 'hotel.data'
Example

DATAEXTRACT FOR DATALOAD TABLE hotel
OUTSTREAM 'hotel.data'

Example

DATALOAD TABLE room
  hno         1
  type        2
  free        3
  price       4
INSTREAM 'room.data'

<if_condition>

You use the syntax rule if_condition to define the selection criterion that determine which records from the data stream are loaded to which target table.

You can selectively load data records that do not fulfill the selection criterion to a specific target table by using the OTHERWISE condition. This means that you can load all those records in the data stream, for which you cannot define a standard selection criterion, to a certain target table.

This syntax rule allows you to select data records when loading them from a data stream into a target table:

Note

OTHERWISE may only be specified for the last table in a series of DATALOAD commands.

Example

You only want to load the data records from the data stream room.data to the target table room in which the room type double is specified and for which the room price is below 200.00.

DATALOAD TABLE room
  
IF POS 16-22 < '200.00' AND POS 06-11 = 'double'
  hno     01-05
  type    06-11
  free    12-15
  price   16-22
INSTREAM 'room.data' FORMATTED

 

Leaving content frame