SAP Table HCMT_BSP_PA_HK_R0344_SUB_B
ID and Passport
HCMT_BSP_PA_HK_R0344_SUB_B (ID and Passport) 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_HK_R0344_SUB_B to other SAP tables.
HCMT_BSP_PA_HK_R0344_SUB_B table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
ICTY1 | Type of identification (IC type) | ICTYP | T5R05 | CHAR | 2 | 0 | ||
ICTX1 | IC description | ICTXT | CHAR | 30 | 0 | |||
ICNM1 | IC number | ICNUM | CHAR | 20 | 0 | |||
AUTH1 | Issuing authority | AUTH1 | CHAR | 30 | 0 | |||
FPDT1 | Date of issue for personal ID | FPDAT | DATS | 8 | 0 | |||
EXPD1 | ID expiry date | EXPID | DATS | 8 | 0 | |||
IDCT1 | Country of ID | PHK_IDCOT | T005 | CHAR | 3 | 0 | ||
IDCT1_TXT | Country Name | LANDX | CHAR | 15 | 0 | |||
ISCT1 | Country of issue | PHK_ISCOT | T005 | CHAR | 3 | 0 | ||
ISCT1_TXT | Country Name | LANDX | CHAR | 15 | 0 | |||
ICTY2 | Type of identification (IC type) | ICTYP | T5R05 | CHAR | 2 | 0 | ||
ICTX2 | IC description | ICTXT | CHAR | 30 | 0 | |||
ICNM2 | IC number | ICNUM | CHAR | 20 | 0 | |||
AUTH2 | Issuing authority | AUTH1 | CHAR | 30 | 0 | |||
FPDT2 | Date of issue for personal ID | FPDAT | DATS | 8 | 0 | |||
EXPD2 | ID expiry date | EXPID | DATS | 8 | 0 | |||
IDCT2 | Country of ID | PHK_IDCOT | T005 | CHAR | 3 | 0 | ||
IDCT2_TXT | Country Name | LANDX | CHAR | 15 | 0 | |||
ISCT2 | Country of issue | PHK_ISCOT | T005 | CHAR | 3 | 0 | ||
ISCT2_TXT | Country Name | LANDX | CHAR | 15 | 0 |
HCMT_BSP_PA_HK_R0344_SUB_B foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
HCMT_BSP_PA_HK_R0344_SUB_B | ICTY1 | SYST | MANDT | T5R05 | Types of Identification | MANDT |
HCMT_BSP_PA_HK_R0344_SUB_B | ICTY1 | HCMT_BSP_PA_HK_R0021 | MOLGA | T5R05 | Types of Identification | MOLGA |
HCMT_BSP_PA_HK_R0344_SUB_B | ICTY1 | HCMT_BSP_PA_HK_R0344_SUB_B | ICTY1 | T5R05 | Types of Identification | ICTYP |
HCMT_BSP_PA_HK_R0344_SUB_B | ICTY2 | HCMT_BSP_PA_HK_R0021 | MOLGA | T5R05 | Types of Identification | MOLGA |
HCMT_BSP_PA_HK_R0344_SUB_B | ICTY2 | HCMT_BSP_PA_HK_R0344_SUB_B | ICTY2 | T5R05 | Types of Identification | ICTYP |
HCMT_BSP_PA_HK_R0344_SUB_B | ICTY2 | SYST | MANDT | T5R05 | Types of Identification | MANDT |
HCMT_BSP_PA_HK_R0344_SUB_B | IDCT1 | SYST | MANDT | T005 | Countries | MANDT |
HCMT_BSP_PA_HK_R0344_SUB_B | IDCT1 | HCMT_BSP_PA_HK_R0344_SUB_B | IDCT1 | T005 | Countries | LAND1 |
HCMT_BSP_PA_HK_R0344_SUB_B | IDCT2 | SYST | MANDT | T005 | Countries | MANDT |
HCMT_BSP_PA_HK_R0344_SUB_B | IDCT2 | HCMT_BSP_PA_HK_R0344_SUB_B | IDCT2 | T005 | Countries | LAND1 |
HCMT_BSP_PA_HK_R0344_SUB_B | ISCT1 | SYST | MANDT | T005 | Countries | MANDT |
HCMT_BSP_PA_HK_R0344_SUB_B | ISCT1 | HCMT_BSP_PA_HK_R0344_SUB_B | ISCT1 | T005 | Countries | LAND1 |
HCMT_BSP_PA_HK_R0344_SUB_B | ISCT2 | HCMT_BSP_PA_HK_R0344_SUB_B | ISCT2 | T005 | Countries | LAND1 |
HCMT_BSP_PA_HK_R0344_SUB_B | ISCT2 | SYST | MANDT | T005 | Countries | MANDT |