T800 SAP (Report Writer: Reports) Table details

Dictionary Type: Table
Description: Report Writer: Reports




ABAP Code to SELECT data from T800
Related tables to T800
Access table T800




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 cust
Display/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
MANDTClient MANDTCLNT3Assigned to domainMANDT
LIBLibrary LIBCHAR3T801KLIBGLB
RNAMEReport RNAMECHAR8RNAMEGRP
CNAMCreated By CRNAMCHAR12USNAM
CDATCreation date CRDATDATS8DATUM
CRTIMECreation Time CR_TIMETIMS6T
UNAMLast Changed By UPNAMCHAR12USNAM
UDATDate on which object was last changed UPDATDATS8DATUM
UPTIMETime of last change UP_TIMETIMS6T
STD_LAYOUTIndicator: Valid standard layout parameters RW_S_PARCHAR1CHAR1
DEFAUStandard layout DEFAUCHAR7T801XDEFAUGSY
RELS1SAP release of report RELS1CHAR4SAPRL
RELS2Last change under release RELS2CHAR4SAPRL
AUTHGRAuthorization group AUTHGRCHAR4TBRGBRGRU
PS_PROGRAMProgram on presentation server PS_PROGRAMCHAR55PS_STRG55
PS_COMMANDParameters for program PS_COMMANDCHAR55PS_STRG55
OUT_FILEFile for Report Writer output OUT_FILECHAR128LOCALFILEGXD
ORIGINReport Writer: Indicator: Origin of the report RW_ORIGINCHAR1RW_ORIGIN
CSTATReport Writer: Status of the report RW_CSTATCHAR1RW_CSTAT
OUT_DEVIOutput medium OUT_DEVICHAR1OUT_DEVI
OUT_FORMOutput format OUT_FORMCHAR1OUT_FORM
OUT_TYPEFile format PC_FORMATCHAR3FILEFORMAT
TRFLGIndicator: Active threshold value condition RW_TRFLGCHAR1XFELD
TRCOLRef. column for threshold value RW_TRCOLNUMC3NUM3
TRMODIndicator: Highlight rows RW_TRMODCHAR1RW_TRMOD
TROPRThreshold value condition RW_TROPRCHAR2RW_TROPR
TRVALThreshold value RW_TRVALCHAR24CHAR24
TRSGNIndicator: Ignore +/- sign RW_TRSGNCHAR1XFELD
TRDETIndicator: Condition only valid for detail rows RW_TRDETCHAR1XFELD
TRFLG2Indicator: Active threshold value condition RW_TRFLGCHAR1XFELD
TRCOL2Ref. column for threshold value RW_TRCOLNUMC3NUM3
TRMOD2Indicator: Highlight rows RW_TRMODCHAR1RW_TRMOD
TROPR2Threshold value condition RW_TROPRCHAR2RW_TROPR
TRVAL2Threshold value RW_TRVALCHAR24CHAR24
TRSGN2Indicator: Ignore +/- sign RW_TRSGNCHAR1XFELD
TRDET2Indicator: Condition only valid for detail rows RW_TRDETCHAR1XFELD
DATEEDisplay format for dates DATEECHAR1DATEE
DECIEDisplay format for decimal places DECIECHAR1DECIE
SIGNEDisplay format for +/- sign SIGNECHAR2STVA2
PAGLNPage length PAGLNCHAR3CHAR3
PAGWDPage width PAGWDCHAR3CHAR3
TOPMGTop margin TOPMGCHAR2CHAR2
BOTMGBottom margin BOTMGCHAR2CHAR2
RGTMGRight margin RGTMGCHAR2CHAR2
LFTMGLeft margin LFTMGCHAR2CHAR2
RTITRRepeat lead column RTITRCHAR1XFIELD
COLSSColumn break character COLSSCHAR1CHAR1
COLCFOffset total in next column COLCFCHAR1XFIELD
SIGCFUnderscoring for offset total SIGCFCHAR1CHAR1
ZERORDisplay format for zero DZERORCHAR1ZEROR
ULTXTUnderscoring text ULTXTCHAR1XFIELD
ULTYPIndicator: Underline column break character ULTYPCHAR1XFIELD
FIFRSTFirst screen for the SAP graphics FIFRSTCHAR2FIFRST
P2TYPE2D graphics type P2TYPECHAR2P2TYPE
P3TYPE3D graphics type P3TYPECHAR3P3TYPE
CLPALTColor palette for graphics CLPALTCHAR1CLPALT
PPATTColumn print pattern PPATTCHAR1XFIELD
PREOFIndicator: Print selection log PREOFCHAR1XFIELD
GTYPEIndicator: Use standard colors STD_COLORSCHAR1XFELD
PARMSLayout changes allowed in output PARMSCHAR1XFIELD
R_INVAL_SIndicator: Symbol for undefined values RW_INVALIDCHAR1XFELD
R_INVAL_QUANIndicator: Display invalid quantities (with unit '*') RW_INVALID_QUANCHAR1XFELD
DEC_ZERONumber of decimal places for zero values RWDECZEROCHAR1DECIP
COLWDColumn width COLWDCHAR2CHAR2
COLWD1Column width COLWDCHAR2CHAR2
COLWD2Column width COLWDCHAR2CHAR2
COLWD3Column width COLWDCHAR2CHAR2
COLWD4Column width COLWDCHAR2CHAR2
COLWD5Column width COLWDCHAR2CHAR2
UWIDTH0Number of columns for currency/unit UWIDTHCHAR1UWIDTH
UWIDTH1Number of columns for currency/unit UWIDTHCHAR1UWIDTH
UWIDTH2Number of columns for currency/unit UWIDTHCHAR1UWIDTH
UWIDTH3Number of columns for currency/unit UWIDTHCHAR1UWIDTH
UWIDTH4Number of columns for currency/unit UWIDTHCHAR1UWIDTH
UWIDTH5Number of columns for currency/unit UWIDTHCHAR1UWIDTH
COLSP0Right column margin COLSPCHAR1COLSP
COLSP1Right column margin COLSPCHAR1COLSP
COLSP2Right column margin COLSPCHAR1COLSP
COLSP3Right column margin COLSPCHAR1COLSP
COLSP4Right column margin COLSPCHAR1COLSP
COLSP5Right column margin COLSPCHAR1COLSP
SIGN0Change +/- sign (of print class) SIGN0CHAR1CSIGN
SIGN1Change +/- sign (of print class) SIGN0CHAR1CSIGN
SIGN2Change +/- sign (of print class) SIGN0CHAR1CSIGN
SIGN3Change +/- sign (of print class) SIGN0CHAR1CSIGN
SIGN4Change +/- sign (of print class) SIGN0CHAR1CSIGN
SIGN5Change +/- sign (of print class) SIGN0CHAR1CSIGN
ROUNDDisplay of large numbers: Scaling ROUNDCHAR1ROUND
ROUND1Display of large numbers: Scaling ROUNDCHAR1ROUND
ROUND2Display of large numbers: Scaling ROUNDCHAR1ROUND
ROUND3Display of large numbers: Scaling ROUNDCHAR1ROUND
ROUND4Display of large numbers: Scaling ROUNDCHAR1ROUND
ROUND5Display of large numbers: Scaling ROUNDCHAR1ROUND
DECIPNumber of decimal places DECIPCHAR1DECIP
DECIP1Number of decimal places DECIPCHAR1DECIP
DECIP2Number of decimal places DECIPCHAR1DECIP
DECIP3Number of decimal places DECIPCHAR1DECIP
DECIP4Number of decimal places DECIPCHAR1DECIP
DECIP5Number of decimal places DECIPCHAR1DECIP
COLTPColumn text position COLTPCHAR1COLTP
COLTXColumn text type COLTXCHAR1COLTX
FRMPRForm printout FRMPRCHAR1XFIELD
GRMRKIndicator: Mark totals (with '*') GRMRKCHAR1XFIELD
ROWTXRow text type ROWTXCHAR1TEXTTYPE
RTITCPosition of lead column RTITCCHAR2CHAR2
ROWTX_LGMaster data texts in the lead column: short or long text? ROWTX_LGCHAR1CHAR1
RTITIIndent title RTITICHAR2CHAR2
RTITWWidth of lead column RTITWCHAR2CHAR2
SIGN_FLAGFlag balance sheet processing SIGN_FLAGCHAR1SIGN_FLAG
SIGN_COLColumn for testing the +/- sign flag SIGN_COLCHAR3CHAR3
SUM_FROMReport summation interval (from level) SUM_FROMCHAR2SUM_LEVEL
SUM_TOReport summation interval (to level) SUM_TOCHAR2SUM_LEVEL
TFROWRow totals at the top TFROWCHAR1XFIELD
TTEXTIndicator: Text before single values RW_TTEXTCHAR1XFIELD
TTSUPIndicator: Suppress duplicated totals TTSUPCHAR1XFIELD
ZSCOLIndicator: Suppress zero columns DZSCOLCHAR1XFIELD
ZSROWIndicator: Hide zero rows DZSROWCHAR1XFIELD
TFCOLColumn totals left TFCOLCHAR1XFIELD
ROWTX_GRIndicator: Display group name in lead column ROWTX_GRCHAR1FLAG
MULTI_CHARMultiple use of characteristics RWMULTI_CHARCHAR1RWMULTI_CHAR
MASTERLANGOriginal Language for Sets (SAP Internal Only) SET_OLANGULANG1T804IISOLASPRAS
OUT_FORM1Output Format (Addition) OUT_FORM1CHAR1OUT_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!