SAP ABAP Table DPR_TS_CTRLPLAN_I_EXT (Control Plan Characteristics Attributes (External))
Hierarchy
☛
CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
⤷ PPM-PRO-CPL (Application Component) Control Plan
⤷ DEVELOPMENT_PROJECTS_CTRL_PLAN (Package) Project Management - Control Plans
⤷ PPM-PRO-CPL (Application Component) Control Plan
⤷ DEVELOPMENT_PROJECTS_CTRL_PLAN (Package) Project Management - Control Plans
Basic Data
Table Category | INTTAB | Structure |
Structure | DPR_TS_CTRLPLAN_I_EXT | Table Relationship Diagram |
Short Description | Control Plan Characteristics Attributes (External) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Attributes for Control Plan Char.(Not Modifiable Externally) | |||||
2 | GUID | DPR_TV_GUID | DPR_GUID | RAW | 16 | 0 | Application Object GUID | ||
3 | LAST_CHANGE_DATE | DPR_TV_LAST_CHANGE_DATE | DATS | 8 | 0 | Date of Last Change | |||
4 | LAST_CHANGE_TIME | DPR_TV_LAST_CHANGE_TIME | TIMS | 6 | 0 | Last Changed at | |||
5 | .INCLUDE | 0 | 0 | Project Planning: Projects and Activities Include Structure | |||||
6 | PROJECT_GUID | CGPL_PROJECT_GUID | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16 Character GUID for Projects | ||
7 | OBJECT_TYPE | CGPL_OBJECT_TYPE | CHAR3 | CHAR | 3 | 0 | Object Type in Project Planning | ||
8 | PRIORITY | CGPL_PRIORITY | NUMC3 | NUMC | 3 | 0 | Priority | CGPL_PRIO | |
9 | ACTUALSTART | CGPL_ACTUALSTART | BCOS_TSTMP | DEC | 15 | 0 | Actual Start Date | ||
10 | ACTUALFINISH | CGPL_ACTUALFINISH | BCOS_TSTMP | DEC | 15 | 0 | Actual Finish Date | ||
11 | PLANSTART | CGPL_PLANSTART | BCOS_TSTMP | DEC | 15 | 0 | Planned start date | ||
12 | PLANFINISH | CGPL_PLANFINISH | BCOS_TSTMP | DEC | 15 | 0 | Planned Finish Date | ||
13 | COMPLETION | CGPL_COMPLETION | CGPL_COMPLETION | NUMC | 3 | 0 | Percentage of Completion | ||
14 | MILESTONE | CGPL_MILESTONE | CHAR1 | CHAR | 1 | 0 | Milestone indicator | ||
15 | CONSTRAINT_TYPE | CGPL_CONSTRAINT | CGPL_CONSTRAINT | CHAR | 1 | 0 | Type of Scheduling Constraint | ||
16 | CONSTRAINT_TIME | CGPL_CONSTRAINT_TIME | BCOS_TSTMP | DEC | 15 | 0 | Constraint Date | ||
17 | CREATED_BY | CGPL_CREATED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Created Object | ||
18 | CREATED_ON | CGPL_CREATED_ON | DATUM | DATS | 8 | 0 | Date on Which the Object was Created | ||
19 | CREATED_IN_BW | CGPL_CREATED_BW | CHAR1 | CHAR | 1 | 0 | Transfer Object to BW | ||
20 | CHANGED_BY | CGPL_CHANGED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
21 | CHANGED_ON | CGPL_CHANGED_ON | DATUM | DATS | 8 | 0 | Date on Which Object Was Last Changed | ||
22 | UPDATED_IN_BW | CGPL_UPDATED_BW | CHAR1 | CHAR | 1 | 0 | Current Object in BW | ||
23 | BWIDENTIFIER | CGPL_BWIDENTIFIER | CGPL_BWIDENTIFIER | NUMC | 8 | 0 | Project Planning - BW Identification | ||
24 | PLANGROUP | CGPL_SEM_PLGRP | CHAR | 4 | 0 | Planning Profile Group | |||
25 | LATEST_START | CGPL_LATEST_START | BCOS_TSTMP | DEC | 15 | 0 | Latest start | ||
26 | LATEST_FINISH | CGPL_LATEST_FINISH | BCOS_TSTMP | DEC | 15 | 0 | Latest finish date | ||
27 | TOTAL_FLOAT | CGPL_TOTAL_FLOAT | CGPL_FLOAT | DEC | 8 | 2 | Total Float | ||
28 | DURATION | CGPL_DURATION | CGPL_DURATION | DEC | 8 | 2 | Duration of Execution | ||
29 | DURATION_UNIT | CGPL_DURATION_UNIT | MEINS | UNIT | 3 | 0 | Time Unit for Execution Duration | * | |
30 | CALENDAR_ID | WFCID | WFCID | CHAR | 2 | 0 | Factory Calendar | * | |
31 | CONSTR_TYPE_FIN | CGPL_CONSTRAINT | CGPL_CONSTRAINT | CHAR | 1 | 0 | Type of Scheduling Constraint | ||
32 | CONSTR_TIME_FIN | CGPL_CONSTRAINT_TIME | BCOS_TSTMP | DEC | 15 | 0 | Constraint Date | ||
33 | APPLICATION | CGPL_APPLICATION_TYPE | CGPL_APPLICATION_TYPE | CHAR | 3 | 0 | Application in Project Planning | * | |
34 | FORECAST_START | CGPL_FORECAST_START | BCOS_TSTMP | DEC | 15 | 0 | Forecast Start | ||
35 | FORECAST_FINISH | CGPL_FORECAST_FINISH | BCOS_TSTMP | DEC | 15 | 0 | Forecast Finish | ||
36 | GUID_CHAR | DPR_TV_OBJECT_GUID_CHAR | SYSUUID_C | CHAR | 32 | 0 | Unique Object Key | ||
37 | CREATED_BY_NAME | DPR_TV_CREATED_BY_NAME | TEXT80 | CHAR | 80 | 0 | Name of Person Who Created the Project Element | ||
38 | CHANGED_BY_NAME | DPR_TV_CHANGED_BY_NAME | TEXT80 | CHAR | 80 | 0 | Name of Person Who Last Changed the Project Element | ||
39 | .INCLUDE | 0 | 0 | Control Plan Characteristic Attributes (Extern. Modifiable) | |||||
40 | EXTERNAL_ID | CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
41 | .INCLUDE | 0 | 0 | Control Plan: Items | |||||
42 | .INCLUDE | 0 | 0 | Control Plan Include: Items Without Strings | |||||
43 | ITEM_ID | DPR_TV_ITEM_UNIQUE_ID | DPR_CP_ITEM_ID | CHAR | 15 | 0 | Unique Characteristic ID in the Control Plan | ||
44 | VERSION_NUMBER | CGPL_TV_VERSION | CGPL_VERSION | CHAR | 24 | 0 | Version Number | ||
45 | PROCESS_NR | DPR_TV_PROC_NR | DPR_CP_CHA_SEQ_NR | NUMC | 10 | 0 | Process Number in Control Plan | ||
46 | PROCESS_ID | DPR_TV_PROC_ID | DPR_CP_ITEM_ID | CHAR | 15 | 0 | Process ID in Control Plan (Predefined in Customizing) | DPR_CP_PROC | |
47 | PROCESS_NAME | DPR_TV_TEXT | DPR_TEXT | CHAR | 40 | 0 | Object Name | ||
48 | PROC_IND | DPR_TV_CP_IND_PROC_OR_PART | DPR_CP_ITEM_TYPE | CHAR | 1 | 0 | Control Plan: Item Category | ||
49 | PROC_STAGE | DPR_TV_CP_STAGE | DPR_STAGE | CHAR | 15 | 0 | Control Plan Stage/Category | ||
50 | TOOL_ID | DPR_TV_CP_TOOL_ID | DPR_CP_ITEM_ID | CHAR | 15 | 0 | Tools, Machines, and so on in Control Plan | DPR_CP_TOOL | |
51 | TOOL_SEQ_NR | DPR_TV_CP_TOOL_SEQ_NR | DPR_CP_TOOL_SEQ_NR | NUMC | 10 | 0 | Sequence Number of a Tool in the Control Plan | ||
52 | TOOL_INFO | DPR_TV_TEXT | DPR_TEXT | CHAR | 40 | 0 | Object Name | ||
53 | CHA_SEQ_NR | DPR_TV_CP_CHA_SEQ_NR | DPR_CP_CHA_SEQ_NR | NUMC | 10 | 0 | Sequence Number of Characteristic in Control Plan | ||
54 | CHA_IND_PROD | DPR_TV_CP_CHA_IND_PROD | DPR_CP_CHA_IND_PROD | CHAR | 1 | 0 | Product (1) or Process Characteristic (0) in Control Plan | ||
55 | CHA_ID | DPR_TV_ITEM_ID | DPR_CP_ITEM_ID | CHAR | 15 | 0 | Characteristic ID in Control Plan | DPR_CP_ITEM | |
56 | CHA_UNIQUE_ID | DPR_TV_CHA_UNIQUE_ID | CHAR24 | CHAR | 24 | 0 | System-Wide Unique Characteristic ID in the Control Plan | ||
57 | CHA_CLASSF | DPR_TV_CP_CHA_CLASSF | DPR_CP_CHA_CLASSF | CHAR | 20 | 0 | Classification of Special Characterictics in Control Plan | ||
58 | CHA_INFO | DPR_TV_TEXT | DPR_TEXT | CHAR | 40 | 0 | Object Name | ||
59 | CHA_PLANTS | DPR_TV_CP_QM_PLANT | CHAR4 | CHAR | 4 | 0 | Plant of Master Inspection Characteristic | ||
60 | MTH_PDPC | DPR_TV_CP_MTH_PDPC | DPR_CP_MTH_PDPC | CHAR | 20 | 0 | Control Plan: Product/Process Specification and Tolerance | ||
61 | MTH_H_EV_MSR | DPR_TV_SYS_ID | DPR_CP_ITEM_ID | CHAR | 15 | 0 | Test System in Control Plan | DPR_CP_SYSTEM | |
62 | MTH_MSR_INFO | DPR_TV_TEXT | DPR_TEXT | CHAR | 40 | 0 | Object Name | ||
63 | MTH_SA_SZ | DPR_TV_CP_MTH_SA_SZ | CHAR | 8 | 0 | Sample Size | |||
64 | MTH_SA_FQ | DPR_TV_SAMPLE_ID | DPR_CP_ITEM_ID | CHAR | 15 | 0 | Sample in Control Plan | DPR_CP_SAMPLE | |
65 | MTH_CTRL | DPR_TV_CP_MTH_CTRL | DPR_CP_MTH_CTRL | CHAR | 20 | 0 | Control Plan: Control Method for a Process Step | ||
66 | REACT_PLAN | DPR_TV_CP_REACT_PLAN | DPR_CP_REACT_PLAN | CHAR | 20 | 0 | Response Plan in Control Plan | ||
67 | .INCLUDE | 0 | 0 | Control Plan Include: Characteristic Values | |||||
68 | CHA_TARGET_VALUE | DPR_TV_CP_CHAR_VALUE | CHAR20 | CHAR | 20 | 0 | Target Value of Characteristic in Control Plan | ||
69 | CHA_UP_VALUE1 | DPR_TV_CP_CHAR_VALUE | CHAR20 | CHAR | 20 | 0 | Target Value of Characteristic in Control Plan | ||
70 | CHA_DOWN_VALUE1 | DPR_TV_CP_CHAR_VALUE | CHAR20 | CHAR | 20 | 0 | Target Value of Characteristic in Control Plan | ||
71 | CHA_UP_VALUE2 | DPR_TV_CP_CHAR_VALUE | CHAR20 | CHAR | 20 | 0 | Target Value of Characteristic in Control Plan | ||
72 | CHA_DOWN_VALUE2 | DPR_TV_CP_CHAR_VALUE | CHAR20 | CHAR | 20 | 0 | Target Value of Characteristic in Control Plan | ||
73 | CHA_UP_VALUE3 | DPR_TV_CP_CHAR_VALUE | CHAR20 | CHAR | 20 | 0 | Target Value of Characteristic in Control Plan | ||
74 | CHA_DOWN_VALUE3 | DPR_TV_CP_CHAR_VALUE | CHAR20 | CHAR | 20 | 0 | Target Value of Characteristic in Control Plan | ||
75 | CHA_PRINT_VALUES | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
76 | CHA_VALUE_UNIT | DPR_TV_CP_CHAR_UNIT | MEINS | UNIT | 3 | 0 | Unit of Characteristic in Control Plan | * | |
77 | .INCLUDE | 0 | 0 | Include for Extended Attributes for Control Plan Item | |||||
78 | EA_DUMMY | DPR_TV_EA_DUMMY | CHAR1 | CHAR | 1 | 0 | Dummy Data Element for Enhanced Proj. Mgmt Attributes | ||
79 | .INCLUDE | 0 | 0 | ||||||
80 | CHA_NAME | DPR_TV_CP_CHAR_NAME | DPR_TEXT | CHAR | 40 | 0 | Characteristic Name | ||
81 | .INCLUDE | 0 | 0 | Control Plan: Include Items with Strings | |||||
82 | INFOFIELD | DPR_TV_IT_INFO | STRG | 0 | 0 | Characteristic Additional Field in Control Plan | |||
83 | DESCRIPTION | CGPL_TEXT1 | TEXT40 | CHAR | 40 | 0 | Language-Dependent Short Text |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | DPR_TS_CTRLPLAN_I_EXT | CHA_ID | DPR_CP_ITEM | ID | REF | 1 | CN |
2 | DPR_TS_CTRLPLAN_I_EXT | MTH_H_EV_MSR | DPR_CP_SYSTEM | ID | REF | 1 | CN |
3 | DPR_TS_CTRLPLAN_I_EXT | MTH_SA_FQ | DPR_CP_SAMPLE | ID | REF | 1 | CN |
4 | DPR_TS_CTRLPLAN_I_EXT | PRIORITY | CGPL_PRIO | PRIORITY | KEY | ||
5 | DPR_TS_CTRLPLAN_I_EXT | PROCESS_ID | DPR_CP_PROC | ID | REF | 1 | CN |
6 | DPR_TS_CTRLPLAN_I_EXT | TOOL_ID | DPR_CP_TOOL | ID | REF | 1 | CN |
History
Last changed by/on | SAP | 20141109 |
SAP Release Created in | 200 |