SAP Japan Tables
Are you looking for the right table related to SAP Japan Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Japan (PY-JP) module.
Top 10 tables in Japan
| Table | Description |
|---|---|
| T7JPCP_APPOFFI | Define Applied Office Data |
| T5J69 | HR Attributes to SYOYO payroll run JP |
| T7JPBP_PNTGRPA | Assign Target Employee Group to Retirement Benefit Point |
| P2RJ_KGT | Kijungai time occured in for-period with Position info |
| PA0889 | HR Master Record: Infotype 0889 |
| T5J58 | HR Combination Insurance Company Type/Product JPN |
| P2RJ_MST | Payroll result: Monthly socail insurance table |
| T5J57 | HR Special Tax Table for Retirement Income (Pension) JPN |
| T5J48 | HR Payroll Income Tax - Reconstruction |
| T5J53 | HR Text for Residence Tax Collection Indicator JPN |
List of tables in Japan
| Table | Description |
|---|---|
| T7JPCP_APPOFFI | Define Applied Office Data |
| T5J69 | HR Attributes to SYOYO payroll run JP |
| T7JPBP_PNTGRPA | Assign Target Employee Group to Retirement Benefit Point |
| P2RJ_KGT | Kijungai time occured in for-period with Position info |
| PA0889 | HR Master Record: Infotype 0889 |
| T5J58 | HR Combination Insurance Company Type/Product JPN |
| P2RJ_MST | Payroll result: Monthly socail insurance table |
| T5J57 | HR Special Tax Table for Retirement Income (Pension) JPN |
| T5J48 | HR Payroll Income Tax - Reconstruction |
| T5J53 | HR Text for Residence Tax Collection Indicator JPN |
| T5J88 | HR-J: Payment class |
| T7JPBP_FORMULA | Calculation Formula |
| T7JPCP_JOBGRD | Define Job Grade |
| T7JPCP_ELGRQ | Participation Eligibility Requisites |
| T7JPCP_FORMCAT | Define Form Category |
| P2RJ_YTT | Payroll Results: Income Tax for Year End Adjustment (Japan) |
| T7JPCP_CPPLNTYPT | Text Table for Corporate Pension Plan Type |
| T5J89 | HR-J: Payment class text |
| T5JNR | HR Normal Collection Reason for Output JPN |
| T7JPBP_ASNPERPT | Text Table for Assignment Period Parameters |
| T7JPBP_PNTTYPT | Text Table for Retirement Benefit Point Type |
| T7JPCP_CLDECFC | Decision Factor |
| T7JPCP_CBDECT | Text Table for Decision Factors of Re-assessment Rate |
| T7JPCP_IMPLCO | Define Corporate-type DC plan Implementing Companies |
| T7JPBP_CALDEC | Decision Factor |
| T5J42 | HR Payroll Income Tax - Monthly Chart JPN |
| T5J41 | HR Rate of Income Tax for Syoyo JPN |
| T7JPCP_BENTYPE | Define Benefit Type |
| T7JPBP_CALCGRPT | Text Table for Allocation Calculation Group |
| T7JPCP_PREMPAR | Premium Rate/Amount Parameter |
| T7JPBP_PNTTYP | Retirement Benefit Point Type |
| T7JPCP_FORMRCDT | Define Form Record Description |
| P2RJ_NT | Payroll Results: Social/Labour Insurance (Japan) |
| T7JPCP_PRDECFC | Decision Factors for Premium Rate/Amount |
| T7JPCP_BENPNTYT | Text table for retirement benefit plan type |
| T7JPCP_RNDRULE | Rounding Rule |
| T7JPCP_AGERQ | Age Requisites |
| T5J39 | HR Standard Annual Income Y.E.A. JPN |
| T7JPCP_PAYCOURT | Text Table for Benefit Payment Period Course |
| T7JPBP_PNTT | Text Table for Retirement Benefit Point |
| T5J52 | HR Residence Tax Collection Indicator JPN |
| T7JPBP_CLFCPART | Text Table for Calculation Factor Parameter |
| T5JOM | 36 Agreement: Overtime Work Limit Modifier |
| T7JPCP_CALCGRPT | Contribution Amount Calculation Group Description |
| T7JPBP_ALLOCST | Text Table for Allocation Course for Benefit Points |
| T7JPBP_CLFCTBL | Calc. Factor Parameter Value Table |
| T7JPCP_CLFCTBL | Calculation Factor Parameter Value Table |
| T5J1A | HR-J: Overseas pay payment rate |
| T5JNC | HR Normal Collection Reason Indicator JPN |
| T7JPCP_REDRULE | Reduction Rule of Current Assignment Period Basis Payment |
| P2RJ_JWPKJ | Add to working place and basic pay (Japan) |
| T7JPCP_BENTYPET | Text Table for Benefit Type |
| P2RJ_JP_SHUKKO | Shukko settlement information |
| T7JPCP_JOBGRDT | Text Table for Job Grade |
| T5J44 | HR Payroll Income Tax - Daily OTSU JPN |
| T7JPCP_SUBPLN | DB Plan Sub Plan |
| T7JPCP_ASNPERD | Assignment Period for Retirement Benefit Resource |
| T7JPCP_DBBERQ | Pension Benefit Eligibility Requisites |
| T7JPCP_PGPLNAS | Assign Participant Group to Pension Plan |
| T7JPCP_REPCO | Define Corporate-type DC plan Representitive Company |
| T7JPCP_FORMSPC | Define Form Specification |
| T5J55 | HR Text for Insurance Product Type JPN |
| T5JNRT | Text Table of Normal Collection Reason for Output |
| T7JPCP_JOBTYPET | Text Table for Job Type |
| T5J36 | HR Tax Indicator Text JPN |
| T7JPCP_PSCHRSN | Reason of Participant Status Change |
| T7JPCP_PRFCTBL | Premium Amount/Rate Parameters Value Table |
| T7JPCP_EXTINST | Define External Institution |
| T5J20 | HR Amount for Famliy Dependent Tax Deduction JPN |
| T7JPCP_JOBTYPE | Define Job Type |
| T5J40 | HR Tax Deduction Amount Y.E.A. JPN |
| T7JPCP_PAYCOUR | Benefit Payment Period Course |
| T5J35 | HR Indicator of Taxation JPN |
| T5J99 | Wagetype correspond Table. |
| T7JPCP_DTFLSTR | Define Data File Structure |
| P2RJ_JP_CPT | Payroll result: Retirement Benefit Result |
| T5J87 | HR-J: Taxation type text |
| T7JPCP_CLBSPAR | Calculation Basis Parameter |
| T7JPCP_PREMTYT | Text Table for Premium Type |
| T5J86 | HR-J: Taxation Type Indicator JPN |
| T5JFT | Multiple payment model in a month |
| T5J38 | HR Year End Adjustment Indicator Text JPN |
| PA0888 | HR Master Record: Infotype 0888 |
| T7JPCP_PENSION | Corporate Pension Plan |
| T7JPCP_EXTINSTT | Text Table for External Institution |
| T7JPCP_PARTGRP | Paticipant Group Definition |
| T7JPCP_CHGRSN | Reason of Change |
| T7JPCP_CBFCPAR | Re-assessment Rate Decision Factor Parameters |
| T7JPBP_PNT | Retirement Benefit Point |
| T7JPCP_SENRQ | Seniority Requisites |
| T7JPCP_FORMULA | Calculation Formulas |
| T7JPCP_SUBPLNT | DB Plan Sub Plan Text Table |
| T7JPCP_CLBSDAS | Calculation Basis Parameter Basic Pay Data Source |
| T7JPCP_PARTSTA | Participant Status |
| T5J51 | HR Text for Residence Tax Change Reason JPN |
| T7JPBP_EMPGRPT | Text Table for Target Employee Group |
| T7JPBP_ASNPERP | Assignment Period Parameters |
| T7JPCP_PRDECFCT | Premium Rate/Amount Parameter Decision Factor Text |
| T7JPCP_CONSRSNT | Define Premium Contribution Suspension Reason Text |
| PA0890 | HR Master Record: Infotype 0890 |
| T7JPCP_INELGRQ | Participation Ineligibility Requisites |
| T7JPCP_PARTSTAT | Participant Status Text Table |
| T7JPBP_CALGRPA | Assign Allocation Calculation Group to SI Modifier |
| T7JPCP_DTRUL | Define Contribution Determination and Reference Date Rule |
| T7JPCP_PENSIONT | Corporate Pension Plan Text Table |
| T5J64 | HR Commuting Allowance - Non-taxable Amounts JPN |
| T7JPCP_BENATTR | Define Benefit Attributes |
| P2RJ_HEIT | Payroll Results: Hei Ran Results Table |
| T7JPCP_CALCGRP | Define Contribution Amount Calculation Groups |
| T7JPBP_ASNPERD | Benefit Point Assginement Period |
| T7JPCP_PAYTPER | Define Benefit Payment Period Information |
| T7JPCP_STDKDT | Key Date for Standard Premium Parameter |
| P2RJ_RET_INFO | Payroll Results: Retirement Information Table |
| T7JPCP_CPPLNTYP | Define Corporate Pension Plan Type |
| P2RJ_MAT | Cumulation Table for Flexible Payroll |
| T7JPBP_UPDEC | Point Unit Price Decision Factor |
| T7JPCP_BENMODA | Assign Benefit Modifier to Pension Plan |
| T7JPBP_CALCGRP | Allocation Calculation Group |
| T5J19 | HR Combination for Family Dependant Tax Deduction JPN |
| T7JPBP_REDRULE | Reduction Rule for Point Value of Current Period |
| T5JRIC | Retroactive Changes to YEA Infotypes |
| T7JPCP_RNDRULET | Rouding Rules Text |
| T7JPCP_CALGRPA | Contribution Amount Calculation Group Assignment |
| T7JPCP_REVPERD | Revision Period |
| T7JPCP_CBACPAR | Virtual Individual Account Balance Parameters |
| T5J54 | HR Insurance Product Type JPN |
| T5JNCT | HR Text for Normal Collection Reason Indicator JPN |
| T7JPBP_CALDECT | Text Table for Decision Factor of Benefit Point |
| T5J50 | HR Residence Tax Change Reason JPN |
| T7JPBP_EMPGRP | Retirement Benefit Point Target Employee Group |
| T5JKG | Kijungai period setting per payroll area |
| T7JPCP_PAYPER | Define Pre-paid Retirement Allowance Calculatuion period |
| T7JPCP_PREMPART | Premium Rate/Amount Parameter Text |
| T7JPCP_PSCHRSNT | Reason of Participant Status Change Text Table |
| P2RJ_RETTAX | Payroll Results: Detailed Retirement Tax Infomation |
| T7JPCP_PREMFML | Premium Calculation Formula |
| T7JPCP_JOBTYRQ | Job Type Requisites |
| T5J37 | HR Indicator Year End Adjustment JPN |
| T5JCR | 36 Agreement: Check Rule of Overtime Work |
| T7JPCP_PARTGRPT | Paticipant Group Definition Text Table |
| T7JPBP_ALLOCS | Allocation Course for Benefit Points |
| T7JPBP_ASNPARA | Assign Assignment Period Parameters |
| T5JLQ | Flextime Labor-Management Agreements |
| T7JPCP_DCDTRMD | Distribution Method of Amount Exceeding Maximum Contribution |
| T5JMA | Multiple payment model in a month |
| T7JPCP_CONSRSN | Define Premium Contribution Suspension Reason |
| T7JPBP_PNTDEC | Assign Decision Point Types to Retirement Benefit Point |
| T7JPCP_REVPERA | Assign Period Parameter |
| PA0903 | HR Master Record: Infotype 0903 |
| T7JPCP_CLFCPAR | Calculation Factor Parameter |
| T7JPCP_PAYMTHD | Define Pre-paid Retirement Allowance Contribution Method |
| T7JPCP_BENPNTY | Define Retirement Benefit Plan Type |
| T7JPBP_PNTTBL | Retirement Benefit Point Value Table |
| T7JPBP_BPCOMA | Assign Retirement Benefit Point System for Each Company Code |
| T7JPCP_PREMTY | Pension Premium Type |
| T7JPCP_CTRC | Maintain Contract Data |
| T7JPCP_CALPERP | Define Calculation Period Parameter |
| T7JPCP_CPPNSTYT | Text Table for Corporate Pension Plan Subtype |
| T7JPBP_ALLOCSA | Assign Allocation Course to Retirement Benefit Plan |
| T7JPCP_CALPERPT | Text Table for Calculation Period Parameters |
| P2RJ_TT | Payroll Results: Income Tax (Japan) |
| T7JPCP_CLDECFCT | Decision Factor Text |
| T7JPCP_CBDEC | Decision Factors for Re-assessment Rate |
| T7JPCP_CBFCTBL | Reassessment Rate Factor Parameter Value Table |
| T5J43 | HR Payroll Income Tax - Daily KOU JPN |
| T7JPBP_UPTBL | Point Unit Price Value Table |
| T7JPCP_CPPNSTY | Define Corporate Pension Plan Subtype |
| T7JPCP_CLFCPART | Calculation Factor Parameter Text |
| T7JPCP_FORMRCD | Define Form Record |
| T7JPBP_CLFCPAR | Calculation Factor Parameters |
| T7JPCP_FORMCATT | Define Form Category Text |