SAP Table P0151
HR Master Record: Infotype 0151 (External Insurance RSA)
P0151 (HR Master Record: Infotype 0151 (External Insurance RSA)) 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 P0151 to other SAP tables.
P0151 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||
INFTY | Infotype | INFTY | T582A | CHAR | 4 | 0 | ||||||
SUBTY | Subtype | SUBTY | CHAR | 4 | 0 | |||||||
OBJPS | Object Identification | OBJPS | CHAR | 2 | 0 | |||||||
SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | 0 | |||||||
ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||
BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||
SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||
AEDTM | Changed On | AEDAT | DATS | 8 | 0 | |||||||
UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||
HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||
ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | 0 |
Possible values
|
||||||
REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||
ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||
ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | 0 | |||||||
PREAS | Reason for Changing Master Data | PREAS | T530E | CHAR | 2 | 0 | ||||||
FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||
FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||
FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||
FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||
RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||
RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||
GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | 0 | |||||||
EMFSL | Payee key for bank transfers | EMFSL | CHAR | 8 | 0 | |||||||
MTGLN | Membership number | MTGLN | CHAR | 20 | 0 | |||||||
GRPRG | Grouping | GRPRG | CHAR | 10 | 0 | |||||||
BETRG | Membership Fee | MTBTR | CURR | 9 | 2 | |||||||
WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
LGART | Wage Type | LGART | T5W3A | CHAR | 4 | 0 | ||||||
ANZHL | Number | ANZHL | DEC | 7 | 2 | |||||||
ZEINH | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
ZFPER | First payment period | DZFPER | NUMC | 2 | 0 | |||||||
ZDATE | First payment date | DZDATE | DATS | 8 | 0 | |||||||
ZANZL | Number for determining further payment dates | DZANZL | DEC | 3 | 0 | |||||||
ZEINZ | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
PRITY | Priority for the address lines | PRITY | CHAR | 1 | 0 | |||||||
UFUNC | Membership function | UFUNC | CHAR | 2 | 0 | |||||||
UNLOC | Insurance or membership type | P16_MEMTY | T591A | CHAR | 4 | 0 | ||||||
USTAT | Membership status | USTAT | CHAR | 2 | 0 | |||||||
CODAT | Policy Date | CODAT | DATS | 8 | 0 | |||||||
MODEL | Payment Model | MODE1 | T549W | CHAR | 4 | 0 |
P0151 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
P0151 | INFTY | SYST | MANDT | T582A | Infotypes: Customer-Specific Settings | MANDT |
P0151 | INFTY | P0151 | INFTY | T582A | Infotypes: Customer-Specific Settings | INFTY |
P0151 | LGART | P0151 | UNLOC | T5W3A | Wagetypes to Subtype relation | SUBTY |
P0151 | LGART | P0151 | LGART | T5W3A | Wagetypes to Subtype relation | LGART |
P0151 | LGART | SYST | MANDT | T5W3A | Wagetypes to Subtype relation | MANDT |
P0151 | LGART | T001P | MOLGA | T5W3A | Wagetypes to Subtype relation | MOLGA |
P0151 | MODEL | SYST | MANDT | T549W | Recurr. Pymts/Deducs: Payment Models | MANDT |
P0151 | MODEL | P0151 | MODEL | T549W | Recurr. Pymts/Deducs: Payment Models | MODEL |
P0151 | PREAS | SYST | MADNT | T530E | Reasons for Changes | MANDT |
P0151 | PREAS | P0151 | INFTY | T530E | Reasons for Changes | INFTY |
P0151 | PREAS | P0151 | PREAS | T530E | Reasons for Changes | PREAS |
P0151 | UNLOC | SYST | MANDT | T591A | Subtype Characteristics | MANDT |
P0151 | UNLOC | P0151 | INFTY | T591A | Subtype Characteristics | INFTY |
P0151 | UNLOC | P0151 | UNLOC | T591A | Subtype Characteristics | SUBTY |
P0151 | WAERS | SYST | MANDT | TCURC | Currency Codes | MANDT |
P0151 | WAERS | P0151 | WAERS | TCURC | Currency Codes | WAERS |
P0151 | ZEINH | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
P0151 | ZEINH | P0151 | ZEINH | T538A | HR Time/Measurement Units | ZEINH |
P0151 | ZEINZ | P0151 | ZEINZ | T538A | HR Time/Measurement Units | ZEINH |
P0151 | ZEINZ | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |