P22_SIL_ALV SAP (Structure for ALV Display for Report RPCSILJ0) Structure details

Dictionary Type: Structure
Description: Structure for ALV Display for Report RPCSILJ0




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




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

P22_SIL_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for ALV Display for Report RPCSILJ0" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_P22_SIL_ALV TYPE P22_SIL_ALV.

The P22_SIL_ALV table consists of various fields, each holding specific information or linking keys about Structure for ALV Display for Report RPCSILJ0 data available in SAP. These include ENAME (Formatted Name of Employee or Applicant), SUBJE (Subject of Change), WERKS (Personnel Area), NAME1 (Personnel Area Text).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP P22_SIL_ALV structure 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
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
ENAMEFormatted Name of Employee or Applicant EMNAMCHAR40TEXT40
SUBJESubject of Change P22_SUBCHCHAR50CHAR50
WERKSPersonnel Area PERSACHAR4Assigned to domainPERSAPBR
NAME1Personnel Area Text PBTXTCHAR30TEXT30
BTRTLPersonnel Subarea BTRTLCHAR4Assigned to domainBTRTLPBS
BTEXTPersonnel Subarea Text BTRTXCHAR15TEXT15
PERSGEmployee Group PERSGCHAR1Assigned to domainPERSGPRG
PTEXTName of Employee Group PGTXTCHAR20TEXT20
PERSKEmployee Subgroup PERSKCHAR2Assigned to domainPERSKPKR
PERSTName of Employee Subgroup PKTXTCHAR20TEXT20
ORGEHOrganizational Unit ORGEHNUMC8Assigned to domainORGEH
ORGTXShort Text of Organizational Unit ORGTXCHAR25TEXT25
PLANSPosition PLANSNUMC8Assigned to domainPLANS
PLSTXPosition (Short Text) PLSTXCHAR25TEXT25
ENTRYEntry Date P22_ENTRYDATS8DATUM
ENTRYJJapanese Entry Date P22_ENTRYJCHAR45CHAR45
LEADTLeaving Date P22_LEADTDATS8DATUM
LEADTJJapanese Date of Leaving P22_LEADTJCHAR45CHAR45
ACQDTAcquisition Date P22_ACQDTDATS8DATUM
ACQDTJAcquisition Date in JP Format P22_ACQDTJCHAR45CHAR45
LOSDTLoss Date P22_LOSDTDATS8DATUM
LOSDTJJapanese Date of Loss P22_LOSDTJCHAR45CHAR45
OFFDTOffice Change Date P22_OFFDTDATS8DATUM
OFFDTJJapanese Date of Office Change P22_OFFDTJCHAR45CHAR45
KANJIName of the Insured (Kanji) P22_KANJICHAR26CHAR26
KANAName of the Insured (Kana) P22_KANANCHAR30CHAR30
GESCHGender P22_GENDERCHAR1
SEXTXGender Text P22_SEXTXCHAR10CHAR10
GBDATDate of Birth GBDATDATS8PDATEGBDAT
GBDATJJapanese Birthday of Employee P22_GBDATJCHAR45TEXT45
ADDREAddress of Employee P22_ADDRECHAR90CHAR90
SIPNRPension Number P22_SIPNRCHAR15TEXT15
SIINRInsurance number P22J_SIINRCHAR15P22J_SIINR
KAJID1Name of Dependent(Kanji) P22_KAJIDCHAR24CHAR24
KANAD1Name of dependent (Katakana) P22_KANADCHAR30CHAR30
BIRTH1Birth Date of Dependent P22_GBDADDATS8DATUM
BIRTHJ1Birth date of dependent (Japanese year style) P22_GBDADJCHAR45CHAR45
FASEX1Sex Text of Dependent P22_FASEXCHAR16CHAR16
STEXT1Name of Subtype SBTTXCHAR40TEXT40
RELAD1Relationship of Dependent P22_RELADCHAR15CHAR15
DCQDT1Acquisition Date of Dependent P22_DCQDTDATS8DATUM
DCQDTJ1Acquisition date of dependent (Japanese year style) P22_DCQDTJCHAR45CHAR45
DLOSD1Loss Date of Dependent P22_DLOSDDATS8DATUM
DLOSDJ1Loss date of dependent (Japanese year style) P22_DLOSDJCHAR45CHAR45
KAJID2Name of Dependent(Kanji) P22_KAJIDCHAR24CHAR24
KANAD2Name of dependent (Katakana) P22_KANADCHAR30CHAR30
BIRTH2Birth Date of Dependent P22_GBDADDATS8DATUM
BIRTHJ2Birth date of dependent (Japanese year style) P22_GBDADJCHAR45CHAR45
FASEX2Sex Text of Dependent P22_FASEXCHAR16CHAR16
STEXT2Name of Subtype SBTTXCHAR40TEXT40
RELAD2Relationship of Dependent P22_RELADCHAR15CHAR15
DCQDT2Acquisition Date of Dependent P22_DCQDTDATS8DATUM
DCQDTJ2Acquisition date of dependent (Japanese year style) P22_DCQDTJCHAR45CHAR45
DLOSD2Loss Date of Dependent P22_DLOSDDATS8DATUM
DLOSDJ2Loss date of dependent (Japanese year style) P22_DLOSDJCHAR45CHAR45
KAJID3Name of Dependent(Kanji) P22_KAJIDCHAR24CHAR24
KANAD3Name of dependent (Katakana) P22_KANADCHAR30CHAR30
BIRTH3Birth Date of Dependent P22_GBDADDATS8DATUM
BIRTHJ3Birth date of dependent (Japanese year style) P22_GBDADJCHAR45CHAR45
FASEX3Sex Text of Dependent P22_FASEXCHAR16CHAR16
STEXT3Name of Subtype SBTTXCHAR40TEXT40
RELAD3Relationship of Dependent P22_RELADCHAR15CHAR15
DCQDT3Acquisition Date of Dependent P22_DCQDTDATS8DATUM
DCQDTJ3Acquisition date of dependent (Japanese year style) P22_DCQDTJCHAR45CHAR45
DLOSD3Loss Date of Dependent P22_DLOSDDATS8DATUM
DLOSDJ3Loss date of dependent (Japanese year style) P22_DLOSDJCHAR45CHAR45
KAJID4Name of Dependent(Kanji) P22_KAJIDCHAR24CHAR24
KANAD4Name of dependent (Katakana) P22_KANADCHAR30CHAR30
BIRTH4Birth Date of Dependent P22_GBDADDATS8DATUM
BIRTHJ4Birth date of dependent (Japanese year style) P22_GBDADJCHAR45CHAR45
FASEX4Sex Text of Dependent P22_FASEXCHAR16CHAR16
STEXT4Name of Subtype SBTTXCHAR40TEXT40
RELAD4Relationship of Dependent P22_RELADCHAR15CHAR15
DCQDT4Acquisition Date of Dependent P22_DCQDTDATS8DATUM
DCQDTJ4Acquisition date of dependent (Japanese year style) P22_DCQDTJCHAR45CHAR45
DLOSD4Loss Date of Dependent P22_DLOSDDATS8DATUM
DLOSDJ4Loss date of dependent (Japanese year style) P22_DLOSDJCHAR45CHAR45
KAJID5Name of Dependent(Kanji) P22_KAJIDCHAR24CHAR24
KANAD5Name of dependent (Katakana) P22_KANADCHAR30CHAR30
BIRTH5Birth Date of Dependent P22_GBDADDATS8DATUM
BIRTHJ5Birth date of dependent (Japanese year style) P22_GBDADJCHAR45CHAR45
FASEX5Sex Text of Dependent P22_FASEXCHAR16CHAR16
STEXT5Name of Subtype SBTTXCHAR40TEXT40
RELAD5Relationship of Dependent P22_RELADCHAR15CHAR15
DCQDT5Acquisition Date of Dependent P22_DCQDTDATS8DATUM
DCQDTJ5Acquisition date of dependent (Japanese year style) P22_DCQDTJCHAR45CHAR45
DLOSD5Loss Date of Dependent P22_DLOSDDATS8DATUM
DLOSDJ5Loss date of dependent (Japanese year style) P22_DLOSDJCHAR45CHAR45
JGNPRName of Representative person P22_JGNPRCHAR40TEXT40
ADDOFAddress of The Applied Office P22_ADDROFCHAR150CHAR150
ADDI1Address of the Insured - Line 1 P22_ADDIS_LINE1CHAR90CHAR90
ADDI2Address of the Insured - Line 2 P22_ADDIS_LINE2CHAR90CHAR90
ADDI3Address of the Insured - Line 3 P22_ADDIS_LINE3CHAR90CHAR90
JGSNMName of Branch office P22J_JGSNMCHAR50TEXT50
TELNRTelephone Number TELNRCHAR14TELNR
REPRETitle and Name of the Representative P22_REPRECHAR50CHAR50
SCICCSocial Insurance Code (Name) P22J_SCICCCHAR8TEXT8
SCINRSocial Insurance given number P22J_SCINRCHAR5TEXT5
CHARGName of Person in Charge P22_CHARGCHAR40CHAR40
INSURERName of Insurer P22_INSURERCHAR50CHAR50

Key field Non-key field



How do I retrieve data from SAP structure P22_SIL_ALV using ABAP code?

As P22_SIL_ALV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on P22_SIL_ALV as there is no data to select.

How to access SAP table P22_SIL_ALV

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