SAP ABAP Table ENT7611 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure ENT7611   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster NPAT    
Delivery Class      
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
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 EINRI EINRI EINRI CHAR 4   0   IS-H: Institution TN01
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 NNAMS NNAMES_PAT CHAR30 CHAR 30   0   IS-H: Standardized Last Name  
7 VNAME VNAME_PAT TEXT30 CHAR 30   0   IS-H: Patient First Name  
8 VNAMS VNAMES_PAT CHAR30 CHAR 30   0   Standardized First Name  
9 TITEL RI_TITEL TITEL CHAR 15   0   IS-H: Title  
10 NAMZU RI_NAMZU TITEL CHAR 15   0   IS-H: Name Affix  
11 VORSW RI_VORSW TITEL CHAR 15   0   IS-H: Name Prefix  
12 NAME2 NAME2_PAT TEXT30 CHAR 30   0   Pseudonym, Order Name  
13 GBDAT RI_GBDAT RI_DATUM DATS 8   0   IS-H: Birthdate  
14 GBNAM GBNAM TEXT30 CHAR 30   0   IS-H: Birthname  
15 GBNAS GBNAMS_PAT CHAR30 CHAR 30   0   IS-H: Standardized Birthname  
16 GLAND GLAND LAND1 CHAR 3   0   IS-H: Country of Birth T005
17 TODKZ PAT_TOD XFELD CHAR 1   0   IS-H: Patient Is Deceased  
18 TODDT TODDV RI_DATUM DATS 8   0   IS-H: Date of Death From  
19 TODZT TODZV UHRZT TIMS 6   0   Time of Death From  
20 TODDB TODDB RI_DATUM DATS 8   0   Date of Death To  
21 TODZB TODZB UHRZT TIMS 6   0   IS-H: Time of Death To  
22 TODUR TODUR TODUR CHAR 3   0   IS-H: Cause of Death TN18A
23 ANRED RI_ANRDS RI_ANRDS CHAR 2   0   IS-H: Form-of-Address Key  
24 FAMST RI_FAMST RI_FAMST CHAR 1   0   IS-H: Marital Status  
25 KONFE RI_KONFE RI_KONFE CHAR 2   0   IS-H: Religion  
26 NATIO RI_NATIO LAND1 CHAR 3   0   IS-H: Nationality T005
27 SPRAS SPRAS_PAT SPRAS LANG 1   0   Patient Language T002
28 LAND LAND_PAT LAND1 CHAR 3   0   IS-H: Country of patient's place of residence T005
29 PSTLZ PSTLZ_PAT PSTLZ CHAR 10   0   IS-H: Patient Postal Code  
30 ORT ORT01_PAT TEXT25 CHAR 25   0   IS-H: City where Patient Resides  
31 ORT2 ORT02_PAT TEXT25 CHAR 25   0   Patient District  
32 STRAS STRAS_PAT STRAS CHAR 30   0   IS-H: Street and House Number of Patient  
33 BLAND ISH_REGION REGIO CHAR 3   0   IS-H: Region (Federal State, Province, County) T005S
34 GEBIE EINZGEBIET EINZGEBIET CHAR 9   0   IS-H: Geographical Area  
35 TELF1 TELF_PAT TEXT16 CHAR 16   0   IS-H: Patient Telephone Number  
36 SPEND SPENKZ XFELD CHAR 1   0   IS-H: Organ Donor Indicator  
37 SPENT SPENTEXT TEXT50 CHAR 50   0   Explanation for Donor Indicator  
38 SPELT RI_LGTXT XFELD CHAR 1   0   Indicator that Long Text Exists  
39 VIPKZ VIPKZ XFELD CHAR 1   0   IS-H: VIP Indicator  
40 ARCHV ARCHIV XFELD CHAR 1   0   IS-H: Archived Data Indicator  
41 STATU PAT_STATUS PAT_STATUS CHAR 1   0   Patient Status  
42 EXTNR EXT_PATNR EXT_PATNR CHAR 20   0   IS-H: External Patient Identification  
43 NOTAN NOTAUF XFELD CHAR 1   0   IS-H: Emergency Admission Indicator  
44 KRZAN KURZAUF XFELD CHAR 1   0   IS-H: Quick Admission Indicator  
45 RFZIF PZIFF_PAT PZIFF CHAR 1   0   IS-H: Check Digit for Patient  
46 BERUF BERUF TEXT25 CHAR 25   0   IS-H: Patient Occupation  
47 AGNUM AGNUM_PAT RI_KUNNR CHAR 10   0   IS-H: Patient's Employer NGPA
48 AGNAM AGNAM TEXT30 CHAR 30   0   IS-H: Employer Name  
49 AGLAN AGLAN LAND1 CHAR 3   0   IS-H: Employer Country T005
50 AGPLZ AGPLZ PSTLZ CHAR 10   0   IS-H: Employer Postal Code  
51 AGORT AGORT TEXT25 CHAR 25   0   IS-H: Employer City  
52 AGSTR AGSTR STRAS CHAR 30   0   IS-H: Employer Street  
53 AGTEL AGTEL TEXT16 CHAR 16   0   IS-H: Employer Telephone Number  
54 RVNUM ISH_RVNUM ISH_SVNUM CHAR 20   0   IS-H: Social Insurance Number  
55 ANNA1 NNAME_ANG TEXT30 CHAR 30   0   IS-H: Last Name of Person to Be Contacted  
56 ANVN1 VNAME_ANG TEXT30 CHAR 30   0   IS-H: First Name of Person to Be Contacted  
57 ANLA1 LAND_ANG LAND1 CHAR 3   0   Country of the Person to Be Contacted T005
58 ANPL1 PSTLZ_ANG PSTLZ CHAR 10   0   IS-H: Postal Code  
59 ANOR1 ORT01_ANG TEXT25 CHAR 25   0   IS-H: City where Person to Be Contacted Resides  
60 ANST1 STRAS_ANG STRAS CHAR 30   0   IS-H: Street and House Number of Person to Be Contacted  
61 ANTE1 TELF_ANG TEXT16 CHAR 16   0   IS-H: Telephone Number of Person to Be Contacted  
62 ANVV1 VERWVH VERWVH CHAR 1   0   IS-H: Relationship TN17B
63 VMKZ1 VORMUND XFELD CHAR 1   0   IS-H: Legal Representative  
64 ANNA2 NNAME_ANG TEXT30 CHAR 30   0   IS-H: Last Name of Person to Be Contacted  
65 ANVN2 VNAME_ANG TEXT30 CHAR 30   0   IS-H: First Name of Person to Be Contacted  
66 ANLA2 LAND_ANG LAND1 CHAR 3   0   Country of the Person to Be Contacted T005
67 ANPL2 PSTLZ_ANG PSTLZ CHAR 10   0   IS-H: Postal Code  
68 ANOR2 ORT01_ANG TEXT25 CHAR 25   0   IS-H: City where Person to Be Contacted Resides  
69 ANST2 STRAS_ANG STRAS CHAR 30   0   IS-H: Street and House Number of Person to Be Contacted  
70 ANTE2 TELF_ANG TEXT16 CHAR 16   0   IS-H: Telephone Number of Person to Be Contacted  
71 ANVV2 VERWVH VERWVH CHAR 1   0   IS-H: Relationship TN17B
72 VMKZ2 VORMUND XFELD CHAR 1   0   IS-H: Legal Representative  
73 KZTXT TEXT_PAT TEXT50 CHAR 50   0   IS-H: Comment on Patient  
74 LGTXT RI_LGTXT XFELD CHAR 1   0   Indicator that Long Text Exists  
75 BEGDT RI_BEGDT RI_DATUM DATS 8   0   IS-H: Valid-From Date of Record  
76 ENDDT RI_ENDDT RI_DATUM DATS 8   0   IS-H: Valid-To Date of Record  
77 HISTK RI_HISTK XFELD CHAR 1   0   Indicator that History Records Are Available  
78 RISKF ISH_RISIKO XFELD CHAR 1   0   IS-H: Risk Information Exists for the Patient  
79 TESTP TESTP XFELD CHAR 1   0   Test Patient Status  
80 PZIFF PZIFF_PAT PZIFF CHAR 1   0   IS-H: Check Digit for Patient  
81 ERDAT RI_ERDAT RI_DATUM DATS 8   0   IS-H: Date when Record Created  
82 ERUSR RI_ERNAM USNAM CHAR 12   0   IS-H: Name of Employee who Created Record  
83 UPDAT RI_UPDAT RI_DATUM DATS 8   0   IS-H: Date of Last Change  
84 UPUSR RI_UPNAM USNAM CHAR 12   0   IS-H: Name of Person who Last Changed Data  
85 STORN RI_STORN XFELD CHAR 1   0   IS-H: Cancellation Indicator  
86 STUSR STORN_USER USNAM CHAR 12   0   IS-H: Name of User who Canceled Data Record  
87 STDAT STORN_DAT RI_DATUM DATS 8   0   Date of Cancellation  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ENT7611 AGLAN T005 LAND1 REF 1 CN
2 ENT7611 AGNUM NGPA GPART REF 1 CN
3 ENT7611 ANLA1 T005 LAND1 REF 1 CN
4 ENT7611 ANLA2 T005 LAND1 REF 1 CN
5 ENT7611 ANVV1 TN17B VERVA REF 1 CN
6 ENT7611 ANVV2 TN17B VERVA REF 1 CN
7 ENT7611 BLAND T005S BLAND REF 1 CN
8 ENT7611 EINRI TN01 EINRI REF 1 CN
9 ENT7611 GLAND T005 LAND1 REF 1 CN
10 ENT7611 LAND T005 LAND1 REF 1 CN
11 ENT7611 MANDT T000 MANDT KEY 1 CN
12 ENT7611 NATIO T005 LAND1 REF 1 CN
13 ENT7611 SPRAS T002 SPRAS REF 1 CN
14 ENT7611 TODUR TN18A TODUR REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in