SAP ABAP Table PA0785 (HR Master Record Infotype 0785)
Hierarchy
☛
SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
⤷ PY-DE-PS-VA (Application Component) Pension Administration
⤷ P01PBSVAVG_DDIC (Package) HR-VADM: Public Sector Pensions Act (DDIC, User Interface)
⤷ PY-DE-PS-VA (Application Component) Pension Administration
⤷ P01PBSVAVG_DDIC (Package) HR-VADM: Public Sector Pensions Act (DDIC, User Interface)
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | PA0785 | Table Relationship Diagram |
Short Description | HR Master Record Infotype 0785 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | .INCLUDE | 0 | 0 | Key for HR Master Data | |||||
3 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | PA0003 | |
4 | SUBTY | SUBTY | SUBTY | CHAR | 4 | 0 | Subtype | ||
5 | OBJPS | OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
6 | SPRPS | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
7 | ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
8 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
9 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
10 | .INCLUDE | 0 | 0 | HR Master Record: Control Field | |||||
11 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
12 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
13 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
14 | ITXEX | ITXEX | XFELD | CHAR | 1 | 0 | Text Exists for Infotype | ||
15 | REFEX | PRFEX | XFELD | CHAR | 1 | 0 | Reference Fields Exist (Primary/Secondary Costs) | ||
16 | ORDEX | ORDEX | XFELD | CHAR | 1 | 0 | Confirmation Fields Exist | ||
17 | ITBLD | ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
18 | PREAS | PREAS | PREAS | CHAR | 2 | 0 | Reason for Changing Master Data | T530E | |
19 | FLAG1 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
20 | FLAG2 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
21 | FLAG3 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
22 | FLAG4 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
23 | RESE1 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
24 | RESE2 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
25 | GRPVL | PCCE_GPVAL | PCCE_GPVAL | CHAR | 4 | 0 | Grouping Value for Personnel Assignments | ||
26 | .INCLUDE | 0 | 0 | Verdict Information - Family Court | |||||
27 | DATUM_RECHTSKR | PDE_PBSVAVG_P57_DATE_RECHTSKR | DATUM | DATS | 8 | 0 | Date: Legally Binding From | ||
28 | DATUM_ANFRAGE | PDE_PBSVAVG_P57_DATE_ANFRAGE | DATUM | DATS | 8 | 0 | Date: Query From | ||
29 | INDV_ERH_VHS | PDE_PBSVAVG_P57_INDV_ERH_VHS | DEC3_2 | DEC | 5 | 2 | Individual Percentage Increase (Manual) | ||
30 | MIT_RGVH_F2003 | PDE_PBSVAVG_P57_MIT_RGVH_F2003 | XFELD | CHAR | 1 | 0 | With Pension Percentage Version 2003 | ||
31 | ABW_GERICHT | PDE_PBSVAVG_P57_ABW_GERICHT | PDE_PBSVAVG_P57_GERICHT | CHAR | 2 | 0 | Different Court (Municipal/Regional Court of Appeal/Fed.Sup) | ||
32 | ABW_ADRNR_GER | PDE_PBSVAVG_P57_ABW_ADRNR_GER | AD_ADDRNUM | CHAR | 10 | 0 | Alternative Address Number of Court | * | |
33 | ABW_AKTENZ | PDE_PBSVAVG_P57_ABW_AKTENZ | TEXT20 | CHAR | 20 | 0 | Other Case Number of Pension Equalization Payment | ||
34 | ART_VERFAHREN | PDE_PBSVAVG_P57_ART_VERFAHREN | PDE_PBSVAVG_P57_ART_VERFAHREN | CHAR | 2 | 0 | Type of Court Hearing | ||
35 | VERS_AUSGLEICH | PDE_PBSVAVG_P57_VERS_AUSGLEICH | PDE_PBSVAVG_P57_VERS_AUSGLEICH | CHAR | 2 | 0 | Pension Equalization Payment | ||
36 | BEGR_BETRAG | PDE_PBSVAVG_P57_BEGR_BETRAG | BETRG | CURR | 9 | 2 | Equalization Value | ||
37 | BEGR_BETRAG_WAER | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | T500W | |
38 | DATUM_WIRKSAM_AB | PDE_PBSVAVG_P57_DATE_WIRKS_AB | DATUM | DATS | 8 | 0 | Effective from Date | ||
39 | VERS_NR_EHEGATTE | PDE_PBSVAVG_P57_VERSICH_NUM | RENUM | CHAR | 14 | 0 | Insurance Policy Number of Spouse | ||
40 | RENTENVERS | PDE_PBSVAVG_P57_RENTENVERS | PDE_PBSVAVG_P57_RENTENVERS | CHAR | 2 | 0 | Pension Insurance | ||
41 | TRFGB | PDE_PBSVAVG_P57_TRFGB_RENTE | TRFGB | CHAR | 2 | 0 | Pay Scale Area for Pension | T510G | |
42 | TRFGR90 | PDE_PBSVAVG_P57_TRFGR90 | TRFGR | CHAR | 8 | 0 | PS Group at End of Marriage for Individual Increase 1990 | T510 | |
43 | TRFST90 | PDE_PBSVAVG_P57_TRFST90 | TRFST | CHAR | 2 | 0 | Pay Scale Level at End of Marriage for Indiv. Increase 1990 | T510 | |
44 | TRFAR90 | PDE_PBSVAVG_P57_TRFAR90 | TRFAR | CHAR | 2 | 0 | Pay Scale Type at End of Marriage for Indiv. Increase 1990 | T510A | |
45 | TRFGB90 | PDE_PBSVAVG_P57_TRFGB90 | TRFGB | CHAR | 2 | 0 | Pay Scale Area at End of Marriage Ind. Increase 1990 | T510G | |
46 | SUZUL90 | PDE_PBSVAVG_P57_SUZUL90 | DEC7_2 | DEC | 9 | 2 | Total of Other Bonuses 1990 | ||
47 | MAN_KAPBETR_P58 | PDE_PBSVAVG_P57_KAPBTR_P58_MAN | BETRG | CURR | 9 | 2 | Manually Entered Prevention Amount | ||
48 | MAN_KAPBETR_WAER | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | T500W | |
49 | KEINE_INDV_ERH | PDE_PBSVAVG_P57_KEINE_INDV_ERH | XFELD | CHAR | 1 | 0 | No Individual Increase 1990 | ||
50 | INDV_ERH_VHS08 | PDE_PBSVAVG_P57_INDV_ERH_VHS08 | DEC3_2 | DEC | 5 | 2 | Individual Percentage Increase (Manual) | ||
51 | SUZUL08 | PDE_PBSVAVG_P57_SUZUL08 | DEC7_2 | DEC | 9 | 2 | Total of Other Bonuses | ||
52 | KEINE_INDV_ERH08 | PDE_PBSVAVG_P57_KEINE_IN_ERH08 | XFELD | CHAR | 1 | 0 | No Individual Increase | ||
53 | TRFAR08 | PDE_PBSVAVG_P57_TRFAR08 | TRFAR | CHAR | 2 | 0 | PS Type at End of Marriage/Partnership for Indiv. Increase | T510A | |
54 | TRFGB08 | PDE_PBSVAVG_P57_TRFGB08 | TRFGB | CHAR | 2 | 0 | PS Area at End of Marriage/Partnership for Indiv. Increase | T510G | |
55 | TRFGR08 | PDE_PBSVAVG_P57_TRFGR08 | TRFGR | CHAR | 8 | 0 | PS Group at End of Marriage/Partnership for Indiv. Increase | T510 | |
56 | TRFST08 | PDE_PBSVAVG_P57_TRFST08 | TRFST | CHAR | 2 | 0 | PS Level at End of Marriage/Partnership for Indiv. Increase | T510 | |
57 | TRFAR_ENDE_EHE | PDE_PBSVAVG_P57_TRFAR | TRFAR | CHAR | 2 | 0 | Pay Scale Type on Date of End of Marriage/Partnership | T510A | |
58 | TRFGB_ENDE_EHE | PDE_PBSVAVG_P57_TRFGB | TRFGB | CHAR | 2 | 0 | Pay Scale Area on Date of End of Marriage/Partnership | T510G | |
59 | TRFGR_ENDE_EHE | PDE_PBSVAVG_P57_TRFGR | TRFGR | CHAR | 8 | 0 | Pay Scale Group on Date of End of Marriage/Partnership | T510 | |
60 | TRFST_ENDE_EHE | PDE_PBSVAVG_P57_TRFST | TRFST | CHAR | 2 | 0 | Pay Scale Level on Date of End of Marriage/Partnership | T510 | |
61 | PERNR_ANSPR_BER | PDE_PBSVAVG_P57_PNR_ANSPR_BER | PERNR | NUMC | 8 | 0 | Pers. No. of Person Entitled to Pension Equalization Payment | ||
62 | GRDL_TEILUNG | PDE_PBSVAVG_P57_GRDL_TEILUNG | PDE_PBSVAVG_P57_GRDL_TEILUNG | CHAR | 2 | 0 | Legal Basis Distribution | ||
63 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PA0785 | BEGR_BETRAG_WAER | T500W | WAERS | |||
2 | PA0785 | MAN_KAPBETR_WAER | T500W | WAERS | |||
3 | PA0785 | PERNR | PA0003 | PERNR | |||
4 | PA0785 | PREAS | T530E | PREAS | |||
5 | PA0785 | TRFAR08 | T510A | TRFAR | |||
6 | PA0785 | TRFAR90 | T510A | TRFAR | |||
7 | PA0785 | TRFAR_ENDE_EHE | T510A | TRFAR | |||
8 | PA0785 | TRFGB | T510G | TRFGB | |||
9 | PA0785 | TRFGB08 | T510G | TRFGB | |||
10 | PA0785 | TRFGB90 | T510G | TRFGB | |||
11 | PA0785 | TRFGB_ENDE_EHE | T510G | TRFGB | |||
12 | PA0785 | TRFGR08 | T510 | TRFGR | KEY | 1 | CN |
13 | PA0785 | TRFGR90 | T510 | TRFGR | KEY | 1 | CN |
14 | PA0785 | TRFGR_ENDE_EHE | T510 | TRFGR | KEY | 1 | CN |
15 | PA0785 | TRFST08 | T510 | TRFST | KEY | 1 | CN |
16 | PA0785 | TRFST90 | T510 | TRFST | KEY | 1 | CN |
17 | PA0785 | TRFST_ENDE_EHE | T510 | TRFST | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 10A |