SAP ABAP Table U_27197 (Generated Table for View U_27197)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_27197	Table Relationship Diagram
Short Description	Generated Table for View U_27197

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
3	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
7	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
8	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
12	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
13	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
14	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
15	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
16	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
17	BAREA	☐	BEN_AREA	BEN_AREA	CHAR	2	0	Benefit area	T5UB3
18	BENGR	☐	BEN_GROUP	BEN_GROUP	CHAR	4	0	Benefit First Program Grouping	T5UBT
19	BSTAT	☐	BEN_EESTAT	BEN_EESTAT	CHAR	4	0	Benefit Second Program Grouping	T5UB9
20	DOCN1	☐	BEN_DOCNAM	TEXT30	CHAR	30	0	Benefit Physician Name
21	DOCI1	☐	BEN_DOCID	CHAR20	CHAR	20	0	Benefit Physician ID
22	DOCN2	☐	BEN_DOCNAM	TEXT30	CHAR	30	0	Benefit Physician Name
23	DOCI2	☐	BEN_DOCID	CHAR20	CHAR	20	0	Benefit Physician ID
24	SMOKE	☐	BEN_SMOKER	BEN_SMOKER	CHAR	1	0	Benefit smoker indicator
25	EVINS	☐	BEN_EVINS	XFELD	CHAR	1	0	Benefit indicator evidence of insurability
26	OFFIC	☐	BEN_OFFIC	XFELD	CHAR	1	0	Benefit company officer
27	OWNER	☐	BEN_OWNER	XFELD	CHAR	1	0	Benefit Enterprise Owner
28	SEASN	☐	BEN_SEASON	XFELD	CHAR	1	0	Benefit seasonal worker
29	OTHER	☐	BEN_OTHER	XFELD	CHAR	1	0	Benefit employee covered by another plan
30	AFFDT	☐	BEN_AFFDT	DATUM	DATS	8	0	Benefit Affidavit date
31	HICMP	☐	BEN_HICMP	XFELD	CHAR	1	0	Benefit highly compensated indicator
32	DOCN3	☐	BEN_DOCNAM	TEXT30	CHAR	30	0	Benefit Physician Name
33	DOCI3	☐	BEN_DOCID	CHAR20	CHAR	20	0	Benefit Physician ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_27197	BAREA	T5UB3	BAREA	KEY	1	CN
2	U_27197	BENGR	T5UBT	BENGR	KEY	1	CN
3	U_27197	BSTAT	T5UB9	BSTAT	KEY	1	CN
4	U_27197	MANDT	T000	MANDT	KEY	1	CN
5	U_27197	PERNR	PA0003	PERNR
6	U_27197	PREAS	T530E	PREAS

History

Last changed by/on	SAP	20050219
SAP Release Created in