T7CN3F SAP table for – Reported Tax Data

Here we would like to draw your attention to T7CN3F table in SAP. As we know it is being mainly used with the SAP PA-PA (Personnel Administration in PA) component which is coming under HR (HCM) PA module (Personnel Management). T7CN3F is a SAP standard transp table used for storing Reported Tax Data related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB28.

SAP T7CN3F table

Table T7CN3F technical data

TableT7CN3F
Data storingReported Tax Data
ModulePA
Sub ModulePA-PA-CN
SAP PackagePB28
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRCCN
Table CategoryTRANSP

SAP T7CN3F Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in T7CN3F table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PERNR : Personnel Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • SEQNR : Sequence Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • INTYP : Tax Income Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ABKRS : Payroll Area
    Its data type is CHAR (Character String) with field length 2
  • FPPER : For-period for payroll
    Its data type is CHAR (Character String) with field length 6
  • IPEND : End of payroll period (IN period)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REPORTDATE : tax report date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CNAME : Alternative name
    Its data type is CHAR (Character String) with field length 60
  • INNUM : Tax ID
    Its data type is CHAR (Character String) with field length 18
  • TXARE : Tax area
    Its data type is CHAR (Character String) with field length 2
  • TXINC : HR Payroll: Amount
    Its data type is CURR (Currency Field) with field length 15
  • EXPAM : Exempted amount
    Its data type is CURR (Currency Field) with field length 13
  • TXPCT : Percentage of Tax Withholding-Fast Formula
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • TXACC : Accumulation for Tax withholding Fast Formula
    Its data type is CURR (Currency Field) with field length 13
  • TXAMT : HR Payroll: Amount
    Its data type is CURR (Currency Field) with field length 15
  • ZXAMT : HR Payroll: Amount
    Its data type is CURR (Currency Field) with field length 15
  • ZXAMT_C : HR Payroll: Amount
    Its data type is CURR (Currency Field) with field length 15
  • ZXAMT_P : HR Payroll: Amount
    Its data type is CURR (Currency Field) with field length 15
  • TXIN2 : HR Payroll: Amount
    Its data type is CURR (Currency Field) with field length 15
  • INCTP : Income type
    Its data type is CHAR (Character String) with field length 4
  • BALANCE : tax report banlance to next month
    Its data type is CURR (Currency Field) with field length 15