SAP Table PA0718
HR Master Record: Infotype 0718
PA0718 (HR Master Record: Infotype 0718) 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 PA0718 to other SAP tables.
PA0718 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||||||
PERNR | Personnel number | PERSNO | PA0003 | NUMC | 8 | 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 | |||||||||||||||
BAREA | Benefit area | BEN_AREA | T5UB3 | CHAR | 2 | 0 | ||||||||||||||
RQTYP | Benefit request type | BPS_RQTYP | T74_BPS07 | CHAR | 4 | 0 | ||||||||||||||
RQOPT | Benefit request type option | BPS_RQOPT | T74_BPS12 | CHAR | 4 | 0 | ||||||||||||||
RQDAT | Benefit request date | BPS_RQDAT | DATS | 8 | 0 | |||||||||||||||
RQSTA | Request status | BPS_RQSTA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
RQPYD | Date of origin | BPS_RQPYD | DATS | 8 | 0 | |||||||||||||||
APPDA | Request approved date | BPS_APPDA | DATS | 8 | 0 | |||||||||||||||
RQAMT | Request amount | BPS_RQAMT | CURR | 13 | 2 | |||||||||||||||
RQCUR | Benefit Currency Key | BEN_CURR | TCURC | CUKY | 5 | 0 | ||||||||||||||
RDPTS | Deduction points | BPS_RDPTS | DEC | 10 | 0 | |||||||||||||||
RBAMT | Reimbursement amount | BPS_RBAMT | CURR | 13 | 2 | |||||||||||||||
RDAMT | Deduction amount | BPS_RDAMT | CURR | 13 | 2 | |||||||||||||||
RBPTS | Purchase points | BPS_RBPTS | DEC | 10 | 0 | |||||||||||||||
CURRE | Benefit Currency Key | BEN_CURR | TCURC | CUKY | 5 | 0 | ||||||||||||||
EXAMT | Excess amount | BPS_EXAMT | CURR | 13 | 2 | |||||||||||||||
EXPTS | Excess points | BPS_EXPTS | DEC | 10 | 0 | |||||||||||||||
RQDTY | Family member subtype of infotype 0021 | BPS_FAMTY | T591A | CHAR | 4 | 0 | ||||||||||||||
RQDID | Family member subtype object of infotype 0021 | BPS_FAMID | CHAR | 2 | 0 | |||||||||||||||
RDPUR | Benefit request purpose | BPS_RDPUR | T74_BPS18 | CHAR | 4 | 0 | ||||||||||||||
RDBEG | Request benefit begin date | BPS_RDBEG | DATS | 8 | 0 | |||||||||||||||
RDEND | Request benefit end date | BPS_RDEND | DATS | 8 | 0 | |||||||||||||||
RDSTA | Benefit request status | BPS_RDSTA | T74_BPS20 | CHAR | 1 | 0 | ||||||||||||||
RDASU | The subtype of infotype 0006 address(TC=1/2) | BPS_ADDRT | T591A | CHAR | 4 | 0 | ||||||||||||||
RDBSU | The subtype of External Bank Transfers infotype (0011) | BPS_BANKT | T512Z | CHAR | 4 | 0 | ||||||||||||||
RDLSU | Benefit point system absence type | BPS_RQATY | T74_BPS21 | CHAR | 4 | 0 | ||||||||||||||
REFER | Reference text | BPS_REFER | CHAR | 128 | 0 | |||||||||||||||
RDESY | School year | BPS_RDESY | DEC | 2 | 0 | |||||||||||||||
RDESP | School period | BPS_RDESP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
RDEPN | School period number | BPS_RDEPN | DEC | 2 | 0 | |||||||||||||||
RDRNP | Number of persons | BPS_RDRNP | DEC | 2 | 0 | |||||||||||||||
RDRNR | Number of rooms | BPS_RDRNR | DEC | 2 | 0 | |||||||||||||||
RDRRS | Room size | BPS_RDRRS | DEC | 2 | 0 | |||||||||||||||
RDRES | Employee staying or not | BPS_RDRES | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
RDRCN | Confirmation number | BPS_RDRCN | CHAR | 10 | 0 | |||||||||||||||
RDRIA | Invoice amount | BPS_RDRIA | CURR | 13 | 2 | |||||||||||||||
RDRCU | Invoice amount currency | BPS_RDRCU | TCURC | CUKY | 5 | 0 | ||||||||||||||
RDGNG | Number of gifts | BPS_RDGNG | DEC | 3 | 0 | |||||||||||||||
RDMPD | Preferred examination date | BPS_RDMPD | DATS | 8 | 0 | |||||||||||||||
RDMCD | Confirmed examination date | BPS_RDMCD | DATS | 8 | 0 | |||||||||||||||
RDLPR | Benefit Name of Benefit Provider | BEN_PROVN | CHAR | 30 | 0 |
PA0718 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
PA0718 | BAREA | SYST | MANDT | T5UB3 | Benefit area | MANDT |
PA0718 | BAREA | PA0718 | BAREA | T5UB3 | Benefit area | BAREA |
PA0718 | CURRE | SYST | MANDT | TCURC | Currency Codes | MANDT |
PA0718 | CURRE | PA0718 | CURRE | TCURC | Currency Codes | WAERS |
PA0718 | PERNR | SYST | MANDT | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
PA0718 | PERNR | PA0718 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
PA0718 | PREAS | SYST | MANDT | T530E | Reasons for Changes | MANDT |
PA0718 | PREAS | PSKEY | INFTY | T530E | Reasons for Changes | INFTY |
PA0718 | PREAS | PA0718 | PREAS | T530E | Reasons for Changes | PREAS |
PA0718 | RDASU | '0006' | T591A | Subtype Characteristics | INFTY | |
PA0718 | RDASU | PA0718 | RDASU | T591A | Subtype Characteristics | SUBTY |
PA0718 | RDASU | SYST | MANDT | T591A | Subtype Characteristics | MANDT |
PA0718 | RDBSU | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
PA0718 | RDBSU | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
PA0718 | RDBSU | '0718' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
PA0718 | RDBSU | * | T512Z | Permissibility of Wage Types per Infotype | MOLGA | |
PA0718 | RDBSU | PA0718 | RDBSU | T512Z | Permissibility of Wage Types per Infotype | LGART |
PA0718 | RDLSU | * | T74_BPS21 | Benefit request type allowed absence types | ENDDA | |
PA0718 | RDLSU | SYST | MANDT | T74_BPS21 | Benefit request type allowed absence types | MANDT |
PA0718 | RDLSU | PA0718 | BAREA | T74_BPS21 | Benefit request type allowed absence types | BAREA |
PA0718 | RDLSU | PA0718 | RQTYP | T74_BPS21 | Benefit request type allowed absence types | RQTYP |
PA0718 | RDLSU | PA0718 | RDLSU | T74_BPS21 | Benefit request type allowed absence types | RQATY |
PA0718 | RDPUR | PA0718 | BAREA | T74_BPS18 | Benefit request purpose | BAREA |
PA0718 | RDPUR | PA0718 | RQTYP | T74_BPS18 | Benefit request purpose | RQTYP |
PA0718 | RDPUR | PA0718 | RDPUR | T74_BPS18 | Benefit request purpose | RDPUR |
PA0718 | RDPUR | SYST | MANDT | T74_BPS18 | Benefit request purpose | MANDT |
PA0718 | RDRCU | SYST | MANDT | TCURC | Currency Codes | MANDT |
PA0718 | RDRCU | PA0718 | RDRCU | TCURC | Currency Codes | WAERS |
PA0718 | RDSTA | PA0718 | RQTYP | T74_BPS20 | Benefit request detail status | RQTYP |
PA0718 | RDSTA | PA0718 | RDSTA | T74_BPS20 | Benefit request detail status | RDSTA |
PA0718 | RDSTA | SYST | MANDT | T74_BPS20 | Benefit request detail status | MANDT |
PA0718 | RDSTA | PA0718 | BAREA | T74_BPS20 | Benefit request detail status | BAREA |
PA0718 | RQCUR | SYST | MANDT | TCURC | Currency Codes | MANDT |
PA0718 | RQCUR | PA0718 | RQCUR | TCURC | Currency Codes | WAERS |
PA0718 | RQDTY | SYST | MANDT | T591A | Subtype Characteristics | MANDT |
PA0718 | RQDTY | '0021' | T591A | Subtype Characteristics | INFTY | |
PA0718 | RQDTY | PA0718 | RQDTY | T591A | Subtype Characteristics | SUBTY |
PA0718 | RQOPT | PA0718 | BAREA | T74_BPS12 | Benefit request type option | BAREA |
PA0718 | RQOPT | PA0718 | RQTYP | T74_BPS12 | Benefit request type option | RQTYP |
PA0718 | RQOPT | PA0718 | RQOPT | T74_BPS12 | Benefit request type option | RQOPT |
PA0718 | RQOPT | PA0718 | RQDAT | T74_BPS12 | Benefit request type option | ENDDA |
PA0718 | RQOPT | SYST | MANDT | T74_BPS12 | Benefit request type option | MANDT |
PA0718 | RQTYP | SYST | MANDT | T74_BPS07 | Benefit request type | MANDT |
PA0718 | RQTYP | PA0718 | BAREA | T74_BPS07 | Benefit request type | BAREA |
PA0718 | RQTYP | PA0718 | RQTYP | T74_BPS07 | Benefit request type | RQTYP |