SAP ABAP Table PA0117 (HR Master Record: Infotype 0117 (Garn. Compensation D))
Hierarchy
SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   PA-PA-DE (Application Component) Germany
     PB01 (Package) HR Master Data: Germany
Basic Data
Table Category TRANSP    Transparent table 
Transparent table PA0117   Table Relationship Diagram
Short Description HR Master Record: Infotype 0117 (Garn. Compensation D)    
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 T000
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   HR Master Record: Infotype 0117 (Garn. Compensation D)  
27 PFART PFARD PFART CHAR 1   0   Garnishment Type  
28 PFNUM PFNUM PFNUM NUMC 3   0   Garnishment Number  
29 AZART AFART AEART CHAR 1   0   Adjustment Type T5D6A
30 AZGRD AZGR1 AZGRD CHAR 2   0   Equalization Reason T5D6B
31 ESTDT ESTD1 DATUM DATS 8   0   Date of origin  
32 BETRG BETG1 WERT05 CURR 9   2   Equalization Amount  
33 OPKEN OPKEN OPKEN CHAR 1   0   Operation Indicator for Wage Types  
34 LGART LGAR4 LGART CHAR 4   0   Equalization Wage Type *
35 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PA0117 AZART T5D6A AZART REF C CN
2 PA0117 AZGRD T5D6B AZGRD REF C CN
3 PA0117 MANDT T000 MANDT KEY 1 CN
4 PA0117 PERNR PA0003 PERNR KEY 1 CN
5 PA0117 PREAS T530E PREAS REF C CN
History
Last changed by/on SAP  20110901 
SAP Release Created in