SAP ABAP Table Q0006 (Screen Fields: Infotype 0006 (Addresses))
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
Table Category | INTTAB | Structure |
Structure | Q0006 | Table Relationship Diagram |
Short Description | Screen Fields: Infotype 0006 (Addresses) |
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 | AREAC | AREAC | NUM3 | NUMC | 3 | 0 | Telephone number area code | ||
2 | TELNR | TELNR | TELNR | CHAR | 14 | 0 | Telephone Number | ||
3 | AREA1 | AREAC | NUM3 | NUMC | 3 | 0 | Telephone number area code | ||
4 | TELN1 | TELNR | TELNR | CHAR | 14 | 0 | Telephone Number | ||
5 | AREA2 | AREAC | NUM3 | NUMC | 3 | 0 | Telephone number area code | ||
6 | TELN2 | TELNR | TELNR | CHAR | 14 | 0 | Telephone Number | ||
7 | AREA3 | AREAC | NUM3 | NUMC | 3 | 0 | Telephone number area code | ||
8 | TELN3 | TELNR | TELNR | CHAR | 14 | 0 | Telephone Number | ||
9 | AREA4 | AREAC | NUM3 | NUMC | 3 | 0 | Telephone number area code | ||
10 | TELN4 | TELNR | TELNR | CHAR | 14 | 0 | Telephone Number | ||
11 | ARCQ0 | P13Q_AREAC | CHAR3 | CHAR | 3 | 0 | Telephone number area code | ||
12 | ARCQ1 | P13Q_AREAC | CHAR3 | CHAR | 3 | 0 | Telephone number area code | ||
13 | ARCQ2 | P13Q_AREAC | CHAR3 | CHAR | 3 | 0 | Telephone number area code | ||
14 | ARCQ3 | P13Q_AREAC | CHAR3 | CHAR | 3 | 0 | Telephone number area code | ||
15 | ARCQ4 | P13Q_AREAC | CHAR3 | CHAR | 3 | 0 | Telephone number area code | ||
16 | OR1KT | P22J_OR1KT | CHAR30 | CHAR | 30 | 0 | Address in Katakana (Japan) | ||
17 | ORT1T | P22J_ORT1T | CHAR25 | CHAR | 25 | 0 | Address in Kanji (Japan) | ||
18 | NAME2 | P22J_NAME2 | PAD_NACHN | CHAR | 40 | 0 | Contact Person (Japan) | ||
19 | MUNIC | PMX_MUNIC | PMX_MUNIC | CHAR | 4 | 0 | Municipal code | T7MX63 | |
20 | TZOEC | PMX_ZOECO | PMX_ZOECO | CHAR | 1 | 0 | Economic zone | ||
21 | TIHAB | PMX_TIHAB | PMX_TIHAB | CHAR | 1 | 0 | Type of abode (FONACOT) | ||
22 | TTIHA | PMX_TTIHA | TEXT20 | CHAR | 20 | 0 | Text Type of abode (FONACOT) | ||
23 | TOWN | PTW_TOWN | TEXT10 | CHAR | 10 | 0 | Town | ||
24 | VILLA | PTW_VILLA | PTW_VILLA | CHAR | 10 | 0 | Village | ||
25 | NEIGH | PTW_NEIGH | PTW_NEIGH | CHAR | 4 | 0 | Neighborhood | ||
26 | ADRTW | PTW_ADRTW | PTW_ADRTW | CHAR | 60 | 0 | Full address | ||
27 | AREA5 | P15_AREAC | CHAR04 | CHAR | 4 | 0 | Prefix | ||
28 | AREA6 | P15_AREAC | CHAR04 | CHAR | 4 | 0 | Prefix | ||
29 | AREA7 | P15_AREAC | CHAR04 | CHAR | 4 | 0 | Prefix | ||
30 | AREA8 | P15_AREAC | CHAR04 | CHAR | 4 | 0 | Prefix | ||
31 | AREA9 | P15_AREAC | CHAR04 | CHAR | 4 | 0 | Prefix | ||
32 | STRAS | P22J_ADDR3 | TEXT40 | CHAR | 40 | 0 | Third address line (Kanji) | ||
33 | ORT01 | P22J_ADDR1 | TEXT40 | CHAR | 40 | 0 | First address line (Kanji) | ||
34 | ORT02 | P22J_ADDR2 | TEXT40 | CHAR | 40 | 0 | Second address line (Kanji) | ||
35 | OR3KK | P22J_ORKK3 | TEXT40 | CHAR | 40 | 0 | Third address line (Katakana) | ||
36 | OR4KK | P22J_ORKK4 | TEXT40 | CHAR | 40 | 0 | Fourth address line (Katakana) | ||
37 | BPNUM | PCN_BPNUM | NUM8 | NUMC | 8 | 0 | B.P. number | ||
38 | STNUM | PCN_STNUM | NUM08 | NUMC | 8 | 0 | B.P. station number | ||
39 | ORT1K | PKR_ORT1 | TEXT40 | CHAR | 40 | 0 | Si/Ku/Kun | ||
40 | ORT2K | PKR_ORT2 | TEXT40 | CHAR | 40 | 0 | Dong/Eup/Myun | ||
41 | EXTN1 | PB10_EXTN | PB10_EXTN | CHAR | 5 | 0 | US:Telephone extension number of the employee | ||
42 | EXTN2 | PB10_EXTN | PB10_EXTN | CHAR | 5 | 0 | US:Telephone extension number of the employee | ||
43 | EXTN3 | PB10_EXTN | PB10_EXTN | CHAR | 5 | 0 | US:Telephone extension number of the employee | ||
44 | EXTN4 | PB10_EXTN | PB10_EXTN | CHAR | 5 | 0 | US:Telephone extension number of the employee | ||
45 | INSEE | P06_INSEE | CHAR5 | CHAR | 5 | 0 | Municipality INSEE code | ||
46 | COMMU | P06_COMMU | TEXT40 | CHAR | 40 | 0 | Employee's residential parish | ||
47 | WAIT100 | P06P_WAIT100 | XFELD | CHAR | 1 | 0 | |||
48 | BISTQ | P06P_BISTQ | P06P_BISTQ | CHAR | 3 | 0 | |||
49 | STRDS | STRTYPEAB | STRTYPEAB | CHAR | 2 | 0 | Street type abbreviation | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | Q0006 | MUNIC | T7MX63 | MUNIC |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |