Background documentation Commands for Loading and Unloading Locate the document in its SAP Library structure

The language scope of the SAP DB Loader allows you load or unload, in increasing granularity, a complete database, the objects of a user, individual tables, or a set of columns of a table.

What is to be loaded/unloaded?

SAP DB Loader Command

Database

DBEXTRACT
DBLOAD

Database catalog

CATALOGEXTRACT ALL, CATALOGLOAD ALL

Database catalog objects and the application data of a user

CATALOGEXTRACT USER
CATALOGLOAD USER

TABLEEXTRACT USER
TABLELOAD USER

Tables

CATALOGEXTRACT TABLE
CATALOGLOAD TABLE

TABLEXTRACT TABLE
TABLELOAD TABLE

DATAEXTRACT
DATALOAD

Set of qualified columns of a table

DATAEXTRACT
DATALOAD

FASTLOAD

DATAUPDATE

See also:

SAP DB Loader: Commands and SQL Statements