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

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS (Application Component) Information System
     ⤷ CNIS (Package) Application development R/3 PS information system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TCNDB	Table Relationship Diagram
Short Description	Profile: Database parameters in Project Info System

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PROFID	☑	PS_PROF_DB	PS_PROF_DB	CHAR	12	0	Profile for logical database PSJ
3	AENAM	☐	PS_AENAM	USNAM	CHAR	12	0	Last changed by
4	PROTECT	☐	PS_PROTECT	XFELD	CHAR	1	0	Indicator: Protected entry
5	CUSTOM	☐	PS_CUSTOM	XFELD	CHAR	1	0	Indicator: Maintenance only allowed from initial menu
6	SDOR	☐	DB_FLG_SOR	XFELD	CHAR	1	0	Select sales document
7	PROJ	☐	DB_FLG_PRO	XFELD	CHAR	1	0	Indicator: Select project definitions
8	PRPS	☐	DB_FLG_PSP	XFELD	CHAR	1	0	Indicator: Select WBS elements
9	HIEKZ	☐	CN_HIEKZ	XFELD	CHAR	1	0	Indicator: WBS element, including hierarchy
10	SUBPRKZ	☐	DB_FLG_TPR	XFELD	CHAR	1	0	Indicator: Subproject view of WBS hierarchy
11	SUBPR	☐	PS_SUBPR	PS_SUBPR	CHAR	12	0	Sub-project in work breakdown structure	PRTP
12	PLAF	☐	DB_FLG_PLF	XFELD	CHAR	1	0	Indicator: Select planned orders
13	NETZ_PSP	☐	DB_FLG_NPS	XFELD	CHAR	1	0	Indicator: Select networks/orders for WBS
14	NETZ	☐	DB_FLG_NET	XFELD	CHAR	1	0	Indicator: Select networks/orders (not those for WBS)
15	ACT_PSP	☐	DB_FLG_APS	XFELD	CHAR	1	0	Indicator: Select WBS activities
16	ACT	☐	DB_FLG_ACT	XFELD	CHAR	1	0	Indicator: Select activities (outside WBS)
17	AOB	☐	DB_FLG_AOB	XFELD	CHAR	1	0	Select relationships
18	AOBKZ	☐	CN_AOBKZ	AOB_KEY	CHAR	1	0	Key: View of relationships
19	MLST	☐	DB_FLG_MLT	XFELD	CHAR	1	0	Indicator: Select milestones
20	PSTX	☐	DB_FLG_PTX	XFELD	CHAR	1	0	Indicator: Select PS texts/documents
21	FHM	☐	DB_FLG_FHM	XFELD	CHAR	1	0	Indicator: Select PRT
22	KAPA	☐	DB_FLG_KAP	XFELD	CHAR	1	0	Indicator: Select capacity requirements
23	KOMP	☐	DB_FLG_MRS	XFELD	CHAR	1	0	Indicator: Select components
24	CONF	☐	DB_FLG_CON	XFELD	CHAR	1	0	Indicator: Select confirmations
25	EVA	☐	DB_FLG_EVA	XFELD	CHAR	1	0	Indicator: Select earned values
26	COST	☐	DB_FLG_OBJ	XFELD	CHAR	1	0	Indicator: Select account assignment data (CO object)
27	EBL	☐	DB_FLG_EBL	XFELD	CHAR	1	0	Select Purchasing Data
28	MAXLEVEL	☐	DB_FLG_LEV	INT1	INT1	3	0	Maximum display in the Project Info System
29	VARIANTE	☐	RALDB_VARI	RALDB_VARI	CHAR	14	0	Variant Name
30	DB_VIEW	☐	PS_DB_VIEW	PS_DB_VIEW	CHAR	12	0	Structure view of Project Info System database	TCNDS
31	VSNUMMER	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
32	VSGRUPPE	☐	VSGRUPPE	TEXT20	CHAR	20	0	Group for a project version
33	MODIF	☐	XFELD	XFELD	CHAR	1	0	Checkbox
34	PFAD_OBEN	☐	PFAD_OBEN	XFELD	CHAR	1	0	Indicator: Superior elements are displayed
35	COREP	☐	DB_FLG_COR	XFELD	CHAR	1	0	Indicator: Commercial evaluation
36	SHOW_VERS	☐	DB_FLG_VER	XFELD	CHAR	1	0	Indicator: Entry from versions allowed
37	SHOW_ARCH	☐	DB_FLG_ARC	XFELD	CHAR	1	0	Indicator: Entry from archives allowed
38	SHOW_STD	☐	DB_FLG_STD	XFELD	CHAR	1	0	Indicator: Standard structures
39	INCNT	☐	CN_INCNT	XFELD	CHAR	1	0	Selection with networks for WBS (Project System)
40	INCVG	☐	CN_INCVG	XFELD	CHAR	1	0	Selection with network activities for WBS (Project System)
41	INCIH	☐	CN_INCIH	XFELD	CHAR	1	0	Indicator: Select maintenance order
42	INCIHVG	☐	CN_INCIHVG	XFELD	CHAR	1	0	Selection with act. in WBS maintenance order (Project Syst.)
43	INCOR	☐	CN_INCOR	XFELD	CHAR	1	0	Selection with other orders for WBS (obsolete)
44	INCORVG	☐	CN_INCORVG	XFELD	CHAR	1	0	Selection with act. of other WBS orders (obsolete)
45	INCIHSUB	☐	CN_INCIHSB	XFELD	CHAR	1	0	Selection with suborders to maintenance order (obsolete)
46	INCCO	☐	CN_INCCO	XFELD	CHAR	1	0	Selection with CO order for WBS (Project System)
47	INCPP	☐	CN_INCPP	XFELD	CHAR	1	0	Selection with production orders for WBS (Project System)
48	INCPPVG	☐	CN_INCPPVG	XFELD	CHAR	1	0	Select activities from prodn orders for the WBS (Proj.Syst.)
49	INCTN	☐	CN_INCTN	XFELD	CHAR	1	0	Indicator: Select subnetworks/order networks/...
50	HIE_DYN	☐	CN_HIE_DYN	XFELD	CHAR	1	0	Dynamic selections also in hierarchy
51	QUANT	☐	CN_QUANT	XFELD	CHAR	1	0	Indicator: Select valuated quantities

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCNDB	DB_VIEW	TCNDS	DB_VIEW	REF	C	CN
2	TCNDB	MANDT	T000	MANDT	KEY	1	CN
3	TCNDB	SUBPR	PRTP	SUBPR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in