SAP Table TCND
Project Info System: Overview Settings
TCND (Project Info System: Overview Settings) 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 TCND to other SAP tables.
TCND table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||
| TABNAME | Table Name | TABNAME | TCNE | CHAR | 30 | 0 | ||||||||||||
| PROFID | Information system profile: Overview | PS_PROF_DT | CHAR | 12 | 0 | |||||||||||||
| AENAM | Last changed by | PS_AENAM | CHAR | 12 | 0 | |||||||||||||
| PROTECT | Indicator: Protected entry | PS_PROTECT | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| CUSTOM | Indicator: Maintenance only allowed from initial menu | PS_CUSTOM | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PROF_FD | Information System Profile: Displayed Fields | PS_PROF_FD | TCNF | CHAR | 12 | 0 | ||||||||||||
| PROF_EG | Project information system profile: graphic field selection | PS_PROF_EG | TCNEG | CHAR | 12 | 0 | ||||||||||||
| PROF_SR | Project Information System Profile: Sort Criteria | PS_PROF_SR | TCNS | CHAR | 12 | 0 | ||||||||||||
| PROF_AG | Project Information System Profile: Summarization Criteria | PS_PROF_AG | TCNA | CHAR | 12 | 0 | ||||||||||||
| PROF_GP | Project Information System Profile: Grouping Criteria | PS_PROF_GP | TCNP | CHAR | 12 | 0 | ||||||||||||
| PROF_GR | Project info system profile: Graphics | PS_PROF_GR | TCNB | CHAR | 12 | 0 | ||||||||||||
| FLG_OTX | Indicator: Object is displayed by its short text | PS_FLG_OTX | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_OTP | Indicator: Object is displayed by object type | PS_FLG_OTP | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_HIE | Indicator: Hierarchy is displayed | PS_FLG_HIE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_TREE | Indicator: Display structure | PS_FLG_TRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_NAGGR | Indicator: Aggregatable fields are not aggregated | PS_FLG_NAGR | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_SUM_ALL | Indicator: total/aggregate all objects | PS_SUM_ALL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_EHZ | Indicator: Display units in header line | PS_FLG_EHZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_GRP | Indicator: Grouping will be displayed | PS_FLG_GRP | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_SRA | Indicator: sort in descending order | PS_FLG_SRA | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_PWT | Indicator: numerical, summable fields as percentage values | PS_FLG_PWT | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_VSV | Indicator: Carry out version comparison line-by-line | PS_FLG_VSV | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_ORG | Indicator: original column width | PS_FLG_ORG | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| WRT_OBJ | Width of the object column | PS_WRT_OBJ | NUMC | 2 | 0 | |||||||||||||
| WRT_FLD | Width of the field columns | PS_WRT_FLD | NUMC | 2 | 0 | |||||||||||||
| SELSET_FLT | Variant for general filter | SELSET_FLT | VARID | CHAR | 14 | 0 | ||||||||||||
| SELSET_BFT | Variants for user-defined filters | SELSET_BFT | VARID | CHAR | 14 | 0 | ||||||||||||
| SELSET_OFT | Variants for object filter | SELSET_OFT | VARID | CHAR | 14 | 0 | ||||||||||||
| SELID | Selection ID for status filter | PS_SELID | TJ48 | CHAR | 7 | 0 | ||||||||||||
| VSCMP_ADD | Indicator: version comparison: filter created objects | VSCMP_ADD | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| VSCMP_HIE | Indicator: version comparison: filter other hierarchy | VSCMP_HIE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| VSCMP_ART | Version comparison: comparison type to change in filter | VSCMP_ART | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PROF_VGL | Project Info System Profile: Comparison Criteria | PS_PROF_VGL | TCNVG | CHAR | 12 | 0 | ||||||||||||
| FLG_SHOWDEL | Indicator: display deleted objects | PS_SHOWDEL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_NOAUTH | Indicator: display objects without authorization | PS_NOAUTH | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_NOPATH | Indicator: path up not displayed | PS_NOPATH | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SELSET_HV1 | Variant for general highlighting 1 | SELSET_HV1 | VARID | CHAR | 14 | 0 | ||||||||||||
| SELSET_BH1 | Variants for user-defined highlighting 1 | SELSET_BH1 | VARID | CHAR | 14 | 0 | ||||||||||||
| SELIDH1 | Selection ID highlighting 1 according to status | PS_SELIDH1 | TJ48 | CHAR | 7 | 0 | ||||||||||||
| VSCMP_ADD1 | Indicator: version comparison: except 1, created objects | VSCMP_ADD1 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| VSCMP_HIE1 | Indicator: version comparison: exception 1 other hierarchy | VSCMP_HIE1 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| VSCMP_ART1 | Version comparision: comparison type for change in except. 1 | VSCMP_ART1 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PROF_VGL1 | Project Info System Profile: Comparison Criteria | PS_PROF_VGL | TCNVG | CHAR | 12 | 0 | ||||||||||||
| SELSET_HV2 | Variant for general highlighting 2 | SELSET_HV2 | VARID | CHAR | 14 | 0 | ||||||||||||
| SELSET_BH2 | Variants for user-defined highlighting 2 | SELSET_BH2 | VARID | CHAR | 14 | 0 | ||||||||||||
| SELIDH2 | Selection ID highlighting 2 according to status | PS_SELIDH2 | TJ48 | CHAR | 7 | 0 | ||||||||||||
| VSCMP_ADD2 | Indicator: version comparison: objs created in exception 2 | VSCMP_ADD2 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| VSCMP_HIE2 | Indicator: version comparison: exception 2 other hierarchy | VSCMP_HIE2 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| VSCMP_ART2 | Version comparison: comparison type in change for except.2 | VSCMP_ART2 | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PROF_VGL2 | Project Info System Profile: Comparison Criteria | PS_PROF_VGL | TCNVG | CHAR | 12 | 0 | ||||||||||||
| FLG_HV_AMP | Indicator: display exceptions as traffic light | PS_FLG_HV_AMP | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_HV_AGR | Indicator: exceptions are aggregated | PS_FLG_HV_AGR | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_IV | Indicator: Display capital investment program | SEL_FLG_IV | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_IP | Indicator: Display capital investment program position | SEL_FLG_IP | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_PD | Indicator: Display project definitions | SEL_FLG_PD | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_PE | Indicator: Display WBS elements | SEL_FLG_PE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_PX | Indicator: Display PS texts | SEL_FLG_PX | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_VB | Indicator: Display sales documents | SEL_FLG_VB | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_VP | Indicator: Display sales document items | SEL_FLG_VP | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_PL | Indicator: Display planned orders | SEL_FLG_PL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_AF | Indicator: Display orders | SEL_FLG_AF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_NZ | Indicator: Display networks | SEL_FLG_NZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_VW | Indicator: Display activities processed internally | SEL_FLG_VW | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_VE | Indicator: Display activities processed externally | SEL_FLG_VE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_VC | Indicator: Display cost activities | SEL_FLG_VC | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_EW | Indicator: Display work elements | SEL_FLG_EW | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_EE | Indicator: Display external elements | SEL_FLG_EE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_EC | Indicator: Display cost components | SEL_FLG_EC | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_AB | Indicator: Display relationships | SEL_FLG_AB | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_MS | Indicator: Display milestones | SEL_FLG_MS | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_FH | Indicator: Display production resources and tools | SEL_FLG_FH | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_KB | Indicator: Display capacity requirements | SEL_FLG_KB | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_MR | Indicator: Display components | SEL_FLG_MR | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_RM | Indicator: Display confirmations | SEL_FLG_RM | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SEL_FLG_SO | Indicator: Display other objects | SEL_FLG_SO | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PSRLV_MIT | Information system: line variant, funds overview | PSRLV_MIT | CHAR | 3 | 0 | |||||||||||||
| PSRLV_ERL | Report version for revenue overview | PSRLV_ERL | CHAR | 3 | 0 | |||||||||||||
| PSRLV_FIN | Information system: Line version of the financial overview | PSRLV_FIN | CHAR | 3 | 0 | |||||||||||||
| PROFIL_ID | ID of a user-spec. profile in the table for overall profiles | PROFIL_ID | TCY06 | CHAR | 10 | 0 | ||||||||||||
TCND foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TCND | MANDT | TCND | MANDT | T000 | Clients | MANDT |
| TCND | PROFIL_ID | TCND | MANDT | TCY06 | Overall profiles for capacity planning | MANDT |
| TCND | PROFIL_ID | TCND | PROFIL_ID | TCY06 | Overall profiles for capacity planning | PROFIL_ID |
| TCND | PROF_AG | TCND | TABNAME | TCNA | Project Information System: Summarization Criteria (Aggr.) | TABNAME |
| TCND | PROF_AG | TCND | PROF_AG | TCNA | Project Information System: Summarization Criteria (Aggr.) | PROFID |
| TCND | PROF_AG | '001' | TCNA | Project Information System: Summarization Criteria (Aggr.) | KENNI | |
| TCND | PROF_AG | TCND | MANDT | TCNA | Project Information System: Summarization Criteria (Aggr.) | MANDT |
| TCND | PROF_EG | TCND | MANDT | TCNEG | Project Information System: Field Selecton for Graphic | MANDT |
| TCND | PROF_EG | TCND | TABNAME | TCNEG | Project Information System: Field Selecton for Graphic | TABNAME |
| TCND | PROF_EG | TCND | PROF_EG | TCNEG | Project Information System: Field Selecton for Graphic | PROFID |
| TCND | PROF_EG | '001' | TCNEG | Project Information System: Field Selecton for Graphic | KENNI | |
| TCND | PROF_FD | TCND | TABNAME | TCNF | Project Information System: Displayed Fields | TABNAME |
| TCND | PROF_FD | TCND | PROF_FD | TCNF | Project Information System: Displayed Fields | PROFID |
| TCND | PROF_FD | '001' | TCNF | Project Information System: Displayed Fields | KENNI | |
| TCND | PROF_FD | TCND | MANDT | TCNF | Project Information System: Displayed Fields | MANDT |
| TCND | PROF_GP | TCND | PROF_GP | TCNP | Project Info System: Grouping Criteria | PROFID |
| TCND | PROF_GP | '001' | TCNP | Project Info System: Grouping Criteria | KENNI | |
| TCND | PROF_GP | TCND | MANDT | TCNP | Project Info System: Grouping Criteria | MANDT |
| TCND | PROF_GP | TCND | TABNAME | TCNP | Project Info System: Grouping Criteria | TABNAME |
| TCND | PROF_GR | TCND | MANDT | TCNB | Information System Profile: Graphic Options | MANDT |
| TCND | PROF_GR | TCND | PROF_GR | TCNB | Information System Profile: Graphic Options | PROF_GR |
| TCND | PROF_SR | TCND | MANDT | TCNS | Project Info System: Sort Criteria | MANDT |
| TCND | PROF_SR | TCND | TABNAME | TCNS | Project Info System: Sort Criteria | TABNAME |
| TCND | PROF_SR | TCND | PROF_SR | TCNS | Project Info System: Sort Criteria | PROFID |
| TCND | PROF_SR | '001' | TCNS | Project Info System: Sort Criteria | KENNI | |
| TCND | PROF_VGL | TCND | MANDT | TCNVG | Project Information System: Version Comparison Criteria | MANDT |
| TCND | PROF_VGL | TCND | TABNAME | TCNVG | Project Information System: Version Comparison Criteria | TABNAME |
| TCND | PROF_VGL | TCND | PROF_VGL | TCNVG | Project Information System: Version Comparison Criteria | PROFID |
| TCND | PROF_VGL | * | TCNVG | Project Information System: Version Comparison Criteria | KENNI | |
| TCND | PROF_VGL1 | TCND | TABNAME | TCNVG | Project Information System: Version Comparison Criteria | TABNAME |
| TCND | PROF_VGL1 | TCND | PROF_VGL1 | TCNVG | Project Information System: Version Comparison Criteria | PROFID |
| TCND | PROF_VGL1 | * | TCNVG | Project Information System: Version Comparison Criteria | KENNI | |
| TCND | PROF_VGL1 | TCND | MANDT | TCNVG | Project Information System: Version Comparison Criteria | MANDT |
| TCND | PROF_VGL2 | TCND | PROF_VGL2 | TCNVG | Project Information System: Version Comparison Criteria | PROFID |
| TCND | PROF_VGL2 | * | TCNVG | Project Information System: Version Comparison Criteria | KENNI | |
| TCND | PROF_VGL2 | TCND | MANDT | TCNVG | Project Information System: Version Comparison Criteria | MANDT |
| TCND | PROF_VGL2 | TCND | TABNAME | TCNVG | Project Information System: Version Comparison Criteria | TABNAME |
| TCND | SELID | TCND | MANDT | TJ48 | Check Table for Selection IDs | MANDT |
| TCND | SELID | TCND | SELID | TJ48 | Check Table for Selection IDs | SELID |
| TCND | SELIDH1 | TCND | MANDT | TJ48 | Check Table for Selection IDs | MANDT |
| TCND | SELIDH1 | TCND | SELIDH1 | TJ48 | Check Table for Selection IDs | SELID |
| TCND | SELIDH2 | TCND | MANDT | TJ48 | Check Table for Selection IDs | MANDT |
| TCND | SELIDH2 | TCND | SELIDH2 | TJ48 | Check Table for Selection IDs | SELID |
| TCND | SELSET_BFT | VARI | REPORT | VARID | Variant directory | REPORT |
| TCND | SELSET_BFT | TCND | SELSET_BFT | VARID | Variant directory | VARIANT |
| TCND | SELSET_BFT | * | VARID | Variant directory | FLAG1 | |
| TCND | SELSET_BFT | * | VARID | Variant directory | FLAG2 | |
| TCND | SELSET_BFT | TCND | MANDT | VARID | Variant directory | MANDT |
| TCND | SELSET_BH1 | VARI | REPORT | VARID | Variant directory | REPORT |
| TCND | SELSET_BH1 | TCND | SELSET_BH1 | VARID | Variant directory | VARIANT |
| TCND | SELSET_BH1 | * | VARID | Variant directory | FLAG1 | |
| TCND | SELSET_BH1 | * | VARID | Variant directory | FLAG2 | |
| TCND | SELSET_BH1 | TCND | MANDT | VARID | Variant directory | MANDT |
| TCND | SELSET_BH2 | TCND | SELSET_BH2 | VARID | Variant directory | VARIANT |
| TCND | SELSET_BH2 | * | VARID | Variant directory | FLAG1 | |
| TCND | SELSET_BH2 | * | VARID | Variant directory | FLAG2 | |
| TCND | SELSET_BH2 | TCND | MANDT | VARID | Variant directory | MANDT |
| TCND | SELSET_BH2 | VARI | REPORT | VARID | Variant directory | REPORT |
| TCND | SELSET_FLT | TCND | SELSET_FLT | VARID | Variant directory | VARIANT |
| TCND | SELSET_FLT | * | VARID | Variant directory | FLAG1 | |
| TCND | SELSET_FLT | * | VARID | Variant directory | FLAG2 | |
| TCND | SELSET_FLT | TCND | MANDT | VARID | Variant directory | MANDT |
| TCND | SELSET_FLT | 'RCNFS000' | VARID | Variant directory | REPORT | |
| TCND | SELSET_HV1 | TCND | SELSET_HV1 | VARID | Variant directory | VARIANT |
| TCND | SELSET_HV1 | * | VARID | Variant directory | FLAG1 | |
| TCND | SELSET_HV1 | * | VARID | Variant directory | FLAG2 | |
| TCND | SELSET_HV1 | TCND | MANDT | VARID | Variant directory | MANDT |
| TCND | SELSET_HV1 | 'RCNFS000' | VARID | Variant directory | REPORT | |
| TCND | SELSET_HV2 | * | VARID | Variant directory | FLAG1 | |
| TCND | SELSET_HV2 | * | VARID | Variant directory | FLAG2 | |
| TCND | SELSET_HV2 | TCND | MANDT | VARID | Variant directory | MANDT |
| TCND | SELSET_HV2 | 'RCNFS000' | VARID | Variant directory | REPORT | |
| TCND | SELSET_HV2 | TCND | SELSET_HV2 | VARID | Variant directory | VARIANT |
| TCND | SELSET_OFT | * | VARID | Variant directory | FLAG1 | |
| TCND | SELSET_OFT | * | VARID | Variant directory | FLAG2 | |
| TCND | SELSET_OFT | TCND | MANDT | VARID | Variant directory | MANDT |
| TCND | SELSET_OFT | 'RCNOF000' | VARID | Variant directory | REPORT | |
| TCND | SELSET_OFT | TCND | SELSET_OFT | VARID | Variant directory | VARIANT |
| TCND | TABNAME | TCND | TABNAME | TCNE | PS Info System: Object Table for Reporting Structures | TABNAME |
