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 |