SAP ABAP Table /ISDFPS/TCUPS_HEADER (DFPS: Confirmation - UPS Distribution)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-PDR (Application Component) Master Data Distribution
     ⤷ /ISDFPS/UPS_EXTENSIONS_ASSET (Package) Asset Objects in UPS

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/TCUPS_HEADER	Table Relationship Diagram
Short Description	DFPS: Confirmation - UPS Distribution

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	Display Structure for PM/CS Confirmation
2	CONF_NO	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
3	CONF_CNT	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
4	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
5	OPERATION	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
6	SUB_OPER	☐	UVORN	VORNR	CHAR	4	0	Suboperation
7	CAPA_CATEGORY	☐	KAPART	KAPART	CHAR	3	0	Capacity category	TC26
8	SPLIT	☐	CY_SPLIT	INT1	INT1	3	0	Split number
9	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	CREATED_DATE	☐	ERSDA	DATUM	DATS	8	0	Created On
11	CREATED_TIME	☐	ERZET	UZEIT	TIMS	6	0	Entry time
12	REVERSED	☐	CO_STOKZ	FLAG	CHAR	1	0	Indicator: Document Has Been Reversed
13	REV_CONF_CNT	☐	CO_STZHL	CIM_COUNT	NUMC	8	0	Confirmation counter of cancelled confirmation
14	FIN_CONF	☐	AUERU_VS	AUERU_VS	CHAR	1	0	Partial/Final Confirmation
15	COMPLETE	☐	LEKNW	XFELD	CHAR	1	0	Indicator: No Remaining Work Expected
16	CLEAR_RES	☐	AUSBU	XFELD	CHAR	1	0	Clear Open Reservations
17	POSTG_DATE	☐	BUCHDATUM	DATUM	DATS	8	0	Posting date
18	DEV_REASON	☐	CO_AGRND	CO_AGRND	CHAR	4	0	Reason for Variance	TRUG
19	DEV_REAS_TXT	☐	CO_GRDTX	TEXT30	CHAR	30	0	Text describing the reason for a variance in a confirmation
20	CONF_TEXT	☐	CO_RTEXT	TEXT40	CHAR	40	0	Confirmation text
21	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
22	WORK_CNTR	☐	ARBPL	ARBPL	CHAR	8	0	Work center
23	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
24	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
25	ACT_WORK	☐	ISMNW	ARBEIT	QUAN	7	1	Actual work
26	UN_WORK	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
27	UN_WORK_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
28	REM_WORK	☐	REMNW	ARBEIT	QUAN	7	1	Remaining work
29	UN_REM_WRK	☐	OFMNE	MEINS	UNIT	3	0	Unit of measure for remaining work	T006
30	UN_REM_WRK_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
31	ACTUAL_DUR	☐	IDAUR	DAUER_4_1	QUAN	5	1	Actual duration for confirmation
32	UN_ACT_DUR	☐	IDAURE	MEINS	UNIT	3	0	Unit for actual duration	T006
33	UN_ACT_DUR_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
34	EXEC_START_DATE	☐	RU_ISDD	DATUM	DATS	8	0	Confirmed date for start of execution
35	EXEC_START_TIME	☐	RU_ISDZ	ATIME	TIMS	6	0	Confirmed time for 'Execution start'
36	EXEC_FIN_DATE	☐	RU_IEDD	DATUM	DATS	8	0	Confirmed date for execution finish
37	EXEC_FIN_TIME	☐	RU_IEDZ	ATIME	TIMS	6	0	Confirmed time for 'Execution finish'
38	FCST_FIN_DATE	☐	CO_PEDD	DATUM	DATS	8	0	Forecast finish date of operation from confirmation
39	FCST_FIN_TIME	☐	CO_PEDZ	ATIME	TIMS	6	0	Forecast finish time of operation from confirmation
40	PERS_NO	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
41	NAME	☐	RU_NAME	TEXT40	CHAR	40	0	Name of employee
42	TIMEID_NO	☐	DZAUSW	ZAUSW	NUMC	8	0	Time Recording ID Number
43	ACT_TYPE	☐	LEARR	LSTAR	CHAR	6	0	Activity type for confirmation	*
44	WAGETYPE	☐	LOHNART	LOART	CHAR	4	0	Wage type
45	CALC_MOTIVE	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
46	EX_CREATED_BY	☐	RU_EXNAM	USNAM	CHAR	12	0	External creator of confirmation
47	EX_CREATED_DATE	☐	RU_EXERD	DATUM	DATS	8	0	External date of entry for confirmation
48	EX_CREATED_TIME	☐	RU_EXERZ	UZEIT	TIMS	6	0	External time of entry for confirmation
49	EX_IDENT	☐	RU_EXTID_CHAR	SYSUUID_C	CHAR	32	0	External key of a confirmation (for example from PDC system)
50	ACT_WORK_2	☐	ISMNW_2	ARBEIT_2	QUAN	8	2	Actual Work
51	UN_WORK_2	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
52	UN_WORK_ISO_2	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
53	REM_WORK_2	☐	REMNW_2	ARBEIT_2	QUAN	8	2	Remaining Work
54	UN_REM_WRK_2	☐	OFMNE	MEINS	UNIT	3	0	Unit of measure for remaining work	T006
55	UN_REM_WRK_ISO_2	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
56	START_POINT	☐	EAML_START_POINT	EAML_POINT	CHAR	18	0	Start Point
57	END_POINT	☐	EAML_END_POINT	EAML_POINT	CHAR	18	0	End Point
58	LINEAR_LENGTH	☐	EAML_LINEAR_LENGTH	EAML_POINT	CHAR	18	0	Length
59	LINEAR_UNIT	☐	EAML_LINEAR_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Linear Data	T006
60	LINEAR_UNIT_ISO	☐	EAML_LINEAR_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Linear Data in ISO Code	*
61	FIRST_OFFSET_TYPE_CODE	☐	EAML_OFFSET1_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of First Offset	EAML_D_OFFSET_TC
62	FIRST_OFFSET_VALUE	☐	EAML_OFFSET1_VALUE	EAML_POINT	CHAR	18	0	Value of Offset 1
63	FIRST_OFFSET_UNIT	☐	EAML_OFFSET1_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 1	T006
64	FIRST_OFFSET_UNIT_ISO	☐	EAML_OFFSET1_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Offset 1 in ISO Code	*
65	SECOND_OFFSET_TYPE_CODE	☐	EAML_OFFSET2_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of Second Offset	EAML_D_OFFSET_TC
66	SECOND_OFFSET_VALUE	☐	EAML_OFFSET2_VALUE	EAML_POINT	CHAR	18	0	Value of Offset 2
67	SECOND_OFFSET_UNIT	☐	EAML_OFFSET2_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 2	T006
68	SECOND_OFFSET_UNIT_ISO	☐	EAML_OFFSET2_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Offset 2 in ISO Code	*
69	MARKER_START_POINT	☐	EAML_MARKER_START_POINT	EAML_MARKER	CHAR	18	0	Marker for Start Point
70	MARKER_DISTANCE_START_POINT	☐	EAML_MARKER_DISTANCE_START	EAML_POINT	CHAR	18	0	Distance between Marker and Start Point
71	MARKER_END_POINT	☐	EAML_MARKER_END_POINT	EAML_MARKER	CHAR	18	0	Marker for End Point
72	MARKER_DISTANCE_END_POINT	☐	EAML_MARKER_DISTANCE_END	EAML_POINT	CHAR	18	0	Length Spec for Distance between Marker and End Point
73	MARKER_DISTANCE_UNIT	☐	EAML_MARKER_DISTANCE_UNIT	MEINS	UNIT	3	0	Unit for the Distance from Marker	T006
74	MARKER_DISTANCE_UNIT_ISO	☐	EAML_MARKER_DISTANCE_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit for the Distance from Marker in ISO Code	*
75	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/TCUPS_HEADER	CAPA_CATEGORY	TC26	KAPAR
2	/ISDFPS/TCUPS_HEADER	DEV_REASON	TRUG	GRUND
3	/ISDFPS/TCUPS_HEADER	FIRST_OFFSET_TYPE_CODE	EAML_D_OFFSET_TC	OFFSET_TC
4	/ISDFPS/TCUPS_HEADER	FIRST_OFFSET_UNIT	T006	MSEHI
5	/ISDFPS/TCUPS_HEADER	LINEAR_UNIT	T006	MSEHI
6	/ISDFPS/TCUPS_HEADER	MARKER_DISTANCE_UNIT	T006	MSEHI
7	/ISDFPS/TCUPS_HEADER	ORDERID	AUFK	AUFNR
8	/ISDFPS/TCUPS_HEADER	PLANT	T001W	WERKS
9	/ISDFPS/TCUPS_HEADER	SECOND_OFFSET_TYPE_CODE	EAML_D_OFFSET_TC	OFFSET_TC
10	/ISDFPS/TCUPS_HEADER	SECOND_OFFSET_UNIT	T006	MSEHI
11	/ISDFPS/TCUPS_HEADER	UN_ACT_DUR	T006	MSEHI
12	/ISDFPS/TCUPS_HEADER	UN_ACT_DUR_ISO	T006I	ISOCODE
13	/ISDFPS/TCUPS_HEADER	UN_REM_WRK	T006	MSEHI
14	/ISDFPS/TCUPS_HEADER	UN_REM_WRK_2	T006	MSEHI
15	/ISDFPS/TCUPS_HEADER	UN_REM_WRK_ISO	T006I	ISOCODE
16	/ISDFPS/TCUPS_HEADER	UN_REM_WRK_ISO_2	T006I	ISOCODE
17	/ISDFPS/TCUPS_HEADER	UN_WORK	T006	MSEHI
18	/ISDFPS/TCUPS_HEADER	UN_WORK_2	T006	MSEHI
19	/ISDFPS/TCUPS_HEADER	UN_WORK_ISO	T006I	ISOCODE
20	/ISDFPS/TCUPS_HEADER	UN_WORK_ISO_2	T006I	ISOCODE

History

Last changed by/on	SAP	20130529
SAP Release Created in	200