T7CN3F SAP (Reported Tax Data) Table details

Dictionary Type: Table
Description: Reported Tax Data




ABAP Code to SELECT data from T7CN3F
Related tables to T7CN3F
Access table T7CN3F




Table field list including key, data, relationships and ABAP select examples

T7CN3F is a standard SAP Table which is used to store Reported Tax Data data and is available within R/3 SAP systems depending on the version and release level.

The T7CN3F table consists of various fields, each holding specific information or linking keys about Reported Tax Data data available in SAP. These include PERNR (Personnel Number), SEQNR (Sequence Number), INTYP (Tax Income Type), ABKRS (Payroll Area).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP T7CN3F table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
SEQNRSequence Number CDSEQNUMC5NUM5
INTYPTax Income Type PCN_INCTYCHAR1CHAR1
ABKRSPayroll Area ABKRSCHAR2Assigned to domainABKRSABK
FPPERFor-period for payroll FAPERCHAR6CHAR6
IPENDEnd of payroll period (IN period) IPENDDATS8DATUM
REPORTDATEtax report date PCN_REPORTDATEDATS8DATUM
CNAMEAlternative name ALNAMCHAR60TEXT60
INNUMTax ID PCN_TAXIDCHAR18CHAR18
TXARETax area PCN_TXARECHAR2Assigned to domainPCN_TXARE
TXINCHR Payroll: Amount MAXBTCURR15(2) PRBETRG
EXPAMExempted amount PCN_EXPAMCURR13(2) P_AMT07V
TXPCTPercentage of Tax Withholding-Fast Formula PTW_TXPCTDEC7(2) DEC5_2
TXACCAccumulation for Tax withholding Fast Formula PTW_TXACCCURR13(2) P_AMT07V
TXAMTHR Payroll: Amount MAXBTCURR15(2) PRBETRG
ZXAMTHR Payroll: Amount MAXBTCURR15(2) PRBETRG
ZXAMT_CHR Payroll: Amount MAXBTCURR15(2) PRBETRG
ZXAMT_PHR Payroll: Amount MAXBTCURR15(2) PRBETRG
TXIN2HR Payroll: Amount MAXBTCURR15(2) PRBETRG
INCTPIncome type PCN_INCTPCHAR4CHAR4
BALANCEtax report banlance to next month PCN_TAXBALANCECURR15(2) PRBETRG

Key field Non-key field



How do I retrieve data from SAP table T7CN3F using ABAP code

The following ABAP code Example will allow you to do a basic selection on T7CN3F to SELECT all data from the table
DATA: WA_T7CN3F TYPE T7CN3F.

SELECT SINGLE *
FROM T7CN3F
INTO CORRESPONDING FIELDS OF WA_T7CN3F
WHERE...

How to access SAP table T7CN3F

Within an ECC or HANA version of SAP you can also view further information about T7CN3F and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!