SAP table TCNDB (Profile: Database parameters in Project Info System)

SAP table TCNDB has 2 primary key fields being MANDT,PROFID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

TCNDB foreign key relationships

Table Field Check Table Check Field
0 TCNDB DB_VIEW TCNDS Structure overview - Project Info System MANDT
0 TCNDB DB_VIEW TCNDS Structure overview - Project Info System DB_VIEW
1 TCNDB SUBPR PRTP Subprojects MANDT
1 TCNDB SUBPR PRTP Subprojects SUBPR