SAP ABAP Table BW_HC_NORG (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BW_HC_NORG	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	FACHR	☐	FACHRTY1	ISH_FACHR	CHAR	4	0	IS-H: Specialty acc. to Federal Reg. for Hospitals (Germany)
20	FACHR2	☐	FACHRTY2	ISH_FACHR	CHAR	4	0	IS-H: Specialty acc. to German Statistical Regulatory Req.
21	FACHR3	☐	FACHRTY3	ISH_FACHR	CHAR	4	0	IS-H: Specialty according to Nursing Staff Regulation
22	SPERR	☐	RI_SPERR	XFELD	CHAR	1	0	Blocking Indicator
23	DATEFROM	☐	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
24	DATETO	☐	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
25	BELEG	☐	RI_BELKZ	XFELD	CHAR	1	0	IS-H: OU May Assign Patients to Beds on OU of Other Dept
26	FREIG	☐	FREIG	XFELD	CHAR	1	0	IS-H: Release Indicator
27	FAZUW	☐	FAZUW	XFELD	CHAR	1	0	Indicator that Departmental Assignment Is Allowed
28	PFZUW	☐	ISH_PFZUW	XFELD	CHAR	1	0	IS-H: Nursing Assignment is Allowed
29	AUFKZ	☐	ORGAUF	XFELD	CHAR	1	0	IS-H: Admitting Facility Indicator
30	INTKZ	☐	RI_INTKZ	XFELD	CHAR	1	0	IS-H: OU Can Be Assigned Patients From Other Department
31	INTEN	☐	ISH_INTENS	XFELD	CHAR	1	0	IS-H: Intensive Care Indicator of Organizational Unit
32	AMBES	☐	AMBES	XFELD	CHAR	1	0	IS-H: Outpatient Visit Allowed
33	ORGDS	☐	ORGDS	XFELD	CHAR	1	0	IS-H: Data Protection Applies to OU
34	PPRKZ	☐	ISH_PPRKZ	XFELD	CHAR	1	0	IS-H: OU Excluded from Nursing Acuity Classification
35	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
36	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
37	LODAT	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
38	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
39	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
40	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
41	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
42	ARCOE	☐	ISH_ARCORG	XFELD	CHAR	1	0	IS-H: Organizational Unit is Medical Record Archive
43	SPVON	☐	ISH_SPERRV	RI_DATUM	DATS	8	0	IS-H: Blocking Date from (Entry Block)
44	SPBIS	☐	ISH_SPERRB	RI_DATUM	DATS	8	0	IS-H: Blocking Date To (Entry Block To)
45	FACHR9	☐	FACHRTY9	ISH_FACHR	CHAR	4	0	IS-H: Specialty - User-Definable
46	PAEDKZ	☐	ISH_PAED	ISH_XFELD	CHAR	1	0	IS-H: Indicator for Pediatrics
47	ABRKZ	☐	ABR_ORGID	XFELD	CHAR	1	0	IS-H: Indicator whether OU is Authorized to Bill Indepndtly
48	KSTKZ	☐	ISH_KSTKZ	XFELD	CHAR	1	0	IS-H: Allocation Indicator Cost Center
49	N1ANFGP	☐	N1ANFGP	XFELD	CHAR	1	0	Locked for Request
50	N1ANFKZ	☐	N1ANFKZ	XFELD	CHAR	1	0	Can be Requested Indicator
51	N1DIKZ	☐	N1DIKZ	XFELD	CHAR	1	0	Scheduling Indicator
52	N1ERBRKZ	☐	N1ERBRKZ	XFELD	CHAR	1	0	Performability Indicator
53	N1AUFANZ	☐	N1AUFANZ	INT1	INT1	3	0	Number of Standard Calls
54	N1AUFZR	☐	N1AUFZR	INT3	NUMC	3	0	Call Period
55	N1CODEKZ	☐	N1CODEKZ	XFELD	CHAR	1	0	Encoding Requirement Indicator
56	N1EXANKZ	☐	N1EXANKZ	XFELD	CHAR	1	0	External Requestability Indicator
57	N1KABKZ	☐	N1KABKZ	XFELD	CHAR	1	0	Changing Room Assignment Indicator
58	N1LEZWKZ	☐	N1LEZWKZ	XFELD	CHAR	1	0	Registration Dept. Indicator Obligatory
59	N1LSTTYP	☐	N1LST_TYP	N1LST_TYP	CHAR	3	0	Service Facility Categories	TN1LST
60	N1TERVKZ	☐	N1TERVKZ	XFELD	CHAR	1	0	Appointment Allocation Indicator
61	TALST	☐	TARLS	TARLS	CHAR	10	0	IS-H: Service in Service Catalog
62	FACHR1	☐	FACHRTY0	ISH_FACHR	CHAR	4	0	IS-H: Specialty According to Fed. Reg. Hosp. 1995 (Germany)
63	FACHR4	☐	FACHRTY4	ISH_FACHR	CHAR	4	0	IS-H: Specialty according to Krazaf (Austria)
64	FACHR5	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty
65	FACHRA	☐	FACHRTY9	ISH_FACHR	CHAR	4	0	IS-H: Specialty - User-Definable
66	FACHRB	☐	FACHRTY9	ISH_FACHR	CHAR	4	0	IS-H: Specialty - User-Definable
67	FACHRC	☐	FACHRTY9	ISH_FACHR	CHAR	4	0	IS-H: Specialty - User-Definable
68	FACHR6	☐	FACHRTY6	ISH_FACHR	CHAR	4	0	IS-H: Specialty according to POLIS (Netherlands)
69	CALEN	☐	ISH_ORGCAL	WFCID	CHAR	2	0	IS-H: Calendar of an Organizational Unit	TFACD
70	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
71	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
72	FACHR7	☐	FACHRTY7	ISH_FACHR	CHAR	4	0	IS-H: Specialty for Organizational Unit
73	SLWRK	☐	ISH_MOEWERKS	WERKS	CHAR	4	0	IS-H MM: Plant of Care Unit Storage Facility for Org. Unit	TNM01
74	SLLGO	☐	ISH_MOELGORT	LGORT	CHAR	4	0	IS-H MM: Plant of Care Unit Storage Facility for Org. Unit	T001L
75	EANNR	☐	ISH_EANNR	CHAR013	CHAR	13	0	IS-H: International Article Number (EAN)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BW_HC_NORG	ADRNR	NADR	ADRNR
2	BW_HC_NORG	CALEN	TFACD	IDENT		1	CN
3	BW_HC_NORG	EINRI	TN01	EINRI	REF	1	CN
4	BW_HC_NORG	LAND	T005	LAND1	KEY	1	CN
5	BW_HC_NORG	MANDT	T000	MANDT	KEY	1	CN
6	BW_HC_NORG	N1LSTTYP	TN1LST	N1LSTTYP	REF	C	CN
7	BW_HC_NORG	ORGTY	TN10A	ORGTY	REF	1	CN
8	BW_HC_NORG	SLLGO	T001L	LGORT	KEY	1	CN
9	BW_HC_NORG	SLWRK	TNM01	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in