SAP for Healthcare Discussions
Foster discussions about patient care, cost reduction, and operational excellence in healthcare organizations using SAP. Join the conversation.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP IS-H Tables details

Former Member
0 Kudos

Hi,

Would anyone be able to give me a list of IS-H tables and a general description of the table functions - like what data it stores, etc.? I am more specifically looking for information to process a) Doctor Management b) Patient Management c) Cash collection d) Doctor Fee processing.

Thanks in advance for your help.

Zubair

6 REPLIES 6

former_member130219
Participant
0 Kudos

Hi Zubair

Following are some of the tables used in patient management.

NPAT Patient Master Data(general)

NPAE Patient Master Data(Institute related)

NFAL Cases

NGPA Business Partners(Referring Hospital)

NORG Organisational Units

NFPZ Assignment of a case to a person.

N1VKG Item of clinical order(Pre-registration)

NBEW Movements for Case

NADR Addresses(Central address management)

NFFZ Assignment of a case to a another case.

NGEB Birth data of new borns

NKSD Treatment certificate details

NKSK Insurance verification/certificate

NPER Persons(External physician,nurses).

Hope will help you.

0 Kudos

Hello,

I reached your reply from searching for some info about visit data. I use the TNMN table to look for a patient, episode and surgery visit, then I link the visit with the NAPP to obtain the details: TNMN.TNMID = NAPP.LNRAPP, however I still cannot link the info about the surgerian which is recorded both in the tables "N1LSTEAM" and "NPLZ". I see the better way is to link with N1LSTEAM.LNRLS but I don't know what other table will have the clear reference to that field.

0 Kudos

Hi Zubair

To access to table NFPZ - where the phisicians are related to cases an movements you should do the following.

Read NTMN an take the FALNR and TMNLB (Movement Number)

Then go table NFPZ where falnr = ntmn-falnr and LFDBW = ntmn-tmnlb.

Please, try with that query and let me know.

With best regards

Matías

0 Kudos

Excelente, Matías!

Muchas gracias!

alejandro_bindi
Active Contributor
0 Kudos

Some additional important ones:

N1CORDER IS-H: Clinical Order

NAPP IS-H: Provisional appointments for visit planning

NBAU IS-H: Building Units

NLEI IS-H: Services Performed

NLEM IS-H*MED: Medical Service

NTMN IS-H: Patient-Specific Appointments (Header Table for NAPP)

NTPK IS-H: Header Data of Service Item

0 Kudos

Hi

Can I know the list of tables in ecc for clinical trials

For related data below

Patient data

Descripancy

Study data

Site

Users

Event

Audit

Organisations