1. Home
  2. Resources
  3. SAP Tables
  4. TCY09 - List profiles (standard settings for lists)

SAP Table TCY09

List profiles (standard settings for lists)

TCY09 (List profiles (standard settings for lists)) 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 TCY09 to other SAP tables.

Source: TCY09 (List profiles (standard settings for lists))

TCY09 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LISPROF_ID List profile LISPROF_ID CHAR 10 0
LVARI Version of the detailed capacity list CY_LVARI CHAR 2 0
LIVAR List version of variable overview CY_LIVAR TCY17 CHAR 10 0
SORT1 Sort accord. to sort criterion "order number" CY_SORT1 NUMC 1 0
1 as first sort field
2 as second sort field
3 as third sort sort field
4 as fourth sort field
5 as fifth sort field
SORT2 Sort accord. to start date CY_SORT2 NUMC 1 0
1 as first sort field
2 as second sort field
3 as third sort sort field
4 as fourth sort field
5 as fifth sort field
SORT3 Sort accord. to finish date CY_SORT3 NUMC 1 0
1 as first sort field
2 as second sort field
3 as third sort sort field
4 as fourth sort field
5 as fifth sort field
SORT4 Sort according to sort criterion "delivery date" CY_SORT4 NUMC 1 0
1 as first sort field
2 as second sort field
3 as third sort sort field
4 as fourth sort field
5 as fifth sort field
SORT5 Sorting acc. to sort criterion "priority" CY_SORT5 NUMC 1 0
1 as first sort field
2 as second sort field
3 as third sort sort field
4 as fourth sort field
5 as fifth sort field
DEFLISTE Default list CY_DEFLIST CHAR 1 0
0 Standard overview
1 Detailed capacity list
2 Variable overview
3 Graphic: Standard overview
4 Graphic: "Operations at the work center"
5 Graphic: Variable overview
EX_PFAD PC path name PC_PATH CHAR 66 0
EX_INQ Query for file name in case of download? CY_EXINQ CHAR 1 0
X
NULL
EX_DVAR Version of the detailed capacity list CY_LVARI CHAR 2 0
EX_UDAT File name of EXCEL table for standard overview CY_EXUDAT CHAR 8 0
EX_DDAT File name of EXCEL table for detailed capacity list CY_EXDDAT CHAR 8 0
EX_VDAT File name of EXCEL table for variable overview CY_EXVDAT CHAR 8 0
EX_OVER Query before overwriting an existing file CY_EXOVER CHAR 1 0
X
NULL
EX_PAGE SAP Character Set ID CPCODEPAGE TCP00 NUMC 4 0
EX_DVAR1 Profile for a list version PROFID_LIS TCYD CHAR 12 0
EX_TABNAME Table Name TABNAME TCYE CHAR 30 0
LVARILIS Profile for a list version PROFID_LIS TCYD CHAR 12 0
TABNAME Table Name TABNAME TCYE CHAR 30 0

TCY09 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCY09 EX_DVAR1 TCY09 MANDT TCYD Profile for detailed capacity list MANDT
TCY09 EX_DVAR1 TCY09 TABNAME TCYD Profile for detailed capacity list TABNAME
TCY09 EX_DVAR1 TCY09 EX_DVAR1 TCYD Profile for detailed capacity list PROFID_LIS
TCY09 EX_PAGE TCY09 EX_PAGE TCP00 SAP code page catalog CPCODEPAGE
TCY09 EX_TABNAME TCY09 EX_TABNAME TCYE Capacity planning: Object type table for detailed cap. list TABNAME
TCY09 LIVAR TCY09 MANDT TCY17 List version - keys MANDT
TCY09 LIVAR TCY09 LIVAR TCY17 List version - keys LIVAR
TCY09 LVARILIS TCY09 MANDT TCYD Profile for detailed capacity list MANDT
TCY09 LVARILIS TCY09 TABNAME TCYD Profile for detailed capacity list TABNAME
TCY09 LVARILIS TCY09 LVARILIS TCYD Profile for detailed capacity list PROFID_LIS
TCY09 MANDT TCY09 MANDT T000 Clients MANDT
TCY09 TABNAME TCY09 TABNAME TCYE Capacity planning: Object type table for detailed cap. list TABNAME