Object documentation TRANSFORMATIONSTEPS Locate the document in its SAP Library structure

THE SAP DB Loader system table TRANSFORMATIONSTEPS describes a transformation at table level.

TRANSFORMATIONSTEPS

PACKAGEGUID

CHAR BYTE(24)

Unique ID of the transformation package

STEPID

FIXED(6,0)

ID of the transformation step

TRANSFORMATION

FIXED(6,0)

Transformation type (EXTRACT | LOAD | UPDATE)

OWNER

CHAR(32)

Owner of the table

TABLENAME

CHAR(32)

Table name

CATALOGSTREAMNAME

CHAR(254)

ID of the CATALOG data stream

DATASTREAMNAME

CHAR(254)

ID of the DATA data stream

DATASTREAMHEADERBLOCK

FIXED(6,0)

Start position of the header of the DATA data stream (in 2 GB blocks)

DATASTREAMHEADERPOS

FIXED(10,0)

Start position of the header of the DATA data stream (in bytes, less than 2 GB)

DATASTREAMDATABLOCK

FIXED(6,0)

Start position of the data of the DATA data stream (in 2 GB blocks)

DATASTREAMDATAPOS

FIXED(10,0)

Start position of the data of the DATA data stream (in bytes, less than 2 GB)

RESTART

BOOLEAN

Transformation step was executed (TRUE) or not (FALSE)

START

FIXED(10,0)

Number of transformed rows