- Home
- Resources
- SAP Tables
- HCMT_BSP_PA_MX_R0006 - Single screen Addresses infotype (Mexico)
SAP Table HCMT_BSP_PA_MX_R0006
Single screen Addresses infotype (Mexico)
HCMT_BSP_PA_MX_R0006 (Single screen Addresses infotype (Mexico)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link HCMT_BSP_PA_MX_R0006 to other SAP tables.
Source: HCMT_BSP_PA_MX_R0006 (Single screen Addresses infotype (Mexico))
HCMT_BSP_PA_MX_R0006 table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
OBJECT_KEY |
HCM Object Key |
HCM_OBJECT_KEY |
|
CHAR |
|
100 |
0 |
|
PERNR |
Personnel Number |
PERNR_D |
|
NUMC |
|
8 |
0 |
|
AEDTM |
Changed On |
AEDAT |
|
DATS |
|
8 |
0 |
|
UNAME |
Name of Person Who Changed Object |
AENAM |
|
CHAR |
|
12 |
0 |
|
SPRPS |
Lock Indicator for HR Master Data Record |
SPRPS |
|
CHAR |
|
1 |
0 |
|
SPRTX |
Lock indicator for HR master record (text) |
SPRPSTEXT |
|
CHAR |
|
40 |
0 |
|
ITBLD |
Infotype Screen Control |
ITBLD |
|
CHAR |
|
2 |
0 |
|
BEGDA |
Valid-From Date |
PAD_BEGDA |
|
DATS |
|
8 |
0 |
|
ENDDA |
Valid To Date |
PAD_ENDDA |
|
DATS |
|
8 |
0 |
|
STEXT |
Name of Subtype |
SBTTX |
|
CHAR |
|
40 |
0 |
|
ANSSA |
Address Record Type |
ANSSA |
|
CHAR |
|
4 |
0 |
|
NAME2 |
Contact Name |
PAD_CONAM |
|
CHAR |
|
40 |
0 |
|
STRAS |
Street and House Number |
PAD_STRAS |
|
CHAR |
|
60 |
0 |
|
HSNMR |
House Number |
PAD_HSNMR |
|
CHAR |
|
10 |
0 |
|
POSTA |
Identification of an apartment in a building |
PAD_POSTA |
|
CHAR |
|
10 |
0 |
|
ORT02 |
District |
PMX_UI_ORT02 |
|
CHAR |
|
40 |
0 |
|
ORT01 |
City |
PMX_UI_ORT01 |
|
CHAR |
|
40 |
0 |
|
STATE |
Region (State, Province, County) |
REGIO |
T005S
|
CHAR |
|
3 |
0 |
|
BEZEI |
Description |
BEZEI20 |
|
CHAR |
|
20 |
0 |
|
RCTVC |
Municipal code |
PMX_MUNIC |
T7MX63
|
CHAR |
|
4 |
0 |
|
TMUNI |
Municipality name |
PMX_TMUNI |
|
CHAR |
|
30 |
0 |
|
TZOEC |
Economic zone |
PMX_ZOECO |
|
CHAR |
|
1 |
0 |
Possible values
A |
Economic zone A |
B |
Economic zone B |
C |
Economic zone C |
|
LAND1 |
Country Key |
LAND1 |
T005
|
CHAR |
|
3 |
0 |
|
LANDX |
Country Name |
LANDX |
|
CHAR |
|
15 |
0 |
|
PSTLZ |
Postal Code |
PSTLZ_HR |
|
CHAR |
|
10 |
0 |
|
TELNR |
Telephone Number |
TELNR |
|
CHAR |
|
14 |
0 |
|
COM01 |
Communication Type |
COMKY |
T536B
|
CHAR |
|
4 |
0 |
|
TYP01 |
Text (20 Characters) |
TEXT20 |
|
CHAR |
|
20 |
0 |
|
NUM01 |
Communication Number |
COMNR |
|
CHAR |
|
20 |
0 |
|
TYP02 |
Text (20 Characters) |
TEXT20 |
|
CHAR |
|
20 |
0 |
|
COM02 |
Communication Type |
COMKY |
T536B
|
CHAR |
|
4 |
0 |
|
NUM02 |
Communication Number |
COMNR |
|
CHAR |
|
20 |
0 |
|
TYP03 |
Text (20 Characters) |
TEXT20 |
|
CHAR |
|
20 |
0 |
|
COM03 |
Communication Type |
COMKY |
T536B
|
CHAR |
|
4 |
0 |
|
NUM03 |
Communication Number |
COMNR |
|
CHAR |
|
20 |
0 |
|
WKWNG |
Type of abode (FONACOT) |
PMX_TIHAB |
|
CHAR |
|
1 |
0 |
Possible values
0 |
Owner |
1 |
Rented |
2 |
Boarding house |
|
STATE_EDIT |
Region (State, Province, County) |
REGIO |
T005S
|
CHAR |
|
3 |
0 |
|
RCTVC_EDIT |
Municipal code |
PMX_MUNIC |
T7MX63
|
CHAR |
|
4 |
0 |
|
HCMT_BSP_PA_MX_R0006 foreign key relationships
Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
HCMT_BSP_PA_MX_R0006 |
COM01 |
HCMT_BSP_PA_MX_R0006 |
COM01 |
T536B |
Communication Keys |
COMKY |
HCMT_BSP_PA_MX_R0006 |
COM01 |
SYST |
MANDT |
T536B |
Communication Keys |
MANDT |
HCMT_BSP_PA_MX_R0006 |
COM02 |
HCMT_BSP_PA_MX_R0006 |
COM02 |
T536B |
Communication Keys |
COMKY |
HCMT_BSP_PA_MX_R0006 |
COM02 |
SYST |
MANDT |
T536B |
Communication Keys |
MANDT |
HCMT_BSP_PA_MX_R0006 |
COM03 |
HCMT_BSP_PA_MX_R0006 |
COM03 |
T536B |
Communication Keys |
COMKY |
HCMT_BSP_PA_MX_R0006 |
COM03 |
SYST |
MANDT |
T536B |
Communication Keys |
MANDT |
HCMT_BSP_PA_MX_R0006 |
LAND1 |
HCMT_BSP_PA_MX_R0006 |
LAND1 |
T005 |
Countries |
LAND1 |
HCMT_BSP_PA_MX_R0006 |
LAND1 |
SYST |
MANDT |
T005 |
Countries |
MANDT |
HCMT_BSP_PA_MX_R0006 |
RCTVC |
HCMT_BSP_PA_MX_R0006 |
RCTVC |
T7MX63 |
Municipalities |
MUNIC |
HCMT_BSP_PA_MX_R0006 |
RCTVC |
HCMT_BSP_PA_MX_R0006 |
STATE |
T7MX63 |
Municipalities |
ESTAD |
HCMT_BSP_PA_MX_R0006 |
RCTVC_EDIT |
HCMT_BSP_PA_MX_R0006 |
RCTVC_EDIT |
T7MX63 |
Municipalities |
MUNIC |
HCMT_BSP_PA_MX_R0006 |
RCTVC_EDIT |
HCMT_BSP_PA_MX_R0006 |
STATE |
T7MX63 |
Municipalities |
ESTAD |
HCMT_BSP_PA_MX_R0006 |
STATE |
HCMT_BSP_PA_MX_R0006 |
STATE |
T005S |
Taxes: Region (Province) Key |
BLAND |
HCMT_BSP_PA_MX_R0006 |
STATE |
HCMT_BSP_PA_MX_R0006 |
LAND1 |
T005S |
Taxes: Region (Province) Key |
LAND1 |
HCMT_BSP_PA_MX_R0006 |
STATE |
SYST |
MANDT |
T005S |
Taxes: Region (Province) Key |
MANDT |
HCMT_BSP_PA_MX_R0006 |
STATE_EDIT |
HCMT_BSP_PA_MX_R0006 |
STATE_EDIT |
T005S |
Taxes: Region (Province) Key |
BLAND |
HCMT_BSP_PA_MX_R0006 |
STATE_EDIT |
HCMT_BSP_PA_MX_R0006 |
LAND1 |
T005S |
Taxes: Region (Province) Key |
LAND1 |
HCMT_BSP_PA_MX_R0006 |
STATE_EDIT |
SYST |
MANDT |
T005S |
Taxes: Region (Province) Key |
MANDT |