T5FDSNCUMCO

Cumulated declared contributions table | #transactional | Component: France
Column Name Description
MANDT FK Client
PERNR FK Personnel Number
PABRJ Payroll year for determining time period
PABRP Payroll period for determining time period
WERKS FK Personnel Area
BTRTL FK Personnel Subarea
SIRET SIRET Number
NRCUM Identification number of the contributions cumulation
FPBEG Start date of payroll period (FOR period)
SECTN FK Forms: Section
CCOID FK Identifier of a contribution indicator
Column Name Description
💲 Currency Key (WAERS):
BASE Contribution Basis
FBASE Contribution Basis
FBASR Contribution Basis
COTEE Employee Contribution
COTER Employer Contribution
DBASE Delta contribution basis
DFBASE Delta employee changed contribution basis
DFBASR Delta employer changed contribution basis
DCOTEE Delta employee contribution
DCOTER Delta employer contribution
Column Name Description
Column Name Description
FPBEG Start date of payroll period (FOR period)
BEGDA Start Date
ENDDA End Date
Column Name Description
LSTRC Key figure last entry of a cumulation for a year Show values
SHIFT Offset payroll flag Show values
Column Name Description Domain name
AFMIL Base Fiscal Year GJAHR
EMMIL Employment millennial GJAHR
Master Data Relations | to Other Relations ↓ Join Conditions
Client T5FDSNCUMCO.MANDT == T000.MANDT
Personnel Number
  • Personnel Number
  • Client
  • T5FDSNCUMCO.PERNR == PA0003.PERNR
  • T5FDSNCUMCO.MANDT == PA0003.MANDT
Forms: Section
  • ?
  • ?
  • Client
  • ?
  • Forms: Section
  • T5FDSNCUMCO.[column in domain "P_APPL"] == T5F99FS.APPL
  • T5FDSNCUMCO.[column in domain "ENDDA"] == T5F99FS.ENDDA
  • T5FDSNCUMCO.MANDT == T5F99FS.MANDT
  • T5FDSNCUMCO.[column in domain "MOLGA"] == T5F99FS.MOLGA
  • T5FDSNCUMCO.SECTN == T5F99FS.SECTN
Currency Key
  • T5FDSNCUMCO.MANDT == TCURC.MANDT
  • T5FDSNCUMCO.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Personnel Subarea
  • Personnel Subarea
  • Personnel Area
  • T5FDSNCUMCO.MANDT == T001P.MANDT
  • T5FDSNCUMCO.BTRTL == T001P.BTRTL
  • T5FDSNCUMCO.WERKS == T001P.WERKS
Identifier of a contribution indicator
  • ?
  • Identifier of a contribution indicator
  • ?
  • ?
  • ?
  • T5FDSNCUMCO.MANDT == T5FDSNCODCO.MANDT
  • T5FDSNCUMCO.[column in domain "P06_DSN_INSCO"] == T5FDSNCODCO.INSCO
  • T5FDSNCUMCO.CCOID == T5FDSNCODCO.CCOID
  • T5FDSNCUMCO.[column in domain "ENDDA"] == T5FDSNCODCO.ENDDA
  • T5FDSNCUMCO.[column in domain "P06_DSN_OPS_TYPE_ID"] == T5FDSNCODCO.TYOPS
  • T5FDSNCUMCO.[column in domain "P06_DSN_CODE_COTIS_FORMAT"] == T5FDSNCODCO.CCFOR
Tax and social insurance payroll costs
  • Tax and social insurance payroll costs
  • Client
  • T5FDSNCUMCO.COTIS == T5F1B.COTIS
  • T5FDSNCUMCO.MANDT == T5F1B.MANDT
SI contribution funds
  • SI contribution funds
  • Client
  • T5FDSNCUMCO.ORGAN == T5F1A.ORGAN
  • T5FDSNCUMCO.MANDT == T5F1A.MANDT
Personnel Area
  • T5FDSNCUMCO.MANDT == T500P.MANDT
  • T5FDSNCUMCO.WERKS == T500P.PERSA