SAP Brazil Tables

Are you looking for the right table related to SAP Brazil 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 Brazil (PA-PA-BR) module.

Top 10 tables in Brazil

TableDescription
T7BREFD_ACCIDPLCAccident location
T7BR596Application groups
T7BREFD_EVEXTTable to connect between internal and external event ID
T7BREFD_PYRCPTPayments made to the worker
T7BREFD_ERINFOEmployer identification
PA0410Infotype 0410 - Transportation ticket
T7BRDEDependents eligibility for income tax
T7BRAIInflation adjustment
T7BRE1Full description of marital status
T7BRCSContract salaries

List of tables in Brazil

TableDescription
T7BREFD_ACCIDPLCAccident location
T7BR596Application groups
T7BREFD_EVEXTTable to connect between internal and external event ID
T7BREFD_PYRCPTPayments made to the worker
T7BREFD_ERINFOEmployer identification
PA0410Infotype 0410 - Transportation ticket
T7BRDEDependents eligibility for income tax
T7BRAIInflation adjustment
T7BRE1Full description of marital status
T7BRCSContract salaries
T7BRCO4Groups for GSW fill in
T7BREFD_ERBKSHBank information
T7BRDISSIDIOBargaining
T7BRCO2Collect codes of SWG
T7BRCBBrazilian Job Occupation Code (by position)
T7BREFD_EVLNKEvent copntrol table event link
T7BR86Wage types for saving entitlement to leave reserve
T7BREFD_FINISNIS archive information
T7BREFD_ERCOINFOCompany additional information
T7BRAGHarmful agent exposure codes (FCSWI)
T7BRCO1Table for GSW assembly
T7BREFD_EPCEPIInformation on EPC and EPI
T7BREFD_ERCNTCContact of person responsible for information
T7BRECMarital status description
T7BREFD_EVBATTable containing link between batches and events of eSocial
T7BR04Definition of circumstances
T7BREFD_FGTSLOANInformation on payroll loan operation with FGTS
T7BR596WWage Types associated to application groups
T7BRCO5Compensation balance of GSW
T7BREFD_ENV_INFOInformation on work environments and risk factors
T7BREFD_ERSWHOSoftware house information
T7BRTTThird-party code description
T7BREFD_STERRStatus error
T7BREFD_ENVRESPInformation on the environmental records responsible
T7BR7CEducation
T7BR0ASplit of absence valuation periods
T7BRT0Legal rights associated with employee situation
T7BREFD_RULEPParameters for rules
T7BREFD_TYPINFTText table for information types
T7BRCITYMunicipality code by postal code interval
T7BR96Severance pay code: texts from T7BR95
PA0398Infotype 0016 - Corporation and contract agreements
T7BREFD_ENVCODEWork environment information
PA0661Termination: general data
T7BREFD_HELPLANCNPJ of health plan provider
T7BR4CWage types for leave valuation
T7BREFD_SUSPINFPayout suspension information on taxes and FGTS
T7BREFD_WRKENVWork environment information
T7BR7USchool grade description
T7BRNANationality codes
T7BRCO3Collect codes of GSW due to retroactive accounting reason
T7BR20Brazilian Job Occupation Code
T7BREFD_RPLCOPReplacement information regarding port operators
T7BREFD_LAWYERLawyer identification
T7BREFD_RKDTSSTAEnvironm.working conditions that originate retirem.- Beginn
T7BREFD_LEGALFEEDetail of lawsuit fees
T7BREFD_RKDTSCHGEnvironm.working conditions that originate retirem.- Change
T7BRMPEmployment relationship
T7BREFD_RPPSPublic agency - Special Social Welfare Policy
T7BRTHThird-party code
T7BREFD_RUMKTInformation on the establishment that traded the production
PA0625Infotype 0002 - Race/complexion
T7BR1BUnion
T7BRS1Child allowance eligibility of subtypes of IT21
T7BREFD_VACPAYDetail of payments made regading the vacation.
T7BR0FThird-party payment assignment
T7BREFD_EEWSCHWorkday
T7BRCTWorker categories description (FCSWI)
T7BREFD_LAWCOINFAdditional information of legal decisions
T7BRT2Transportation type
T7BRD0Transfer of payroll external results: PRS
T7BRB4Branch - Withholding Income Tax Declaration
T7BRANCH_ATTRBranch/construction site and HR attributes
PA0734HR master record infotype 0734
T7BREFD_PYGARPayments made to alimony beneficiaries
PA0737Alimony debit for Brazil
T7BRABAdditional information for absences
T7BREFD_WTSUITAdministrative process or lawsuit related to a wage type
T7BR7BSchool grade
T7BRASIAI percentage for special retirement
PA0397Infotype 0021 Family
T7BRB8SEFIP: other informations per site
T7BREFD_REINTReintegration information
T7BR05Text table of circumstances
T7BRERCONTACTCompany contact table
T7BREFD_FEDLIMFederative person compensation limits
T7BREFD_ABSMEDCAdditional information regarding medical certificate
T7BREFD_MEDEXAMOccupational medical examination information
PA0465HR master record infotype 0465
PB0734HR master record infotype 0734
T7BREFD_NRESIPAYPayment to non-resident or resident abroad
T7BRDRWithholding Income Tax Declaration withholding code
T7BREFD_RISKDATEInformation on work environments and risk factors
T7BR7TEducation description
T7BREFD_EPCCollective protection equipments - EPC
PA0736Alimony order for Brazil
PB0695HR Master record infotype 0695
T7BRB7SEFIP: revenue Sports Event/ Sponsored Subscription
T7BREFD_PYPARTComp.information regarding the partial made payment
T7BRAEEconomic activity
T7BREFD_WTYPEWage type information
PA0437Multiple employment (BR)
T7BRB6Branch - Employee tab page no.
T7BRCXWorker categories (FCSWI)
T7BR596TApplication group texts
T7BR03Relate wage types to old results
T7BRSAMovement code for FGTS withdrawal
T7BRC1Construction site information
T7BREFD_STLOGEvent status log
T7BREFD_ABSRECTTemporary absence correction information
T7BREFD_PAYRESCDetails on payments made regarding terminations
T7BRB1Branch - general information
T7BR_DOCUMENTSTable to store XML sent to the government
T7BREFD_RURALACQAcquisition of rural production information
T7BREFD_RURLWRKRRural producer information
T7BRCITY_TEXTText table for Brazilian municipality code
T7BRCO6Field values of GSW (FCSWI)
T7BR02Additional information for absence and quota generation
T7BREFD_EVENTEvents
T7BREFD_PYPAYINFDetails on payments made regarding payroll
PA0738Alimony adjustment for Brazil
T7BR07Parameters Responsible branch - SEFIP
T7BRC0Construction site code
T7BREFD_PYAGREIdentification of agreement/convention/bargaining
T7BREFD_EROINFOther employer information
T7BRTPTransportation ticket description
T7BRAPBranches and/or construction sites grouping
T7BREFD_EVTOGENControl table of events to be generated
T7BRATEconomic activity description
T7BREFD_RULAWLawsuit of rural producer
T7BRPZWage types for planned period
T7BREFD_PYBENINFDetail of payments regarding Welfare benefits
T7BREFD_RKDTHSTAEnvironmental working conditions - Beginn
T7BRISSIB table
T7BR01Losing leave entitlement: rules
PA0695HR Master record infotype 0695
T7BREFD_INFRRAAdditional information - income received cumulatively
T7BRCONVRULEValue conversion
T7BREFD_EETRFRWorker transfer information group
T7BREFD_EPIIndividual protection equipment
T7BREFD_ADMLAWSTAdministrative lawsuit information
T7BREFD_HAZCATRisk factors
T7BREFD_CPFCHGCPF change information group
T7BREFD_EELVNTEmployee leave notice
T7BRG4Calculation unit for alimony
T7BREFD_PORTOPPort operator information
T7BREFD_PYWTAMWage types that form the employee remuneration
T7BREFD_EESVNCInformation group of employment relationship succession
T7BREFD_ALQFENFederative person factoring information
PB0398Infotype 0016 - Corporation and contract agreements
T7BRX2Retrocalculation areas/Incoming wage types
T7BREFD_RKDTHENDEnvironmental working conditions - End
T7BREFD_PYREMEmployee remuneration information
T7BREFD_BENRACTBenefit reactivation information
T7BREFD_BENEFRYBeneficiary information group
PB0465HR master record infotype 0465
T7BRT3Transportation type description
T7BREFD_RKDTSENDEnvironm.working conditions that originate retirem.- End
T7BRWTAssignment of wage types for absence in double
T7BREFD_EEPENSNInformation on provider of survivor`s pension
T7BR90Rules for calculation of severance pay
T7BREFD_PSPYWTAMWage types that form the employee remuneration
T7BR06Parameters Responsible branch - SIAL
T7BREFD_TYPINFInformation type
T7BREFD_EETEMPWorker on temporary loan
T7BREFD_RULETRule text table for event
T7BRPPWage types for planned period
T7BREFD_BENEFPayment beneficiary identification.
T7BREFD_ASOOccupational health certificate
PB0625Infotype 0002 - Race/complexion
T7BREFD_ININFOTrainee exclusive information
T7BRDTWithholding Income Tax Decl.withholding code description
T7BRQTAbsence quota type
T7BRSBExclusion of movement code for FGTS withdrawal
T7BREFD_PYPREPERInforms remuneration differences from previous period
T7BREFD_CATVICTDetail of the victims of the work accident
T7BREFD_UNIONDUEInformation on the employer union dues
T7BREFD_TRAINERProfessional responsible for training
T7BREFD_STBATTable for change log in the batch
T7BREFD_EEFWSCWorkday in fixed shifts information
T7BRTXWIT table
T7BREFD_EVDELEvent exclusion
T7BR9ADiscount percentage on third-party payment
T7BRFTSAWF code description
T7BREFD_PAYINFOInformation on the payments made
T7BREFD_PYCLOSEInformation on closing of periodic events
T7BREFD_WTLAWSProcesses - Obsolete table - See T7BREFD_WTSUIT
T7BREFD_PAYEXTAddit.info regarding payment made to beneficiary abroad
T7BREFD_EEBANKEmployee bank details
T7BREFD_EETERMTermination
T7BREFD_EEOINFOther information of employee
T7BR_UNINTRTrailer record - unemployment insurance
T7BREFD_BENDEPBeneficiary dependents
T7BR0PPersonnel areas assignment to branches/c.sites groups
T7BREFD_NDOCKRemuneration of temporary workers, non dockworkers
T7BREFD_EREXEMAdditional information - Exempted companies - Exemption data
T7BRSSSS Relation between value type (BRSOC) and wage type
T7BRB3Branch, SIAL report
T7BREFD_WRKSCHWorkday information
T7BR98Employee grouping for calculation of severance pay
T7BRNTDescription of establishment legal nature
T7BREFDMEVENTTText for code mapping for EFD
T7BREFD_EEASOOccupational health certificate
T7BRCPWage type assignment for absence double compensation
T7BREFD_EXMPINCExempt/non-taxable income
T7BREFD_PYREVNPayroll additional information
T7BREFD_DUMMYNODTable for recursive node control
T7BRAXDescription of harmful agent exposure codes (FCSWI)
T7BREFDMEVENTSCode mapping for EFD
T7BRC2Company - General information
T7BRB2Branch - Social insurance body
T7BREFD_EEEDMPDismissal protection end
T7BREFD_BRANCHBranches/construction sites table
T7BREFD_EVTYPETEvent type text table
T7BREFD_PAYBPFBeneficiary natural person - resident in Brazil
T7BREFD_BENONRESData of beneficiary non-resident or resident abroad
T7BRMTDescription of employment relationship
T7BREFD_TRAININGTranings and simulated training
T7BREFD_RULEDTText table for rule conditions
T7BREFD_BENINFOBeneficiary and income identification
T7BREFD_ERFGTSExclusive information for FGTS
T7BREFD_INTWRKIntermittent work convocation information
T7BREFD_LAWSTRDInformation on the existence of lawsuits
T7BREFD_EEEWSCSpecial workday information
T7BREFD_ASOMONBiological monitoring result
T7BREFD_DRUGTESTInformation on drug testing for professional drivers
T7BREFD_EVTYPEEvent types
T7BREFD_PREMREGInformation on the employee preliminary record
T7BREFD_BATCHBatch table of the eSocial
T7BREFD_BATERError/warning messages contained in batch
T7BREFD_JOBJob information
T7BREFD_HAZINFORisk factors
T7BRRAEmployee's movement code to SIAL
T7BREFD_EEUNIONWorker trade union membership
T7BRSISIB table
T7BREFD_EVTY_CEvent types
T7BRUNIONDUEInformation on the employer union dues
T7BREFD_RULEDRule condition for event
T7BREFD_LEGCOMPInformation regarding legal compensation
T7BRTMPunch clock codes
T7BREFD_CATCERTMedical certificate
T7BREFD_EEDWSCRegular workday information
T7BREFD_EERSNCChange to absence reason
T7BREFD_EEFACTRelevant fact statement
T7BREFD_HAZINFEnvironmental risk factors
T7BREFD_EEGARPayments made to alimony beneficiaries
T7BREFD_EEADDREmployee address
T7BREFD_EELINFEmployee legal information
T7BREFD_ITEVTRIGFields of infotypes relevant for event generation
T7BREFD_CATCAUSEWork accident causer detail
T7BREFD_EEFORForeign employee
T7BREFD_EEEODSUnion leader source company
T7BREFD_PYREOTRemuneration other company codes
T7BRESSchools
T7BREFD_NFSInvoice details
T7BREFD_EEWDAYContract schedule
T7BRX0Table for Labor Debits Update
T7BREFD_EECNTREmployment information
T7BRRTDescription of movement code to SIAL
T7BRQCQuota compensation types
T7BREFD_CODATIVWork environment information (obsolete)
T7BREFD_EERABSEmployee temporary absence return
T7BRTAXWRKAREAPersonnel area/subarea and tax workplaces
T7BREFD_CAT_INFOCommunication of work accident
T7BREFD_RESMONBiological monitoring manager data
T7BREFD_DDLINETTexts of rule names
T7BREFD_PYCMPLPayroll additional information
T7BREFD_PYPAYWage types that form employee remuneration
T7BREFD_PYRESCInformation regarding harmfAgent and simplesInfo
T7BREFD_CATADDRSAccident location
T7BREFD_PAYBPJFramework table control
T7BREFD_TEMPWRKInfomation regarding temporary worker's remuneration
T7BREFD_EECNTRPSStatutory worker information
T7BREFD_EERISKHarmful agents
T7BREFD_WRKPLCWorkplace information
T7BRFMEmployee movement code for FGTS
T7BRNJLegal nature of establishment
T7BREFD_NTPRCACancellation of notice period
T7BREFD_DTCTRLCurrent and previous validity
T7BRTFDescription of FGTS movement code
T7BREFD_MSGSPossible messages in batches/events
T7BREFD_EEPACTPerformed activity
T7BRTAUnion dues
T7BREFD_PREVINFPayment detail
T7BREFD_RKDTHCHGEnvironmental working conditions - Change
T7BREFD_PYINFOPayroll additional information
T7BREFD_DNOD1300Dependents control of the eSocial framework 1300 - PAY
T7BRSFChild allowance
T7BREFD_DETDEDUCDetail of deductions
T7BREFD_ORGEDUCEducational entity
T7BREFD_PREVPAYPayment regarding prev.comp.at the eSocial start
T7BREFD_PSCAREERPayout suspension information on taxes and FGTS
T7BREFD_BENSUCNBenefit transfer information group
T7BREFD_COMPLINFAdditional information to periodic events
T7BRTRTransportation ticket
T7BREFD_EEWRKPEmployee place of work
T7BREFD_CESSIONInformation regarding assignment/exercise in another body
T7BREFD_BCPFCHGCPF change information group
T7BREFD_EEDEPDependents
T7BREFD_NOTPERNotice
T7BREFD_EELOANLoaned employee information
T7BREFD_EEWERTInfo termination employee with no employment relationship
T7BREFD_NIDENPAYPayments to unidentified beneficiaries
T7BREFD_EEABSEmployee temporary absence
T7BRX1Labor Debits
T7BR_UNINHEHeader record - unemployment insurance
T7BREFD_EECNTCEmployee contact information
T7BREFD_PYBENEFInformation on paymento to beneficiary public sector
T7BREFD_EECOMPEmployee identification additional information
T7BREFD_CLOSEPayment closing regarding companies
T7BREFD_PYPERperiod to which the remuneration differences refer to
T7BREFD_NOTESComments
T7BREFD_PYTOTTotaling of worker's remuneration
T7BREFD_EELAWSLawsuit of the employee
T7BREFD_BENCESSInformation regarding the benefit termination
T7BRSTDescription of movement code for FGTS withdrawal
T7BRRKHazard and health risk grouping
T7BREFD_EEIDPYWorker identification
T7BREFD_EEVWSCRelief shift workday information
T7BREFD_BENDATAData related to the benefit.
T7BREFD_RULERules for events
T7BRPM0Table of penalty and interest percentages
T7BRGRSIB table - Self-employed
T7BRG4TDescription of calculation unit for alimony
T7BREFD_BREAKTWork day breaks
T7BREFD_EESDMPDismissal protection start
T7BREFD_BENSUSPInformation regarding benefit suspension
T7BRFPSAWF code
T7BR_UNINEEApplication record - unemployment insurance
T7BRTAXWRKPLCTax workplaces
T7BREFD_ROLERole identification information
T7BREFD_EESUBSTReplaced worker identification
T7BREFD_DEPPLANDependent of health care private plan
T7BREFD_DETCOMDetail of competences to which the payment refers
T7BREFD_PYWPLEstablishment identification and workplace
T7BREFD_EEEXAMTests done
T7BREFD_EEDOCSEmployee identification documents
T7BREFD_DDLINEEvent deadline calculation rules
T7BREFD_CONFIGSystem configurations for eSocial
T7BREFD_EEINFOEmployee information
T7BREFD_EEDISAChallenged employee
T7BREFD_CATCommunication of work accident
T7BREFD_EEORESCondominium information
T7BREFD_DOCLNKDocument links for the eSocial