SAP ABAP Table P0697 (Drug screening)

Hierarchy

☛ SAP_HRCUS (Software Component) Sub component SAP_HRCUS of SAP_HR
   ⤷ PY-US-PS (Application Component) Öffentlicher Dienst
     ⤷ P10P1 (Package) HR Public Sector USA

Basic Data

Table Category	INTTAB	Structure
Structure	P0697	Table Relationship Diagram
Short Description	Drug screening

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	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	Drug screening
28	TESTY	☐	P10_TESTY	SUBTY_591A	CHAR	4	0	Drug screening test type	T591A
29	TESDT	☐	P10_TESDT	DDATE	DATS	8	0	Sample collecting date
30	TESRN	☐	P10_TERSN	P10_TERSN	CHAR	4	0	Drug screening test reason	T5UPBS20DSR
31	TRESU	☐	P10_TRESU	P10_TRESU	CHAR	1	0	Overall test result	T5UPBS20DSU
32	SANUM	☐	P10_SANUM	CHAR8	CHAR	8	0	Sample number
33	TEXEC	☐	P10_TEXEC	TEXT80	CHAR	80	0	Test executer name
34	TOBSE	☐	P10_TOBSE	TEXT80	CHAR	80	0	Test observer name
35	TSITE	☐	P10_TSITE	P10_TSITE	CHAR	4	0	Test site	T5UPBS20DSS
36	TMEDA	☐	P10_TMEDA	P10_TMETH	CHAR	4	0	Test method for sample A	T5UPBS20DSM
37	TMEDB	☐	P10_TMEDB	P10_TMETH	CHAR	4	0	Test method for sample B	T5UPBS20DSM
38	STA01	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
39	RSA01	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
40	ATA01	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
41	UTA01	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
42	STA02	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
43	RSA02	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
44	ATA02	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
45	UTA02	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
46	STA03	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
47	RSA03	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
48	ATA03	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
49	UTA03	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
50	STA04	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
51	RSA04	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
52	ATA04	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
53	UTA04	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
54	STA05	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
55	RSA05	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
56	ATA05	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
57	UTA05	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
58	STA06	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
59	RSA06	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
60	ATA06	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
61	UTA06	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
62	STA07	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
63	RSA07	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
64	ATA07	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
65	UTA07	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
66	STA08	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
67	RSA08	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
68	ATA08	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
69	UTA08	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
70	STA09	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
71	RSA09	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
72	ATA09	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
73	UTA09	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
74	STA10	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
75	RSA10	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
76	ATA10	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
77	UTA10	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
78	STB01	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
79	RSB01	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
80	ATB01	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
81	UTB01	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
82	STB02	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
83	RSB02	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
84	ATB02	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
85	UTB02	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
86	STB03	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
87	RSB03	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
88	ATB03	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
89	UTB03	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
90	STB04	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
91	RSB04	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
92	ATB04	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
93	UTB04	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
94	STB05	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
95	RSB05	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
96	ATB05	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
97	UTB05	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
98	STB06	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
99	RSB06	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
100	ATB06	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
101	UTB06	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
102	STB07	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
103	RSB07	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
104	ATB07	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
105	UTB07	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
106	STB08	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
107	RSB08	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
108	ATB08	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
109	UTB08	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
110	STB09	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
111	RSB09	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
112	ATB09	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
113	UTB09	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
114	STB10	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
115	RSB10	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
116	ATB10	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
117	UTB10	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
118	EADDR	☐	P10_CADDR	AD_ADDRNUM	CHAR	10	0	Address number	*
119	OADDR	☐	P10_CADDR	AD_ADDRNUM	CHAR	10	0	Address number	*
120	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0697	INFTY	T582A	INFTY
2	P0697	PREAS	T530E	PREAS
3	P0697	RSA01	T5UPBS20DSUT	TRESU
4	P0697	RSA02	T5UPBS20DSUT	TRESU
5	P0697	RSA03	T5UPBS20DSUT	TRESU
6	P0697	RSA04	T5UPBS20DSUT	TRESU
7	P0697	RSA05	T5UPBS20DSUT	TRESU
8	P0697	RSA06	T5UPBS20DSUT	TRESU
9	P0697	RSA07	T5UPBS20DSUT	TRESU
10	P0697	RSA08	T5UPBS20DSUT	TRESU
11	P0697	RSA09	T5UPBS20DSUT	TRESU
12	P0697	RSA10	T5UPBS20DSUT	TRESU
13	P0697	RSB01	T5UPBS20DSUT	TRESU
14	P0697	RSB02	T5UPBS20DSUT	TRESU
15	P0697	RSB03	T5UPBS20DSUT	TRESU
16	P0697	RSB04	T5UPBS20DSUT	TRESU
17	P0697	RSB05	T5UPBS20DSUT	TRESU
18	P0697	RSB06	T5UPBS20DSUT	TRESU
19	P0697	RSB07	T5UPBS20DSUT	TRESU
20	P0697	RSB08	T5UPBS20DSUT	TRESU
21	P0697	RSB09	T5UPBS20DSUT	TRESU
22	P0697	RSB10	T5UPBS20DSUT	TRESU
23	P0697	STA01	T5UPBS20DS	SUBST
24	P0697	STA02	T5UPBS20DS	SUBST
25	P0697	STA03	T5UPBS20DS	SUBST
26	P0697	STA04	T5UPBS20DS	SUBST
27	P0697	STA05	T5UPBS20DS	SUBST
28	P0697	STA06	T5UPBS20DS	SUBST
29	P0697	STA07	T5UPBS20DS	SUBST
30	P0697	STA08	T5UPBS20DS	SUBST
31	P0697	STA09	T5UPBS20DS	SUBST
32	P0697	STA10	T5UPBS20DS	SUBST
33	P0697	STB01	T5UPBS20DS	SUBST
34	P0697	STB02	T5UPBS20DS	SUBST
35	P0697	STB03	T5UPBS20DS	SUBST
36	P0697	STB04	T5UPBS20DS	SUBST
37	P0697	STB05	T5UPBS20DS	SUBST
38	P0697	STB06	T5UPBS20DS	SUBST
39	P0697	STB07	T5UPBS20DS	SUBST
40	P0697	STB08	T5UPBS20DS	SUBST
41	P0697	STB09	T5UPBS20DS	SUBST
42	P0697	STB10	T5UPBS20DS	SUBST
43	P0697	TESRN	T5UPBS20DSR	TESRN
44	P0697	TESTY	T591A	SUBTY
45	P0697	TMEDA	T5UPBS20DSM	TMETH
46	P0697	TMEDB	T5UPBS20DSM	TMETH
47	P0697	TRESU	T5UPBS20DSU	TRESU
48	P0697	TSITE	T5UPBS20DSS	TSITE

History

Last changed by/on	SAP	20110901
SAP Release Created in	470