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
⤷ 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 |