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 |
Possible values
|
||||||
XAFLG1 | Indicator: Statistical outline | XAFLG | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
XAFLG2 | Indicator: Statistical outline | XAFLG | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
XAFLG3 | Indicator: Statistical outline | XAFLG | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
XAFLG4 | Indicator: Statistical outline | XAFLG | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
XAFLG5 | Indicator: Statistical outline | XAFLG | CHAR | 1 | 0 |
Possible values
|
||||||
XANLN1 | Indicator: Totals by main number in reporting | XANLN1 | CHAR | 1 | 0 |
Possible values
|
||||||
XANLN2 | Indicator: Sort asset subnumbers in descending order | XANLN2 | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
XNEWPG2 | Indicator: New page when this sort field has new contents | XNEWPG | CHAR | 1 | 0 |
Possible values
|
||||||
XNEWPG3 | Indicator: New page when this sort field has new contents | XNEWPG | CHAR | 1 | 0 |
Possible values
|
||||||
XNEWPG4 | Indicator: New page when this sort field has new contents | XNEWPG | CHAR | 1 | 0 |
Possible values
|
||||||
XNEWPG5 | Indicator: New page when this sort field has new contents | XNEWPG | CHAR | 1 | 0 |
Possible values
|
||||||
ANZUNTNR | Number of subnumbers at which the main number is totalled | ANZUNTNR | NUMC | 1 | 0 |
Possible values
|
||||||
XLEERZL | Indicator: Blank line after total for main number | XLEERZL | CHAR | 1 | 0 |
Possible values
|
T086 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
T086 | MANDT | T086 | MANDT | T000 | Clients | MANDT |