P06DAD_DONNEES_SOCIALES3 SAP (DADS-U: Activity period (S41.G01.00)) Structure details

Dictionary Type: Structure
Description: DADS-U: Activity period (S41.G01.00)




ABAP Code to SELECT data from P06DAD_DONNEES_SOCIALES3
Related tables to P06DAD_DONNEES_SOCIALES3
Access table P06DAD_DONNEES_SOCIALES3




Structure field list including key, data, relationships and ABAP select examples

P06DAD_DONNEES_SOCIALES3 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DADS-U: Activity period (S41.G01.00)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_P06DAD_DONNEES_SOCIALES3 TYPE P06DAD_DONNEES_SOCIALES3.

The P06DAD_DONNEES_SOCIALES3 table consists of various fields, each holding specific information or linking keys about DADS-U: Activity period (S41.G01.00) data available in SAP. These include MOT_DEB1 (DADS-U: Period start reason code), MOT_DEB2 (DADS-U: Period start reason code), MOT_DEB3 (DADS-U: Period start reason code), MOT_DEB4 (DADS-U: Period start reason code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP P06DAD_DONNEES_SOCIALES3 structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PER_DEB P06DAD_PER_DEB_SITDATS8DATUM
MOT_DEB1DADS-U: Period start reason code P06_MOT_DEBCHAR3CHAR3
MOT_DEB2DADS-U: Period start reason code P06_MOT_DEBCHAR3CHAR3
MOT_DEB3DADS-U: Period start reason code P06_MOT_DEBCHAR3CHAR3
MOT_DEB4DADS-U: Period start reason code P06_MOT_DEBCHAR3CHAR3
MOT_DEB5DADS-U: Period start reason code P06_MOT_DEBCHAR3CHAR3
PER_FIN P06DAD_PER_FIN_SITDATS8DATUM
MOT_FIN1DADS-U: Period end reason code P06_MOT_FINCHAR3CHAR3
MOT_FIN2DADS-U: Period end reason code P06_MOT_FINCHAR3CHAR3
MOT_FIN3DADS-U: Period end reason code P06_MOT_FINCHAR3CHAR3
MOT_FIN4DADS-U: Period end reason code P06_MOT_FINCHAR3CHAR3
MOT_FIN5DADS-U: Period end reason code P06_MOT_FINCHAR3CHAR3
NUMICNIC P06_NUMICCHAR5CHAR5
SIRENCSIREN number P06_SIRENCHAR9
NUMICCNIC P06_NUMICCHAR5CHAR5
SIRENTSIREN number P06_SIRENCHAR9
NUMICTNIC P06_NUMICCHAR5CHAR5
EMPMULTIConcurrent employment code P06_EMPMULTICHAR2CHAR2
EMPLOISConcurrent employment code P06_EMPLOISCHAR2CHAR2
DECPAIEPayroll offset code P06_DECPAIECHAR2CHAR2
NATEMPLOIType of employment P06_NATEMPLOICHAR120CHAR120
PCSSocio-professional category INSEE code P06_PCSCHAR4Assigned to domainP06_PCS
CONTRATDADS-U: Work contract code P06_CONTRATCHAR2CHAR2
DROIT_CONTRATWork contract law indicator P06_DR_CONTRCHAR2P06_DROITC
CAR_TRAVDADS-U: Characteristic code of activity or contract P06_CAR_TRAVCHAR2CHAR2
STATPROFDADS-U : Employee professional status code P06_STATPROFCHAR2CHAR2
STATCATEGDADS-U: Employee collective agreement group status indicator P06_STATCATEG_CONVCHAR2CHAR2
STATCATRTDADS-U: Employee AGIRC-ARRCO group status indicator P06_STATCATEG_AGIRCCHAR2CHAR2
CONVCOLLDADS-U: Collective agreement code P06_CONVCOLLCHAR4CHAR4
CLASCONVDADS-U: Conventional assignment to wage lev. P06_CLASCONVCHAR120TEXT120
REGIME_BASEDADS-U: Compulsory basic plan indicator P06_REGIME_BASECHAR3P06_REGIME
REGIME_MALADIECompulsory illness risk scheme indicator P06_REGIME_MALADIECHAR3P06_REGIME
REGIME_ACCTRAVCompulsory work accident risk scheme indicator P06_REGIME_ACCTRAVCHAR3P06_REGIME
REGIME_VIEPATRCompulsory pension plan code (employer part) P06_REGIME_VIEPATRCHAR3P06_REGIME
REGIME_VIESALARDADS-U: Compulsory pension plan code (employee part) P06_REGIME_VIESALARCHAR3P06_REGIME
REGIME_ALS_MOSAlsace-Moselle extension code P06_REGIME_ALS_MOSCHAR2CHAR2
MATRICULEEmployee's personnel number in the work place P06_MATRICULE30CHAR30CHAR30
TAUX_TPDADS-U: Rate of part-time employment P06_TAUX_TPDEC4(2) DEC2_2
HRSTRAVDADS-U: Number of hours worked for period P06_HRSTRAVDEC4DEC4
HRSPAIEDADS-U: number of paid hours for the period P06_HRSPAIEDEC4DEC4
DER_MOISDADS-U: Last month with 60 working hours P06_DER_MOISNUMC2NUM2
HRSCHOMDADS-U: Total amount of partial unemployment hours P06_HRSCHOMDEC4DEC4
AT_SECTIONCompany section I.A. P06_SECTIOCHAR2CHAR2
AT_RISQUERisk code P06_CODRISCHAR5CHAR5
BUREAUOffice code P06_CODBURCHAR1CHAR1
TXACCTIndustrial accident rate P06DAD_TXACCTDEC5(2) DEC3_2
SSBRUTDADS-U: Gross Social Security base for the period P06_AMOUNT_SSBRUTDEC8P06_AMOUNT_DADSU
NATBASESDADS-U: Nature code for contributions bases P06DAD_NATBASECHAR2P06DAD_NATBASE
SSLIMDADS-U: Base limited to Social Security threshold P06_AMOUNT_SSLIMDEC8P06_AMOUNT_DADSU
CSGDADS-U : General Social Contribution (CSG) P06_AMOUNT_CSGDEC8P06_AMOUNT_DADSU
CRDSDADS-U: Social Debt Reimbursement Contribution P06_AMOUNT_CRDSDEC8P06_AMOUNT_DADSU
ETR_FROWork abroad or cross-border code P06_ETR_FROCHAR2CHAR2
BASE_BRUTDADS-U: Gross tax base P06_AMOUNT_BBRUTDEC8P06_AMOUNT_DADSU
NAT_VALEURDADS-U: Value imputed income P06_NAT_VALDEC8P06_AMOUNT_DADSU
NAT_NOURRDADS-U: Meals P06_NAT_NOURRCHAR1CHAR1
NAT_LOGMTDADS-U: Residency P06_NAT_LOGMTCHAR1CHAR1
NAT_VOITDADS-U: Car P06_NAT_VOITCHAR1CHAR1
NAT_AUTRDADS-U: Other advantages P06_NAT_AUTRCHAR1CHAR1
RETENUEDADS-U: Deduction from pay P06_RETENUEDEC8P06_AMOUNT_DADSU
POURBOIREDADS-U: Tip income P06_POURBOIRECHAR1CHAR1
FRAIS_PROFDADS-U: Professional expenses amount P06_FRAIS_PROFDEC8P06_AMOUNT_DADSU
FORFAITDADS-U: Lump-sum allowances P06_FORFAITCHAR1CHAR1
REMB_FRAISDADS-U: Professional expenses reimbursements P06_REMB_FRAISCHAR1CHAR1
PRIS_EMPLDADS-U: Covered by employer P06_PRIS_EMPLCHAR1CHAR1
REMB_AUTRDADS-U: Reimbursements other than professional expenses P06_REMB_AUTRCHAR1CHAR1
CHEQ_VACDADS-U: Amount of employer participation in checks P06_CHEQ_VACDEC8P06_AMOUNT_DADSU
IMPOTSDADS-U: Taxes withheld at source P06_IMPOTSDEC8P06_AMOUNT_DADSU
IND_EXPADADS-U: Location allowance P06_IND_EXPADEC8P06_AMOUNT_DADSU
PAIE_ETABDADS-U: Employee remunerated by diverse places of work P06_PAIE_ETABCHAR6CHAR6
TOT_TAXSALDADS-U: Total subject to salary tax P06_AMOUNT_TAXSALDEC8P06_AMOUNT_DADSU
BASE_TAUX1DADS-U: 1st rate tax base P06_AMOUNT_BTAUX1DEC8P06_AMOUNT_DADSU
BASE_TAUX2DADS-U: 2nd rate tax base P06_AMOUNT_BTAUX2DEC8P06_AMOUNT_DADSU
TAXSALDADS-U: Salary tax total P06_TAXSAL_DADSUDEC8P06_AMOUNT_DADSU
ACTIVITESDADS-U: Net taxable income from activities P06_ACTIVITESDEC8P06_AMOUNT_DADSU
CONGES_PAYESDADS-U: Total paid leave payments P06_CONGES_PAYESDEC8P06_AMOUNT_DADSU
OTHER_REVENUESDADS-U: Other taxable net income P06_AMOUNT_REVDEC8P06_AMOUNT_DADSU
EPARG_RETRSavings-retirement contributions P06_AMOUNT_EPRTDEC8P06_AMOUNT_DADSU
NTICDADS-U: Tools issued from NTIC P06_OUTILS_NTICCHAR1CHAR1
IMPATDADS-U: Patriation costs P06_AMOUNT_IMPDEC8P06_AMOUNT_DADSU
SERV_PERSDADS-U: Participation in personal services financing P06_AMOUNT_SERVDEC8P06_AMOUNT_DADSU
CODE_CNBFDADS-U: CNBF extension class code P06_CODE_CNBFCHAR2CHAR2
INDEMN_CPPDADS-U: Maximum paid leave compensation amount P06_AMOUNT_INDCPPDEC8P06_AMOUNT_DADSU
MNT_HSHCRemuneration excl. overtime and extra hours P06_AMOUNT_HSHCDEC8P06_AMOUNT_DADSU

Key field Non-key field



How do I retrieve data from SAP structure P06DAD_DONNEES_SOCIALES3 using ABAP code?

As P06DAD_DONNEES_SOCIALES3 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on P06DAD_DONNEES_SOCIALES3 as there is no data to select.

How to access SAP table P06DAD_DONNEES_SOCIALES3

Within an ECC or HANA version of SAP you can also view further information about P06DAD_DONNEES_SOCIALES3 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!