SAP France Tables

Are you looking for the right table related to SAP France Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in France (PY-FR) module.

Top 10 tables in France

TableDescription
T5F6LSend Details (DDE)
T5F6RInterface Table for Reporting Purposes
T5FPASCATEGDS: parameter setting category
T5F5RADADS-U check: Attributes of time-independent ALV nodes
P2RF_SUSPENSIONPayroll results: interrupted contract
T5FDSNABCATAbsence categories for DSN
T5F6GBatch header recording
T5F1P_PERIODWorkplaces
T5F62Dynamic Mapping for Interface: Wage Types as Master Data
P2RF_CCRTPayroll Results: Cumulation of Contributions, Wage Types

List of tables in France

TableDescription
T5F6LSend Details (DDE)
T5F6RInterface Table for Reporting Purposes
T5FPASCATEGDS: parameter setting category
T5F5RADADS-U check: Attributes of time-independent ALV nodes
P2RF_SUSPENSIONPayroll results: interrupted contract
T5FDSNABCATAbsence categories for DSN
T5F6GBatch header recording
T5F1P_PERIODWorkplaces
T5F62Dynamic Mapping for Interface: Wage Types as Master Data
P2RF_CCRTPayroll Results: Cumulation of Contributions, Wage Types
T5F2RAFinancing line content
T5F2RFinancing line content: Clarified Payroll Slip
T5F1BCContribution base nature type code mapping
T5F1BSContribution basis type code by application
T5F1BATCommercial designation of insurance contract
T5F1BNTContribution basis type code
T5FN4DSPDFParameter setting table to upload AER file (.pdf) in SAP
T77TNM_CCTCost Category Text
T77TNM_TETraining Employee Group
T5FPASCATEGETDS: wage type text category
T5FPRMODIdentity table remuneration periodicity modifier
T77TNM_C0TParameter description
T5FN4DS109S40G2000
T5F4LPCS supplement
P2RF_SARPayroll Results: Garnishment
T5FCTPPension: Pension contract population type
T5FN4DSCN4DS implementing classes
T5FCPOPension: Pension contract option.
T5FN4DS009S40G2000
T5F6EFree Format 409 Incident Codes
T77TNM_CGTCost Category Group Text
T77TNM_CACost Attributes
T5F6ATEDC VR
T77TNM_CCCost Category
T77TNMFR_TYTNM/France: mapping table form. type/legal type
T5FDSNSECVIDSN: Section to hide from end-user
T5FN4DS001RT
T5F2RCSpecial grouping rule
T5FDSNPERPAYMAPDSN, frequency matching by OPSID
T5F3IApproval no. for statements
T5FDSNOPSPYMAOPS: Payment attributes
T77TNM_CLTNM: class reference - table type S
T5FDSN_PP_CONSOLPayments process, grouping rule for blocks 20
T5F63Dynamic Mapping for Interface: Interfaced Wage Types
T5FDSN_PP_SETUPDSN: Snapshot Customizing Finalize Payments
T77TNM_QUTNM: quota customizing table
T5F3ITText of approval no. for statements
T5FADR_GRPAssignment of addresses to groups (legal reporting)
T5FDSNRETAXTemp table for PAYFR_RESULT-RETAX
T5FDSNDEFLTDSN Default value for fields for modif. blocks
T5FDSNCPPTemp table for PAYFR_RESULT-CPP
T5FDSNCKDEFTDSN: check definition (text table)
T5FDSNENUMCDSN - Values for enumerations (OBSOLETE, use T5FDSNENUM)
T77TNM_FATNM: factory class
HRP1687DB Table for Infotype 1687
P2RF_FDPayroll results: tax data
HRP1681DB Table for Infotype 1681
T77TNM_RSTAbsence Reason
T5F4LIPCS supplement
P2RF_AB_FRPayroll results: absences France
T77TNMFR_TETNM: 2483, mapping table "Tr. Emp. Grp" to category 2483
T77TNM_OGTTable Training Objective Group Text
T5FDSNOPSTYDefinition of types of OPS (Social Protection Agencies)
T5FDSNACTITemp table for PAYFR_RESULT-ACTI
T5F1BMContribution basis type code mapping
T5FDSNFTYPEDSN - Field data type mapping
T77TNM_FCTraining Fund Category
T5F1OContribution attribute modifiers
T5FDSNCOTIS2DSN: contributions parameter setting
T5F5RTDADS-U check: ALV text nodes
T77TNM_STTable Training Needs Status
T77TNM_CGCost Category Group
T77TNM_CCLTNM: class reference - table type C
T77TNM_VATNM: store ref. of class used for val. process (syst. table)
T77TNM_C0Valid parameter names
T5F6NNCommunication of Error Messages (ADP Interface)?
T5F67Interface: Link PAC Payroll Area
T77TNM_PCTTraining Plan category: Text Table
HRPAD940Additional data PAD940
T5F1BARAttributes of the contribution assessment bases
T5F9ANTReference of pension fund contract: time dependencies
T5FDSNFMAPCValidation of differences for change blocks (client)
T5F1BNContribution basis type code
T5FN4DS105S40
T5FDA2TText for DADS-U codes
T77TNMFR_LRTNM: 2483, legal typologies mapping table
T5FCP1PPension: SIRET number and pension contract
P2RF_REMPayroll results: remunerations
T5FDSNPAYMTemp table for PAYFR_RESULT-PAYM
T5FDSNTDCPSETeCATT TDC Parameter Sets
T77TNMFR_CACost items attributes
T5FDSNREMTemp table for PAYFR_RESULT-REM
T77TNM_TYFCMTraining type / Training Fund Category: mapping table
T5F7BInsurance contribution modifier
T5FDSN_PP_B2ADSN: Postprocessing B2A data
T5F49RSpecific payroll period attributes (France)
T5FDSNTHERATemp table for PAYFR_RESULT-THERA
T77TNM_OBTTable Training Objective Text
T5FDSNPARALLELDSN: Files of DSN
T5FN4DSN4DS SAP implementing classes
T77TNM_TYTraining type
T5FDSNCOTICAdjustment of contributions at SIRET level
T5FN4DS006S40G1000
T77TNM_S0TNM settings table
T5F1AFTText for organizations
T5FDSNCKDEFDSN: check definition
T5FDSNCODEFTDSN: definition of conditions (text table)
T5F5RDADS-U check: Hierarchy and attributes of ALV nodes
T77TNM_RETable Training Needs Status Reason
T5FN4DS106S40G1000
T5FDSNMSGLEVELLevel of message detail
T5FPRRemuneration periodicity
T5FCPPPension: Pension contract population.
T5FDSNENUMTDSN - Values for enumerations
T5FDSNDDEFCDSN - Data definitions (OBSOLETE, use T5FDSNDDEF)
T5F6BDynamic Mapping for Interface: DDIC ADP (309FF)
T5FDSNB2AACTB2A Action - Transaction Mapping
T5FDSNDDEFDSN - Data definitions
T77TNM_TETTraining Employee Group Text
T5FN4DS003Totals Groups
T5FDSNFISCALSTax liability periods (SAP area)
HRPAD941Additional data PAD941
T5F6PTable for Communication and Language of Services
T5F1P_FISCALWorkplaces with tax NIC
T5FDSNMSGLEVEL_CLevel of message detail
T5FDA2DADSU codes groups
T5FDSNCOTISDSN: contributions parameter setting
T77TNM_OBTable Training Objective
T5F4LTPCS supplement
HRT1691Table Part Infotype 1691
T77TNM_DETNM: deduction customizing table
P2RF_FMDPayroll results: Master data
T5FPRMODTShort text of remuneration periodicity modifier
T5F9ANReference of pension fund contract: time dependencies
T5FDSN_COUMQ_DUMDummy control table (allows search help to be called /PMEF5)
PA0435HR Master Record for Infotype 0435
T5FDSN_GEN_HDRDSN: Header of generated sections
T5F1BAContribution attributes for insurance companies
T5F2RCTText for rule
PA0436HR Master Record for Infotype 0436
T5FDSNENUMDSN - Values for enumerations
T5FDSNFPERSTemp table for PAYFR_RESULT-FPERS
T5FDSNPNPSELTable for extended personnel number selection in DSN
HRP1691DB Table for Infotype 1691
P2RF_PSPPPersonal Work Schedule (Table PSP)
T5FN4DS107S40G1005
T5FDSNFOLLOWUPTDSN: Text for follow-up mapping between steps GIP and SAP
T5FDSNOPSIDList of OPS (Social Protection Agencies)
T5FDSN_PP_FOLLOWDSN: Postprocessing SECTION DATA snapshot
T5FDSNFOLLOWUPDSN: It contains the list of the GIP steps
T77TNM_RSAbsence Reason
T5FDSNRELFLDDSN Released DAQ Fields
T5F1BASAttributes of policies with insurance companies
T5F6NGlobal Error Messages
PA3403Infotype 3403
T5F9AReference of the pension fund contract
T5F5R1DADS-U check: Additional fields (nodes)
T5FDSNMTOMADSN: MTOM List Web Service
T5F1BAPAttributes of pension contracts with pension companies
T5FPASCATEGEDS: category
P2RF_PAYMPayroll results: payments
T5FDSNCODEFDSN: definition of conditions
T5FDATSTRSnapshot of Table PB2ADATSTR
P2RF_ZLPTime wage types (ZL table)
T5F1C10Modifier for calculation parameters
T5FRPTCLASSDS Reporting: reference classes
T5FWGPayroll - Wage type groupes - Attributes
T5FDSNPADEFTDescription of DSN parameters
T5FDSNBADI_FIELDDSN: authorized fields for BAdI
T5F6JList of Individual Transfers
T5FN4DS004S30
T5F2RTFinancing line text
T5F1BDTWage type text contribution basis type code
T5FDSNSTATORDERDSN: It contains the list of the statuses and their order
T5FPASBAREMEDS: Scale
T5FDSNREMMAPCMapping table for pay type
T77TNM_HITraining history customizing table
T5F1C10TCalculation parameters for contribution via function module
T5FDSN_COAGI_DUMDummy control table (allows search help to be called)
T5FDSNCANCELDSN: List of generated blocks to ignore for a cancelled DSN
T5FDSNENUMTCDSN - Values for enumerations (OBSOLETE, use T5FDSNENUMT)
T5F6HList of Employer Banks
T5FDSNCTTemp table for PAYFR_RESULT-CT
T5FPYCLASSPY: reference classes
P2RF_ACTIPayroll results: activities
T5F2LAbsence categories / associated parameter
HRP1680DB Table for Infotype 1680
HRT1683Table Part Infotype 1683
HRP1684DB Table for Infotype 1684
T5F68TEDC TDT
T5FDSN_PP_SECTNDSN: Postprocessing SECTION DATA snapshot
P2RF_CTT_ENDPayroll results: end of contracts
P2RF_RECOTPayroll Results: Cumulation of Contributions
T77TNM_ABTNM: absence records table
T5FDSNCUMCOCumulated declared contributions table
T5FN4DS101RT
T5F6KSend Table (TDE)
T5FDSNPAVALDSN parameters table
T5F9ATWage type texts for personnel groupings insurance policies
T5FDSNCTT_ENDTemp table for PAYFR_RESULT-CTT_END
T77TNM_TYTTraining type text
T5F7APersonnel grouping for insurance policies
T5FDSNAB_FRTemp table for PAYFR_RESULT-AB_FR
HRT1684Table Part Infotype 1684
T5F6CITF TEDC Funds Code
T5F64Coding Table Interface
T77TNMFR_FSForms: Sections
T5F1BSTWage type text contribution basis type code
T5FDSNFCOTISDefinition of input source for contribution indicators
T5FCPAPension: Pension contract attributes.
T5FDSN_PREDMELOGLog for Pre-DME
T5FN4DS002S20
T5F60Dynamic Mapping for Interface: Infotypes
T5FDSNOPSPAYINFOInfos about payments via SIRET/OPS type
T5F8ATWage type texts for personnel groupings insurance policies
T5FADRCreate contacts
T5FDSNFDTemp table for PAYFR_RESULT-FD
T5F1AFOfficial organization codes
HRP1690DB Table for Infotype 1690
T5FDSNFILES_V2DSN: Files of DSN
T5F1C9Calculation parameters for contribution via function module
T5FDSNCONDICDSN: Definitions of conditions - Customer
HRP1685BD table for infotype 1685
T5F1P_OPSList of OPSs by SIREN/SIRET
T5FDSNTDCPSECTNAssignment of DAQ section to parameter set
T5F8APersonnel grouping for pension contracts
T5FDSNXMLPATHDSN: XML parser path for the response XML of GIP
T5FN4DS108S40G1010
T77TNM_IVCompensation Indirect Valuation
T5FDSNCONDIDSN: Definitions of conditions
T5FDSNSECTNDSN: reference classes for section
T5FDSNSTRUCDSN: reference structures
T5FDSNCHECKSUMDSN: field list to take into account in checksum
T5FDSNFISCALTax liability periods (client area)
T5FWGMODIdentity table wage type group modifier
T5FDSNCLASS_FPDSN: reference classes
T77TNM_TACTNM: table to handle tabstrip naming (custo)
P2RF_WPEPayroll results; additional WPBP data
T5F1BDContribution basis type code by application
T5F61Dynamic Mapping for Interface: Clusters.
T5FDSNCODCODefinition of contribution indicators
T77TNM_VACTNM: store ref. of class used for val. process (custo table)
T5F1OTWage type texts for contribution attribute modifiers
T5F4E1DDTEPP address
T5FSCPAPension: Enrollment contract attributes
T5FWGMODTTexts for wage type group modifiers
T5FPAYFRF0Additional "French related" attributes of a DAQ form
T5FDSNDIVALDSN, validation of differences for change blocks
T77TNM_PCTraining Plan Category
T5F6MReturns Table (TDR)
T77TNMFR_FCTNM/France: mapping table form. type/legal type
T5FDSNFILESObsolete - DSN: Files of DSN
T5FDSNPADEFName of DSN parameters
T5FN4DS007S40G1005
T77TNM_FCTTraining Fund Category: text table
T5FDSNCLASSDSN: reference classes
T5FDSNFMAPSDSN, validation of differences for change blocks
T5FDSN_PP_DECLDSN: Postprocessing DECLaration snapshot
HRP1686DB Table for Infotype 1686
T5F6TADP Interface Text Table for PAC
T5FDSN_GEN_SECTNDSN: Generated sections
T5FN4DS005S40
P2RF_THERAPayroll results: therapy part time
T5FDSNMTOMCDSN: MTOM Dynamic Web Service settings
T5F1G2Resume contribution basis
T5FDSNVALPATHSDSN: Contains the end-user paths for local DSN_VAL
T77TNM_LRTTraining Legal Reference (text table)
P2RF_CPENSupplementary Retirement Plan
T5FDSNFILE_ORDERDSN: Define the order to process response file of the GIP
T77TNM_STTTable Training Needs Status Text
T5FDSNCHECKDSN: Definitions of conditions
T5F5R2DADS-U check: Origin of ALV data nodes
T5FDSNCPENTemp table for PAYFR_RESULT-CPEN
T5FN4DS000N4DS IDs result
T5FDSNCODCNDefinition of contributions
T5FDA1Absence categories for DADS-U structures
T5F1VFSVAV derived wage type customizing
T5F2RBSpecial rule for sub-category
T5FDSNFTYPECDSN - Field data type mapping (OBSOLETE, use T5FDSNFTYPE)
T5FN4DS008S40G1010
T5F7ATWage type texts for personnel groupings insurance policies
T77TNM_OGTable Training Objective Group
T5F6UInterface: Link PAC Processing Type
T5F6FM-1 management of presence incidents (SAP/ADP interface)
T77TNM_LRTraining Legal Reference
T5F7BTWage type text insurance contribution modifier
HRP1682DB Table for Infotype 1682
T5FDSNSUSPENSIONTemp table for PAYFR_RESULT-SUSPENSION
T77TNM_DCTNM Decoupling Class
T5FDSNPAS_ALVALV variants for DS summary
P2RF_FPERSPayroll results: personal data
T77TNM_RETTable Training Needs Status Reason Text
P2RF_CPPPayrollResults: Personal hazardous/unpl. work prevent. accnt
T5F69TEDC DDT
T5FDSNMTOMBDSN: MTOM Authorization
T77TNM_TASTNM: table to handle tabstrip naming
HRT1680Table Part Infotype 1680
P2RF_FPWPPayroll results: add. data WPBP (PSF)
HRT1686Table Part Infotype 1686
P2RF_CTTPayroll results: contracts
T77TNM_HICTraining History
HRP1683DB Table for Infotype 1683
HRT1681Table Part Infotype 1681
P2RF_SVPayroll Result: Social Insurance (F)
T5FDSNPASTemp table for PAYFR_RESULT-PAS
T5FGRPContact group