SAP table PA0066 (HR Master data infotype 0066 - Canadian garnishment: order)
SAP table PA0066 has 8 primary key fields being MANDT,PERNR,SUBTY,OBJPS,SPRPS,ENDDA,BEGDA,SEQNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||
| PERNR | Personnel Number | NUMC | 8 | 0 | PA0003 | PERSNO | |||||||||||||||||
| SUBTY | Subtype | CHAR | 4 | 0 | SUBTY | ||||||||||||||||||
| OBJPS | Object Identification | CHAR | 2 | 0 | OBJPS | ||||||||||||||||||
| SPRPS | Lock Indicator for HR Master Data Record | CHAR | 1 | 0 | SPRPS | ||||||||||||||||||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||||||||||||||||||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||||||||||||||||||
| SEQNR | Number of Infotype Record With Same Key | NUMC | 3 | 0 | SEQNR | ||||||||||||||||||
| AEDTM | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||||||||||||
| UNAME | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||||||||||||||||||
| HISTO | Historical Record Flag | CHAR | 1 | 0 | HISTO | ||||||||||||||||||
| ITXEX | Text Exists for Infotype | CHAR | 1 | 0 | ITXEX | ||||||||||||||||||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | CHAR | 1 | 0 | PRFEX | ||||||||||||||||||
| ORDEX | Confirmation Fields Exist | CHAR | 1 | 0 | ORDEX | ||||||||||||||||||
| ITBLD | Infotype Screen Control | CHAR | 2 | 0 | ITBLD | ||||||||||||||||||
| PREAS | Reason for Changing Master Data | CHAR | 2 | 0 | T530E | PREAS | |||||||||||||||||
| FLAG1 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||||||||||||||||||
| FLAG2 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||||||||||||||||||
| FLAG3 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||||||||||||||||||
| FLAG4 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||||||||||||||||||
| RESE1 | Reserved Field/Unused Field of Length 2 | CHAR | 2 | 0 | NUSED2 | ||||||||||||||||||
| RESE2 | Reserved Field/Unused Field of Length 2 | CHAR | 2 | 0 | NUSED2 | ||||||||||||||||||
| GRPVL | Grouping Value for Personnel Assignments | CHAR | 4 | 0 | PCCE_GPVAL | ||||||||||||||||||
| IONUM | Internal order number | NUMC | 4 | 0 | P_IONUM | ||||||||||||||||||
| JURIS | Code for jurisdiction | CHAR | 4 | 0 | T52G0 | P_JURIS | |||||||||||||||||
| GCATE | Code for category | CHAR | 1 | 0 | T52G2 | P_GCATE | |||||||||||||||||
| IOPRI | Order priority | NUMC | 3 | 0 | P_IOPRI | ||||||||||||||||||
| AGCOD | Code for agency | CHAR | 1 | 0 | T52G4 | P_AGCOD | |||||||||||||||||
| GFCOD | Garnishee fee rule | CHAR | 1 | 0 | T52GI | P_GFCOD | |||||||||||||||||
| CRETY | HR payee type | CHAR | 1 | 0 | CRETY |
|
|||||||||||||||||
| CRENR | HR payee number | NUMC | 8 | 0 | T51RH | CRENR | |||||||||||||||||
| LIFNR | Vendor | CHAR | 10 | 0 | LFA1 | P_LIFNR | |||||||||||||||||
| LIFSG | Vendor subgroup | NUMC | 5 | 0 | ACSUB | ||||||||||||||||||
| RULNR | Remittance Rule | NUMC | 5 | 0 | T51RK | P_IOREM | |||||||||||||||||
| IOSCI | Single cheque indicator | CHAR | 1 | 0 | P_IOSCI | ||||||||||||||||||
| IOCN1 | Case number | CHAR | 25 | 0 | PCA_IOCN1 | ||||||||||||||||||
| IOCN2 | Case file number | CHAR | 25 | 0 | PCA_IOCN2 | ||||||||||||||||||
| IOCTD | Court order date | DATS | 8 | 0 | PCA_IOCTD | ||||||||||||||||||
| IORCD | Received date | DATS | 8 | 0 | PCA_IORCD | ||||||||||||||||||
| IORLD | Release date | DATS | 8 | 0 | PCA_IORLD | ||||||||||||||||||
| IOSTS | Garnishment order status | CHAR | 1 | 0 | PCA_IOSTS |
|
|||||||||||||||||
| IOANM | Agency name | CHAR | 40 | 0 | PCA_IOANM | ||||||||||||||||||
| IOAST | Agency street | CHAR | 35 | 0 | PCA_IOAST | ||||||||||||||||||
| IOACI | Agency city | CHAR | 35 | 0 | PCA_IOACI | ||||||||||||||||||
| IOAPC | Agency postal code | CHAR | 10 | 0 | PCA_IOAPC | ||||||||||||||||||
| IOAPR | Agency province | CHAR | 3 | 0 | T005S | PCA_IOAPR | |||||||||||||||||
| IOACO | Agency country | CHAR | 3 | 0 | T005 | PCA_IOACO | |||||||||||||||||
| IOAPH | Agency phone number | CHAR | 16 | 0 | PCA_IOAPH | ||||||||||||||||||
| IOPAY | Make cheque payable to plantiff | CHAR | 1 | 0 | PCA_IOPAY | ||||||||||||||||||
| IOPLN | Plaintiff | CHAR | 40 | 0 | PCA_IOPLN | ||||||||||||||||||
| IOGFA | Garnishee fee | CURR | 9 | 2 | PCA_IOGFA | ||||||||||||||||||
| IOCOL | Correspondence language | LANG | 1 | 0 | T002 | PCA_IOCOL |
PA0066 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 PA0066 | AGCOD | T52G4 | Agency | MANDT |
| 1 PA0066 | CRENR | T51RH | HR payee derived link to FI vendor | MANDT |
| 0 PA0066 | GCATE | T52G2 | Garnishment category | MANDT |
| 1 PA0066 | GFCOD | T52GI | Garnishee fee | MANDT |
| 1 PA0066 | GFCOD | T52GI | Garnishee fee | JURIS |
| 0 PA0066 | IOACO | T005 | Countries | MANDT |
| 0 PA0066 | IOACO | T005 | Countries | LAND1 |
| 1 PA0066 | IOAPR | T005S | Taxes: Region (Province) Key | LAND1 |
| 0 PA0066 | IOCOL | T002 | Language Keys (Component BC-I18) | SPRAS |
| 1 PA0066 | JURIS | T52G0 | Jurisdiction | MANDT |
| 0 PA0066 | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 0 PA0066 | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 1 PA0066 | MANDT | T000 | Clients | MANDT |
| 0 PA0066 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
| 0 PA0066 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
| 1 PA0066 | PREAS | T530E | Reasons for Changes | MANDT |
| 1 PA0066 | PREAS | T530E | Reasons for Changes | INFTY |
| 1 PA0066 | PREAS | T530E | Reasons for Changes | PREAS |
| 0 PA0066 | RULNR | T51RK | Remittance rule definition | MANDT |