| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | SUBTY | Subtype | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | OBJPS | Object Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | SPRPS | Lock Indicator for HR Master Data Record | char | 1 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | AEDTM | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | HISTO | Historical Record Flag | char | 1 | 0 | | | | Allow NULL? |
| 12 | ITXEX | Text Exists for Infotype | char | 1 | 0 | | | | Allow NULL? |
| 13 | REFEX | Reference Fields Exist (Primary/Secondary Costs) | char | 1 | 0 | | | | Allow NULL? |
| 14 | ORDEX | Confirmation Fields Exist | char | 1 | 0 | | | | Allow NULL? |
| 15 | ITBLD | Infotype Screen Control | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | PREAS | Reason for Changing Master Data | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | FLAG1 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 18 | FLAG2 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 19 | FLAG3 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 20 | FLAG4 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 21 | RESE1 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | RESE2 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | GRPVL | Grouping Value for Personnel Assignments | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | SVART | Subtype for Supplementary Social Insurance | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | BEZ01 | Name of supplementary insurance | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | KVB01 | HI contribution class for voluntarily insured | nvarchar | 6 | 0 | | | | Allow NULL? |
| 27 | KVF01 | Contribution for Supplementary Social Insurance Germany | decimal | 7 | 2 | | | | |
| 28 | ZUS01 | Subsidizable Amount | decimal | 7 | 2 | | | | |
| 29 | SEL01 | Self-Payer Indicator | char | 1 | 0 | | | | Allow NULL? |
| 30 | BES01 | Model Confirmation of Supplementary Social Insurance | char | 1 | 0 | | | | Allow NULL? |
| 31 | SON01 | Special Regulations: Supplementary Insurances | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | ZVB01 | Distribution of SI Contributions | char | 1 | 0 | | | | Allow NULL? |
| 33 | BEZ02 | Name of supplementary insurance | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | KVB02 | HI contribution class for voluntarily insured | nvarchar | 6 | 0 | | | | Allow NULL? |
| 35 | KVF02 | Contribution for Supplementary Social Insurance Germany | decimal | 7 | 2 | | | | |
| 36 | ZUS02 | Subsidizable Amount | decimal | 7 | 2 | | | | |
| 37 | SEL02 | Self-Payer Indicator | char | 1 | 0 | | | | Allow NULL? |
| 38 | BES02 | Model Confirmation of Supplementary Social Insurance | char | 1 | 0 | | | | Allow NULL? |
| 39 | SON02 | Special Regulations: Supplementary Insurances | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | ZVB02 | Distribution of SI Contributions | char | 1 | 0 | | | | Allow NULL? |
| 41 | BEZ03 | Name of supplementary insurance | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | KVB03 | HI contribution class for voluntarily insured | nvarchar | 6 | 0 | | | | Allow NULL? |
| 43 | KVF03 | Contribution for Supplementary Social Insurance Germany | decimal | 7 | 2 | | | | |
| 44 | ZUS03 | Subsidizable Amount | decimal | 7 | 2 | | | | |
| 45 | SEL03 | Self-Payer Indicator | char | 1 | 0 | | | | Allow NULL? |
| 46 | BES03 | Model Confirmation of Supplementary Social Insurance | char | 1 | 0 | | | | Allow NULL? |
| 47 | SON03 | Special Regulations: Supplementary Insurances | nvarchar | 2 | 0 | | | | Allow NULL? |
| 48 | ZVB03 | Distribution of SI Contributions | char | 1 | 0 | | | | Allow NULL? |
| 49 | BEZ04 | Name of supplementary insurance | nvarchar | 8 | 0 | | | | Allow NULL? |
| 50 | KVB04 | HI contribution class for voluntarily insured | nvarchar | 6 | 0 | | | | Allow NULL? |
| 51 | KVF04 | Contribution for Supplementary Social Insurance Germany | decimal | 7 | 2 | | | | |
| 52 | ZUS04 | Subsidizable Amount | decimal | 7 | 2 | | | | |
| 53 | SEL04 | Self-Payer Indicator | char | 1 | 0 | | | | Allow NULL? |
| 54 | BES04 | Model Confirmation of Supplementary Social Insurance | char | 1 | 0 | | | | Allow NULL? |
| 55 | SON04 | Special Regulations: Supplementary Insurances | nvarchar | 2 | 0 | | | | Allow NULL? |
| 56 | ZVB04 | Distribution of SI Contributions | char | 1 | 0 | | | | Allow NULL? |
| 57 | BEZ05 | Name of supplementary insurance | nvarchar | 8 | 0 | | | | Allow NULL? |
| 58 | KVB05 | HI contribution class for voluntarily insured | nvarchar | 6 | 0 | | | | Allow NULL? |
| 59 | KVF05 | Contribution for Supplementary Social Insurance Germany | decimal | 7 | 2 | | | | |
| 60 | ZUS05 | Subsidizable Amount | decimal | 7 | 2 | | | | |
| 61 | SEL05 | Self-Payer Indicator | char | 1 | 0 | | | | Allow NULL? |
| 62 | BES05 | Model Confirmation of Supplementary Social Insurance | char | 1 | 0 | | | | Allow NULL? |
| 63 | SON05 | Special Regulations: Supplementary Insurances | nvarchar | 2 | 0 | | | | Allow NULL? |
| 64 | ZVB05 | Distribution of SI Contributions | char | 1 | 0 | | | | Allow NULL? |
| 65 | BTS01 | Basic Rate Private Social Insurance for Tax | decimal | 7 | 2 | | | | |
| 66 | BTS02 | Basic Rate Private Social Insurance for Tax | decimal | 7 | 2 | | | | |
| 67 | BTS03 | Basic Rate Private Social Insurance for Tax | decimal | 7 | 2 | | | | |
| 68 | BTS04 | Basic Rate Private Social Insurance for Tax | decimal | 7 | 2 | | | | |
| 69 | BTS05 | Basic Rate Private Social Insurance for Tax | decimal | 7 | 2 | | | | |
