ENT7611 SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
ENT7611 is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The ENT7611 table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include PATNR (IS-H: Patient Number), EINRI (Institution), GSCHL (IS-H: Sex Indicator - Internal), NNAME (Patient Last Name).. 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: Not classified
SAP ENT7611 table view 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | ALPHA | PATNR | PAT | ||
EINRI | Institution | EINRI | CHAR | 4 | TN01 | ALPHA | EINRI | EIN | |
GSCHL | IS-H: Sex Indicator - Internal | GSCHL | CHAR | 1 | GSCHL | ||||
NNAME | Patient Last Name | NNAME_PAT | CHAR | 30 | TEXT30 | ||||
NNAMS | IS-H: Standardized Last Name | NNAMES_PAT | CHAR | 30 | CHAR30 | ||||
VNAME | IS-H: Patient First Name | VNAME_PAT | CHAR | 30 | TEXT30 | ||||
VNAMS | Standardized First Name | VNAMES_PAT | CHAR | 30 | CHAR30 | ||||
TITEL | IS-H: Title | RI_TITEL | CHAR | 15 | TITEL | ||||
NAMZU | IS-H: Name Affix | RI_NAMZU | CHAR | 15 | TITEL | ||||
VORSW | IS-H: Name Prefix | RI_VORSW | CHAR | 15 | TITEL | ||||
NAME2 | Pseudonym, Order Name | NAME2_PAT | CHAR | 30 | TEXT30 | ||||
GBDAT | IS-H: Birthdate | RI_GBDAT | DATS | 8 | RI_DATUM | ||||
GBNAM | IS-H: Birthname | GBNAM | CHAR | 30 | TEXT30 | ||||
GBNAS | IS-H: Standardized Birthname | GBNAMS_PAT | CHAR | 30 | CHAR30 | ||||
GLAND | IS-H: Country of Birth | GLAND | CHAR | 3 | T005 | LAND1 | |||
TODKZ | IS-H: Patient Is Deceased | PAT_TOD | CHAR | 1 | XFELD | ||||
TODDT | IS-H: Date of Death From | TODDV | DATS | 8 | RI_DATUM | ||||
TODZT | Time of Death From | TODZV | TIMS | 6 | UHRZT | ||||
TODDB | Date of Death To | TODDB | DATS | 8 | RI_DATUM | ||||
TODZB | IS-H: Time of Death To | TODZB | TIMS | 6 | UHRZT | ||||
TODUR | IS-H: Cause of Death | TODUR | CHAR | 3 | TN18A | TODUR | |||
ANRED | IS-H: Form-of-Address Key | RI_ANRDS | CHAR | 2 | RI_ANRDS | ||||
FAMST | IS-H: Marital Status | RI_FAMST | CHAR | 1 | RI_FAMST | ||||
KONFE | IS-H: Religion | RI_KONFE | CHAR | 2 | RI_KONFE | ||||
NATIO | IS-H: Nationality | RI_NATIO | CHAR | 3 | T005 | LAND1 | |||
SPRAS | Patient Language | SPRAS_PAT | LANG | 1 | T002 | ISOLA | SPRAS | ||
LAND | IS-H: Country of patient's place of residence | LAND_PAT | CHAR | 3 | T005 | LAND1 | |||
PSTLZ | IS-H: Patient Postal Code | PSTLZ_PAT | CHAR | 10 | PSTLZ | ||||
ORT | IS-H: City where Patient Resides | ORT01_PAT | CHAR | 25 | TEXT25 | ||||
ORT2 | Patient District | ORT02_PAT | CHAR | 25 | TEXT25 | ||||
STRAS | IS-H: Street and House Number of Patient | STRAS_PAT | CHAR | 30 | STRAS | ||||
BLAND | IS-H: Region (Federal State, Province, County) | ISH_REGION | CHAR | 3 | T005S | REGIO | |||
GEBIE | IS-H: Geographical Area | EINZGEBIET | CHAR | 9 | EINZGEBIET | ||||
TELF1 | IS-H: Patient Telephone Number | TELF_PAT | CHAR | 16 | TEXT16 | ||||
SPEND | Organ Donor Indicator | SPENKZ | CHAR | 1 | XFELD | ||||
SPENT | Explanation for Donor Indicator | SPENTEXT | CHAR | 50 | TEXT50 | ||||
SPELT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
VIPKZ | IS-H: VIP Indicator | VIPKZ | CHAR | 1 | XFELD | ||||
ARCHV | IS-H: Archived Data Indicator | ARCHIV | CHAR | 1 | XFELD | ||||
STATU | Patient Status | PAT_STATUS | CHAR | 1 | PAT_STATUS | ||||
EXTNR | IS-H: External Patient Identification | EXT_PATNR | CHAR | 20 | EXT_PATNR | ||||
NOTAN | IS-H: Emergency Admission Indicator | NOTAUF | CHAR | 1 | XFELD | ||||
KRZAN | IS-H: Quick Admission Indicator | KURZAUF | CHAR | 1 | XFELD | ||||
RFZIF | Check Digit for Patient | PZIFF_PAT | CHAR | 1 | PZIFF | PZP | |||
BERUF | IS-H: Patient Occupation | BERUF | CHAR | 25 | TEXT25 | ||||
AGNUM | IS-H: Patient's Employer | AGNUM_PAT | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
AGNAM | IS-H: Employer Name | AGNAM | CHAR | 30 | TEXT30 | ||||
AGLAN | IS-H: Employer Country | AGLAN | CHAR | 3 | T005 | LAND1 | |||
AGPLZ | IS-H: Employer Postal Code | AGPLZ | CHAR | 10 | PSTLZ | ||||
AGORT | IS-H: Employer City | AGORT | CHAR | 25 | TEXT25 | ||||
AGSTR | IS-H: Employer Street | AGSTR | CHAR | 30 | STRAS | ||||
AGTEL | IS-H: Employer Telephone Number | AGTEL | CHAR | 16 | TEXT16 | ||||
RVNUM | IS-H: Social Insurance Number | ISH_RVNUM | CHAR | 20 | ISH_SVNUM | ||||
ANNA1 | IS-H: Last Name of Person to Be Contacted | NNAME_ANG | CHAR | 30 | TEXT30 | ||||
ANVN1 | IS-H: First Name of Person to Be Contacted | VNAME_ANG | CHAR | 30 | TEXT30 | ||||
ANLA1 | Country of the Person to Be Contacted | LAND_ANG | CHAR | 3 | T005 | LAND1 | |||
ANPL1 | IS-H: Postal Code | PSTLZ_ANG | CHAR | 10 | PSTLZ | ||||
ANOR1 | IS-H: City where Person to Be Contacted Resides | ORT01_ANG | CHAR | 25 | TEXT25 | ||||
ANST1 | IS-H: Street and House Number of Person to Be Contacted | STRAS_ANG | CHAR | 30 | STRAS | ||||
ANTE1 | IS-H: Telephone Number of Person to Be Contacted | TELF_ANG | CHAR | 16 | TEXT16 | ||||
ANVV1 | IS-H: Relationship | VERWVH | CHAR | 1 | TN17B | VERWVH | |||
VMKZ1 | IS-H: Legal Representative | VORMUND | CHAR | 1 | XFELD | ||||
ANNA2 | IS-H: Last Name of Person to Be Contacted | NNAME_ANG | CHAR | 30 | TEXT30 | ||||
ANVN2 | IS-H: First Name of Person to Be Contacted | VNAME_ANG | CHAR | 30 | TEXT30 | ||||
ANLA2 | Country of the Person to Be Contacted | LAND_ANG | CHAR | 3 | T005 | LAND1 | |||
ANPL2 | IS-H: Postal Code | PSTLZ_ANG | CHAR | 10 | PSTLZ | ||||
ANOR2 | IS-H: City where Person to Be Contacted Resides | ORT01_ANG | CHAR | 25 | TEXT25 | ||||
ANST2 | IS-H: Street and House Number of Person to Be Contacted | STRAS_ANG | CHAR | 30 | STRAS | ||||
ANTE2 | IS-H: Telephone Number of Person to Be Contacted | TELF_ANG | CHAR | 16 | TEXT16 | ||||
ANVV2 | IS-H: Relationship | VERWVH | CHAR | 1 | TN17B | VERWVH | |||
VMKZ2 | IS-H: Legal Representative | VORMUND | CHAR | 1 | XFELD | ||||
KZTXT | IS-H: Comment on Patient | TEXT_PAT | CHAR | 50 | TEXT50 | ||||
LGTXT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
BEGDT | IS-H: Valid-From Date of Record | RI_BEGDT | DATS | 8 | RI_DATUM | ||||
ENDDT | IS-H: Valid-To Date of Record | RI_ENDDT | DATS | 8 | RI_DATUM | ||||
HISTK | Indicator that History Records Are Available | RI_HISTK | CHAR | 1 | XFELD | ||||
RISKF | IS-H: Risk Information Exists for the Patient | ISH_RISIKO | CHAR | 1 | XFELD | ||||
TESTP | Test Patient Status | TESTP | CHAR | 1 | XFELD | ||||
PZIFF | Check Digit for Patient | PZIFF_PAT | CHAR | 1 | PZIFF | PZP | |||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | XFELD | ||||
STUSR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | USNAM | ||||
STDAT | Date of Cancellation | STORN_DAT | DATS | 8 | RI_DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table ENT7611 using ABAP code
The following ABAP code Example will allow you to do a basic selection on ENT7611 to SELECT all data from the tableDATA: WA_ENT7611 TYPE ENT7611.
SELECT SINGLE *
FROM ENT7611
INTO CORRESPONDING FIELDS OF WA_ENT7611
WHERE...
How to access SAP table ENT7611
Within an ECC or HANA version of SAP you can also view further information about ENT7611 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects