P2RF_CTT - Payroll results: contracts
Payroll results: contracts information is stored in SAP table P2RF_CTT.
It is part of development package PC06 in software component PY-FR. This development package consists of objects that can be grouped under "HR Payroll: France".
It is part of development package PC06 in software component PY-FR. This development package consists of objects that can be grouped under "HR Payroll: France".
Fields for table P2RF_CTT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | HRDCT_S_PAYKEY | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| .INCLUDE | PCLKEY | X | HRDCT_S_PYPCL2KEY | 0 | ||
| DCT_PERNR | Personnel Number | X | P_PERNR | NUMC | 16 | |
| DCT_SEQNR | Sequence Number | X | CDSEQ | NUMC | 10 | HRPY_RGDIR |
| DCT_ROWID | Unique Row Number | X | HRDCT_ROWID | NUMC | 10 | |
| .INCLUDE | PC2CT | 0 | ||||
| .INCLUDE | HRPAYFR_S_CT_WITH_KEY | 0 | ||||
| NUMCT | CT split | P06_CT_NUMCT | RAW | 1 | ||
| .INCLUDE | HRPAYFR_S_PY_CT_DATA | 0 | ||||
| GRCT1 | Grouping table CT 1 (Link to table REM) | P06_PY_GROUPING_CT_1 | NUMC | 8 | ||
| GRCT2 | Grouping table CT 2 (Reporting DSN, Block 40 Generation) | P06_PY_GROUPING_CT_2 | NUMC | 8 | ||
| UIDCT | Payroll: Unique contract ID | P06_PY_UNIQUE_ID_CONTRACT | CHAR | 66 | ||
| BEGDA | Start Date | BEGDA | DATS | 16 | ||
| ENDDA | End Date | ENDDA | DATS | 16 | ||
| AKTIVJN | Indicator: Active | AKTIVJN | CHAR | 2 | ||
| SPKEY | Payroll: Split key | P06_PY_SPLIT_KEY | CHAR | 100 | ||
| WERKS | Personnel Area | PERSA | CHAR | 8 | * | |
| BTRTL | Personnel Subarea | BTRTL | CHAR | 8 | * | |
| ANSVH | Work Contract | ANSVH | CHAR | 4 | * | |
| CTTYP | Contract Type | CTTYP | CHAR | 4 | * | |
| MODAL | Special Type of Contract | P06_MODAL | CHAR | 4 | ||
| CODEB | Payroll: Contract start date | P06_PY_DATE_BEGDA_CONTRACT | DATS | 16 | ||
| COFIN | Payroll: Contract end date | P06_PY_DATE_ENDDA_CONTRACT | DATS | 16 | ||
| COSIR | Work place identifier | P06_CONTRAT_ID_LIEU_TRAVAIL | CHAR | 28 | * | |
| CONUM | Payroll: Contrat number | P06_PY_NUMERO_CONTRAT | CHAR | 66 | ||
| COSTA | Payroll: Employee status (pay scale dependent) | P06_PY_STATCATEG | CHAR | 8 | ||
| COAGI | Payroll: Mandatory categorical compl. retirement status code | P06_PY_STATCATEG_AGIRC | CHAR | 8 | ||
| CONAT | Payroll: Nature of contract | P06_PY_NATURE_CONTRAT | CHAR | 8 | ||
| COINT | Payroll: Public political facility | P06_PY_CD_INTITULE_CONTRAT | CHAR | 8 | ||
| COUMQ | Payroll: Unit of measure for quota | P06_PY_UNITE_QUOTITE | CHAR | 8 | ||
| COQTC | Work contract work amount | P06_PY_QUOTITE_CONTRAT | DEC | 8 | ||
| COMEX | Payroll: Exercise modality of employment contract | P06_PY_MODALITE_CONTRAT | CHAR | 8 | ||
| COSAL | Payroll: Reference salary carried by the contract | P06_PY_SALAIRE_REF_CONTRAT | CURR | 8 | ||
| WAERS | Currency Key | WAERS | CUKY | 10 | * | |
| COALS | Payroll: Local scheme for Alsace Moselle | P06_PY_REGIME_ALSACE | CHAR | 8 | ||
| COCOL | DADS-U: Collective agreement indicator | P06_PY_CD_CONV_COLLECTIVE | CHAR | 8 | ||
| COASI | SIRET Number | P06_SIRET | CHAR | 28 | * | |
| COMRE | Employment contract: Reason for recourse to a CDD | P06_CONTRAT_MOTIF_RECOURS_CDD | CHAR | 4 | ||
| COTDF | Payroll: Contribution rate | P06_PY_TAUX | DEC | 3 | ||
| COSTE | Payroll: Status abroad | P06_PY_STATUS_ETRANGER | CHAR | 8 | ||
| COCSP | PCS code: Nomenclature of professions and socio. categories | P06_PCS | CHAR | 8 | * | |
| COPCS | PCS supplement | P06_CCPCS | CHAR | 12 | ||
| COQTR | Payroll: Reference work quota lot of company | P06_PY_QUOTITE_REF | DEC | 8 | ||
| COCCP | Payroll: Professional paid leave fund code | P06_PY_CD_CAISSE_PROF_CONGE_P | CHAR | 8 | ||
| COROB | Payroll: Mandatory sickness plan code | P06_PY_CD_REGIME_MALADIE | CHAR | 8 | ||
| CORIS | Payroll: Basic old age pension scheme code | P06_PY_CD_RISQUE_VIEILLESSE | CHAR | 8 | ||
| COEXC | Payroll: Reason of exclusion DSN | P06_PY_CD_DSN_MOTIF_EXCL | CHAR | 8 | ||
| COEST | Payroll: Employee employment status | P06_PY_CD_COEST | CHAR | 8 | ||
| COASC | Payroll: Unemployment insurance assgnmnt cde S21.G00.40.027 | P06_PY_CD_COASC | CHAR | 16 | ||
| CONEP | Payroll: Internal number for public employer | P06_PY_NUM_CONEP | CHAR | 32 | ||
| COGAC | Payroll: Type of unemployment insurance management | P06_PY_CD_COGAC | CHAR | 8 | ||
| CODAD | Payroll: Date of signing | P06_PY_DATE_CODAD | DATS | 16 | ||
| CODDE | Payroll: Date of termination | P06_PY_DATE_CODDE | DATS | 16 | ||
| CODEC | Payroll: Date of effect of management convention | P06_PY_DATE_CODEC | DATS | 16 | ||
| CONCG | Payroll: Number of management convention | P06_PY_NUM_CONCG | CHAR | 24 | ||
| COEFF | Payroll: staff indicator | P06_PY_CD_EFFECTIVE | CHAR | 2 | ||
| COFIP | Payroll: Planned contract end date | P06_PY_DATE_PRE_ENDDA_CONTRACT | DATS | 16 | ||
| CORSA | Payroll: Industrial accident risk code | P06_PY_CODRIS | CHAR | 16 | ||
| COSCA | Payroll: APECITA category status indicator | P06_PY_STAT_CAT_APECITA | CHAR | 8 | ||
| COSTP | Payroll: Part-time employee contributing at full-time rate | P06_PY_SAL_COT_TPS_PLEIN | CHAR | 8 | ||
| REALB | Trainee working on actual basis | P06_PY_TRAINEE_REAL_BASE | CHAR | 2 | ||
| COTAT | Industrial accident contribution rate | P06_PY_DSN_TAUX_AT | DEC | 4 | ||
| COCCL | Payroll: Professional paid leave fund indicator | P06_PY_CD_CAISSE_PROF_CONGE_PL | CHAR | 60 | ||
| PPERI | Customary period for the payment of remuneration | P06_PY_PAYMENT_PERIODICITY | CHAR | 8 | ||
| ABARE | Payroll: rate, exemption condition result | P06_PY_BAREME_ABATTEMENT_COND | CHAR | 2 | ||
| PASEX | Payroll: DS, exemption condition result | P06_PY_PAS_EXEMPTION_COND | CHAR | 2 | ||
| .INCLUDE | P19V01 | HRPAYFR_S_PY_CTT_DATA_P19V01 | 0 | |||
| CDSEC | P06_PY_CODE_SECTEUR | CHAR | 4 | |||
| COFPP | P06_PY_FP_COMP_PCS_NNE | CHAR | 8 | |||
| CONPO | P06_PY_FP_NAT_POSTE | CHAR | 4 | |||
| COQTT | P06_PY_NBHRS_FP_QUOT_TRAV | DEC | 4 | |||
| COTTP | Payroll: Rate of part-time employment | P06_PY_RATE_TAUX_TRAV_TPART | DEC | 4 | ||
| COCCS | P06_PY_FP_CCAT_SERV | CHAR | 4 | |||
| COCIB | P06_PY_FP_IND_BRUT | CHAR | 8 | |||
| COCIM | P06_PY_RATE_FP_IND_MAJ | DEC | 3 | |||
| CONBI | Payroll: [FP] New Grading Bonus Payment (NBI) | P06_PY_NUM_FP_NOUV_BONI_IND | DEC | 5 | ||
| COIBO | P06_PY_FP_IND_BRUT_ORI | CHAR | 8 | |||
| COIES | P06_PY_FP_IND_BRUT_ES | CHAR | 8 | |||
| COIBG | P06_PY_FP_ANC_EMPLOYEUR_PUBLIC | CHAR | 4 | |||
| COIBP | P06_PY_FP_IND_BRUT_ORI_EMPL | CHAR | 8 | |||
| COIBS | P06_PY_FP_IND_BRUT_SPP | CHAR | 8 | |||
| COMTC | P06_PY_FP_MAINT_ORIG_CT | CHAR | 8 | |||
| ABARD | Payroll: rate, exemption condition date | P06_PY_BAREME_ABATTEMENT_DATE | DATS | 16 | ||
| TDETA | P06_PY_FP_TYPE_DETACHEMENT | CHAR | 4 | |||
| COTSA | Payroll: Active service rate | P06_PY_DSN_COTSA | DEC | 4 | ||
| CONRX | Payroll: Remuneration level | P06_PY_DSN_CONRX | CHAR | 10 | ||
| COECH | Payroll: Pay Scale Level | P06_PY_DSN_COECH | CHAR | 8 | ||
| COCOH | Payroll: hierarc. factor | P06_PY_DSN_COCOH | DEC | 4 | ||
| COGEN | Payroll: Navigation type | P06_PY_DSN_COGEN | CHAR | 8 | ||
| COSBO | Payroll: BOETH status | P06_PY_DSN_COSBO | CHAR | 8 | ||
| COCDP | Payroll: Additional Public Policy Measure | P06_PY_DSN_COCDP | CHAR | 8 | ||
| CODEI | Paie: Case of extern. provision of person assign. to workpl. | P06_PY_DSN_CODEI | CHAR | 8 | ||
| COCCF | Payroll: final assignment to wage group category | P06_PY_DSN_COCCF | CHAR | 8 | ||
| COCRM | Payroll: Depreciated | P06_PY_DSN_COCRM | CHAR | 10 | ||
| CORVI | Payroll: Depreciated | P06_PY_DSN_CORVI | CHAR | 10 | ||
| COIEM | Payroll: Marine committment contract ID | P06_PY_DSN_COIEM | CHAR | 66 | ||
| COIEG | Payroll: Labor dispute group (CNIEG) | P06_PY_DSN_COIEG | CHAR | 8 | ||
| COTAP | Payroll: working time during part-time employment | P06_PY_DSN_COTAP | CHAR | 8 | ||
| COXXX | Payroll: Depreciated | P06_PY_DSN_DEPREC | CHAR | 8 | ||
| PACRE | DS: Income Class 50.014 | P06_PY_PAS_CD_EARNING_CLASS | CHAR | 6 | ||
| COEMM | Payroll: Concurrent employment code | P06_PY_COEMM | CHAR | 8 | ||
| COERM | Payroll: Concurrent employment code | P06_PY_COERM | CHAR | 8 | ||
| CORAT | Payroll: Code for Compulsory work accident plan | P06_PY_CORAT | CHAR | 8 | ||
| COPCC | Payroll: Position. collective agreement | P06_PY_COPCC | CHAR | 200 | ||
| COCO2 | Payroll: Hierarchical Factor 40.071 | P06_PY_DSN_COCO2 | CHAR | 20 | ||
| COGRA | Payroll: Grade 40.079 | P06_PY_DSN_CONTRAT_GRADE | CHAR | 16 | ||
| COCTI | Payroll: [FP] Index CTI 40.080 | P06_PY_DSN_CONTRAT_CTI | CHAR | 8 | ||
| COFGE | Payroll: Geographical FINESS No 40.081 | P06_PY_DSN_CO_FINESSGEOGRAPHI | CHAR | 40 |