T800 SAP (Report Writer: Reports) Table details
Dictionary Type: Table
Description: Report Writer: Reports
Description: Report Writer: Reports
Table field list including key, data, relationships and ABAP select examples
T800 is a standard SAP Table which is used to store Report Writer: Reports data and is available within R/3 SAP systems depending on the version and release level.
The T800 table consists of various fields, each holding specific information or linking keys about Report Writer: Reports data available in SAP. These include LIB (Library), RNAME (Report), CNAM (Created By), CDAT (Creation date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
Text table = T800T
SAP T800 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
LIB | Library | LIB | CHAR | 3 | T801K | LIB | GLB | ||
RNAME | Report | RNAME | CHAR | 8 | RNAME | GRP | |||
CNAM | Created By | CRNAM | CHAR | 12 | USNAM | ||||
CDAT | Creation date | CRDAT | DATS | 8 | DATUM | ||||
CRTIME | Creation Time | CR_TIME | TIMS | 6 | T | ||||
UNAM | Last Changed By | UPNAM | CHAR | 12 | USNAM | ||||
UDAT | Date on which object was last changed | UPDAT | DATS | 8 | DATUM | ||||
UPTIME | Time of last change | UP_TIME | TIMS | 6 | T | ||||
STD_LAYOUT | Indicator: Valid standard layout parameters | RW_S_PAR | CHAR | 1 | CHAR1 | ||||
DEFAU | Standard layout | DEFAU | CHAR | 7 | T801X | DEFAU | GSY | ||
RELS1 | SAP release of report | RELS1 | CHAR | 4 | SAPRL | ||||
RELS2 | Last change under release | RELS2 | CHAR | 4 | SAPRL | ||||
AUTHGR | Authorization group | AUTHGR | CHAR | 4 | TBRG | BRGRU | |||
PS_PROGRAM | Program on presentation server | PS_PROGRAM | CHAR | 55 | PS_STRG55 | ||||
PS_COMMAND | Parameters for program | PS_COMMAND | CHAR | 55 | PS_STRG55 | ||||
OUT_FILE | File for Report Writer output | OUT_FILE | CHAR | 128 | LOCALFILE | GXD | |||
ORIGIN | Report Writer: Indicator: Origin of the report | RW_ORIGIN | CHAR | 1 | RW_ORIGIN | ||||
CSTAT | Report Writer: Status of the report | RW_CSTAT | CHAR | 1 | RW_CSTAT | ||||
OUT_DEVI | Output medium | OUT_DEVI | CHAR | 1 | OUT_DEVI | ||||
OUT_FORM | Output format | OUT_FORM | CHAR | 1 | OUT_FORM | ||||
OUT_TYPE | File format | PC_FORMAT | CHAR | 3 | FILEFORMAT | ||||
TRFLG | Indicator: Active threshold value condition | RW_TRFLG | CHAR | 1 | XFELD | ||||
TRCOL | Ref. column for threshold value | RW_TRCOL | NUMC | 3 | NUM3 | ||||
TRMOD | Indicator: Highlight rows | RW_TRMOD | CHAR | 1 | RW_TRMOD | ||||
TROPR | Threshold value condition | RW_TROPR | CHAR | 2 | RW_TROPR | ||||
TRVAL | Threshold value | RW_TRVAL | CHAR | 24 | CHAR24 | ||||
TRSGN | Indicator: Ignore +/- sign | RW_TRSGN | CHAR | 1 | XFELD | ||||
TRDET | Indicator: Condition only valid for detail rows | RW_TRDET | CHAR | 1 | XFELD | ||||
TRFLG2 | Indicator: Active threshold value condition | RW_TRFLG | CHAR | 1 | XFELD | ||||
TRCOL2 | Ref. column for threshold value | RW_TRCOL | NUMC | 3 | NUM3 | ||||
TRMOD2 | Indicator: Highlight rows | RW_TRMOD | CHAR | 1 | RW_TRMOD | ||||
TROPR2 | Threshold value condition | RW_TROPR | CHAR | 2 | RW_TROPR | ||||
TRVAL2 | Threshold value | RW_TRVAL | CHAR | 24 | CHAR24 | ||||
TRSGN2 | Indicator: Ignore +/- sign | RW_TRSGN | CHAR | 1 | XFELD | ||||
TRDET2 | Indicator: Condition only valid for detail rows | RW_TRDET | CHAR | 1 | XFELD | ||||
DATEE | Display format for dates | DATEE | CHAR | 1 | DATEE | ||||
DECIE | Display format for decimal places | DECIE | CHAR | 1 | DECIE | ||||
SIGNE | Display format for +/- sign | SIGNE | CHAR | 2 | STVA2 | ||||
PAGLN | Page length | PAGLN | CHAR | 3 | CHAR3 | ||||
PAGWD | Page width | PAGWD | CHAR | 3 | CHAR3 | ||||
TOPMG | Top margin | TOPMG | CHAR | 2 | CHAR2 | ||||
BOTMG | Bottom margin | BOTMG | CHAR | 2 | CHAR2 | ||||
RGTMG | Right margin | RGTMG | CHAR | 2 | CHAR2 | ||||
LFTMG | Left margin | LFTMG | CHAR | 2 | CHAR2 | ||||
RTITR | Repeat lead column | RTITR | CHAR | 1 | XFIELD | ||||
COLSS | Column break character | COLSS | CHAR | 1 | CHAR1 | ||||
COLCF | Offset total in next column | COLCF | CHAR | 1 | XFIELD | ||||
SIGCF | Underscoring for offset total | SIGCF | CHAR | 1 | CHAR1 | ||||
ZEROR | Display format for zero | DZEROR | CHAR | 1 | ZEROR | ||||
ULTXT | Underscoring text | ULTXT | CHAR | 1 | XFIELD | ||||
ULTYP | Indicator: Underline column break character | ULTYP | CHAR | 1 | XFIELD | ||||
FIFRST | First screen for the SAP graphics | FIFRST | CHAR | 2 | FIFRST | ||||
P2TYPE | 2D graphics type | P2TYPE | CHAR | 2 | P2TYPE | ||||
P3TYPE | 3D graphics type | P3TYPE | CHAR | 3 | P3TYPE | ||||
CLPALT | Color palette for graphics | CLPALT | CHAR | 1 | CLPALT | ||||
PPATT | Column print pattern | PPATT | CHAR | 1 | XFIELD | ||||
PREOF | Indicator: Print selection log | PREOF | CHAR | 1 | XFIELD | ||||
GTYPE | Indicator: Use standard colors | STD_COLORS | CHAR | 1 | XFELD | ||||
PARMS | Layout changes allowed in output | PARMS | CHAR | 1 | XFIELD | ||||
R_INVAL_S | Indicator: Symbol for undefined values | RW_INVALID | CHAR | 1 | XFELD | ||||
R_INVAL_QUAN | Indicator: Display invalid quantities (with unit '*') | RW_INVALID_QUAN | CHAR | 1 | XFELD | ||||
DEC_ZERO | Number of decimal places for zero values | RWDECZERO | CHAR | 1 | DECIP | ||||
COLWD | Column width | COLWD | CHAR | 2 | CHAR2 | ||||
COLWD1 | Column width | COLWD | CHAR | 2 | CHAR2 | ||||
COLWD2 | Column width | COLWD | CHAR | 2 | CHAR2 | ||||
COLWD3 | Column width | COLWD | CHAR | 2 | CHAR2 | ||||
COLWD4 | Column width | COLWD | CHAR | 2 | CHAR2 | ||||
COLWD5 | Column width | COLWD | CHAR | 2 | CHAR2 | ||||
UWIDTH0 | Number of columns for currency/unit | UWIDTH | CHAR | 1 | UWIDTH | ||||
UWIDTH1 | Number of columns for currency/unit | UWIDTH | CHAR | 1 | UWIDTH | ||||
UWIDTH2 | Number of columns for currency/unit | UWIDTH | CHAR | 1 | UWIDTH | ||||
UWIDTH3 | Number of columns for currency/unit | UWIDTH | CHAR | 1 | UWIDTH | ||||
UWIDTH4 | Number of columns for currency/unit | UWIDTH | CHAR | 1 | UWIDTH | ||||
UWIDTH5 | Number of columns for currency/unit | UWIDTH | CHAR | 1 | UWIDTH | ||||
COLSP0 | Right column margin | COLSP | CHAR | 1 | COLSP | ||||
COLSP1 | Right column margin | COLSP | CHAR | 1 | COLSP | ||||
COLSP2 | Right column margin | COLSP | CHAR | 1 | COLSP | ||||
COLSP3 | Right column margin | COLSP | CHAR | 1 | COLSP | ||||
COLSP4 | Right column margin | COLSP | CHAR | 1 | COLSP | ||||
COLSP5 | Right column margin | COLSP | CHAR | 1 | COLSP | ||||
SIGN0 | Change +/- sign (of print class) | SIGN0 | CHAR | 1 | CSIGN | ||||
SIGN1 | Change +/- sign (of print class) | SIGN0 | CHAR | 1 | CSIGN | ||||
SIGN2 | Change +/- sign (of print class) | SIGN0 | CHAR | 1 | CSIGN | ||||
SIGN3 | Change +/- sign (of print class) | SIGN0 | CHAR | 1 | CSIGN | ||||
SIGN4 | Change +/- sign (of print class) | SIGN0 | CHAR | 1 | CSIGN | ||||
SIGN5 | Change +/- sign (of print class) | SIGN0 | CHAR | 1 | CSIGN | ||||
ROUND | Display of large numbers: Scaling | ROUND | CHAR | 1 | ROUND | ||||
ROUND1 | Display of large numbers: Scaling | ROUND | CHAR | 1 | ROUND | ||||
ROUND2 | Display of large numbers: Scaling | ROUND | CHAR | 1 | ROUND | ||||
ROUND3 | Display of large numbers: Scaling | ROUND | CHAR | 1 | ROUND | ||||
ROUND4 | Display of large numbers: Scaling | ROUND | CHAR | 1 | ROUND | ||||
ROUND5 | Display of large numbers: Scaling | ROUND | CHAR | 1 | ROUND | ||||
DECIP | Number of decimal places | DECIP | CHAR | 1 | DECIP | ||||
DECIP1 | Number of decimal places | DECIP | CHAR | 1 | DECIP | ||||
DECIP2 | Number of decimal places | DECIP | CHAR | 1 | DECIP | ||||
DECIP3 | Number of decimal places | DECIP | CHAR | 1 | DECIP | ||||
DECIP4 | Number of decimal places | DECIP | CHAR | 1 | DECIP | ||||
DECIP5 | Number of decimal places | DECIP | CHAR | 1 | DECIP | ||||
COLTP | Column text position | COLTP | CHAR | 1 | COLTP | ||||
COLTX | Column text type | COLTX | CHAR | 1 | COLTX | ||||
FRMPR | Form printout | FRMPR | CHAR | 1 | XFIELD | ||||
GRMRK | Indicator: Mark totals (with '*') | GRMRK | CHAR | 1 | XFIELD | ||||
ROWTX | Row text type | ROWTX | CHAR | 1 | TEXTTYPE | ||||
RTITC | Position of lead column | RTITC | CHAR | 2 | CHAR2 | ||||
ROWTX_LG | Master data texts in the lead column: short or long text? | ROWTX_LG | CHAR | 1 | CHAR1 | ||||
RTITI | Indent title | RTITI | CHAR | 2 | CHAR2 | ||||
RTITW | Width of lead column | RTITW | CHAR | 2 | CHAR2 | ||||
SIGN_FLAG | Flag balance sheet processing | SIGN_FLAG | CHAR | 1 | SIGN_FLAG | ||||
SIGN_COL | Column for testing the +/- sign flag | SIGN_COL | CHAR | 3 | CHAR3 | ||||
SUM_FROM | Report summation interval (from level) | SUM_FROM | CHAR | 2 | SUM_LEVEL | ||||
SUM_TO | Report summation interval (to level) | SUM_TO | CHAR | 2 | SUM_LEVEL | ||||
TFROW | Row totals at the top | TFROW | CHAR | 1 | XFIELD | ||||
TTEXT | Indicator: Text before single values | RW_TTEXT | CHAR | 1 | XFIELD | ||||
TTSUP | Indicator: Suppress duplicated totals | TTSUP | CHAR | 1 | XFIELD | ||||
ZSCOL | Indicator: Suppress zero columns | DZSCOL | CHAR | 1 | XFIELD | ||||
ZSROW | Indicator: Hide zero rows | DZSROW | CHAR | 1 | XFIELD | ||||
TFCOL | Column totals left | TFCOL | CHAR | 1 | XFIELD | ||||
ROWTX_GR | Indicator: Display group name in lead column | ROWTX_GR | CHAR | 1 | FLAG | ||||
MULTI_CHAR | Multiple use of characteristics | RWMULTI_CHAR | CHAR | 1 | RWMULTI_CHAR | ||||
MASTERLANG | Original Language for Sets (SAP Internal Only) | SET_OLANGU | LANG | 1 | T804I | ISOLA | SPRAS | ||
OUT_FORM1 | Output Format (Addition) | OUT_FORM1 | CHAR | 1 | OUT_FORM1 |
Key field | Non-key field |
How do I retrieve data from SAP table T800 using ABAP code
The following ABAP code Example will allow you to do a basic selection on T800 to SELECT all data from the tableDATA: WA_T800 TYPE T800.
SELECT SINGLE *
FROM T800
INTO CORRESPONDING FIELDS OF WA_T800
WHERE...
How to access SAP table T800
Within an ECC or HANA version of SAP you can also view further information about T800 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects