SAP ABAP Table U_17680 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_17680	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	ORGID	☑	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key
3	ORGTY	☐	ORGTYP	ORGTYP	CHAR	2	0	IS-H: Category of Organizational Unit	TN10A
4	ORGNA	☐	ORGNA	TEXT30	CHAR	30	0	IS-H: Organizational Unit Name
5	ORGZU	☐	ORGZU	TEXT30	CHAR	30	0	IS-H: Additional Name of Organizational Unit
6	ORGKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
7	OKURZ	☐	OEKURZ	ORGKZ	CHAR	5	0	IS-H: Identifier of Organizational Unit in the Application
8	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
9	ARCHV	☐	ARCHIV	XFELD	CHAR	1	0	IS-H: Archived Data Indicator
10	LAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
11	PSTLZ	☐	RI_PLZ	PSTLZ	CHAR	10	0	IS-H: Postal Code
12	ORT	☐	ORT01	TEXT25	CHAR	25	0	City
13	STRAS	☐	STRAS_ORG	TEXT30	CHAR	30	0	IS-H: Street and Street Number of Organizational Unit
14	TELNR	☐	TELF_ORG	TEXT16	CHAR	16	0	IS-H: Telephone Number of Organizational Unit
15	TELFX	☐	TELFX_ORG	TEXT31	CHAR	31	0	Fax Number of Organizational Unit
16	TELTX	☐	TELTX_ORG	TEXT30	CHAR	30	0	IS-H: Teletex number of organizational unit
17	KZTXT	☐	TEXT_ORG	TEXT50	CHAR	50	0	IS-H: Comment on Organizational Unit
18	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
19	SPERR	☐	RI_SPERR	XFELD	CHAR	1	0	Blocking Indicator
20	BEGDT	☐	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
21	ENDDT	☐	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
22	BELEG	☐	RI_BELKZ	XFELD	CHAR	1	0	IS-H: OU May Assign Patients to Beds on OU of Other Dept
23	FREIG	☐	FREIG	XFELD	CHAR	1	0	IS-H: Release Indicator
24	AUFKZ	☐	ORGAUF	XFELD	CHAR	1	0	IS-H: Admitting Facility Indicator
25	INTKZ	☐	RI_INTKZ	XFELD	CHAR	1	0	IS-H: OU Can Be Assigned Patients From Other Department
26	INTEN	☐	ISH_INTENS	XFELD	CHAR	1	0	IS-H: Intensive Care Indicator of Organizational Unit
27	ORGDS	☐	ORGDS	XFELD	CHAR	1	0	IS-H: Data Protection Applies to OU
28	PPRKZ	☐	ISH_PPRKZ	XFELD	CHAR	1	0	IS-H: OU Excluded from Nursing Acuity Classification
29	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
30	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
31	LODAT	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
32	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
33	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
34	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
35	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
36	SPVON	☐	ISH_SPERRV	RI_DATUM	DATS	8	0	IS-H: Blocking Date from (Entry Block)
37	SPBIS	☐	ISH_SPERRB	RI_DATUM	DATS	8	0	IS-H: Blocking Date To (Entry Block To)
38	PAEDKZ	☐	ISH_PAED	ISH_XFELD	CHAR	1	0	IS-H: Indicator for Pediatrics
39	KSTKZ	☐	ISH_KSTKZ	XFELD	CHAR	1	0	IS-H: Allocation Indicator Cost Center
40	TALST	☐	TARLS	TARLS	CHAR	10	0	IS-H: Service in Service Catalog
41	FACHR1	☐	FACHRTY0	ISH_FACHR	CHAR	4	0	IS-H: Specialty According to Fed. Reg. Hosp. 1995 (Germany)
42	FACHR4	☐	FACHRTY4	ISH_FACHR	CHAR	4	0	IS-H: Specialty according to Krazaf (Austria)
43	FACHR5	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty
44	FACHRA	☐	FACHRTY9	ISH_FACHR	CHAR	4	0	IS-H: Specialty - User-Definable
45	FACHRB	☐	FACHRTY9	ISH_FACHR	CHAR	4	0	IS-H: Specialty - User-Definable
46	FACHRC	☐	FACHRTY9	ISH_FACHR	CHAR	4	0	IS-H: Specialty - User-Definable
47	FACHR6	☐	FACHRTY6	ISH_FACHR	CHAR	4	0	IS-H: Specialty according to POLIS (Netherlands)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_17680	EINRI	TN01	EINRI	REF	1	CN
2	U_17680	LAND	T005	LAND1	KEY	1	CN
3	U_17680	MANDT	T000	MANDT	KEY	1	CN
4	U_17680	ORGTY	TN10A	ORGTY	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in