1. Home
  2. Resources
  3. SAP Tables
  4. TCNDB - Profile: Database parameters in Project Info System

SAP Table TCNDB

Profile: Database parameters in Project Info System

TCNDB (Profile: Database parameters in Project Info System) 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 TCNDB to other SAP tables.

TCNDB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PROFID Profile for logical database PSJ PS_PROF_DB CHAR 12 0
AENAM Last changed by PS_AENAM CHAR 12 0
PROTECT Indicator: Protected entry PS_PROTECT CHAR 1 0
X Yes
NULL No
CUSTOM Indicator: Maintenance only allowed from initial menu PS_CUSTOM CHAR 1 0
X Yes
NULL No
SDOR Select sales document DB_FLG_SOR CHAR 1 0
X Yes
NULL No
PROJ Indicator: Select project definitions DB_FLG_PRO CHAR 1 0
X Yes
NULL No
PRPS Indicator: Select WBS elements DB_FLG_PSP CHAR 1 0
X Yes
NULL No
HIEKZ Indicator: WBS element, including hierarchy CN_HIEKZ CHAR 1 0
X Yes
NULL No
SUBPRKZ Indicator: Subproject view of WBS hierarchy DB_FLG_TPR CHAR 1 0
X Yes
NULL No
SUBPR Sub-project in work breakdown structure PS_SUBPR PRTP CHAR 12 0
PLAF Indicator: Select planned orders DB_FLG_PLF CHAR 1 0
X Yes
NULL No
NETZ_PSP Indicator: Select networks/orders for WBS DB_FLG_NPS CHAR 1 0
X Yes
NULL No
NETZ Indicator: Select networks/orders (not those for WBS) DB_FLG_NET CHAR 1 0
X Yes
NULL No
ACT_PSP Indicator: Select WBS activities DB_FLG_APS CHAR 1 0
X Yes
NULL No
ACT Indicator: Select activities (outside WBS) DB_FLG_ACT CHAR 1 0
X Yes
NULL No
AOB Select relationships DB_FLG_AOB CHAR 1 0
X Yes
NULL No
AOBKZ Key: View of relationships CN_AOBKZ CHAR 1 0
1 Predecessor
2 Successor
3 Mixed
4 As created
MLST Indicator: Select milestones DB_FLG_MLT CHAR 1 0
X Yes
NULL No
PSTX Indicator: Select PS texts/documents DB_FLG_PTX CHAR 1 0
X Yes
NULL No
FHM Indicator: Select PRT DB_FLG_FHM CHAR 1 0
X Yes
NULL No
KAPA Indicator: Select capacity requirements DB_FLG_KAP CHAR 1 0
X Yes
NULL No
KOMP Indicator: Select components DB_FLG_MRS CHAR 1 0
X Yes
NULL No
CONF Indicator: Select confirmations DB_FLG_CON CHAR 1 0
X Yes
NULL No
EVA Indicator: Select earned values DB_FLG_EVA CHAR 1 0
X Yes
NULL No
COST Indicator: Select account assignment data (CO object) DB_FLG_OBJ CHAR 1 0
X Yes
NULL No
EBL Select Purchasing Data DB_FLG_EBL CHAR 1 0
X Yes
NULL No
MAXLEVEL Maximum display in the Project Info System DB_FLG_LEV INT1 3 0
VARIANTE Variant Name RALDB_VARI CHAR 14 0
DB_VIEW Structure view of Project Info System database PS_DB_VIEW TCNDS CHAR 12 0
VSNUMMER Number or description of a version VSNMR CHAR 12 0
VSGRUPPE Group for a project version VSGRUPPE CHAR 20 0
MODIF Checkbox XFELD CHAR 1 0
X Yes
NULL No
PFAD_OBEN Indicator: Superior elements are displayed PFAD_OBEN CHAR 1 0
X Yes
NULL No
COREP Indicator: Commercial evaluation DB_FLG_COR CHAR 1 0
X Yes
NULL No
SHOW_VERS Indicator: Entry from versions allowed DB_FLG_VER CHAR 1 0
X Yes
NULL No
SHOW_ARCH Indicator: Entry from archives allowed DB_FLG_ARC CHAR 1 0
X Yes
NULL No
SHOW_STD Indicator: Standard structures DB_FLG_STD CHAR 1 0
X Yes
NULL No
INCNT Selection with networks for WBS (Project System) CN_INCNT CHAR 1 0
X Yes
NULL No
INCVG Selection with network activities for WBS (Project System) CN_INCVG CHAR 1 0
X Yes
NULL No
INCIH Indicator: Select maintenance order CN_INCIH CHAR 1 0
X Yes
NULL No
INCIHVG Selection with act. in WBS maintenance order (Project Syst.) CN_INCIHVG CHAR 1 0
X Yes
NULL No
INCOR Selection with other orders for WBS (obsolete) CN_INCOR CHAR 1 0
X Yes
NULL No
INCORVG Selection with act. of other WBS orders (obsolete) CN_INCORVG CHAR 1 0
X Yes
NULL No
INCIHSUB Selection with suborders to maintenance order (obsolete) CN_INCIHSB CHAR 1 0
X Yes
NULL No
INCCO Selection with CO order for WBS (Project System) CN_INCCO CHAR 1 0
X Yes
NULL No
INCPP Selection with production orders for WBS (Project System) CN_INCPP CHAR 1 0
X Yes
NULL No
INCPPVG Select activities from prodn orders for the WBS (Proj.Syst.) CN_INCPPVG CHAR 1 0
X Yes
NULL No
INCTN Indicator: Select subnetworks/order networks/... CN_INCTN CHAR 1 0
X Yes
NULL No
HIE_DYN Dynamic selections also in hierarchy CN_HIE_DYN CHAR 1 0
X Yes
NULL No
QUANT Indicator: Select valuated quantities CN_QUANT CHAR 1 0
X Yes
NULL No

TCNDB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCNDB DB_VIEW TCNDB MANDT TCNDS Structure overview - Project Info System MANDT
TCNDB DB_VIEW TCNDB DB_VIEW TCNDS Structure overview - Project Info System DB_VIEW
TCNDB MANDT TCNDB MANDT T000 Clients MANDT
TCNDB SUBPR TCNDB SUBPR PRTP Subprojects SUBPR
TCNDB SUBPR TCNDB MANDT PRTP Subprojects MANDT