SAP ABAP Table BW_HC_NPAT (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure BW_HC_NPAT   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 PATNR PATNR PATNR CHAR 10   0   IS-H: Patient Number  
3 LANGU EINR_SPRAS SPRAS LANG 1   0   IS-H: Language of Institution T002
4 GSCHL GSCHL GSCHL CHAR 1   0   IS-H: Sex Indicator - Internal  
5 NNAME NNAME_PAT TEXT30 CHAR 30   0   IS-H: Patient Last Name  
6 VNAME VNAME_PAT TEXT30 CHAR 30   0   IS-H: Patient First Name  
7 TITEL RI_TITEL TITEL CHAR 15   0   IS-H: Title  
8 NAMZU RI_NAMZU TITEL CHAR 15   0   IS-H: Name Affix  
9 VORSW RI_VORSW TITEL CHAR 15   0   IS-H: Name Prefix  
10 NAME2 NAME2_PAT TEXT30 CHAR 30   0   Pseudonym, Order Name  
11 GBDAT RI_GBDAT RI_DATUM DATS 8   0   IS-H: Birthdate  
12 GBNAM GBNAM TEXT30 CHAR 30   0   IS-H: Birthname  
13 GLAND GLAND LAND1 CHAR 3   0   IS-H: Country of Birth T005
14 TODKZ PAT_TOD XFELD CHAR 1   0   IS-H: Patient Is Deceased  
15 TODDB TODDB RI_DATUM DATS 8   0   Date of Death To  
16 TODDT TODDV RI_DATUM DATS 8   0   IS-H: Date of Death From  
17 TODZT TODZV UHRZT TIMS 6   0   Time of Death From  
18 TODZB TODZB UHRZT TIMS 6   0   IS-H: Time of Death To  
19 TODUR TODUR TODUR CHAR 3   0   IS-H: Cause of Death TN18A
20 ANRED RI_ANRDS RI_ANRDS CHAR 2   0   IS-H: Form-of-Address Key  
21 FAMST RI_FAMST RI_FAMST CHAR 1   0   IS-H: Marital Status  
22 KONFE RI_KONFE RI_KONFE CHAR 2   0   IS-H: Religion  
23 NATIO RI_NATIO LAND1 CHAR 3   0   IS-H: Nationality T005
24 SPRAS SPRAS_PAT SPRAS LANG 1   0   Patient Language T002
25 GEBIE EINZGEBIET EINZGEBIET CHAR 9   0   IS-H: Geographical Area  
26 SPEND SPENKZ XFELD CHAR 1   0   IS-H: Organ Donor Indicator  
27 SPENT SPENTEXT TEXT50 CHAR 50   0   Explanation for Donor Indicator  
28 VIPKZ VIPKZ XFELD CHAR 1   0   IS-H: VIP Indicator  
29 ARCHV ARCHIV XFELD CHAR 1   0   IS-H: Archived Data Indicator  
30 NOTAN NOTAUF XFELD CHAR 1   0   IS-H: Emergency Admission Indicator  
31 KRZAN KURZAUF XFELD CHAR 1   0   IS-H: Quick Admission Indicator  
32 BERUF BERUF TEXT25 CHAR 25   0   IS-H: Patient Occupation  
33 AGNUM AGNUM_PAT RI_KUNNR CHAR 10   0   IS-H: Patient's Employer NGPA
34 AGNAM AGNAM TEXT30 CHAR 30   0   IS-H: Employer Name  
35 RVNUM ISH_RVNUM ISH_SVNUM CHAR 20   0   IS-H: Social Insurance Number  
36 BEGDT RI_BEGDT RI_DATUM DATS 8   0   IS-H: Valid-From Date of Record  
37 ENDDT RI_ENDDT RI_DATUM DATS 8   0   IS-H: Valid-To Date of Record  
38 PZIFF PZIFF_PAT PZIFF CHAR 1   0   IS-H: Check Digit for Patient  
39 GBORT ISH_GBORT TEXT25 CHAR 25   0   IS-H: Patient Birthplace  
40 HARNR HARNR RI_KUNNR CHAR 10   0   IS-H: Personnel Number of Family Physician NGPA
41 EARNR EARNR RI_KUNNR CHAR 10   0   IS-H: Personnel Number of Referring Physician NGPA
42 UARNR UARNR RI_KUNNR CHAR 10   0   IS-H: Personnel Number of Referring Physician NGPA
43 RACE ISH_RACE ISH_RACE CHAR 2   0   IS-H: Race TN17R
44 RESID ISH_RESID XFELD CHAR 1   0   IS-H: Indicator that Patient is Non-Resident  
45 PASSTY ISH_PASSTY ISH_PASSTY CHAR 2   0   Type of Identification Document TN17D
46 PASSNR ISH_PASSNR ISH_PASSNR CHAR 15   0   IS-H: Identification Document Number  
47 EINRI EINRI EINRI CHAR 4   0   IS-H: Institution TN01
48 PFORT PFORT XFELD CHAR 1   0   IS-H: Patient Does not Appear in Public List  
49 PFAKZ PFAKZ XFELD CHAR 1   0   IS-H: Religious List Indicator  
50 PFARR PFARR PFARR CHAR 2   0   IS-H: Parish TN13A
51 STATU PAT_STATUS PAT_STATUS CHAR 1   0   Patient Status  
52 SZVOR SZVOR XFELD CHAR 1   0   IS-H: Company code for self-pay patient IR available  
53 STORN RI_STORN XFELD CHAR 1   0   IS-H: Cancellation Indicator  
54 STUSR STORN_USER USNAM CHAR 12   0   IS-H: Name of User who Canceled Data Record  
55 STDAT STORN_DAT RI_DATUM DATS 8   0   Date of Cancellation  
56 ERDAT RI_ERDAT RI_DATUM DATS 8   0   IS-H: Date when Record Created  
57 ERUSR RI_ERNAM USNAM CHAR 12   0   IS-H: Name of Employee who Created Record  
58 UPDAT RI_UPDAT RI_DATUM DATS 8   0   IS-H: Date of Last Change  
59 UPUSR RI_UPNAM USNAM CHAR 12   0   IS-H: Name of Person who Last Changed Data  
60 EXTNR EXT_PATNR EXT_PATNR CHAR 20   0   IS-H: External Patient Identification  
61 VMKZ1 VORMUND XFELD CHAR 1   0   IS-H: Legal Representative  
62 VMKZ2 VORMUND XFELD CHAR 1   0   IS-H: Legal Representative  
63 RISKF ISH_RISIKO XFELD CHAR 1   0   IS-H: Risk Information Exists for the Patient  
64 ADRNR ISH_ADRNR ISH_ADRNR CHAR 10   0   IS-H: Address Number NADR
65 ADROB ISH_ADROBJ ISH_ADROBJ CHAR 4   0   IS-H: Address Object  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BW_HC_NPAT ADRNR NADR ADRNR REF 1 C
2 BW_HC_NPAT AGNUM NGPA GPART REF 1 CN
3 BW_HC_NPAT EARNR NGPA GPART REF 1 CN
4 BW_HC_NPAT EINRI TN01 EINRI KEY 1 CN
5 BW_HC_NPAT GLAND T005 LAND1 REF 1 CN
6 BW_HC_NPAT HARNR NGPA GPART REF 1 CN
7 BW_HC_NPAT LANGU T002 SPRAS KEY 1 CN
8 BW_HC_NPAT MANDT T000 MANDT KEY 1 CN
9 BW_HC_NPAT NATIO T005 LAND1 REF 1 CN
10 BW_HC_NPAT PASSTY TN17D PASSTY REF 1 CN
11 BW_HC_NPAT PFARR TN13A PFARR REF 1 CN
12 BW_HC_NPAT RACE TN17R RACE REF 1 CN
13 BW_HC_NPAT SPRAS T002 SPRAS REF 1 CN
14 BW_HC_NPAT TODUR TN18A TODUR REF 1 CN
15 BW_HC_NPAT UARNR NGPA GPART REF 1 CN
History
Last changed by/on SAP  20131127 
SAP Release Created in