SAP table T800 (Report Writer: Reports)

SAP table T800 has 3 primary key fields being MANDT,LIB,RNAME.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
LIB Library CHAR 3 0 T801K LIB
RNAME Report CHAR 8 0 RNAME
CNAM Created By CHAR 12 0 CRNAM
CDAT Creation date DATS 8 0 CRDAT
CRTIME Creation Time TIMS 6 0 CR_TIME
UNAM Last Changed By CHAR 12 0 UPNAM
UDAT Date on which object was last changed DATS 8 0 UPDAT
UPTIME Time of last change TIMS 6 0 UP_TIME
STD_LAYOUT Indicator: Valid standard layout parameters CHAR 1 0 RW_S_PAR
DEFAU Standard layout CHAR 7 0 T801X DEFAU
RELS1 SAP release of report CHAR 4 0 RELS1
RELS2 Last change under release CHAR 4 0 RELS2
AUTHGR Authorization group CHAR 4 0 TBRG AUTHGR
PS_PROGRAM Program on presentation server CHAR 55 0 PS_PROGRAM
PS_COMMAND Parameters for program CHAR 55 0 PS_COMMAND
OUT_FILE File for Report Writer output CHAR 128 0 OUT_FILE
ORIGIN Report Writer: Indicator: Origin of the report CHAR 1 0 RW_ORIGIN
Created by Report Writer
P Created by Report Painter
CSTAT Report Writer: Status of the report CHAR 1 0 RW_CSTAT
OUT_DEVI Output medium CHAR 1 0 OUT_DEVI
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
I Office integration (internal only)
O Data transfer to OIW (internal only)
OUT_FORM Output format CHAR 1 0 OUT_FORM
List format
0 List format
1 Tabular format
2 Excel format
3 HTML format
OUT_TYPE File format CHAR 3 0 PC_FORMAT
TRFLG Indicator: Active threshold value condition CHAR 1 0 RW_TRFLG
TRCOL Ref. column for threshold value NUMC 3 0 RW_TRCOL
TRMOD Indicator: Highlight rows CHAR 1 0 RW_TRMOD
1 Only print selected rows
2 Highlight selected rows in red
3 Highlight selected rows in green
TROPR Threshold value condition CHAR 2 0 RW_TROPR
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
TRVAL Threshold value CHAR 24 0 RW_TRVAL
TRSGN Indicator: Ignore +/- sign CHAR 1 0 RW_TRSGN
TRDET Indicator: Condition only valid for detail rows CHAR 1 0 RW_TRDET
TRFLG2 Indicator: Active threshold value condition CHAR 1 0 RW_TRFLG
TRCOL2 Ref. column for threshold value NUMC 3 0 RW_TRCOL
TRMOD2 Indicator: Highlight rows CHAR 1 0 RW_TRMOD
1 Only print selected rows
2 Highlight selected rows in red
3 Highlight selected rows in green
TROPR2 Threshold value condition CHAR 2 0 RW_TROPR
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
TRVAL2 Threshold value CHAR 24 0 RW_TRVAL
TRSGN2 Indicator: Ignore +/- sign CHAR 1 0 RW_TRSGN
TRDET2 Indicator: Condition only valid for detail rows CHAR 1 0 RW_TRDET
DATEE Display format for dates CHAR 1 0 DATEE
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)
5 Adopt user parameters
6 Year/Month/Day (YYYY/MM/DD)
DECIE Display format for decimal places CHAR 1 0 DECIE
, 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 CHAR 2 0 SIGNE
PAGLN Page length CHAR 3 0 PAGLN
PAGWD Page width CHAR 3 0 PAGWD
TOPMG Top margin CHAR 2 0 TOPMG
BOTMG Bottom margin CHAR 2 0 BOTMG
RGTMG Right margin CHAR 2 0 RGTMG
LFTMG Left margin CHAR 2 0 LFTMG
RTITR Repeat lead column CHAR 1 0 RTITR
COLSS Column break character CHAR 1 0 COLSS
COLCF Offset total in next column CHAR 1 0 COLCF
SIGCF Underscoring for offset total CHAR 1 0 SIGCF
ZEROR Display format for zero CHAR 1 0 DZEROR
ULTXT Underscoring text CHAR 1 0 ULTXT
ULTYP Indicator: Underline column break character CHAR 1 0 ULTYP
FIFRST First screen for the SAP graphics CHAR 2 0 FIFRST
2D 2-dimensional
3D 3-dimensional
GP Groups
PU Choose
P2TYPE 2D graphics type CHAR 2 0 P2TYPE
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 CHAR 3 0 P3TYPE
ED Corners
NET Network
PY Pyramids
TO Towers
WE Wedges
CLPALT Color palette for graphics CHAR 1 0 CLPALT
A Blue
B Yellow
C Green
D Gray
E Dot matrix printer
F PostScript
PPATT Column print pattern CHAR 1 0 PPATT
PREOF Indicator: Print selection log CHAR 1 0 PREOF
GTYPE Indicator: Use standard colors CHAR 1 0 STD_COLORS
PARMS Layout changes allowed in output CHAR 1 0 PARMS
R_INVAL_S Indicator: Symbol for undefined values CHAR 1 0 RW_INVALID
R_INVAL_QUAN Indicator: Display invalid quantities (with unit '*') CHAR 1 0 RW_INVALID_QUAN
DEC_ZERO Number of decimal places for zero values CHAR 1 0 RWDECZERO
COLWD Column width CHAR 2 0 COLWD
COLWD1 Column width CHAR 2 0 COLWD
COLWD2 Column width CHAR 2 0 COLWD
COLWD3 Column width CHAR 2 0 COLWD
COLWD4 Column width CHAR 2 0 COLWD
COLWD5 Column width CHAR 2 0 COLWD
UWIDTH0 Number of columns for currency/unit CHAR 1 0 UWIDTH
No unit
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
UWIDTH1 Number of columns for currency/unit CHAR 1 0 UWIDTH
No unit
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
UWIDTH2 Number of columns for currency/unit CHAR 1 0 UWIDTH
No unit
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
UWIDTH3 Number of columns for currency/unit CHAR 1 0 UWIDTH
No unit
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
UWIDTH4 Number of columns for currency/unit CHAR 1 0 UWIDTH
No unit
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
UWIDTH5 Number of columns for currency/unit CHAR 1 0 UWIDTH
No unit
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
COLSP0 Right column margin CHAR 1 0 COLSP
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 CHAR 1 0 COLSP
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 CHAR 1 0 COLSP
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 CHAR 1 0 COLSP
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 CHAR 1 0 COLSP
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 CHAR 1 0 COLSP
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) CHAR 1 0 SIGN0
SIGN1 Change +/- sign (of print class) CHAR 1 0 SIGN0
SIGN2 Change +/- sign (of print class) CHAR 1 0 SIGN0
SIGN3 Change +/- sign (of print class) CHAR 1 0 SIGN0
SIGN4 Change +/- sign (of print class) CHAR 1 0 SIGN0
SIGN5 Change +/- sign (of print class) CHAR 1 0 SIGN0
ROUND Display of large numbers: Scaling CHAR 1 0 ROUND
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 CHAR 1 0 ROUND
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 CHAR 1 0 ROUND
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 CHAR 1 0 ROUND
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 CHAR 1 0 ROUND
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 CHAR 1 0 ROUND
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 CHAR 1 0 DECIP
No Decimal Places
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
DECIP1 Number of decimal places CHAR 1 0 DECIP
No Decimal Places
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
DECIP2 Number of decimal places CHAR 1 0 DECIP
No Decimal Places
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
DECIP3 Number of decimal places CHAR 1 0 DECIP
No Decimal Places
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
DECIP4 Number of decimal places CHAR 1 0 DECIP
No Decimal Places
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
DECIP5 Number of decimal places CHAR 1 0 DECIP
No Decimal Places
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
COLTP Column text position CHAR 1 0 COLTP
1 Align left
2 Centered
3 Align right
COLTX Column text type CHAR 1 0 COLTX
Adopt standard layout
1 Master data text
2 Field value and master data text
3 Field name and field value
4 Field value
9 Title from headers
FRMPR Form printout CHAR 1 0 FRMPR
GRMRK Indicator: Mark totals (with '*') CHAR 1 0 GRMRK
ROWTX Row text type CHAR 1 0 ROWTX
RTITC Position of lead column CHAR 2 0 RTITC
ROWTX_LG Master data texts in the lead column: short or long text? CHAR 1 0 ROWTX_LG
RTITI Indent title CHAR 2 0 RTITI
RTITW Width of lead column CHAR 2 0 RTITW
SIGN_FLAG Flag balance sheet processing CHAR 1 0 SIGN_FLAG
A +/- sign check for all columns
D No balance sheet preparation
X +/- sign check for a specific column
SIGN_COL Column for testing the +/- sign flag CHAR 3 0 SIGN_COL
SUM_FROM Report summation interval (from level) CHAR 2 0 SUM_FROM
SUM_TO Report summation interval (to level) CHAR 2 0 SUM_TO
TFROW Row totals at the top CHAR 1 0 TFROW
TTEXT Indicator: Text before single values CHAR 1 0 RW_TTEXT
TTSUP Indicator: Suppress duplicated totals CHAR 1 0 TTSUP
ZSCOL Indicator: Suppress zero columns CHAR 1 0 DZSCOL
ZSROW Indicator: Hide zero rows CHAR 1 0 DZSROW
TFCOL Column totals left CHAR 1 0 TFCOL
ROWTX_GR Indicator: Display group name in lead column CHAR 1 0 ROWTX_GR
MULTI_CHAR Multiple use of characteristics CHAR 1 0 RWMULTI_CHAR
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) LANG 1 0 T804I SET_OLANGU
OUT_FORM1 Output Format (Addition) CHAR 1 0 OUT_FORM1
0 Formatted figures
1 Unformatted figures

T800 foreign key relationships

Table Field Check Table Check Field
0 T800 AUTHGR TBRG Authorization groups MANDT
0 T800 AUTHGR TBRG Authorization groups BRGRU
1 T800 DEFAU T801X Report Writer: Standard Layout - Lang. Independent (new) MANDT
1 T800 DEFAU T801X Report Writer: Standard Layout - Lang. Independent (new) SNAME
0 T800 LIB T801K Report Writer: Libraries MANDT
0 T800 LIB T801K Report Writer: Libraries LIB
1 T800 MASTERLANG T804I Report Writer: Supported Languages LANGU