- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Business Accounting (FIN-BAC)
- Business Analytics (FIN-BA)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Corporate Governance (FIN-CGV)
- Financial Shared Service Center (FIN-SSC)
- Financial Supply Chain Management (FIN-FSCM)
- Financials Basis (FIN-FB)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Generic Contract Accounts Receivable and Payable (FI-CAX)
- Lease Accounting (FI-LA)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4H Best Practices - Content and Content Activation (FI-CNT)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Strategic Enterprise Management (FIN-SEM)
- Tax Management Framework (FIN-TMF)
- Tax Subledger (FI-TXL)
- Travel Management (FI-TV)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
/TMF/HDSNTRAB
eSocial - Vinculo de trabalho - Staging
|
#transactional
|
Component: Tax Management Framework
- 🔑 Keys (3)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (25)
- ☰ Categorical (36)
- Other (85)
- 🔗 Relations (1)
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| ID_EVENTO | Event ID | |
| RECORD_ID | Record ID |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| DT_NASCTO | Date of birth | |
| DT_EXPED_RIC | RIC: dispatch date | |
| DT_EXPED_RG | RG: dispatch date | |
| DT_EXPED_RNE | RNE: dispatch date | |
| DT_EXPED_OC | OC: dispatch date | |
| DT_VALID_OC | OC: validity date | |
| DT_EXPED_CNH | CNH: dispatch date | |
| DT_VALID_CNH | CNH: validity date | |
| DT_PRI_HAB | CNH: first license date | |
| DT_CHEGADA | Arrival date | |
| DT_ADM | Admission date | |
| DT_OPC_FGTS | Option date by FGTS | |
| DT_NOMEACAO | Nomination date | |
| DT_POSSE | Possession date | |
| DT_EXERCICIO | Entry activity date by server | |
| DT_INGR_CARR | Date of carreer admission | |
| DT_TERM | End date of the employment contract | |
| DT_INI_VINCULO | Employment relationship start date (previous employment) | |
| DT_ALTERACAO | Change date | |
| DT_ASO_ADM | null | |
| DT_INI_AFAST | Absence start date | |
| DT_DESLIG | Move-out date | |
| DT_EF | Effective date of law | |
| DT_TRANSF | Date of transfer | |
| DT_TRANSF_TD | TD: Date of transfer Domestic |
| Column Name | Description | |
|---|---|---|
| RACA_COR | Raça e Cor do Trabalhador | Show values |
| EST_CIV | Marital status | Show values |
| GRAU_INSTR | Education degree | Show values |
| IND_PRI_EMPR | Indicador de Primeiro Emprego | Show values |
| CATEGORIA_CNH | CNH category | Show values |
| CLASS_TRAB_ESTRANG | Classification of foreign employee condition in Brazil | Show values |
| CASADO_BR | Brazilian spouse | Show values |
| FILHOS_BR | Brazilian children | Show values |
| DEF_FISICA | Physical disability indicator | Show values |
| DEF_VISUAL | Visual disability indicator | Show values |
| DEF_AUDITIVA | Auditory disability indicator | Show values |
| DEF_MENTAL | Mental disability indicator | Show values |
| DEF_INTELECTUAL | Intellectual disability indicator | Show values |
| REAB_READAP | Indicador de Reabilitação | Show values |
| INFO_COTA | Quota for licensed disabled people or beneficiaries | Show values |
| TP_REG_TRAB | Tipo de Regime Trabalhista | Show values |
| TP_REG_PREV | Tipo de Regime Previdenciário | Show values |
| TP_ADMISSAO | Tipo de Admissão | Show values |
| IND_ADMISSAO | Admission indicative | Show values |
| TP_REG_JOR | Identifica o regime de jornada do empregado | Show values |
| NAT_ATIVIDADE | Natureza da atividade | Show values |
| OPC_FGTS | Opção pelo FGTS | Show values |
| HIP_LEG | Legal hypothesis for hiring temporary employee | Show values |
| TP_INCL_CONTR | Inclusion contract type | Show values |
| TP_INSC_TOMADOR | Tipo Inscrição do tomador de serviços temporário | Show values |
| TP_INSC_ESTAB_VINC | Registration type of contractor services | Show values |
| TP_INSC_APREN | Registration type of apprendice employer | Show values |
| IND_PROVIM | Indicador de Provimento | Show values |
| TP_PROV | Tipo de Provimento | Show values |
| TP_PLAN_RP | Plan type of separation of mass of people | Show values |
| UND_SAL_FIXO | Unidade de pagamento da parte fixa da remuneração | Show values |
| TP_CONTR | Tipo de Contrato de Trabalho | Show values |
| TP_INSC_TRAB | Tipo de inscrição (Local de Trabalho) | Show values |
| TP_JORNADA | Tipo da Jornada | Show values |
| TMP_PARC | Half-time employment contract | Show values |
| MTV_ALTER | Reason for changing position or function | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| NM_TRAB | Nome do Trabalhador | CHAR70 | |
| SEXO | Sexo | CHAR01 | |
| NM_SOC | Social name for transsexual person | CHAR70 | |
| COD_MUNIC_NASCTO | Code of the birth municipality | /TMF/H_COD_MUNICIPIO | |
| UF_NASCTO | UF do Nascimento | /TMF/H_UF | |
| PAIS_NASCTO | PaÃs de Nascimento | CHAR03 | |
| PAIS_NAC | PaÃs de Nacionalidade | CHAR03 | |
| NM_MAE | Nome da Mãe | ||
| NM_PAI | Nome do Pai | ||
| NR_CTPS | CTPS: No.carteira de trabalho e Previdência Social trabalho | CHAR11 | |
| SERIE_CTPS | CTPS: Serie | CHAR5 | |
| UF_CTPS | CTPS: Estado | CHAR2 | |
| NR_RIC | RIC: Número do Documento Nacional de Identidade - DNI. | CHAR14 | |
| ORGAO_EMISSOR_RIC | RIC: Órgão e UF de emissão | CHAR20 | |
| NR_RG | RG: Número do RG | CHAR14 | |
| ORGAO_EMISSOR_RG | RG: Órgão e UF de emissão | CHAR20 | |
| NR_RNE | RNE: Número no Registro Nacional de Estrangeiros | CHAR14 | |
| ORGAO_EMISSOR_RNE | RNE: Órgão e UF de emissão | CHAR20 | |
| NR_OC | OC: Número de Inscr. na Organização de Classe | CHAR14 | |
| ORGAO_EMISSOR_OC | OC: Órgão e UF de emissão | CHAR20 | |
| NR_REG_CNH | CNH: Número da Carteira Nacional de Habilitação | CHAR12 | |
| UF_CNH | CNH: Estado | CHAR2 | |
| TP_LOGRAD | Tipo de Logradouro | CHAR04 | |
| DSC_LOGRAD | Address description | CHAR80 | |
| NR_LOGRAD | Número do logradouro | CHAR10 | |
| COMPLEMENTO | Address complement | CHAR30 | |
| BAIRRO | District | CHAR60 | |
| CEP | Postal code | CHAR08 | |
| COD_MUNIC | Code of the federative entities municipality | CHAR07 | |
| UF | Estado | /TMF/H_UF | |
| PAIS_RESID | Código do paÃs de residência | CHAR03 | |
| NM_CID | Nome da Cidade | CHAR50 | |
| COD_POSTAL | Postal code | CHAR12 | |
| OBS_DEFICIENCIA | Observação sobre Deficiência | CHAR255 | |
| TRAB_APOSENT | Indicador de Aposentadoria do Trabalhador | CHAR01 | |
| FONE_PRINC | Telephone number | CHAR13 | |
| FONE_ALTERNAT | Alternative telephone number | CHAR13 | |
| EMAIL_PRINC | CHAR60 | ||
| EMAIL_ALTERNAT | Email (alternative) | CHAR60 | |
| MATRICULA | null | ||
| NR_REC_INF_PRELIM | Número do recibo Admissão | CHAR40 | |
| DT_BASE | Base date | CHAR2 | |
| CNPJ_SIND_CATEG_PROF | CNPJ of the representative union of the category | CHAR14 | |
| MTV_CONTRAT | null | ||
| JUST_CONTR | Legal hypothesis for hiring temporary employee description | ||
| NR_INSC_TOMADOR | Número Inscrição do Tomador de Serviço temporário | CHAR15 | |
| NR_INSC_ESTAB_VINC | Registration number of contractor services | CHAR15 | |
| NR_INSC_APREN | Registration number of apprendice employer | CHAR15 | |
| CPF_TRAB_SUBST | null | ||
| MATRIC_TRAB_SUBST | null | ||
| NR_PROC_JUD_EST | Número do processo judicial | /TMF/H_NR_PROCESSO | |
| COD_CARGO | Job code | CHAR30 | |
| COD_FUNCAO | Role code | CHAR30 | |
| COD_CATEG | Category code | /TMF/H_COD_CATEG | |
| COD_CARREIRA | Carreer code | ||
| VR_SAL_FX | Salário base do trabalhador, correspondente à parte fixa | /TMF/H_VALOR | |
| DSC_SAL_VAR | Variable salary description | CHAR255 | |
| NR_INSC_TRAB | Número de Inscrição do Local de Trabalho | CHAR15 | |
| DESC_COMP | Workplace complementary description | CHAR80 | |
| TP_LOGRAD_TRAB | Tipo de Logradouro (Local de Trabalho) | CHAR04 | |
| DSC_LOGRAD_TRAB | Address (Workplace) | CHAR80 | |
| NR_LOGRAD_TRAB | Número do logradouro (Local de Trabalho) | CHAR10 | |
| COMPLEMENTO_TRAB | Address complement (workplace) | CHAR30 | |
| BAIRRO_TRAB | District (Workplace) | CHAR60 | |
| CEP_TRAB | Post code (Workplace) | CHAR08 | |
| COD_MUNIC_TRAB | Code of the Federative Entities Municipality (Workplace) | CHAR07 | |
| UF_TRAB | Estado (Local de Trabalho) | /TMF/H_UF_TRAB | |
| QTD_HRS_SEM | Quantidade média de horas relativas à jornada semanal do | /TMF/H_QTD_HRS_SEM | |
| DSC_TP_JORN | Journey type description | ||
| CNPJ_SIND_TRAB | null | ||
| NR_PROC_JUD | Número do processo judicial | /TMF/H_NR_PROCESSO | |
| CNPJ_EMPREG_ANT | Previous employer CPF/CNPJ | /TMF/H_CNPJ_CEI | |
| MATRIC_ANT | Matricula do trabalhador no emprego anterior | CHAR030 | |
| OBS_SUCESSAO_VINC | Observação VÃnculo empresa anterior | CHAR255 | |
| NR_CRM | null | ||
| UF_CRM | null | ||
| COD_MOT_AFAST | Temporary leave reason code | CHAR2 | |
| DSC_ALT | Change description | ||
| JUST_PRORR | Justification extension of the temporary contract | STRING | |
| CAD_INI | Event refers to initial registration or admission | CHAR1 | |
| CLAU_ASSEG | Insurance clause | CHAR1 | |
| TP_INSC_APREND | null | ||
| NR_INSC_APREND | null | ||
| CPF_SUBSTITUIDO_TD | CPF Replaced | /TMF/H_CPF | |
| MATRIC_ANT_TD | TD: Worker's Enrollment on previous employment | CHAR030 |
| Master Data Relations | Join Conditions |
|---|---|
| Client | /TMF/HDSNTRAB.MANDT == T000.MANDT |