ISH_PUBLICLIST_ALV SAP (IS-H: Public List - Fields for List Output) Structure details

Dictionary Type: Structure
Description: IS-H: Public List - Fields for List Output




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




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

ISH_PUBLICLIST_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 "IS-H: Public List - Fields for List Output" 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_ISH_PUBLICLIST_ALV TYPE ISH_PUBLICLIST_ALV.

The ISH_PUBLICLIST_ALV table consists of various fields, each holding specific information or linking keys about IS-H: Public List - Fields for List Output data available in SAP. These include KZAMB (Indicator Inpatient(1), Outpatient(2)), KZAE (Indicator Present/Discharged), KZP (Indicator Planned P/D of Day), PFORT (IS-H: Patient Does not Appear in Public List).. 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 (character-type or numeric)


SAP ISH_PUBLICLIST_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
KZAMB Indicator Inpatient(1), Outpatient(2)0
KZAE Indicator Present/Discharged0
KZP Indicator Planned P/D of Day0
PFORTIS-H: Patient Does not Appear in Public List PFORTCHAR1XFELD
VIPKZIS-H: VIP Indicator VIPKZCHAR1XFELD
NNAMSIS-H: Standardized Last Name NNAMES_PATCHAR30CHAR30
VNAMSStandardized First Name VNAMES_PATCHAR30CHAR30
NNAMEPatient Last Name NNAME_PATCHAR30TEXT30
VNAMEIS-H: Patient First Name VNAME_PATCHAR30TEXT30
GBDATIS-H: Birthdate RI_GBDATDATS8RI_DATUM
FALNRIS-H: Case Number FALNRCHAR10Assigned to domainALPHAFALNRFAL
GSCHLIS-H: Sex Indicator - Internal GSCHLCHAR1GSCHL
AUFDTIS-H: Public List - Date of Admission/Visit ISH_PLAUFDTDATS8
ENTDTPublic List - Date of Discharge/Date of Visit ISH_PLENTDTDATS8RI_DATUM
EINRIInstitution EINRICHAR4Assigned to domainALPHAEINRIEIN
ORGFAIS-H: OU with Departmental Responsibility for Case NZUWFACHAR8Assigned to domainALPHAORGID
ORGPFOrganizational Unit Assigned to Case NZUWPFCHAR8Assigned to domainALPHAORGID
ZIMMRIS-H: Building ID of Room ISH_ZIMMIDCHAR8Assigned to domainALPHABAUID
ZIMKBRoom ID ISH_ZIMMKBCHAR12TEXT12
BETTIS-H: Building ID of Bed Location BETTIDCHAR8Assigned to domainALPHABAUID
BETKBBed ID ISH_BETTKBCHAR12TEXT12
TELOEIS-H: Telephone Number ISH_TELNRCHAR30CHAR30
TELNRIS-H: Telephone Number of Patient in Institution TELF_INTCHAR16TEXT16
STRASIS-H: Street and House Number of Patient STRAS_PATCHAR30STRAS
PSTLZIS-H: Patient Postal Code PSTLZ_PATCHAR10PSTLZ
ORTIS-H: City where Patient Resides ORT01_PATCHAR25TEXT25
ADRNRIS-H: Address Number ISH_ADRNRCHAR10Assigned to domainALPHAISH_ADRNR
ADROBIS-H: Address Object ISH_ADROBJCHAR4ISH_ADROBJ
ORGKBIS-H: Public List - Short Text for Current Nursing OU ISH_PLORGKBCHAR12TEXT12
ORGDSData Protection Applies to an Organizational Unit ORGDSCHAR1XFELD
ORGDSBData Protection Applies to an Organizational Unit ORGDSCHAR1XFELD
ORGKBFIS-H: Public List - Short Text of Current Departmental OU ISH_PLORGKBFCHAR12TEXT12
ORGDSFData Protection Applies to an Organizational Unit ORGDSCHAR1XFELD
ORGDSBFData Protection Applies to an Organizational Unit ORGDSCHAR1XFELD
TODKZIS-H: Indicator for Discharge Type 'Deceased' TODKZCHAR1XFELD
FALARIS-H: Case Type FALLARTCHAR1FALLART
LANDIS-H: Country ISH_LANDCHAR3Assigned to domainLAND1
VIPTXTIS-H: Public List - Text for VIP ISH_PLVIPTXTCHAR3TEXT3
TODTXTIS-H: Public List - Text for Deceased Patient ISH_PLTODTXTCHAR10TEXT10
PFSTXTIS-H: Public List - Text for Public List Block ISH_PLPLOTXTCHAR15TEXT15
NAMEIS-H: Patient Name RI_NAMECHAR30TEXT30
PFORTB Authorization for Public List Block0
GSCHLEIS-H: Sex Indicator - User-Specific GSCHLECHAR1Assigned to domainGSCHLE
KZ_ABWIS-H: Public List - Patient is Absent ISH_PLABSKZCHAR1CHAR1
BEGIN_ABWIS-H: Public List - Start Date of Absence ISH_PLABSBEGDATDATS8DATUM
BEGIZ_ABWIS-H: Public List - Start Time of Absence ISH_PLABSBEGTIMTIMS6UZEIT
ENDE_ABWIS-H: Public List - End Date of Absence ISH_PLABSENDDATDATS8DATUM
ENDZ_ABWIS-H: Public List - End Time of Absence ISH_PLABSENDTIMTIMS6UZEIT
KZ_ENTLIS-H: Public List - Patient Is Discharged ISH_PLENTKZCHAR1CHAR1
KZPLENTIS-H: 'Planned Discharge' Indicator ISH_KZPLENTCHAR1CHAR1
LFDBEWIS-H: Sequence Number of Movement LFDBEWNUMC5Assigned to domainLFDBEW
ORGPFKBIS-H: Organizational Unit Short Text ORGKBCHAR12TEXT12
PATNRIS-H: Patient Number PATNRCHAR10Assigned to domainALPHAPATNRPAT
DISTYPIS-H: Movement Type RI_BWARTCHAR2Assigned to domainRI_BWART
DISTYP_TXTIS-H: Text for Movement Type BEWARTXTCHAR15TEXT15
ADRN2IS-H: Address Number ISH_ADRNRCHAR10Assigned to domainALPHAISH_ADRNR
ADRO2IS-H: Address Object ISH_ADROBJCHAR4ISH_ADROBJ
PLSNRIS-H: PRS Number ISH_EXTNR_PLSCHAR20ISH_EXTNR_PLS
ICON_TODIS-H: Public List - Patient is Deceased ISH_PLICONTODCHAR4CHAR4
KZS Indicator Patient as Text0
LETTER Initial Letter of Patient's Last Name0
SPACERIS-H: Placeholder for Public List ISH_PLSPACERCHAR15CHAR15
FILTER_OE Filter Value for Restricted List KZAE(1)-ORGID(8)-ENTDT(8)0
FILTER_PFORTIS-H: Patient Does not Appear in Public List PFORTCHAR1XFELD
FILTER_PRESENT Filter Value for Present0
SORT_NAME Sort Index for Sorting by Name0
SORT_OU Sort Index for Sorting by Org. Unit0

Key field Non-key field



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

As ISH_PUBLICLIST_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 ISH_PUBLICLIST_ALV as there is no data to select.

How to access SAP table ISH_PUBLICLIST_ALV

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