SAP ABAP Table PS0697 (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	PS0697	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	TESTY	☐	P10_TESTY	SUBTY_591A	CHAR	4	0	Drug screening test type	T591A
2	TESDT	☐	P10_TESDT	DDATE	DATS	8	0	Sample collecting date
3	TESRN	☐	P10_TERSN	P10_TERSN	CHAR	4	0	Drug screening test reason	T5UPBS20DSR
4	TRESU	☐	P10_TRESU	P10_TRESU	CHAR	1	0	Overall test result	T5UPBS20DSU
5	SANUM	☐	P10_SANUM	CHAR8	CHAR	8	0	Sample number
6	TEXEC	☐	P10_TEXEC	TEXT80	CHAR	80	0	Test executer name
7	TOBSE	☐	P10_TOBSE	TEXT80	CHAR	80	0	Test observer name
8	TSITE	☐	P10_TSITE	P10_TSITE	CHAR	4	0	Test site	T5UPBS20DSS
9	TMEDA	☐	P10_TMEDA	P10_TMETH	CHAR	4	0	Test method for sample A	T5UPBS20DSM
10	TMEDB	☐	P10_TMEDB	P10_TMETH	CHAR	4	0	Test method for sample B	T5UPBS20DSM
11	STA01	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
12	RSA01	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
13	ATA01	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
14	UTA01	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
15	STA02	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
16	RSA02	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
17	ATA02	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
18	UTA02	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
19	STA03	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
20	RSA03	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
21	ATA03	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
22	UTA03	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
23	STA04	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
24	RSA04	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
25	ATA04	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
26	UTA04	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
27	STA05	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
28	RSA05	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
29	ATA05	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
30	UTA05	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
31	STA06	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
32	RSA06	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
33	ATA06	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
34	UTA06	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
35	STA07	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
36	RSA07	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
37	ATA07	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
38	UTA07	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
39	STA08	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
40	RSA08	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
41	ATA08	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
42	UTA08	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
43	STA09	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
44	RSA09	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
45	ATA09	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
46	UTA09	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
47	STA10	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
48	RSA10	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
49	ATA10	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
50	UTA10	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
51	STB01	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
52	RSB01	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
53	ATB01	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
54	UTB01	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
55	STB02	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
56	RSB02	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
57	ATB02	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
58	UTB02	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
59	STB03	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
60	RSB03	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
61	ATB03	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
62	UTB03	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
63	STB04	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
64	RSB04	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
65	ATB04	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
66	UTB04	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
67	STB05	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
68	RSB05	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
69	ATB05	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
70	UTB05	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
71	STB06	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
72	RSB06	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
73	ATB06	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
74	UTB06	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
75	STB07	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
76	RSB07	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
77	ATB07	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
78	UTB07	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
79	STB08	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
80	RSB08	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
81	ATB08	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
82	UTB08	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
83	STB09	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
84	RSB09	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
85	ATB09	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
86	UTB09	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
87	STB10	☐	P10_SUBST	CHAR4	CHAR	4	0	Substance test content code	T5UPBS20DS
88	RSB10	☐	P10_TSRES	P10_TRESU	CHAR	1	0	Substance test result	T5UPBS20DSUT
89	ATB10	☐	P10_TSAMT	P10_TSAMT	QUAN	8	4	Substance test amout
90	UTB10	☐	P10_TSUNT	CDUNIT	UNIT	3	0	Substance test unit
91	EADDR	☐	P10_CADDR	AD_ADDRNUM	CHAR	10	0	Address number	*
92	OADDR	☐	P10_CADDR	AD_ADDRNUM	CHAR	10	0	Address number	*
93	.INCLUDE	☐				0	0

Foreign Keys

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

History

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