TCNDB SAP table for – Profile: Database parameters in Project Info System

Here we would like to draw your attention to TCNDB table in SAP. As we know it is being mainly used with the SAP PS-IS (Information System in PS) component which is coming under PS module (Project Systems). TCNDB is a SAP standard transparent table used for storing Profile: Database parameters in Project Info System related data in SAP. It comes under the package CNIS.

SAP TCNDB table

Table TCNDB technical data

TableTCNDB
Data storingProfile: Database parameters in Project Info System
ModulePS
ComponentPS-IS
SAP PackageCNIS
Delivery ClassE – System table whose data is transported with its own transport objects
Table CategoryTRANSPARENT

SAP TCNDB Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TCNDB table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SUBPR
    Its data type is C (Character String) with field length 12
  • NETZ_PSP
    Its data type is C (Character String) with field length 1
  • ACT
    Its data type is C (Character String) with field length 1
  • AOBKZ
    Its data type is C (Character String) with field length 1
  • MLST
    Its data type is C (Character String) with field length 1
  • PROFID : CMC: Profile
    Its a key field. Its data type is C (Character String) with field length 12
  • FHM
    Its data type is C (Character String) with field length 1
  • CONF
    Its data type is C (Character String) with field length 1
  • EVA
    Its data type is C (Character String) with field length 1
  • EBL
    Its data type is C (Character String) with field length 1
  • MAXLEVEL
    Its data type is X (Byte string) with field length 1
  • VARIANTE : Filter: Variant
    Its data type is C (Character String) with field length 14
  • VSNUMMER
    Its data type is C (Character String) with field length 12
  • VSGRUPPE
    Its data type is C (Character String) with field length 20
  • COREP
    Its data type is C (Character String) with field length 1
  • SHOW_ARCH
    Its data type is C (Character String) with field length 1
  • SHOW_STD
    Its data type is C (Character String) with field length 1
  • PROTECT
    Its data type is C (Character String) with field length 1
  • INCIH
    Its data type is C (Character String) with field length 1
  • INCIHVG
    Its data type is C (Character String) with field length 1
  • INCORVG
    Its data type is C (Character String) with field length 1
  • INCIHSUB
    Its data type is C (Character String) with field length 1
  • INCPP
    Its data type is C (Character String) with field length 1
  • INCPPVG
    Its data type is C (Character String) with field length 1
  • HIE_DYN
    Its data type is C (Character String) with field length 1
  • QUANT
    Its data type is C (Character String) with field length 1
  • SDOR
    Its data type is C (Character String) with field length 1
  • PRPS
    Its data type is C (Character String) with field length 1
  • HIEKZ
    Its data type is C (Character String) with field length 1