P2IN_ESI SAP (ESI - Payroll Structure India) Table details

Dictionary Type: Table
Description: ESI - Payroll Structure India




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




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

P2IN_ESI is a standard SAP Table which is used to store ESI - Payroll Structure India data and is available within R/3 SAP systems depending on the version and release level.

The P2IN_ESI table consists of various fields, each holding specific information or linking keys about ESI - Payroll Structure India data available in SAP. These include MANDT (Client), DCT_PERNR (Personnel Number), DCT_SEQNR (Sequence Number), DCT_ROWID (Unique Row Number).. 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: Cannot Be Enhanced


SAP P2IN_ESI 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
DCT_PERNRPersonnel Number P_PERNRNUMC8PERNR
DCT_SEQNRSequence Number CDSEQNUMC5HRPY_RGDIRNUM5
DCT_ROWIDUnique Row Number HRDCT_ROWIDNUMC5HRDCT_ROWID
CNTR1SI split CNTR1RAW1RAW1
BEGDAStart Date BEGDADATS8DATUM
ENDDAEnd Date ENDDADATS8DATUM
TICNOTemporary identification certificate number PIN_TICNOCHAR12TEXT12
ESINOemployees' state insurance number PIN_ESINOCHAR20TEXT20
ESIDPEmployee's state insurance dispensary/hospital attached PIN_ESIDPCHAR12TEXT12
EECNREmployee's contrib. percentage to Employees' state insurance PIN_EECNRDEC5(2) DEC03_2
ERCNREmployer's contrib. percentage to Employees' state insurance PIN_ERCNRDEC5(2) DEC03_2
ESDAYNumber of ESIable days in a period PIN_ESDAYDEC3DEC3
ESINMemployees' state insurance number PIN_ESINMCHAR25TEXT25
TICNMTemporary identification certificate number PIN_TICNMCHAR25TEXT25

Key field Non-key field



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

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

SELECT SINGLE *
FROM P2IN_ESI
INTO CORRESPONDING FIELDS OF WA_P2IN_ESI
WHERE...

How to access SAP table P2IN_ESI

Within an ECC or HANA version of SAP you can also view further information about P2IN_ESI 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!