SAP ABAP Table BAPIP0021US (HR Master Record: Infotype 0021 (Family/Rel.Person) US)
Hierarchy
SAP_HRCUS (Software Component) Sub component SAP_HRCUS of SAP_HR
   PA-PA-US (Application Component) USA
     PB10 (Package) HR master data: USA
Basic Data
Table Category INTTAB    Structure 
Structure BAPIP0021US   Table Relationship Diagram
Short Description HR Master Record: Infotype 0021 (Family/Rel.Person) US    
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 .INCLUDE       0   0   Key for HR Master Data  
2 EMPLOYEENO PERNR_D PERNR NUMC 8   0   Personnel Number *
3 SUBTYPE SUBTY SUBTY CHAR 4   0   Subtype  
4 OBJECTID OBJPS OBJPS CHAR 2   0   Object Identification  
5 LOCKINDIC SPRPS SPRPS CHAR 1   0   Lock Indicator for HR Master Data Record  
6 VALIDEND ENDDA DATUM DATS 8   0   End Date  
7 VALIDBEGIN BEGDA DATUM DATS 8   0   Start Date  
8 RECORDNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
9 MEMBERTYPE FAMSA SUBTY CHAR 4   0   Type of Family Record  
10 NAMEOFSUBTYPE SBTTX TEXT40 CHAR 40   0   Name of Subtype  
11 LASTNAME PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
12 FIRSTNAME PAD_VORNA PAD_VORNM CHAR 40   0   First Name  
13 MAIDENNAME PAD_NAME2 PAD_NACHN CHAR 40   0   Name at Birth  
14 GENDER GESCH GESCH CHAR 1   0   Gender Key  
15 NAMEOFGENDER AS4TEXT AS4TEXT CHAR 60   0   Short Description of Repository Objects  
16 DATEOFBIRTH GBDAT GBDAT DATS 8   0   Date of Birth  
17 NATIONALITY NATSL LAND1 CHAR 3   0   Nationality T005
18 NATIONALITY2 NATS2 LAND1 CHAR 3   0   Second Nationality T005
19 NATIONALITY3 NATS3 LAND1 CHAR 3   0   Third Nationality T005
20 NAMEOFNATIO NATIO TEXT15 CHAR 15   0   Nationality  
21 NAMEOFNATIO2 NATIO TEXT15 CHAR 15   0   Nationality  
22 NAMEOFNATIO3 NATIO TEXT15 CHAR 15   0   Nationality  
23 REFPERSNO ERBNR CHAR12 CHAR 12   0   Reference Personnel Number for Family Member  
24 IDNUMBER PRDNI CHAR20 CHAR 20   0   Personnel ID Number  
25 PHONENUMBER TELNR TELNR CHAR 14   0   Telephone Number  
26 STREETANDHOUSE STRAS TEXT30 CHAR 30   0   House number and street  
27 SECONDADDRLINE STRAS TEXT30 CHAR 30   0   House number and street  
28 CITY ORT01 TEXT25 CHAR 25   0   City  
29 STATE REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
30 NAMEOFSTATE BEZEI20 TEXT20 CHAR 20   0   Description  
31 POSTALCODE PSTLZ PSTLZ CHAR 10   0   Postal Code  
32 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
33 NAMEOFCOUNTRY LANDX TEXT15 CHAR 15   0   Country Name  
34 DATEOFSEP SEPDT DATUM DATS 8   0   Legal Separation Date  
35 NAMEOFPHYS1 BEN_DOCNAM TEXT30 CHAR 30   0   Benefit Physician Name  
36 PHYSICIANID1 BEN_DOCID CHAR20 CHAR 20   0   Benefit Physician ID  
37 NAMEOFPHYS2 BEN_DOCNAM TEXT30 CHAR 30   0   Benefit Physician Name  
38 PHYSICIANID2 BEN_DOCID CHAR20 CHAR 20   0   Benefit Physician ID  
39 STUDENT BEN03 XFELD CHAR 1   0   Student Indicator  
40 COBRA BEN04 XFELD CHAR 1   0   COBRA Indicator  
41 MEDICARE BEN_MEDIC XFELD CHAR 1   0   Benefit Indicator for Medicare  
42 DISABILITY DISABTY XFELD CHAR 1   0   Disability  
43 DATEOFDISAB DISDT DATUM DATS 8   0   Date of Determination of Disability Status  
44 DATEDISABLEARN DISLE DATUM DATS 8   0   Date Employer Learned of Disability Status  
45 SMOKER BEN_SMOKER BEN_SMOKER CHAR 1   0   Benefit smoker indicator  
46 MARITAL_STATUS FAMST FAMST CHAR 1   0   Marital Status Key *
47 MARITALSTATTEXT FATXT FATXT CHAR 6   0   Marital Status  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BAPIP0021US COUNTRY T005 LAND1    
2 BAPIP0021US NATIONALITY T005 LAND1    
3 BAPIP0021US NATIONALITY2 T005 LAND1    
4 BAPIP0021US NATIONALITY3 T005 LAND1    
5 BAPIP0021US STATE T005S BLAND    
History
Last changed by/on SAP  20130529 
SAP Release Created in