SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

NPAT Table in SAP | IS-H: Patient Master Data (General) Table & Fields List

NPAT is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of NPAT in SAP.

  • Table description : IS-H: Patient Master Data (General)
  • Module : CRM
  • Parent Module : CRM
  • Package : NPVS
  • Software Component : BBPCRM
NPAT table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP NPAT Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
PATNRIS-H: Patient NumberPATNRPATNR
EINRIIS-H: InstitutionEINRIEINRI
GSCHLIS-H: Sex Indicator - InternalGSCHLGSCHL
NNAMEIS-H: Patient Last NameNNAME_PATTEXT30
NNAMSIS-H: Standardized Last NameNNAMES_PATCHAR30
VNAMEIS-H: Patient First NameVNAME_PATTEXT30
VNAMSStandardized First NameVNAMES_PATCHAR30
TITELIS-H: TitleRI_TITELTITEL
NAMZUIS-H: Name AffixRI_NAMZUTITEL
VORSWIS-H: Name PrefixRI_VORSWTITEL
NAME2Pseudonym, Order NameNAME2_PATTEXT30
GBDATIS-H: BirthdateRI_GBDATRI_DATUM
GBNAMIS-H: BirthnameGBNAMTEXT30
GBNASIS-H: Standardized BirthnameGBNAMS_PATCHAR30
GLANDIS-H: Country of BirthGLANDLAND1
TODKZIS-H: Patient Is DeceasedPAT_TODXFELD
TODDTIS-H: Date of Death FromTODDVRI_DATUM
TODZTTime of Death FromTODZVUHRZT
TODDBDate of Death ToTODDBRI_DATUM
TODZBIS-H: Time of Death ToTODZBUHRZT
TODURIS-H: Cause of DeathTODURTODUR
ANREDIS-H: Form-of-Address KeyRI_ANRDSRI_ANRDS
FAMSTIS-H: Marital StatusRI_FAMSTRI_FAMST
KONFEIS-H: ReligionRI_KONFERI_KONFE
NATIOIS-H: NationalityRI_NATIOLAND1
SPRASPatient LanguageSPRAS_PATSPRAS
LANDIS-H: Country of patient's place of residenceLAND_PATLAND1
PSTLZIS-H: Patient Postal CodePSTLZ_PATPSTLZ
ORTIS-H: City where Patient ResidesORT01_PATTEXT25
ORT2Patient DistrictORT02_PATTEXT25
STRASIS-H: Street and House Number of PatientSTRAS_PATSTRAS
BLANDIS-H: Region (Federal State, Province, County)ISH_REGIONREGIO
GEBIEIS-H: Geographical AreaEINZGEBIETEINZGEBIET
TELF1IS-H: Patient Telephone NumberTELF_PATTEXT16
SPENDIS-H: Organ Donor IndicatorSPENKZXFELD
SPENTExplanation for Donor IndicatorSPENTEXTTEXT50
SPELTIndicator that Long Text ExistsRI_LGTXTXFELD
VIPKZIS-H: VIP IndicatorVIPKZXFELD
ARCHVIS-H: Archived Data IndicatorARCHIVXFELD
STATUPatient StatusPAT_STATUSPAT_STATUS
EXTNRIS-H: External Patient IdentificationEXT_PATNREXT_PATNR
NOTANIS-H: Emergency Admission IndicatorNOTAUFXFELD
KRZANIS-H: Quick Admission IndicatorKURZAUFXFELD
RFPATReference to Patient Number in MergingRFPATPATNR
RFZIFIS-H: Check Digit for PatientPZIFF_PATPZIFF
BERUFIS-H: Patient OccupationBERUFTEXT25
AGNUMIS-H: Patient's EmployerAGNUM_PATRI_KUNNR
AGNAMIS-H: Employer NameAGNAMTEXT30
AGLANIS-H: Employer CountryAGLANLAND1
AGPLZIS-H: Employer Postal CodeAGPLZPSTLZ
AGORTIS-H: Employer CityAGORTTEXT25
AGSTRIS-H: Employer StreetAGSTRSTRAS
AGTELIS-H: Employer Telephone NumberAGTELTEXT16
RVNUMIS-H: Social Insurance NumberISH_RVNUMISH_SVNUM
ANNA1IS-H: Last Name of Person to Be ContactedNNAME_ANGTEXT30
ANVN1IS-H: First Name of Person to Be ContactedVNAME_ANGTEXT30
ANLA1Country of the Person to Be ContactedLAND_ANGLAND1
ANPL1IS-H: Postal CodePSTLZ_ANGPSTLZ
ANOR1IS-H: City where Person to Be Contacted ResidesORT01_ANGTEXT25
ANST1IS-H: Street and House Number of Person to Be ContactedSTRAS_ANGSTRAS
ANTE1IS-H: Telephone Number of Person to Be ContactedTELF_ANGTEXT16
ANVV1IS-H: RelationshipVERWVHVERWVH
VMKZ1IS-H: Legal RepresentativeVORMUNDXFELD
ANNA2IS-H: Last Name of Person to Be ContactedNNAME_ANGTEXT30
ANVN2IS-H: First Name of Person to Be ContactedVNAME_ANGTEXT30
ANLA2Country of the Person to Be ContactedLAND_ANGLAND1
ANPL2IS-H: Postal CodePSTLZ_ANGPSTLZ
ANOR2IS-H: City where Person to Be Contacted ResidesORT01_ANGTEXT25
ANST2IS-H: Street and House Number of Person to Be ContactedSTRAS_ANGSTRAS
ANTE2IS-H: Telephone Number of Person to Be ContactedTELF_ANGTEXT16
ANVV2IS-H: RelationshipVERWVHVERWVH
VMKZ2IS-H: Legal RepresentativeVORMUNDXFELD
KZTXTIS-H: Comment on PatientTEXT_PATTEXT50
LGTXTIndicator that Long Text ExistsRI_LGTXTXFELD
BEGDTIS-H: Valid-From Date of RecordRI_BEGDTRI_DATUM
ENDDTIS-H: Valid-To Date of RecordRI_ENDDTRI_DATUM
HISTKIndicator that History Records Are AvailableRI_HISTKXFELD
RISKFIS-H: Risk Information Exists for the PatientISH_RISIKOXFELD
TESTPTest Patient StatusTESTPXFELD
PZIFFIS-H: Check Digit for PatientPZIFF_PATPZIFF
ERDATIS-H: Date when Record CreatedRI_ERDATRI_DATUM
ERUSRIS-H: Name of Employee who Created RecordRI_ERNAMUSNAM
UPDATIS-H: Date of Last ChangeRI_UPDATRI_DATUM
UPUSRIS-H: Name of Person who Last Changed DataRI_UPNAMUSNAM
STORNIS-H: Cancellation IndicatorRI_STORNXFELD
STUSRIS-H: Name of User who Canceled Data RecordSTORN_USERUSNAM
STDATDate of CancellationSTORN_DATRI_DATUM
GBORTIS-H: Patient BirthplaceISH_GBORTTEXT25
HARNRIS-H: Personnel Number of Family PhysicianHARNRRI_KUNNR
EARNRIS-H: Personnel Number of Referring PhysicianEARNRRI_KUNNR
UARNRIS-H: Personnel Number of Referring PhysicianUARNRRI_KUNNR
RACEIS-H: RaceISH_RACEISH_RACE
RESIDIS-H: Indicator that Patient is Non-ResidentISH_RESIDXFELD
PASSTYType of Identification DocumentISH_PASSTYISH_PASSTY
PASSNRIS-H: Identification Document NumberISH_PASSNRISH_PASSNR
ADRNRIS-H: Address NumberISH_ADRNRISH_ADRNR
ADROBIS-H: Address ObjectISH_ADROBJISH_ADROBJ
ADNAGIS-H: Address NumberISH_ADRNRISH_ADRNR
ADOAGIS-H: Address ObjectISH_ADROBJISH_ADROBJ
ADNN1IS-H: Address NumberISH_ADRNRISH_ADRNR
ADON1IS-H: Address ObjectISH_ADROBJISH_ADROBJ
ADNN2IS-H: Address NumberISH_ADRNRISH_ADRNR
ADON2IS-H: Address ObjectISH_ADROBJISH_ADROBJ
ANEX1IS-H: External Identification of Next of Kin/Assoc. PartyEXTNR_ANGEXT_PATNR
ANEX2IS-H: External Identification of Next of Kin/Assoc. PartyEXTNR_ANGEXT_PATNR
ADRN2IS-H: Address NumberISH_ADRNRISH_ADRNR
ADRO2IS-H: Address ObjectISH_ADROBJISH_ADROBJ
INACT'Inactive' IndicatorISH_INACTIVEXFELD
USER1IS-H: User-Defined Field 1ISH_PATUSER1ISH_PATUSER1
USER2IS-H: User-Defined Field 2ISH_PATUSER2ISH_PATUSER2
USER3IS-H: User-Defined Field 3ISH_PATUSER3ISH_PATUSER3
USER4IS-H: User-Defined Field 4ISH_PATUSER4ISH_PATUSER4
USER5IS-H: User-Defined Field 5ISH_PATUSER5ISH_PATUSER5
USER6IS-H: User-Defined Field 6ISH_PATUSER6ISH_PATUSER6
EXTAUFGIS-H: Kennzeichen externer AuftraggeberEXTAUFGXFELD
EXTAUFGAIS-H: EA Externe AuftraggeberartEXTAUFGAEXTAUFGA
EMPSCIS-H: Employed SinceISH_EMPDATRI_DATUM
UNKNOWN_GBDATGeburtsdatum nicht genau bekanntISH_UNKNOWN_GBDATISH_UNKNOWN_GBDAT
INSIDDE: Eindeutige Versichertennummer (EGK)ISH_VERS_NR  

NPAT related tables

TableNote
NPATIS-H: Patient Master Data (General)
NPAEIS-H: Patient master data (institution-related)
NPAPIS-H: Provisional Patient Master Data
N1PATMIS-H*MED: Medical Patient Master Record
CRMM_ISH_CASEPatient Data for Business Partner
CRMM_ISH_PATPatient Data for Business Partner
ISH_PATIENTAHealthcare BP: Patient Data
N1MEDOBSOLETE: Patient-Related Medication Data for a Prescription
N1RISMISIS-H*MED: Data transfer error (case - patient)
NEHC_PATIS-H: Health Insurance Card (Patient Data)
CRM_ISH_SERPatient Service Information
CRM_ISH_SERHPatient Service Information
CRM_ISH_SER_GRPatient Service Group
CRM_ISH_SER_GRHPatient Service Group
N1FPVIS-H*MED: Patient Transport Service - Available Transporters
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com