1. Home
  2. Resources
  3. SAP Tables
  4. T800 - Report Writer: Reports

SAP Table T800

Report Writer: Reports

T800 (Report Writer: Reports) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T800 to other SAP tables.

T800 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LIB Library LIB T801K CHAR 3 0
RNAME Report RNAME CHAR 8 0
CNAM Created By CRNAM CHAR 12 0
CDAT Creation date CRDAT DATS 8 0
CRTIME Creation Time CR_TIME TIMS 6 0
UNAM Last Changed By UPNAM CHAR 12 0
UDAT Date on which object was last changed UPDAT DATS 8 0
UPTIME Time of last change UP_TIME TIMS 6 0
STD_LAYOUT Indicator: Valid standard layout parameters RW_S_PAR CHAR 1 0
DEFAU Standard layout DEFAU T801X CHAR 7 0
RELS1 SAP release of report RELS1 CHAR 4 0
RELS2 Last change under release RELS2 CHAR 4 0
AUTHGR Authorization group AUTHGR TBRG CHAR 4 0
PS_PROGRAM Program on presentation server PS_PROGRAM CHAR 55 0
PS_COMMAND Parameters for program PS_COMMAND CHAR 55 0
OUT_FILE File for Report Writer output OUT_FILE CHAR 128 0
ORIGIN Report Writer: Indicator: Origin of the report RW_ORIGIN CHAR 1 0
NULL Created by Report Writer
P Created by Report Painter
CSTAT Report Writer: Status of the report RW_CSTAT CHAR 1 0
OUT_DEVI Output medium OUT_DEVI CHAR 1 0
0 Screen/printer
1 File on the application server
2 File on the presentation server
3 Screen/department printer
4 Excel
5 Transfer data to EIS
6 HTML format transfer in SAP memory
7 Send mail
O Data transfer to OIW (internal only)
I Office integration (internal only)
OUT_FORM Output format OUT_FORM CHAR 1 0
0 List format
1 Tabular format
2 Excel format
3 HTML format
NULL List format
OUT_TYPE File format PC_FORMAT CHAR 3 0
ASC ASCII
BIN Binary
DBF DBASE format
IBM ASCII with IBM code page conversion (DOS)
WK1 Spreadsheet format
DAT ASCII data table with column tab
DIR Check directory for validation of file names
TRFLG Indicator: Active threshold value condition RW_TRFLG CHAR 1 0
X Yes
NULL No
TRCOL Ref. column for threshold value RW_TRCOL NUMC 3 0
TRMOD Indicator: Highlight rows RW_TRMOD CHAR 1 0
1 Only print selected rows
2 Highlight selected rows in red
3 Highlight selected rows in green
TROPR Threshold value condition RW_TROPR CHAR 2 0
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
TRVAL Threshold value RW_TRVAL CHAR 24 0
TRSGN Indicator: Ignore +/- sign RW_TRSGN CHAR 1 0
X Yes
NULL No
TRDET Indicator: Condition only valid for detail rows RW_TRDET CHAR 1 0
X Yes
NULL No
TRFLG2 Indicator: Active threshold value condition RW_TRFLG CHAR 1 0
X Yes
NULL No
TRCOL2 Ref. column for threshold value RW_TRCOL NUMC 3 0
TRMOD2 Indicator: Highlight rows RW_TRMOD CHAR 1 0
1 Only print selected rows
2 Highlight selected rows in red
3 Highlight selected rows in green
TROPR2 Threshold value condition RW_TROPR CHAR 2 0
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
TRVAL2 Threshold value RW_TRVAL CHAR 24 0
TRSGN2 Indicator: Ignore +/- sign RW_TRSGN CHAR 1 0
X Yes
NULL No
TRDET2 Indicator: Condition only valid for detail rows RW_TRDET CHAR 1 0
X Yes
NULL No
DATEE Display format for dates DATEE CHAR 1 0
1 Day.Month.Year (DD.MM.YYYY)
2 Month/Day/Year (MM/DD/YYYY)
3 Month-Day-Year (MM-DD-YYYY)
4 Year.Month.Day (YYYY.MM.DD)
6 Year/Month/Day (YYYY/MM/DD)
5 Adopt user parameters
DECIE Display format for decimal places DECIE CHAR 1 0
, Decimal comma (E.g.: 1 million = 1.000.000,00)
. Decimal point (E.g.: 1 million = 1,000,000.00)
S Adopt user parameters
SIGNE Display format for +/- sign SIGNE CHAR 2 0
- Display type -100.20
- Display type 100.20-
() Display type (100.20)
CR Display type 100.20 CR
NS Display type 100,20
PAGLN Page length PAGLN CHAR 3 0
PAGWD Page width PAGWD CHAR 3 0
TOPMG Top margin TOPMG CHAR 2 0
BOTMG Bottom margin BOTMG CHAR 2 0
RGTMG Right margin RGTMG CHAR 2 0
LFTMG Left margin LFTMG CHAR 2 0
RTITR Repeat lead column RTITR CHAR 1 0
NULL No
X Yes
COLSS Column break character COLSS CHAR 1 0
COLCF Offset total in next column COLCF CHAR 1 0
NULL No
X Yes
SIGCF Underscoring for offset total SIGCF CHAR 1 0
ZEROR Display format for zero DZEROR CHAR 1 0
0 Displayed with "0" (0.00)
- Displayed with "-" (- )
NULL Displayed with " " ( )
ULTXT Underscoring text ULTXT CHAR 1 0
NULL No
X Yes
ULTYP Indicator: Underline column break character ULTYP CHAR 1 0
NULL No
X Yes
FIFRST First screen for the SAP graphics FIFRST CHAR 2 0
GP Groups
PU Choose
2D 2-dimensional
3D 3-dimensional
P2TYPE 2D graphics type P2TYPE CHAR 2 0
HB Horizontal bars
HS Stacked horizontal bars
LN Lines
MA Masked areas
MS Stepped areas
PI Pie chart
PO Polar diagram
PP Relative polar diagram
SA Stacked areas
ST Stepped diagram
TD Perspective bars
TP Perspective pie chart
VB Vertical bars
VS Stacked vertical bars
VT Vertical triangles
P3TYPE 3D graphics type P3TYPE CHAR 3 0
ED Corners
NET Network
PY Pyramids
TO Towers
WE Wedges
CLPALT Color palette for graphics CLPALT CHAR 1 0
A Blue
B Yellow
C Green
D Gray
E Dot matrix printer
F PostScript
PPATT Column print pattern PPATT CHAR 1 0
NULL No
X Yes
PREOF Indicator: Print selection log PREOF CHAR 1 0
NULL No
X Yes
GTYPE Indicator: Use standard colors STD_COLORS CHAR 1 0
X Yes
NULL No
PARMS Layout changes allowed in output PARMS CHAR 1 0
NULL No
X Yes
R_INVAL_S Indicator: Symbol for undefined values RW_INVALID CHAR 1 0
X Yes
NULL No
R_INVAL_QUAN Indicator: Display invalid quantities (with unit '*') RW_INVALID_QUAN CHAR 1 0
X Yes
NULL No
DEC_ZERO Number of decimal places for zero values RWDECZERO CHAR 1 0
0 No Decimal Places
1 1 Decimal Place
2 2 Decimal Places
3 3 Decimal Places
4 4 Decimal Places
5 5 Decimal Places
6 6 Decimal Places
7 7 Decimal Places
8 8 Decimal Places
9 9 Decimal Places
NULL No Decimal Places
COLWD Column width COLWD CHAR 2 0
COLWD1 Column width COLWD CHAR 2 0
COLWD2 Column width COLWD CHAR 2 0
COLWD3 Column width COLWD CHAR 2 0
COLWD4 Column width COLWD CHAR 2 0
COLWD5 Column width COLWD CHAR 2 0
UWIDTH0 Number of columns for currency/unit UWIDTH CHAR 1 0
0 No unit
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
NULL No unit
UWIDTH1 Number of columns for currency/unit UWIDTH CHAR 1 0
0 No unit
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
NULL No unit
UWIDTH2 Number of columns for currency/unit UWIDTH CHAR 1 0
0 No unit
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
NULL No unit
UWIDTH3 Number of columns for currency/unit UWIDTH CHAR 1 0
0 No unit
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
NULL No unit
UWIDTH4 Number of columns for currency/unit UWIDTH CHAR 1 0
0 No unit
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
NULL No unit
UWIDTH5 Number of columns for currency/unit UWIDTH CHAR 1 0
0 No unit
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
NULL No unit
COLSP0 Right column margin COLSP CHAR 1 0
0 No margin
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
COLSP1 Right column margin COLSP CHAR 1 0
0 No margin
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
COLSP2 Right column margin COLSP CHAR 1 0
0 No margin
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
COLSP3 Right column margin COLSP CHAR 1 0
0 No margin
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
COLSP4 Right column margin COLSP CHAR 1 0
0 No margin
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
COLSP5 Right column margin COLSP CHAR 1 0
0 No margin
1 1 character
2 2 characters
3 3 characters
4 4 characters
5 5 characters
6 6 characters
7 7 characters
8 8 characters
9 9 characters
SIGN0 Change +/- sign (of print class) SIGN0 CHAR 1 0
NULL No sign change
X Sign change
SIGN1 Change +/- sign (of print class) SIGN0 CHAR 1 0
NULL No sign change
X Sign change
SIGN2 Change +/- sign (of print class) SIGN0 CHAR 1 0
NULL No sign change
X Sign change
SIGN3 Change +/- sign (of print class) SIGN0 CHAR 1 0
NULL No sign change
X Sign change
SIGN4 Change +/- sign (of print class) SIGN0 CHAR 1 0
NULL No sign change
X Sign change
SIGN5 Change +/- sign (of print class) SIGN0 CHAR 1 0
NULL No sign change
X Sign change
ROUND Display of large numbers: Scaling ROUND CHAR 1 0
0 Normal display
1 Display in tens
2 Display in hundreds
3 Display in thousands
4 Display in tens of thousands
5 Display in hundreds of thousands
6 Display in millions
7 Display in 10 millions
8 Display in 100 millions
9 Display in billions
ROUND1 Display of large numbers: Scaling ROUND CHAR 1 0
0 Normal display
1 Display in tens
2 Display in hundreds
3 Display in thousands
4 Display in tens of thousands
5 Display in hundreds of thousands
6 Display in millions
7 Display in 10 millions
8 Display in 100 millions
9 Display in billions
ROUND2 Display of large numbers: Scaling ROUND CHAR 1 0
0 Normal display
1 Display in tens
2 Display in hundreds
3 Display in thousands
4 Display in tens of thousands
5 Display in hundreds of thousands
6 Display in millions
7 Display in 10 millions
8 Display in 100 millions
9 Display in billions
ROUND3 Display of large numbers: Scaling ROUND CHAR 1 0
0 Normal display
1 Display in tens
2 Display in hundreds
3 Display in thousands
4 Display in tens of thousands
5 Display in hundreds of thousands
6 Display in millions
7 Display in 10 millions
8 Display in 100 millions
9 Display in billions
ROUND4 Display of large numbers: Scaling ROUND CHAR 1 0
0 Normal display
1 Display in tens
2 Display in hundreds
3 Display in thousands
4 Display in tens of thousands
5 Display in hundreds of thousands
6 Display in millions
7 Display in 10 millions
8 Display in 100 millions
9 Display in billions
ROUND5 Display of large numbers: Scaling ROUND CHAR 1 0
0 Normal display
1 Display in tens
2 Display in hundreds
3 Display in thousands
4 Display in tens of thousands
5 Display in hundreds of thousands
6 Display in millions
7 Display in 10 millions
8 Display in 100 millions
9 Display in billions
DECIP Number of decimal places DECIP CHAR 1 0
0 No Decimal Places
1 1 Decimal Place
2 2 Decimal Places
3 3 Decimal Places
4 4 Decimal Places
5 5 Decimal Places
6 6 Decimal Places
7 7 Decimal Places
8 8 Decimal Places
9 9 Decimal Places
NULL No Decimal Places
DECIP1 Number of decimal places DECIP CHAR 1 0
0 No Decimal Places
1 1 Decimal Place
2 2 Decimal Places
3 3 Decimal Places
4 4 Decimal Places
5 5 Decimal Places
6 6 Decimal Places
7 7 Decimal Places
8 8 Decimal Places
9 9 Decimal Places
NULL No Decimal Places
DECIP2 Number of decimal places DECIP CHAR 1 0
0 No Decimal Places
1 1 Decimal Place
2 2 Decimal Places
3 3 Decimal Places
4 4 Decimal Places
5 5 Decimal Places
6 6 Decimal Places
7 7 Decimal Places
8 8 Decimal Places
9 9 Decimal Places
NULL No Decimal Places
DECIP3 Number of decimal places DECIP CHAR 1 0
0 No Decimal Places
1 1 Decimal Place
2 2 Decimal Places
3 3 Decimal Places
4 4 Decimal Places
5 5 Decimal Places
6 6 Decimal Places
7 7 Decimal Places
8 8 Decimal Places
9 9 Decimal Places
NULL No Decimal Places
DECIP4 Number of decimal places DECIP CHAR 1 0
0 No Decimal Places
1 1 Decimal Place
2 2 Decimal Places
3 3 Decimal Places
4 4 Decimal Places
5 5 Decimal Places
6 6 Decimal Places
7 7 Decimal Places
8 8 Decimal Places
9 9 Decimal Places
NULL No Decimal Places
DECIP5 Number of decimal places DECIP CHAR 1 0
0 No Decimal Places
1 1 Decimal Place
2 2 Decimal Places
3 3 Decimal Places
4 4 Decimal Places
5 5 Decimal Places
6 6 Decimal Places
7 7 Decimal Places
8 8 Decimal Places
9 9 Decimal Places
NULL No Decimal Places
COLTP Column text position COLTP CHAR 1 0
1 Align left
2 Centered
3 Align right
COLTX Column text type COLTX CHAR 1 0
1 Master data text
2 Field value and master data text
3 Field name and field value
4 Field value
9 Title from headers
NULL Adopt standard layout
FRMPR Form printout FRMPR CHAR 1 0
NULL No
X Yes
GRMRK Indicator: Mark totals (with '*') GRMRK CHAR 1 0
NULL No
X Yes
ROWTX Row text type ROWTX CHAR 1 0
1 Master data text
2 Field value and master data text
3 Field name and field value
4 Field value
5 Long text from set
NULL Adopt standard layout
RTITC Position of lead column RTITC CHAR 2 0
ROWTX_LG Master data texts in the lead column: short or long text? ROWTX_LG CHAR 1 0
RTITI Indent title RTITI CHAR 2 0
RTITW Width of lead column RTITW CHAR 2 0
SIGN_FLAG Flag balance sheet processing SIGN_FLAG CHAR 1 0
D No balance sheet preparation
X +/- sign check for a specific column
A +/- sign check for all columns
SIGN_COL Column for testing the +/- sign flag SIGN_COL CHAR 3 0
SUM_FROM Report summation interval (from level) SUM_FROM CHAR 2 0
SUM_TO Report summation interval (to level) SUM_TO CHAR 2 0
TFROW Row totals at the top TFROW CHAR 1 0
NULL No
X Yes
TTEXT Indicator: Text before single values RW_TTEXT CHAR 1 0
NULL No
X Yes
TTSUP Indicator: Suppress duplicated totals TTSUP CHAR 1 0
NULL No
X Yes
ZSCOL Indicator: Suppress zero columns DZSCOL CHAR 1 0
NULL No
X Yes
ZSROW Indicator: Hide zero rows DZSROW CHAR 1 0
NULL No
X Yes
TFCOL Column totals left TFCOL CHAR 1 0
NULL No
X Yes
ROWTX_GR Indicator: Display group name in lead column ROWTX_GR CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
MULTI_CHAR Multiple use of characteristics RWMULTI_CHAR CHAR 1 0
NULL No multiple usage, check with each entry
U No multiple usage, check when saving
X Multiple usage allowed
MASTERLANG Original Language for Sets (SAP Internal Only) SET_OLANGU T804I LANG 1 0
OUT_FORM1 Output Format (Addition) OUT_FORM1 CHAR 1 0
0 Formatted figures
1 Unformatted figures

T800 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T800 AUTHGR T800 AUTHGR TBRG Authorization groups BRGRU
T800 AUTHGR T800 MANDT TBRG Authorization groups MANDT
T800 AUTHGR 'G_800_GRP' TBRG Authorization groups BROBJ
T800 DEFAU T800 MANDT T801X Report Writer: Standard Layout - Lang. Independent (new) MANDT
T800 DEFAU T800 DEFAU T801X Report Writer: Standard Layout - Lang. Independent (new) SNAME
T800 LIB T800 MANDT T801K Report Writer: Libraries MANDT
T800 LIB T800 LIB T801K Report Writer: Libraries LIB
T800 MASTERLANG T800 MASTERLANG T804I Report Writer: Supported Languages LANGU