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 (PA-PA-JP) module.
Top 10 tables in Japan
| Table | Description |
|---|---|
| T7JPSI_INSURER | Define Health Insurance Insurer |
| T5JMD | Module for Liquidation/Allowance Items (JP) |
| T5J80 | HR Definition of Service Years - Factor - Patterns JP |
| T5J98 | HR Conversion IT0144 to IT0169 JP |
| T5J66 | HR Institution/school type JPN |
| T5JIM | Image File Up/download |
| T5J62 | HR Address Information of Personnel Subarea for Income Tax |
| T5J79 | HR Syoyo payemnt rate per pay scale JP |
| T5J68T | HR Faculty JP |
| T5JGR | Employee Group for Leaving (JAPAN) |
List of tables in Japan
| Table | Description |
|---|---|
| T7JPSI_INSURER | Define Health Insurance Insurer |
| T5JMD | Module for Liquidation/Allowance Items (JP) |
| T5J80 | HR Definition of Service Years - Factor - Patterns JP |
| T5J98 | HR Conversion IT0144 to IT0169 JP |
| T5J66 | HR Institution/school type JPN |
| T5JIM | Image File Up/download |
| T5J62 | HR Address Information of Personnel Subarea for Income Tax |
| T5J79 | HR Syoyo payemnt rate per pay scale JP |
| T5J68T | HR Faculty JP |
| T5JGR | Employee Group for Leaving (JAPAN) |
| T5JIST | Text Table for Status in Individual Number Processing |
| T5J73T | HR Retirement Allowance Modifier JP |
| T5JIU | Usages for Individual Numbers |
| T5J56 | HR Weighting for Appraisal Main Feature JPN |
| T5J30 | HR Text for SI Entitlement Acquired/Lost JPN |
| T5JL3 | HR Address Infomation 3 of Labour Bureau for LI JP |
| T5J74 | HR Retirement Allowance Unit Amount JP |
| T5JGRT | Employee Group for Leaving Text (JAPAN) |
| T5J03 | Person Group/Subgroup JP |
| T7JPLV_GIAJ_INST | Define GIAJ Specific Insurer Company Name |
| T51T3T | Text table for T51T3 |
| T5JTU | Transaction and Usage Details Assignment |
| T5JSC | HR SI Grade of standard compensation JP |
| T7JPSI_INSURERT | Define Health Insurance Insurer |
| PA0142 | HR Master Record: Infotype 0142 (Residence Tax JP) |
| T5JSR | HR Rate of Premium for Social Insurance JPN |
| T7JPEI_PERACTCT | Condition Text of Permission on Activities Beyond Scope |
| T5J02 | HR Union Member Category JP |
| TJPESS_COM_HELP | JP ESS Help Text or Reference Information about ESS Forms |
| T7JPSK_CONTTY_T | Shukko Contract Types |
| T7JP_CHARSET_T | Text for character set |
| T5J29 | HR SI Entitlement Acquired/Lost JPN |
| T5JRA | HR Collector Number for Residence Tax JP |
| T5JLT | Leaving Type (JAPAN) |
| T5J04 | HR Union Member Category Text JP |
| PA0851 | HR Master Record: Infotype 0851 |
| T5JTA | Transaction Code and Date of Retention Assignment |
| T5JUU | Usage and Usage Details Assignment |
| T5J71 | HR Retirement Reason Category JP |
| TJPESS_TXT_MEANS | JP ESS IT0559 Means of Transportation Description |
| T5J24 | HR Text for Indicator SI Insured JPN |
| PA3204 | HR Master Record: Infotype 3204 |
| T5J13 | HR Text for Appraisal Detail Feature JPN |
| PA0853 | HR Master Record: Infotype 0853 |
| T5J68 | HR Faculty JP |
| PA0141 | HR Master Record: Infotype 0141 (SI Premium Data JP) |
| T5J1CT | HR-J: Car type text |
| T5J01 | HR Union texts JP |
| T5JLTT | Leaving Type Text (JAPAN) |
| T5J60 | HR Parameters for pay scale recreation JPN |
| T51T5T | Text table for T51T5 |
| T5JXP | Japan eGov Procedure Information |
| T7JP_LVE_ATT | Attachment Information |
| TJPESS_PKMAMT_PS | ESS JP: IT0559 - Amount Per KM By Per. Area and Subarea |
| T5JCN | HR Corporate Number Information for Japan |
| T7JP_LVE_DRS | Relation between HI Dependent Reason and Change Reason |
| TJPESS_MEANS_TYP | JP ESS IT0559 Combination of Means of Transportation |
| T7JP_LVE_DHI | Determine HI Relation from subtypes and relationships |
| T7JPEI_PERACTC | Condition of Permission on Activities Beyond Scope |
| TJPESS_INT_GROUP | JP ESS IT0559 Interval Grouping |
| T5JXD | Japan eGov XML Definition |
| T5J22 | HR Insurance Company Name JPN |
| T5JXT | e-GOV: XML Attributes |
| T7JPLV_GIAJ_INS | Define GIAJ specific insurer codes |
| T7JP_UPDFLD | Fields Monitor for Update Log |
| T5JR0 | Definition of Retirement Liquidation/Allowance Items(JP) |
| T5J84 | HR Service Years - Factor - Patterns for Retirement JP |
| T5JR1 | Configuration of Retirement Liquidation/Allowance Items (JP) |
| T5J15 | HR Pay Scale Level for Appraisal Rank Criteria JPN |
| T7JPLA_COVRT | Define OT Accu. Target & Time Off Conversion Rate |
| T7JPLV_DATALAY | Define Data Layout |
| T7JPLV_FILETYPE | Define File Type |
| T5J0P | Personnel Area / Personnel Subarea JP |
| TJPESST_INTERVAL | JP ESS IT0559 Interval Description |
| T7JPLV_RECDSTRU | Define Record Structure |
| T5J32 | HR Social Insurance Entitlement JPN |
| T5J70 | HR Retirement Reason Category JP |
| T7JPLA_WKHRS | Define Hours of Time Off from Overtime |
| T7JPLA_OTGRP | Define employee group for overtime |
| T5JUDT | Usage Details Text Definition |
| T7JPSK_CCPRL | Shukko Cost Charging Prorating Rules |
| T7JP_UPTLOG | Update Log |
| T5JSI | HR Branch Office Information for Social Insurance JP |
| PA3387 | HR Master Record: Infotype 3387 |
| T7JPLV_FILESTRU | Define File Structure |
| TPTJPFWS_RULEATT | ESS Flexible Work Schedule: Attributes for rule group |
| TJPESS_PKMAMT_CC | ESS JP: IT0559 - Amount Per KM By Company Code |
| TJP_ESSPDC | Register Versions of YEA Forms |
| T5J14 | HR Pay Scale Level for Appraisal Point Criteria JPN |
| PA3208 | HR Master Record: Infotype 3208 |
| T5J26 | HR Text for Indicator of Labour Insurance Premium Rate JPN |
| T7JPLV_INSCCCT | Define Insurance Company Insurance Product Type |
| T5J17 | HR Combination for Income Tax Deduction JPN |
| T5J81 | HR Associate retirement reason category to service years JP |
| T5JRNT | Reason Text (JAPAN) |
| PA0268 | HR Master Record Infortype view 0045 and 0268 (Loan JPN) |
| T5J65 | HR School Japan |
| PA0144 | HR Master Record: Infotype 0144 (Property Accum. JP) |
| T5J31 | HR SI Entitlement JPN |
| T5J82 | HR Associate pay scale to service years JP |
| T7JPEI_WKREST | Work Restriction Text |
| T5J28 | HR Text for Indicator of Social Insurance Premium Rate JPN |
| T5J1D | HR Nursing Insurance cost JP |
| T5J21 | HR Insurance Company Key Master JPN |
| T5J65T | HR School Japan |
| T7JPLA_WTGRPT | Text table for Wage Type Group |
| T5J63 | HR Municipal City Codes JP |
| PA0146 | HR Master Record: Infotype 0146 (Y.E.A. Data JP) |
| T7JP_UPDINF | Infotype Monitor for Update Log |
| T7JPLV_FILETYPET | Text Table of T7JPLV_FILETYPET |
| PA3140 | HR Master Record: Infotype 3140 |
| T5J61 | HR Address Information of Pers. Subarea for Residence Tax |
| T5JEVT | Text Table for Evidence Japan |
| T5JIS | Status for Individual Number Processing |
| T7JPLA_OTGRPT | Text table for employee group for overtime |
| PA0148 | HR Master Record: Infotype 0148 (Family JP) |
| T7JPSK_CCRL_C | Shukko Cost Charging Rule Characteristics |
| T7JP_ACCLOG | Access Log |
| T7JPEI_RESSTA | Define Residence Status |
| T7JP_LVE_CLB | Child Care Leave Benefits |
| T7JPLV_GIAJI_TYP | Define Insurance Type Relationship |
| T5J78 | HR Taxable amount reduction for retirement allowance JP |
| T5JIUT | Text Table for Usage of Individual Numbers |
| T5JAD | HR company office address JP |
| PA0388 | HR Master Record: Infotype 0388 (Union JP) |
| PA0162 | HR Master Record: Infotype 0162 (Ins. Y.E.T.A Data JP) |
| TJP_ESSPFC | JP ESS YEA Form Maint(Form Customization ). |
| T5J00 | HR Union JP |
| T7JPSI_INR_ASN | Assign Health Insurance Insurer to Social Insurance Modifier |
| T7JPLV_GIAJ_TYPE | Define Insurance Type Relationship for GIAJ company |
| PA3203 | HR Master Record: Infotype 3203 |
| T7JPSK_CCRL | Shukko Cost Charging Rules |
| T5JEV | Evidence types for HCM Japan |
| PA3239 | HR Master Record: Infotype 3239 |
| PA0140 | HR Master Record: Infotype 0140 (SI Basic Data JP) |
| PA0143 | HR Master Record: Infotype 0143 (Life Insurance JP) |
| T5JXE | Employee List for B2A Manager |
| T5JUD | Usage Details Definition |
| T5JR0T | Text table for Retirement Liquidation/Allowance Items (JP) |
| TJPESS_COM_GROUP | JP ESS IT0559 Subtype Grouping |
| T5J59 | HR Job promotion - pay scale level ordering JPN |
| T5J76 | HR Santei/Geppen Form remarks column text JP |
| T5J23 | HR Indicator SI Insured JPN |
| T5J33 | HR Insurance company type JPN |
| T7JPLA_WTGRP | Define Wage Type Group |
| T7JPSK_CCRL_T | Shukko Cost Charging Rules |
| T5JOT | Overtime Liquidation Indicator (JAPAN) |
| T5J1E | HR Grade No. of standard compensation for health ins. JP |
| T5JXA | Procedure Attachment Information |
| PB3208 | Applicant data infotype 3208 (model) |
| T7JPEI_WKRES | Work Restriction |
| T5J73 | HR Retirement Allowance Modifier JP |
| PTJPFWS_ITEMDATA | (Obsolete) Request Item Data for Flexible Work Schedule JP |
| T7JP_LVE_STF | Application and Notification Forms for Special Treatment |
| T7JPLA_VADPD | Define Leave Quota Validity for Time Off from Overtime |
| T5JRN | Reason (JAPAN) |
| PA0373 | HR loan repayment plan JP (for P0268) |
| T7JPSK_PARTNER_T | Shukko Partner Texts |
| T7JPSK_CCWT | Shukko Cost Charging Wagetype |
| T5JL2 | HR Address Infomation 2 of Personnel Subarea for LI JP |
| T5J67 | HR Institution/school type text JP |
| TJP_ESSPDF | JP ESS YEA Form Maint. |
| T7JP_LVE_CLN | Child Care Leave (Termination) Notification |
| PB3387 | Applicant data infotype 3387 (Additional Personal Data JP) |
| T7JP_LVE_MLN | Maternity Leave (Termination) Notification |
| T5J10 | HR Appraisal Main Feature JPN |
| T5J1F | HR Grade No. of standard compensation for EE's pension JP |
| T5J11 | HR Text for Appraisal Main Feature JPN |
| T5JSP | Social Insurance Premiums Liquidation Indicator (JAPAN) |
| TJPESS_PERKM_AMT | JP ESS IT0559 Per KM Amount Setting |
| T5J46 | HR Appraisal Rank Criteria JPN |
| T7JP_ACCOPN | Infotype Operation Monitor for Access Log |
| T5JXV | Japan eGov XML Style Summary |
| T5J83 | HR Service Years - Factor - Patterns for Retirement JP |
| T5JMS | Configuration for Mail Notification |
| TJPESS_YEA_RANGE | Japan YEA year range table for retrieving data in HCMPF |
| T7JPSK_CONTT | Shukko Contract Template |
| T7JP_LVE_JSH | Determine Jisshi from subtypes and relationships |
| T5J25 | HR Indicator of Labour Insurance Premium Rate JPN |
| T5JLA | LI: Adjustments for Annual Update Forms |
| T7JPSK_CCPRL_T | Shukko Cost Charging Prorating Rules |
| TJPESS_PKMAMT_NA | ESS JP: IT0559 - Amount Per KM By National Average |
| T5JRH | Action types for Leaving-Reentry |
| T5JLG | Premium amount for employment insurance |
| T5J1C | HR-J: Car type |
| T7JP_CHARSET | Character set |
| T5JL1 | HR Address Infomation 1 of Personnel Subarea for LI JP |
| T7JPEI_RESSTAT | Text Table for Residence Status |
| T7JPLA_WTASN | Assign Overtime Accumulation Wage Types |
| T5J05 | HR Union due calculation master JP |
| T5J77 | HR Katakana writing for Country Names JP |
| PA0560 | HR Master Record: Infotype 0560 |
| T5JXL | Contact Information for Office |
| T7JPLV_GIAJI_J21 | Define Relationship between GIAJ specific Insurance Company |
| T5J27 | HR Indicator of Social Insurance Premium Rate JPN |
| T7JP_UPDOPN | Infotype Operation Monitor for Update Log |
| PA0145 | HR Master Record: Infotype 0145 (Personnel Tax Status JP) |
| T7JP_LVE_DRE | Determine Relationship from subtypes |
| T7JPEI_PERSTAY | Period of Stay |
| T7JPLV_DATALAYT | Text Table to Define Data Layout |
| T5JLR | HR Rate of Premium for Labour Insurance JPN |
| T7JPLA_OTLIM | Define overtime extension limits |
| T5JSPT | Social Insurance Premiums Liquidation Indicator Text (JAPAN) |
| PA3386 | HR Master Record: Infotype 3386 |
| T7JPSK_CONTTY | Shukko Contract Types |
| PA0559 | HR Master Record: Infotype 0559 (Commuting allowance Info.) |
| T5J18 | HR Amount for Income Tax Deduction JPN |
| PA0852 | HR Master Record: Infotype 0852 |
| T7JP_ACCINF | Infotype Monitor for Access Log |
| PA0147 | HR Master Record: Infotype 0147 |
| T5JER | HCM JP: Era Codes for Reports |
| TPTJPFWS_ITEMDAT | Request Item Data for Flexible Work Schedule JP |
| T5J47 | HR Combination Insurance Type/Insurance Company JPN |
| T5J2F | Format for HR Name (JP) |
| T7JP_UPDSUB | Subtype Monitor for Update Log |
| T5JOTT | Overtime Liquidation Indicator Text (JAPAN) |
| T5J72 | HR Supplements to Reason for Events JP |
| T7JPBT_BUSOFFICE | Define Business Establishments |
| TPTJPFWS_SUBSTI | ESS Flexible Work Schedule: Substitution linkage |
| T5J12 | HR Appraisal Detail Feature JPN |
| T5JA2 | HR Weighting for Appraisal Detail Feature JPN |
| T7JP_LVE_NLB | Nursing Leave Benefits |
| T5J16 | HR Text for Appraisal Rank Criteria JPN |
| T7JP_CHARRNG | Range of characters in a character set |
| T5J34 | HR Insurance company type text JPN |
| T5J75 | HR Santei/Geppen Form remarks column text ID JP |
| TJPESS_COM_MEANS | JP ESS IT0559 Means of Transportation Definition |
| T7JPLV_INSCCT | Text Table for T7JPLV_INSCC |
| T7JPLV_INSCC | Define LINC Insurance Company |
| T7JPSK_PARTNER | Shukko Partners |
| T7JPLV_INSCC_J21 | Define Relationship between LINC Insurance Company and T5J21 |
| T5JR2 | Default Items for Retirement Liquidation/Allowance (JP) |
| T5JBK | HR Bank key for Property accumulation savings JP |
| T7JPEI_PERSTAYT | Period of Stay Text |
| T5JXR | e-GOV Style Generation from Reports |
| T7JPBT_EXCLUDEWT | Determine Wage Types to be excluded from Business Office Tax |
| T7JP_DHI_DRS | Mapping for the defined reason for DHI Form |
| TJPESS_INTERVAL | JP ESS IT0559 Interval Definition |
| T7JPBT_BSOFFICET | Business Establishment Text Table |
| T7JP_ACCSUB | Subtype Monitor for Access Log |