SAP Table BAPISTUDENT_PERSONAL
BAPI Structure for Student: Personal Data
BAPISTUDENT_PERSONAL (BAPI Structure for Student: Personal Data) 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 BAPISTUDENT_PERSONAL to other SAP tables.
Source: BAPISTUDENT_PERSONAL (BAPI Structure for Student: Personal Data)
BAPISTUDENT_PERSONAL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FORM_OF_ADDRESS_KEY | Form-of-Address Key | ANRDE | T522G | CHAR | 1 | 0 | ||||||||
| INITIALS | Initials | INITS | CHAR | 10 | 0 | |||||||||
| FIRST_NAME | First Name | PAD_VORNA | CHAR | 40 | 0 | |||||||||
| LAST_NAME | Last Name | PAD_NACHN | CHAR | 40 | 0 | |||||||||
| MIDDLE_NAME | Middle Name | PAD_MIDNM | CHAR | 40 | 0 | |||||||||
| TITEL | Title | TITEL | T535N | CHAR | 15 | 0 | ||||||||
| NAME_AFFIX | Name Prefix | VORSW | T535N | CHAR | 15 | 0 | ||||||||
| ARISTOCRATIC_TITLE | Other Title | NAMZU | T535N | CHAR | 15 | 0 | ||||||||
| NICKNAME | Known As | PIQ_RUFNM | CHAR | 40 | 0 | |||||||||
| NAME_AT_BIRTH | Name at Birth | PAD_NAME2 | CHAR | 40 | 0 | |||||||||
| DATE_BIRTH | Date of Birth | PIQ_GBDAT | DATS | 8 | 0 | |||||||||
| BIRTHPLACE | Birthplace | PAD_GBORT | CHAR | 40 | 0 | |||||||||
| COUNTRY_OF_BIRTH | Country of Birth | GBLND | T005 | CHAR | 3 | 0 | ||||||||
| COUNTRY_OF_BIRTH_ISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| REGION_OF_BIRTH | Region of Birth (State, Province, County) | PIQ_GBDEP | T005S | CHAR | 3 | 0 | ||||||||
| NATIONALITY_AT_BIRTH | Nationality (Citizenship) at Birth | PIQ_GBNAT | CHAR | 3 | 0 | |||||||||
| NATIONALITY_AT_BIRTH_ISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| NATIONALITY | Nationality (Citizenship) | PIQNATSL | CHAR | 3 | 0 | |||||||||
| NATIONALITY_ISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| SECOND_NATIONALITY | Second Nationality (Citizenship) | PIQNATS2 | CHAR | 3 | 0 | |||||||||
| SECOND_NATIONALITY_ISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| THIRD_NATIONALITY | Third Nationality (Citizenship) | PIQNATS3 | CHAR | 3 | 0 | |||||||||
| THIRD_NATIONALITY_ISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| GENDER_KEY | Gender Key | GESCH | CHAR | 1 | 0 |
Possible values
|
||||||||
| MARITAL_STATUS | Marital Status Key | FAMST | T502T | CHAR | 1 | 0 | ||||||||
| PERSIDNO | Identification Number | PIQ_PRDNI | CHAR | 20 | 0 | |||||||||
| CORRESP_LANGUAGE | Language of Communication | PIQ_SPRAS | T002 | LANG | 1 | 0 | ||||||||
| CORRESP_LANGUAGE_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2 | 0 | |||||||||
| DEATH_DATE | Date of Death | PIQ_DEATHDATE | DATS | 8 | 0 | |||||||||
| DEATH_REGDATE | Date On Which Death Was Recorded | PIQ_REGDEATHDATE | DATS | 8 | 0 | |||||||||
BAPISTUDENT_PERSONAL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BAPISTUDENT_PERSONAL | ARISTOCRATIC_TITLE | 'Z' | T535N | Name affixes | ART | |
| BAPISTUDENT_PERSONAL | ARISTOCRATIC_TITLE | BAPISTUDENT_PERSONAL | ARISTOCRATIC_TITLE | T535N | Name affixes | TITEL |
| BAPISTUDENT_PERSONAL | ARISTOCRATIC_TITLE | SYST | MANDT | T535N | Name affixes | MANDT |
| BAPISTUDENT_PERSONAL | CORRESP_LANGUAGE | BAPISTUDENT_PERSONAL | CORRESP_LANGUAGE | T002 | Language Keys (Component BC-I18) | SPRAS |
| BAPISTUDENT_PERSONAL | COUNTRY_OF_BIRTH | BAPISTUDENT_PERSONAL | COUNTRY_OF_BIRTH | T005 | Countries | LAND1 |
| BAPISTUDENT_PERSONAL | COUNTRY_OF_BIRTH | SYST | MANDT | T005 | Countries | MANDT |
| BAPISTUDENT_PERSONAL | FORM_OF_ADDRESS_KEY | BAPISTUDENT_PERSONAL | FORM_OF_ADDRESS_KEY | T522G | Title Keys | ANRED |
| BAPISTUDENT_PERSONAL | FORM_OF_ADDRESS_KEY | SYST | MANDT | T522G | Title Keys | MANDT |
| BAPISTUDENT_PERSONAL | MARITAL_STATUS | SYST | MANDT | T502T | Marital Status Designators | MANDT |
| BAPISTUDENT_PERSONAL | MARITAL_STATUS | SYST | LANGU | T502T | Marital Status Designators | SPRSL |
| BAPISTUDENT_PERSONAL | MARITAL_STATUS | BAPISTUDENT_PERSONAL | MARITAL_STATUS | T502T | Marital Status Designators | FAMST |
| BAPISTUDENT_PERSONAL | NAME_AFFIX | BAPISTUDENT_PERSONAL | NAME_AFFIX | T535N | Name affixes | TITEL |
| BAPISTUDENT_PERSONAL | NAME_AFFIX | 'V' | T535N | Name affixes | ART | |
| BAPISTUDENT_PERSONAL | NAME_AFFIX | SYST | MANDT | T535N | Name affixes | MANDT |
| BAPISTUDENT_PERSONAL | REGION_OF_BIRTH | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| BAPISTUDENT_PERSONAL | REGION_OF_BIRTH | BAPISTUDENT_PERSONAL | COUNTRY_OF_BIRTH | T005S | Taxes: Region (Province) Key | LAND1 |
| BAPISTUDENT_PERSONAL | REGION_OF_BIRTH | BAPISTUDENT_PERSONAL | REGION_OF_BIRTH | T005S | Taxes: Region (Province) Key | BLAND |
| BAPISTUDENT_PERSONAL | TITEL | BAPISTUDENT_PERSONAL | TITEL | T535N | Name affixes | TITEL |
| BAPISTUDENT_PERSONAL | TITEL | 'T' | T535N | Name affixes | ART | |
| BAPISTUDENT_PERSONAL | TITEL | SYST | MANDT | T535N | Name affixes | MANDT |
