1. Home
  2. Resources
  3. SAP Tables
  4. TCY07 - Sel. profiles (Sets for sel. screens & interv. for display)

SAP Table TCY07

Sel. profiles (Sets for sel. screens & interv. for display)

TCY07 (Sel. profiles (Sets for sel. screens & interv. for display)) 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 TCY07 to other SAP tables.

Source: TCY07 (Sel. profiles (Sets for sel. screens & interv. for display))

TCY07 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SETPROF_ID ID of a user-spec. profile in the tab. for selectn. profiles SETPROF_ID CHAR 10 0
SETTAB Table for set SETTABLE CHAR 30 0
ARBPL_SET Name of the work center set ARBPL_SET SETHEADER CHAR 24 0
AUFTR_SET Name of the order set AUFTR_SET SETHEADER CHAR 24 0
KAPAR_SET Name of the capacity category set KAPAR_SET SETHEADER CHAR 24 0
ANFNG_SET Name of the work center-set for the initial screen ANFNG_SET SETHEADER CHAR 24 0
BDATUM Offset (in days) of start date to current date BDATUM_CNT DEC 5 0
SDATUM Offset (in days) of end date to current date SDATUM_CNT DEC 5 0
DATE_TYPE Type of date specification CY_DBDATY CHAR 1 0
A Calendar day
B Factory calendar day
C Calendar week
D Calendar month
E Posting period
F Calendar year
G Number of calendar days
H Number of factory calendar days
I Number of calendar weeks
J Number of calendar months
K Number of posting periods
L Number of calendar years
DBDATEFROM Start date for data base selection CY_DBDATEF CHAR 10 0
DBDATETO Finish date for data base selection CY_DBDATET CHAR 10 0
TERMLEVEL Scheduling level SCHED_TYPE CHAR 1 0
1 Detailed planning
2 Rate-based planning
3 Rough-cut planning
SHOPORDER Capacity requirements of work orders are read CY_SHOPORD CHAR 1 0
X
NULL
PLANORDER Capacity requirements from planned orders are read CY_PLANORD CHAR 1 0
X
NULL
SOPORDER Capacity requirements from SOP orders are read CY_SOPORD CHAR 1 0
X
NULL
AVAICAPVER Version of available capacity CY_CAPVER TC36 NUMC 2 0

TCY07 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCY07 ANFNG_SET '0201' SETHEADER Set Header and Directory SETCLASS
TCY07 ANFNG_SET ' ' SETHEADER Set Header and Directory SUBCLASS
TCY07 ANFNG_SET TCY07 ANFNG_SET SETHEADER Set Header and Directory SETNAME
TCY07 ANFNG_SET TCY07 MANDT SETHEADER Set Header and Directory MANDT
TCY07 ARBPL_SET TCY07 MANDT SETHEADER Set Header and Directory MANDT
TCY07 ARBPL_SET '0201' SETHEADER Set Header and Directory SETCLASS
TCY07 ARBPL_SET ' ' SETHEADER Set Header and Directory SUBCLASS
TCY07 ARBPL_SET TCY07 ARBPL_SET SETHEADER Set Header and Directory SETNAME
TCY07 AUFTR_SET '0201' SETHEADER Set Header and Directory SETCLASS
TCY07 AUFTR_SET TCY07 AUFTR_SET SETHEADER Set Header and Directory SETNAME
TCY07 AUFTR_SET ' ' SETHEADER Set Header and Directory SUBCLASS
TCY07 AUFTR_SET TCY07 MANDT SETHEADER Set Header and Directory MANDT
TCY07 AVAICAPVER TCY07 MANDT TC36 Available capacity version MANDT
TCY07 AVAICAPVER TCY07 AVAICAPVER TC36 Available capacity version VERSN
TCY07 KAPAR_SET TCY07 MANDT SETHEADER Set Header and Directory MANDT
TCY07 KAPAR_SET '0201' SETHEADER Set Header and Directory SETCLASS
TCY07 KAPAR_SET ' ' SETHEADER Set Header and Directory SUBCLASS
TCY07 KAPAR_SET TCY07 KAPAR_SET SETHEADER Set Header and Directory SETNAME
TCY07 MANDT TCY07 MANDT T000 Clients MANDT