Select data from sap tables T7CN_
Display SAP table details
T7CN09 - Periods of Notice (CN)
T7CN0P - Personal Areas/Subareas (CHINA)
T7CN10 - Tax Calculation for Casual Worker
T7CN11 - Tax Rate for Additional Tax
T7CN13 - Salary information (CN)
T7CN13_SWITCH - Switch Period to Read Salary Information
T7CN13_TAX - Salary Information for Tax Area (CN)
T7CN14 - Contribution change reason
T7CN15 - Social insurance authority institution information
T7CN15T - Social insurance authority institution name
T7CN16 - Public Housing Fund authority institution information
T7CN16T - Public Housing Fund authority institution name
T7CN17 - Minimum Salary
T7CN17T - Minimum Salary Area Description
T7CN18 - Extended insurance authority institution information
T7CN18T - Supplementary Insurance Authority Institution Name
T7CN1A - Contribution change reason text
T7CN20 - Contribution base
T7CN20_CHI - CHI Tax Exemption for Tax Area (CN)
T7CN20_CPI - CPI Tax Exemption for Tax Area (CN)
T7CN21 - Contribution Group
T7CN21T - Contribution Group Text
T7CN22 - Pass Rule ER-to-EE
T7CN23 - Contribution Level
T7CN23T - Contribution Level Text
T7CN24 - Contribution Type
T7CN25 - Contribution Area
T7CN26 - Contribution switch period
T7CN27 - Social average salary switch period
T7CN28 - Service Fee to Holding Location
T7CN28T - Service Fee to Holding Location
T7CN29 - Social insurance
T7CN2A - Contribution Area Text
T7CN2P - Assign Sup. Insurance Authority Institution to PA/PSA
T7CN2W - Assign Wage Types for Supplementary Insurance
T7CN2Y - Contribution Type Text
T7CN30 - Tax Withholding Fast Formula
T7CN31 - Special rule category
T7CN32 - Tax Area
T7CN33 - Exempted Amount Table
T7CN34 - Special Calculation Rule
T7CN35 - Special rule rely on protocol
T7CN36 - Tax grouping for company
T7CN36T - Text Table for Tax grouping for company
T7CN37 - country codes for china tax
T7CN38 - Occupation category
T7CN38T - Occupation category Text
T7CN39 - Income category
T7CN39T - Income category Text
T7CN3A - Special rule category text
T7CN3B - Tax Area Text
T7CN3E - Special rule rely on protocol
T7CN3F - Reported Tax Data
T7CN40 - Personal File Category
T7CN41 - From/To Category
T7CN43 - Apply Status
T7CN44 - Social Class Status
T7CN45 - Personal Identity
T7CN4D - Personnel Class Status Text
T7CN4E - Personal Identity Text
T7CN4T - Personal File Category Text
T7CN4U - Text for From/To Category
T7CN4W - Apply Status Text
T7CN53 - Occupation
T7CN54 - Role in project
T7CN55 - Achievement(Result) Level Code
T7CN56 - Achievement(Reward) Code
T7CN57 - Position Category Code
T7CN58 - Position Name Code
T7CN59 - Political status
T7CN5P - Position Category Code Text
T7CN5Q - Position name
T7CN5R - Political status text
T7CN5S - Occupation Text
T7CN5V - Text for role in project
T7CN5W - Achievement Level Code Text
T7CN5Y - Achievement(Reward) code text
T7CN60 - Appointment Reason Code
T7CN61 - Position Level Code
T7CN62 - Position Type Code
T7CN63 - Going Abroad Purpose Category
T7CN64 - Expense Provider Category
T7CN65 - Occupation status for family member
T7CN67 - Political Affiliation Exception Type
T7CN68 - Project Type
T7CN69 - Project or Achievement Related Infomation
T7CN6H - Position Holding Type
T7CN6P - Position Holding Type Text
T7CN6Q - Project Type Text
T7CN6R - Political Affiliation Exception Type Text
T7CN6S - Position Level
T7CN6T - Appointment Reason Text
T7CN6U - Position Type Text
T7CN6V - Going Abroad Purpose Text
T7CN6W - Expense Provider Category Text
T7CN6X - Occoupation status text
T7CN71 - Province Key for CN
T7CN80 - Service year Valuation Rule
T7CN81 - Sick leave deduction rate
T7CN82 - Define Relevant Absence Types
T7CN83 - Long Sick Leave Salary Payment Rate
T7CN84 - Medical Treatment Entitlment and Accumulation period
T7CN90 - Year end tax declaration reported information - CTXE
T7CNA1 - check table for attribue of educational institution
T7CNA1T - Text table for attribue of educational institution
T7CNA2 - check table for category of educational institution
T7CNA2T - Text table for category of educational institution
T7CNA3 - Check table for Instruction Mode
T7CNA3T - Text table for instruction mode
T7CNA4 - Check table for academic qualification
T7CNA4T - Text table for academic qualification
T7CNAA - Qualification Certificate Code
T7CNAAT - Text of Qualification Certificate Code
T7CNAB - Qualification Certificate Level
T7CNABT - Text of Qualification Certificate Level
T7CNAC - Application Type
T7CNACT - Text of Application Type
T7CNAD - Way of Acquiring the Qualification certificate
T7CNADT - Text of Way of Acquiring the Qualification certificate
T7CNAE - Title Category
T7CNAET - Text of Title Category
T7CNAF - Evaluation Panel
T7CNAFT - Text of Evaluation Panel
T7CNAI - Income Category Average Wage
T7CNAIT - Income Category Description
T7CNAK - Off Position Type
T7CNAKT - Off Position Type Text
T7CNAL - Retirement Type
T7CNALT - Retirement Type Text
T7CNAM - Issued By
T7CNAMT - Issued By Text
T7CNAN - Retmt Grade
T7CNANT - Retmt Grade Text
T7CNAO - Highest Position
T7CNAOT - Highest Position Text
T7CNAP - Paid By
T7CNAPT - Paid By Text
T7CNAQ - Retmt Benefits Type
T7CNAQT - Retmt Benefits Type Text
T7CNAR - Retirement Benefits
T7CNART - Retirement Benefits Text
T7CNAS - Early Retmt Reason
T7CNAST - Early Retmt Reason Text
T7CNAU - Awards/Penalties Reason Code
T7CNAUT - Awards/Penalties Reason Code Text
T7CNAV - Assign reward/penalties type to reward/penalties mark
T7CNAW - AVG wage Type table
T7CNC0 - Contribution Calculation
T7CNC1 - Define Corporate Pension Plan
T7CNC1T - Text Table for Coporate Pension Plan
T7CNC2 - Define Status of Corporate Pension Plan
T7CNC2T - Text Table of Corporate Pension Plan Status
T7CNC3 - Reason for Changing Plan Information
T7CNC3T - Text Table of Reason for Changing Plan Information
T7CNC4 - Define Employee Group
T7CNC4T - Text Table of Employee Group Definition
T7CNC5 - Assign Employee Group to Pension Plan
T7CNC6 - Define Participant Status
T7CNC6T - Text Table of Participant Status Definition
T7CNC7 - Define Reason for Participant Status Change
T7CNC7T - Text Table of Reason for Participant Status Change
T7CNC8 - Define External Institution
T7CNC8T - Text Table of External Institution Definition
T7CNC9 - Assign External Institution to Pension Plan
T7CNCA - Define Contribution Period
T7CNCB - Define Reason for Suspending Contribution
T7CNCBT - Text Table of Reason for Suspending Contribution
T7CNCC - Define Reason for Benefit Eligibility
T7CNCCT - Text Table of Reason for Benefit Eligibility
T7CNCP - Commercial Pension Insurance Product
T7CNCPT - Text Table for Commercial Pension Insurance Product
T7CNDC - Define Disability Classification
T7CNDCT - Text Table for Disability Classification
T7CNDE - Employee Grouping of Disability
T7CNDET - Text Table for Employee Grouping of Disability
T7CNDE_AMOUNT - Deduction Amount for Deduction Type
T7CNDE_CITYC - Working City Category
T7CNDE_SUBTC - Deduction Subcategory
T7CNDE_SUBTCT - Deduction Subcategory
T7CNDE_WCITYT - Working City Decription
T7CNDG - Define Disability Grade
T7CNDGT - Text Table for Disability Grade
T7CNDX - Tax Policy for Disability Employee Groups
T7CNF1 - Individual Tax Declaration Income Type for Foreign Employee
T7CNF1T - Individual Tax Declaration Income Type for Foreign Employee
T7CNF2 - Wage Type Assignment for Income Type in Tax Declaration
T7CNIC - Income Category
T7CNICT - Income Category Description
T7CNIW - Wagetype Configuration for Income Category
T7CNIWT - Wagetype Title
T7CNLC_ACTION - Action Taken
T7CNLC_ACTIONT - Action Taken Description
T7CNLC_ASSOUT - Assignment of Outcome
T7CNLC_DECTYP - Decision Type
T7CNLC_DECTYPT - Decision Type Description
T7CNLC_ISSUE - Issue
T7CNLC_ISSUET - Issue Description
T7CNLC_ISUDTL - Issue Details
T7CNLC_ISUDTLT - Issue Details Description
T7CNLC_OUTCM - Outcome
T7CNLC_OUTCMT - Outcome Description
T7CNLC_STRS - CN: Wage Type Assignment for Simulate Termination PY Result
T7CNLC_TMNGRP - Termination Group
T7CNLC_TMNGRPT - Termination Group Description
T7CNLC_TMNRSN - Termination Reason
T7CNLC_TMNRSNT - Termination Reason Description
T7CNLG - wage Type table
T7CNRA - Assignment of Tax Calculation Rule to Income Category
T7CNREW_APRCFG - Approval flow
T7CNREW_APRDEL - Payroll renewal - Approval set delegation
T7CNREW_APRHIS - Payroll approval item history
T7CNREW_APRITEM - Payroll approval items
T7CNREW_APRPARS - Payroll result master table
T7CNREW_APRPYRS - Payroll result sub table
T7CNREW_NXTAPR - Table for next approvers
T7CNREW_USRFPA - User favorate control record
T7CNRMP_CHGMGMT - Detail of Change Management
T7CNRMP_CHGMGMTT - Text Table of Detail of Change Management
T7CNRMP_CUSTEXT - Customer Exit
T7CNRMP_CUSTEXTT - Text Table of Customer Exit
T7CNRMP_CUST_PD - Configuration Table for Fields in Organization Management
T7CNRMP_CUST_PDT - Text Table of Configuration Table for Fields in OM
T7CNRMP_DETFCT - Determining Factor
T7CNRMP_DETFCTT - Text Table of Determining Factor
T7CNRMP_DETITM - Determining Factor Item
T7CNRMP_DETITMT - Text Table of Determining Factor Item
T7CNRMP_DREPORT - Report with Dynamic Rows or Columns
T7CNRMP_DREPORTT - Text Table of Report with Dynamic Rows or Columns
T7CNRMP_FORMULA - Formula
T7CNRMP_FORMULAT - Text Table of Formula
T7CNRMP_FRMOPR - Formula Operand
T7CNRMP_FRMOPRT - Text Table of Formula Operand
T7CNRMP_RPTASSGN - Assign Reports for User
T7CNRMP_RPTGRP - Grouping Dimension for Report
T7CNRMP_RPTGRPT - Text Table of Grouping Dimension
T7CNRMP_RPTSTA - Statistical Dimension for Report
T7CNRMP_RPTSTAT - Text Table of Statistical Dimension
T7CNRMP_SUMITM - Summary Structure Item
T7CNRMP_SUMITMT - Text Table of Summary Structure Item
T7CNRMP_SUMSTRU - Summary Structure
T7CNRMP_SUMSTRUT - Text Table of Summary Structure
T7CNRMP_TEXTMAP - Mapping Table of the Corresponding Text Table and Text Field
T7CNRMP_VALITMT - Value Item of Statistical Item with Value Reading Type
T7CNRMP_VALUEITM - Value Item of Statistical Item with Value Reading Type
T7CNRM_ASSIGN - Report Assignment
T7CNRM_BCTGRY - Business Category
T7CNRM_BCTGRYT - Business Category Name
T7CNRM_CHNGCNTNT - Detail of Change Management
T7CNRM_COUNTER - Counter for Technical Keys
T7CNRM_DECFCT - Define Determining Factors
T7CNRM_DECFCTT - Text Table of Decision Factor
T7CNRM_DECITM - Determining Factor Item
T7CNRM_DECSET - Decision Factor SET - OBSOLETE
T7CNRM_DREPORT - Report with Dynamic Rows or Columns
T7CNRM_DREPORTT - Text Table of Report with Dynamic Rows or Columns
T7CNRM_FMTITM - Format Item
T7CNRM_FMTITMT - Format Item Text
T7CNRM_FMTSET - Format Set - OBSOLETE
T7CNRM_FMTSETT - Format Set Text - OBSOLETE
T7CNRM_FORMAT - Define Report Layout Format - OBSOLETE
T7CNRM_FORMATT - Text Table of Report Layout Format
T7CNRM_FORMULA - Calculation Formula
T7CNRM_FORMULAT - Text Table for Table T7CNRM_FORMULA
T7CNRM_FRMOPR - Operands for Formula
T7CNRM_GRPDIM - Grouping Dimension
T7CNRM_GRPDIMT - Grouping Dimension Text
T7CNRM_PSTATS - Reporting Period Status
T7CNRM_REPORT - Report
T7CNRM_REPORTT - Report Name
T7CNRM_RPDATAC - Report Data Content
T7CNRM_RPDATAK - Report Data Key
T7CNRM_RPSTRU - Reporting Structure
T7CNRM_RPSTRUT - Reporting Structure Name
T7CNRM_RPTASSIGN - Assign Reports for User
T7CNRM_RPTPRD - Reporting Period Definition
T7CNRM_RPTSTA - Statistical Dimension Definition
T7CNRM_RPTSTAT - Statistical Dimension Name
T7CNRM_RSCNTNT - Reporting Structure Content
T7CNRM_SASSGN - Business Category Assignment
T7CNRM_TTABMAP - Mapping Table of the Corresponding Text Table and Text Field
T7CNRM_TXDTTYP - Detail of Statistical Item Type of Text
T7CNRX - Tax Calculation Rule Configuration
T7CNSI_ADDWT - Define Supplementary Wage Type for SI Report Display
T7CNST - CN: Last Result of Simulate Termination Payment for Labor WB
T7CNT1 - Tax Declaration Report Controlling Setup
T7CNT1T - Text Table for T7CNT1
T7CNTC - Define Tax Calculation Rule
T7CNTCT - Text Table for Tax Calculation Rule
T7CNTC_BRULE - Calculation Base Rule
T7CNTC_BRULE_T - Text Table of Calculation Base Rule
T7CNTC_BR_DETAIL - Detail of Calculation Base Rule
T7CNTPM_AMNT - TPM: Item Amount
T7CNTPM_CALC - TPM: Calculation Method
T7CNTPM_ITM - TPM: Item
T7CNTPM_ITMGRP - TPM: Programme
T7CNTPM_ITMGRPT - TPM: Item Group Name
T7CNTPM_ITMT - TPM: Item Name
T7CNTPM_ITMTYP - Total Payment Management: Item Type
T7CNTPM_ITMTYPT - TPM: Item Type Name
T7CNTPM_NODREL - TPM: Node and Group Relationship
T7CNTPM_ORGGRP - TPM: Organization Group
T7CNTPM_ORGNOD - TPM:Organization Structure
T7CNTPM_ORGSTR - TPM: Org Structure
T7CNTPM_PLN - TPM: Plan
T7CNTPM_PLNT - TPM: Plan name
T7CNTPM_PLNTYP - TPM: Plan Type
T7CNTPM_PLNTYPT - TPM: Plan Type Description
T7CNTPM_PRD - Total Payment Management: Period
T7CNTPM_PROC - TPM: Process
T7CNTPM_PROCDEF - TPM: Process Definition(Step)
T7CNTPM_PROCREC - TPM: Process Record
T7CNTPM_TYPREL - TPM: Relationship of Plan Type and Item Type
T7CNTPM_USAGE - TPM: Usage Data
T7CNTPM_WAGTP - TPM: Wage Type Selection for Calculation Method
T7CNTX - Tax Rate or Amount Paid by Employer
T7CNTX_AMT - Tax Area Relevant Amount
T7CNTX_RATE - Tax Withholding Fast Formula - Tax Reform
T7CNY1 - Individual Tax Declaration Income Type for Year-end
T7CNY1T - Individual Tax Declaration Income Type for Year-end
T7CNY2 - Wage Type Assignment for Income Type in Year-end Report
T7CN_RPT_CLM_TXT - Report Column Text
T7CN_RPT_COLUMN - Table for report column maintenance
T7CN_RPT_MGT - Table for report management
T7CN_RPT_PHF_FMT - Format maintenance for Public Housing Fund Report
T7CN_RPT_SI_FMT - Format maintenance for SI Report
T7CN_RPT_TAX_FMT - Format maintenance for Tax Report
Return Table index