TCY08 SAP (Option profiles) Table details
Dictionary Type: Table
Description: Option profiles
Description: Option profiles
Table field list including key, data, relationships and ABAP select examples
TCY08 is a standard SAP Table which is used to store Option profiles data and is available within R/3 SAP systems depending on the version and release level.
The TCY08 table consists of various fields, each holding specific information or linking keys about Option profiles data available in SAP. These include DARPROF_ID (ID of a user-spec. profile in the table for option profiles), HIEVER (Cumulate capacity requirements using work center hierarchy), HIEAUF (Explode hierarchy), KUMUL (Indicator, whether cumulated display is desired).. 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: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TCY12
SAP TCY08 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 |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| DARPROF_ID | ID of a user-spec. profile in the table for option profiles | DARPROF_ID | CHAR | 10 | DARPROF_ID | ||||
| HIEVER | Cumulate capacity requirements using work center hierarchy | HIEVER | CHAR | 1 | KREUZ | ||||
| HIEAUF | Explode hierarchy | HIEAUF | CHAR | 1 | KREUZ | ||||
| KUMUL | Indicator, whether cumulated display is desired | KUMULD | CHAR | 1 | KREUZ | ||||
| MINBEL | Minimum load that will be displayed | MINBELA | DEC | 3 | BELAST | ||||
| MAXBEL | Maximum load that will be displayed | MAXBELA | DEC | 3 | BELAST | ||||
| RUECKDAT | Offset (in days) of dispatch date for backlog to curr. date | RDATUM_CNT | DEC | 5 | DAYCNT | ||||
| PEINHEIT | Unit in which the period duration is specified (day, week..) | DAPER | CHAR | 1 | DAPER | ||||
| PDAUER | Duration of a period (units as specified in period type) | DAPED | DEC | 3 | CY_DAPED | ||||
| LIBART | Requirements category (scheduled or remaining) | CY_SBART | CHAR | 1 | CY_SBART | ||||
| ZAPER | Type of date specification | CY_ZAPER | CHAR | 1 | CY_ZAPER | ||||
| LIDAVCNT | Offset (in days) of start date for lists to current date | CY_DCNTV | DEC | 5 | DAYCNT | ||||
| LIDABCNT | Offset (in days) of end date for lists to current date | CY_DCNTB | DEC | 5 | DAYCNT | ||||
| LIEINH | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| DAVAP | Distribution according to key in work center or operation | DAVAP | CHAR | 1 | XFELD | ||||
| HNAME | Name of hierarchy | CR_HNAME | CHAR | 10 | CHAR10 | CHY | |||
| HWERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| VERTL1 | Distribution of capacity requirements (Planned/prod.order) | CR_VERTL | CHAR | 8 | TC29 | CR_VERTL | |||
| VERTLN | Distr.cap.reqmts (plant maint.,process order, network) | CR_VERTLN | CHAR | 8 | TC29 | CR_VERTL | |||
| POOLKAP | Indicator: Cumulated view of the rqmts of pooled capacity | CY_POOLKAP | CHAR | 1 | KREUZ | ||||
| TT_FAUFT | Indicator: Branch to production order - change or display | CY_TTFAUFT | CHAR | 1 | CY_TRANSTY | ||||
| TT_PAUFT | Indicator: Branch to planned order display or maintenance | CY_TTPAUFT | CHAR | 1 | CY_TRANSTY | ||||
| TT_ARBPL | Switch: Branch to work center - change or display | CY_TTARBPL | CHAR | 1 | CY_TRANSTY | ||||
| ANVER | Cumulate available capacity using work center hierarchy | CY_ANVER | CHAR | 1 | CY_ANVER | ||||
| DATEFROM | Start date for output of capacity evaluations | CY_DATEF | CHAR | 10 | CHAR10 | ||||
| DATETO | Finish date for output of capacity evaluations | CY_DATET | CHAR | 10 | CHAR10 | ||||
| RDATE_TYPE | Type of date specification | CY_RDATETY | CHAR | 1 | CY_ZAPER | ||||
| RDATE | Date of backlog dispatching | CY_RDATE | CHAR | 10 | CHAR10 | ||||
| MRPP | PPC planning calendar | MRPPP | CHAR | 3 | T439G | MRPPP | |||
| UNITSOURCE | Origin of unit of measure for available cap. and cap.reqmts | CY_UNITSRC | CHAR | 1 | KREUZ | ||||
| PPSWERK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C |
| Key field | Non-key field |
How do I retrieve data from SAP table TCY08 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCY08 to SELECT all data from the tableDATA: WA_TCY08 TYPE TCY08.
SELECT SINGLE *
FROM TCY08
INTO CORRESPONDING FIELDS OF WA_TCY08
WHERE...
How to access SAP table TCY08
Within an ECC or HANA version of SAP you can also view further information about TCY08 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects