- Home
- Resources
- SAP Tables
- PS0465 - HR master record infotype 0465 (Documents)
SAP Table PS0465
HR master record infotype 0465 (Documents)
PS0465 (HR master record infotype 0465 (Documents)) 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 PS0465 to other SAP tables.
Source: PS0465 (HR master record infotype 0465 (Documents))
PS0465 table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| TPDOC |
Document Type |
TPDOC |
T591A
|
CHAR |
|
4 |
0 |
|
| DT_EMIS |
Document's Issue Date |
PBR_DEMIS |
|
DATS |
|
8 |
0 |
|
| ES_EMIS |
State (FU) |
PBR_ESTAD |
|
CHAR |
|
3 |
0 |
Possible values
| AC |
Acre |
| AL |
Alagoas |
| AM |
Amazonas |
| AP |
Amapá |
| BA |
Bahia |
| CE |
Ceará |
| DF |
Distrito Federal |
| ES |
Espírito Santo |
| GO |
Goiás |
| MA |
Maranhão |
| MG |
Minas Gerais |
| MS |
Mato Grosso do Sul |
| MT |
Mato Grosso |
| PA |
Pará |
| PB |
Paraíba |
| PE |
Pernambuco |
| PI |
Piauí |
| PR |
Paraná |
| RJ |
Rio de Janeiro |
| RN |
Rio Grande do Norte |
| RO |
Rondônia |
| RR |
Roraima |
| RS |
Rio Grande do Sul |
| SC |
Santa Catarina |
| SE |
Sergipe |
| SP |
São Paulo |
| TO |
Tocantins |
|
| CPF_NR |
Sole Proprietor's Registry number (CPF) |
PBR_CPFNR |
|
CHAR |
|
15 |
0 |
|
| IDENT_NR |
Identification Document number |
PBR_IDNR |
|
CHAR |
|
16 |
0 |
|
| IDENT_ORG |
Identification Document Issuer |
PBR_IDORG |
|
CHAR |
|
8 |
0 |
|
| CTPS_NR |
Worker's Card for Social Welfare number - WCSW |
PBR_CTNR |
|
CHAR |
|
10 |
0 |
|
| CTPS_SERIE |
Worker's Card series number - WCSW |
PBR_CTSR |
|
CHAR |
|
6 |
0 |
|
| CREG_NR |
Regional Council register number |
PBR_CRNR |
|
CHAR |
|
15 |
0 |
|
| CREG_NAME |
Regional Council name |
PBR_CRNAM |
|
CHAR |
|
90 |
0 |
|
| CREG_INIT |
Regional Council abbreviation |
PBR_CRIN |
|
CHAR |
|
10 |
0 |
|
| ELEC_NR |
Voter Registration Card number |
PBR_ELECN |
|
CHAR |
|
15 |
0 |
|
| ELEC_ZONE |
Voter Registration Card area |
PBR_ELECZ |
|
CHAR |
|
5 |
0 |
|
| ELEC_SECT |
Voting Section |
PBR_ELECS |
|
CHAR |
|
5 |
0 |
|
| PIS_NR |
SIP/PSHFP number |
PBR_PSNR |
|
CHAR |
|
20 |
0 |
|
| MIL_NR |
Military Certificate number |
PBR_MILNR |
|
CHAR |
|
12 |
0 |
|
| MIL_TYPE |
Military Certificate type |
PBR_MILTY |
|
CHAR |
|
8 |
0 |
|
| MIL_CAT |
Military Certificate category |
PBR_MILCA |
|
CHAR |
|
3 |
0 |
|
| IDFOR_NR |
Foreign Identification Document number |
PBR_IDFNR |
|
CHAR |
|
20 |
0 |
|
| VISA_NR |
Visa series number |
PBR_VISNR |
|
CHAR |
|
6 |
0 |
|
| VISA_TYPE |
Type of Visa |
PBR_VISTY |
|
CHAR |
|
20 |
0 |
|
| MARRY_BR |
Brazilian spouse |
PBR_MARBR |
|
CHAR |
|
1 |
0 |
Possible values
|
| DT_ARRV |
Date of arrival in Brazil |
PBR_DTARR |
|
DATS |
|
8 |
0 |
|
| DRIVE_NR |
Professional Driver's License number |
PBR_DRVNR |
|
CHAR |
|
12 |
0 |
|
| DRIVE_CAT |
Driver's License category |
PBR_DRVCT |
|
CHAR |
|
3 |
0 |
|
| PASSP_NR |
Passport number |
PBR_PASNR |
|
CHAR |
|
15 |
0 |
|
| NIT_NR |
Employee Identification Number - EIN |
PBR_NITNR |
|
CHAR |
|
11 |
0 |
|
| CARTO |
Name of public notary |
PBR_CARTO |
|
CHAR |
|
40 |
0 |
|
| CDEAT |
Death certificate |
PBR_CDEAT |
|
CHAR |
|
10 |
0 |
|
| DEATH |
Date of death notification |
PBR_DEATH |
|
DATS |
|
8 |
0 |
|
| CAUDE |
Cause of death |
PBR_CAUDE |
|
CHAR |
|
1 |
0 |
Possible values
|
| CHILDBR |
Children with Brazilian indicator |
HRPADBR_BRAZIL_CHILD |
|
CHAR |
|
1 |
0 |
|
PS0465 foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| PS0465 |
TPDOC |
SYST |
MANDT |
T591A |
Subtype Characteristics |
MANDT |
| PS0465 |
TPDOC |
'0465' |
|
T591A |
Subtype Characteristics |
INFTY |
| PS0465 |
TPDOC |
PS0465 |
TPDOC |
T591A |
Subtype Characteristics |
SUBTY |
