SAP ABAP Table RPUPLZC0_ALV1 (Comparison of Address Data Switzerland)

Hierarchy

☛ SAP_HRCCH (Software Component) Sub component SAP_HRCCH of SAP_HR
   ⤷ PA-PA-CH (Application Component) Switzerland
     ⤷ PB02 (Package) HR Master Data: Switzerland

Basic Data

Table Category	INTTAB	Structure
Structure	RPUPLZC0_ALV1	Table Relationship Diagram
Short Description	Comparison of Address Data Switzerland

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	STATUS	☐	P02_ALV_STATUS	P02_ALV_STATUS	CHAR	1	0	Status Information for Infotype Record
2	STATUS_LED	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
3	.INCLUDE	☐				0	0	HR Master Record: Infotype 0006 (Addresses)
4	.INCLUDE	☐				0	0	Headers for Infotype Records
5	.INCLUDE	☐				0	0	Keys for HR Master Data
6	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
7	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
8	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
9	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
10	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
11	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
12	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
13	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
14	.INCLUDE	☐				0	0	HR Master Record: Control Field
15	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
17	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
18	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
19	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
20	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
21	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
22	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
23	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
25	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
26	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
27	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
28	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
29	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
30	.INCLUDE	☐				0	0	HR Master Record: Infotype 0006 (Addresses)
31	ANSSA	☐	ANSSA	SUBTY_591A	CHAR	4	0	Address Record Type	*
32	NAME2	☐	PAD_CONAM	PAD_NACHN	CHAR	40	0	Contact Name
33	STRAS	☐	PAD_STRAS	PAD_STRAS	CHAR	60	0	Street and House Number
34	ORT01	☐	PAD_ORT01	PAD_ORT01	CHAR	40	0	City
35	ORT02	☐	PAD_ORT02	PAD_ORT01	CHAR	40	0	District
36	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
37	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
38	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
39	ENTKM	☐	ENTKM	DEC3	DEC	3	0	Distance in Kilometers
40	WKWNG	☐	WKWNG	CHAR1	CHAR	1	0	Company Housing
41	BUSRT	☐	BUSRT	CHAR3	CHAR	3	0	Bus Route
42	LOCAT	☐	PAD_LOCAT	PAD_LOCAT	CHAR	40	0	2nd address line
43	ADR03	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
44	ADR04	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
45	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
46	HSNMR	☐	PAD_HSNMR	PAD_HSNMR	CHAR	10	0	House Number
47	POSTA	☐	PAD_POSTA	PAD_HSNMR	CHAR	10	0	Identification of an apartment in a building
48	BLDNG	☐	AD_BLD_10	TEXT10	CHAR	10	0	Building (number or code)
49	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
50	STRDS	☐	STRDS	STRDS	CHAR	2	0	Street Abbreviation	T5EVP
51	ENTK2	☐	ENTKM	DEC3	DEC	3	0	Distance in Kilometers
52	COM01	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
53	NUM01	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
54	COM02	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
55	NUM02	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
56	COM03	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
57	NUM03	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
58	COM04	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
59	NUM04	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
60	COM05	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
61	NUM05	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
62	COM06	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
63	NUM06	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
64	INDRL	☐	P22J_INDRL	AUSPR	CHAR	2	0	Indicator for relationship (specification code)	T577
65	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
66	RCTVC	☐	P22J_RCTVC	P22J_RCTVC	CHAR	6	0	Municipal city code	*
67	OR2KK	☐	P22J_ORKK2	TEXT40	CHAR	40	0	Second address line (Katakana)
68	CONKK	☐	P22J_PCNKK	P22J_PNAME	CHAR	40	0	Contact Person (Katakana) (Japan)
69	OR1KK	☐	P22J_ORKK1	TEXT40	CHAR	40	0	First address line (Katakana)
70	RAILW	☐	RAILW	RAILW	NUMC	1	0	Social Subscription Railway
71	.INCLUDE	☐				0	0
72	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
73	MESSG	☐	BALTMSG	BALTMSG	CHAR	255	0	Application Log: Formatted message text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RPUPLZC0_ALV1	COM01	T536B	COMKY
2	RPUPLZC0_ALV1	COM02	T536B	COMKY
3	RPUPLZC0_ALV1	COM03	T536B	COMKY
4	RPUPLZC0_ALV1	COM04	T536B	COMKY
5	RPUPLZC0_ALV1	COM05	T536B	COMKY
6	RPUPLZC0_ALV1	COM06	T536B	COMKY
7	RPUPLZC0_ALV1	COUNC	T005E	COUNC
8	RPUPLZC0_ALV1	INDRL	T577	AUSPR
9	RPUPLZC0_ALV1	INFTY	T582A	INFTY
10	RPUPLZC0_ALV1	LAND1	T005	LAND1
11	RPUPLZC0_ALV1	PREAS	T530E	PREAS
12	RPUPLZC0_ALV1	STATE	T005S	BLAND
13	RPUPLZC0_ALV1	STRDS	T5EVP	STRDS

History

Last changed by/on	SAP	20130529
SAP Release Created in	600