SAP ABAP Table U_37100C (Generated Table for View U_37100C)

Basic Data

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

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	PLVAR	☑	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
3	OTYPE	☑	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
4	OBJID	☑	HROBJID	HROBJID	NUMC	8	0	Object ID
5	REPAIR	☑	HRREPAIR	CHAR1_X	CHAR	1	0	Repair Flag for Object
6	SHORT	☑	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
7	STEXT	☑	STEXT	TEXT40	CHAR	40	0	Object Name
8	GDATE	☑	GDATE	DATUM	DATS	8	0	Delimitation date
9	MC_SHORT	☑	HR_MCSHORT	CHAR12	CHAR	12	0	Object Abbreviation
10	MC_STEXT	☑	HR_MCSTEXT	CHAR40	CHAR	40	0	Name
11	MC_SEARK	☑	HR_MCSEARK	CHAR52	CHAR	52	0	Search Term
12	LANGU	☑	LANGU	SPRAS	LANG	1	0	Language Key	T002
13	TABNR	☑	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	HRITABNR
14	TABSEQNR	☑	HRTABSEQNR	NUM06	NUMC	6	0	Sequence Number in Table Part of Table Infotype
15	TLINE	☑	HRLINE79	TEXT79	CHAR	79	0	Line With Length 79 for Infotype 1002
16	TFORMAT	☑	TDFORMAT	TDELEMSTYL	CHAR	2	0	Tag column
17	ISTAT	☑	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
18	BEGDA	☑	BEGDATUM	DATUM	DATS	8	0	Start Date
19	ENDDA	☑	ENDDATUM	DATUM	DATS	8	0	End Date
20	VARYF	☑	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
21	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
22	INFTY	☑	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T778T
23	OTJID	☑	OTJID	CHAR10	CHAR	10	0	Concatenation of Object Type and Object ID
24	AEDTM	☑	AEDTM	DATUM	DATS	8	0	Changed on
25	UNAME	☑	USRNAME	CHAR12	CHAR	12	0	User Name
26	REASN	☑	REASN	CHAR2	CHAR	2	0	Reason
27	HISTO	☑	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
28	ITXNR	☑	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
29	RTEXT	☑	FKURSTXT	NUM01	NUMC	1	0	Flag for reading business event text from event itself
30	INKBR	☑	INKBR	NUM01	NUMC	1	0	Indicator for inclusion in business event brochure
31	KONGX	☑	KONGX	CHAR1_X	CHAR	1	0	Indicator for convention
32	NO_INT_INST	☑	INT_OFF_INST	CHAR1_X	CHAR	1	0	No integration for instructors
33	NO_INT_PART	☑	INT_OFF_PART	CHAR1_X	CHAR	1	0	No integration for attendees
34	DAYS_OFF_INST	☑	DAYS_OFF_INST	CHAR1_X	CHAR	1	0	Allowed in instructor's time off
35	DAYS_OFF_PART	☑	DAYS_OFF_PART	CHAR1_X	CHAR	1	0	Allowed in attendee's time off
36	MINPRESENCE	☑	MINPRESENCE	DEC3_2	DEC	5	2	Minimum percentage attendance
37	NYEARS	☑	NYEARS	DEC3	DEC	3	0	Number of years
38	NMONTHS	☑	NMONTHS	DEC3	DEC	3	0	Number of Months
39	N_TYPE	☑	N_TYPE	N_TYPE	CHAR	1	0	Flag: 'Depreciation Meter/Validity' Infotype
40	TEILN_TYP	☑	TEILNTYP	OTYPE	CHAR	2	0	Attendee type	T778O
41	BCHECK	☑	BCHECK	BCHECK	CHAR	1	0	Check for bookings for same business event type
42	VCHECK	☑	VCHECK	VCHECK	CHAR	1	0	Check for prebookings on same business event type
43	KCHECK	☑	KCHECK	VCHECK	CHAR	1	0	Check for prerequisite business event
44	QCHECK	☑	QCHECK	VCHECK	CHAR	1	0	Check Attendee's Qualification
45	QASSIGN	☑	QASSIGN	CHAR1_X	CHAR	1	0	Transfer objectives to attendee as qualifications
46	DELRKURS	☑	DELRKURS	CHAR1_X	CHAR	1	0	Delete relationship business event/attendee after bus.event
47	INSRKTYP	☑	INSRKTYP	CHAR1_X	CHAR	1	0	Create relationship event type / attendee after bus. event
48	XDATA	☑	XDATA	CHAR6	CHAR	6	0	Reserve field PX030

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_37100C	INFTY	T778T	INFTY	KEY	1	CN
2	U_37100C	ISTAT	T778S	ISTAT	KEY	1	CN
3	U_37100C	LANGU	T002	SPRAS
4	U_37100C	MANDT	T000	MANDT	KEY	1	CN
5	U_37100C	OTYPE	T778O	OTYPE	KEY	1	CN
6	U_37100C	PLVAR	T778P	PLVAR	KEY	1	CN
7	U_37100C	TABNR	HRITABNR	TABNR	KEY	1	CN
8	U_37100C	TEILN_TYP	T778O	OTYPE	KEY	1	CN

History

Last changed by/on	SAP	20041209
SAP Release Created in