SAP ABAP Table U_17076 (Generated Table for View)

Basic Data

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

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	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
12	ANSSA	☐	ANSSA	SUBTY_591A	CHAR	4	0	Address Record Type
13	NAME2	☐	PAD_CONAM	PAD_NACHN	CHAR	40	0	Contact Name
14	STRAS	☐	PAD_STRAS	PAD_STRAS	CHAR	60	0	Street and House Number
15	ORT01	☐	PAD_ORT01	PAD_ORT01	CHAR	40	0	City
16	ORT02	☐	PAD_ORT02	PAD_ORT01	CHAR	40	0	District
17	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
18	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
19	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
20	ENTKM	☐	ENTKM	DEC3	DEC	3	0	Distance in Kilometers
21	WKWNG	☐	WKWNG	CHAR1	CHAR	1	0	Company Housing
22	BUSRT	☐	BUSRT	CHAR3	CHAR	3	0	Bus Route
23	LOCAT	☐	PAD_LOCAT	PAD_LOCAT	CHAR	40	0	2nd address line
24	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	HSNMR	☐	PAD_HSNMR	PAD_HSNMR	CHAR	10	0	House Number
26	POSTA	☐	PAD_POSTA	PAD_HSNMR	CHAR	10	0	Identification of an apartment in a building
27	STRDS	☐	STRDS	STRDS	CHAR	2	0	Street Abbreviation	T5EVP
28	ENTK2	☐	ENTKM	DEC3	DEC	3	0	Distance in Kilometers
29	COM01	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
30	NUM01	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
31	COM02	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
32	NUM02	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
33	COM03	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
34	NUM03	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
35	COM04	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
36	NUM04	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
37	COM05	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
38	NUM05	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
39	COM06	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
40	NUM06	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
41	INDRL	☐	P22J_INDRL	AUSPR	CHAR	2	0	Indicator for relationship (specification code)	T577
42	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
43	RCTVC	☐	P22J_RCTVC	P22J_RCTVC	CHAR	6	0	Municipal city code
44	OR2KK	☐	P22J_ORKK2	TEXT40	CHAR	40	0	Second address line (Katakana)
45	CONKK	☐	P22J_PCNKK	P22J_PNAME	CHAR	40	0	Contact Person (Katakana) (Japan)
46	OR1KK	☐	P22J_ORKK1	TEXT40	CHAR	40	0	First address line (Katakana)
47	ADR03	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
48	ADR04	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
49	RAILW	☐	RAILW	RAILW	NUMC	1	0	Social Subscription Railway

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_17076	COM01	T536B	COMKY	REF	C	CN
2	U_17076	COM02	T536B	COMKY	REF	C	CN
3	U_17076	COM03	T536B	COMKY	REF	C	CN
4	U_17076	COM04	T536B	COMKY	REF	C	CN
5	U_17076	COM05	T536B	COMKY	REF	C	CN
6	U_17076	COM06	T536B	COMKY	REF	C	CN
7	U_17076	COUNC	T005E	COUNC
8	U_17076	INDRL	T577	AUSPR
9	U_17076	LAND1	T005	LAND1	REF	C	CN
10	U_17076	MANDT	T000	MANDT	KEY	1	CN
11	U_17076	PERNR	PA0003	PERNR	KEY	1	CN
12	U_17076	PREAS	T530E	PREAS	KEY	1	CN
13	U_17076	STATE	T005S	BLAND	REF	C	CN
14	U_17076	STRDS	T5EVP	STRDS

History

Last changed by/on	SAP	20130529
SAP Release Created in