SAP Table T086

Sort version Reporting

T086 (Sort version Reporting) 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 T086 to other SAP tables.

T086 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SRTVAR Sort version for reporting SRTVAR CHAR 4 0
TABLN1 Table Name TABNAME CHAR 30 0
FELDN1 Field name FELDNM CHAR 30 0
XSUMM1 Indicator: Create totals at this sort level XSUMME CHAR 1 0
X Yes
NULL No
XAFLG1 Indicator: Statistical outline XAFLG CHAR 1 0
X Yes
NULL No
TABLN2 Table Name TABNAME CHAR 30 0
FELDN2 Field name FELDNM CHAR 30 0
XSUMM2 Indicator: Create totals at this sort level XSUMME CHAR 1 0
X Yes
NULL No
XAFLG2 Indicator: Statistical outline XAFLG CHAR 1 0
X Yes
NULL No
TABLN3 Table Name TABNAME CHAR 30 0
FELDN3 Field name FELDNM CHAR 30 0
XSUMM3 Indicator: Create totals at this sort level XSUMME CHAR 1 0
X Yes
NULL No
XAFLG3 Indicator: Statistical outline XAFLG CHAR 1 0
X Yes
NULL No
TABLN4 Table Name TABNAME CHAR 30 0
FELDN4 Field name FELDNM CHAR 30 0
XSUMM4 Indicator: Create totals at this sort level XSUMME CHAR 1 0
X Yes
NULL No
XAFLG4 Indicator: Statistical outline XAFLG CHAR 1 0
X Yes
NULL No
TABLN5 Table Name TABNAME CHAR 30 0
FELDN5 Field name FELDNM CHAR 30 0
XSUMM5 Indicator: Create totals at this sort level XSUMME CHAR 1 0
X Yes
NULL No
XAFLG5 Indicator: Statistical outline XAFLG CHAR 1 0
X Yes
NULL No
XANLN1 Indicator: Totals by main number in reporting XANLN1 CHAR 1 0
X Yes
NULL No
XANLN2 Indicator: Sort asset subnumbers in descending order XANLN2 CHAR 1 0
X Yes
NULL No
OFFSET1 Offset within the field F_OFFSET NUMC 2 0
LAENGE1 Internal field length F_LAENGE NUMC 2 0
OFFSET2 Offset within the field F_OFFSET NUMC 2 0
LAENGE2 Internal field length F_LAENGE NUMC 2 0
OFFSET3 Offset within the field F_OFFSET NUMC 2 0
LAENGE3 Internal field length F_LAENGE NUMC 2 0
OFFSET4 Offset within the field F_OFFSET NUMC 2 0
LAENGE4 Internal field length F_LAENGE NUMC 2 0
OFFSET5 Offset within the field F_OFFSET NUMC 2 0
LAENGE5 Internal field length F_LAENGE NUMC 2 0
XNEWPG1 Indicator: New page when this sort field has new contents XNEWPG CHAR 1 0
X Yes
NULL No
XNEWPG2 Indicator: New page when this sort field has new contents XNEWPG CHAR 1 0
X Yes
NULL No
XNEWPG3 Indicator: New page when this sort field has new contents XNEWPG CHAR 1 0
X Yes
NULL No
XNEWPG4 Indicator: New page when this sort field has new contents XNEWPG CHAR 1 0
X Yes
NULL No
XNEWPG5 Indicator: New page when this sort field has new contents XNEWPG CHAR 1 0
X Yes
NULL No
ANZUNTNR Number of subnumbers at which the main number is totalled ANZUNTNR NUMC 1 0
1 You get main number total after this number of subnumbers
XLEERZL Indicator: Blank line after total for main number XLEERZL CHAR 1 0
X Yes
NULL No

T086 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T086 MANDT T086 MANDT T000 Clients MANDT