SAP ABAP View U_17076 (Person - private address)
Hierarchy
☛
SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
⤷ PA-PA (Application Component) Personnel Administration
⤷ PBAS (Package) SAP HR Master Data Application Development
⤷ PA-PA (Application Component) Personnel Administration
⤷ PBAS (Package) SAP HR Master Data Application Development
Basic Data
View Type | D | Database View |
Database View | U_17076 | |
Short Description | Person - private address | |
Root table | PA0006 | HR Master Record: Infotype 0006 (Addresses) |
Entity Type | DM02L |
Short text | Person - private address |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | PA0006 | PA0006 |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | PA0006 | MANDT | MANDT | Client | |||
2 | PERNR | PA0006 | PERNR | PERSNO | Personnel number | |||
3 | SUBTY | PA0006 | SUBTY | SUBTY | Subtype | |||
4 | OBJPS | PA0006 | OBJPS | OBJPS | Object Identification | |||
5 | SPRPS | PA0006 | SPRPS | SPRPS | Lock Indicator for HR Master Data Record | |||
6 | ENDDA | PA0006 | ENDDA | ENDDA | End Date | |||
7 | BEGDA | PA0006 | BEGDA | BEGDA | Start Date | |||
8 | SEQNR | PA0006 | SEQNR | SEQNR | Number of Infotype Record With Same Key | |||
9 | AEDTM | PA0006 | AEDTM | AEDAT | Last Changed On | |||
10 | UNAME | PA0006 | UNAME | AENAM | Name of Person Who Changed Object | |||
11 | PREAS | PA0006 | PREAS | PREAS | Reason for Changing Master Data | |||
12 | ANSSA | PA0006 | ANSSA | ANSSA | Address Record Type | |||
13 | NAME2 | PA0006 | NAME2 | PAD_CONAM | Contact Name | |||
14 | STRAS | PA0006 | STRAS | PAD_STRAS | Street and House Number | |||
15 | ORT01 | PA0006 | ORT01 | PAD_ORT01 | City | |||
16 | ORT02 | PA0006 | ORT02 | PAD_ORT02 | District | |||
17 | PSTLZ | PA0006 | PSTLZ | PSTLZ_HR | Postal Code | |||
18 | LAND1 | PA0006 | LAND1 | LAND1 | Country Key | |||
19 | TELNR | PA0006 | TELNR | TELNR | Telephone Number | |||
20 | ENTKM | PA0006 | ENTKM | ENTKM | Distance in Kilometers | |||
21 | WKWNG | PA0006 | WKWNG | WKWNG | Company Housing | |||
22 | BUSRT | PA0006 | BUSRT | BUSRT | Bus Route | |||
23 | LOCAT | PA0006 | LOCAT | PAD_LOCAT | 2nd address line | |||
24 | STATE | PA0006 | STATE | REGIO | Region (State, Province, County) | |||
25 | HSNMR | PA0006 | HSNMR | PAD_HSNMR | House Number | |||
26 | POSTA | PA0006 | POSTA | PAD_POSTA | Identification of an apartment in a building | |||
27 | STRDS | PA0006 | STRDS | STRDS | Street Abbreviation | |||
28 | ENTK2 | PA0006 | ENTK2 | ENTKM | Distance in Kilometers | |||
29 | COM01 | PA0006 | COM01 | COMKY | Communication Type | |||
30 | NUM01 | PA0006 | NUM01 | COMNR | Communication Number | |||
31 | COM02 | PA0006 | COM02 | COMKY | Communication Type | |||
32 | NUM02 | PA0006 | NUM02 | COMNR | Communication Number | |||
33 | COM03 | PA0006 | COM03 | COMKY | Communication Type | |||
34 | NUM03 | PA0006 | NUM03 | COMNR | Communication Number | |||
35 | COM04 | PA0006 | COM04 | COMKY | Communication Type | |||
36 | NUM04 | PA0006 | NUM04 | COMNR | Communication Number | |||
37 | COM05 | PA0006 | COM05 | COMKY | Communication Type | |||
38 | NUM05 | PA0006 | NUM05 | COMNR | Communication Number | |||
39 | COM06 | PA0006 | COM06 | COMKY | Communication Type | |||
40 | NUM06 | PA0006 | NUM06 | COMNR | Communication Number | |||
41 | INDRL | PA0006 | INDRL | P22J_INDRL | Indicator for relationship (specification code) | |||
42 | COUNC | PA0006 | COUNC | COUNC | County Code | |||
43 | RCTVC | PA0006 | RCTVC | P22J_RCTVC | Municipal city code | |||
44 | OR2KK | PA0006 | OR2KK | P22J_ORKK2 | Second address line (Katakana) | |||
45 | CONKK | PA0006 | CONKK | P22J_PCNKK | Contact Person (Katakana) (Japan) | |||
46 | OR1KK | PA0006 | OR1KK | P22J_ORKK1 | First address line (Katakana) | |||
47 | ADR03 | PA0006 | ADR03 | AD_STRSPP1 | Street 2 | |||
48 | ADR04 | PA0006 | ADR04 | AD_STRSPP2 | Street 3 | |||
49 | RAILW | PA0006 | RAILW | RAILW | Social Subscription Railway | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |