SAP ABAP Table PA0697 (Infotype 0697 ( 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	TRANSP	Transparent table
Transparent table	PA0697	Table Relationship Diagram
Short Description	Infotype 0697 ( Drug Screening)

Delivery and Maintenance

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

Foreign Keys

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

History

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