1. Home
  2. Resources
  3. SAP Tables
  4. NORG - IS-H: Organizational Units

SAP Table NORG

IS-H: Organizational Units

NORG (IS-H: Organizational Units) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link NORG to other SAP tables.

NORG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ORGID Identification Key of Organizational Unit ORGID CHAR 8 0
ORGTY IS-H: Category of Organizational Unit ORGTYP TN10A CHAR 2 0
ORGNA IS-H: Organizational Unit Name ORGNA CHAR 30 0
ORGZU Additional Name of Organizational Unit ORGZU CHAR 30 0
ORGKB IS-H: Organizational Unit Short Text ORGKB CHAR 12 0
OKURZ IS-H: Identifier of Organizational Unit in the Application OEKURZ CHAR 5 0
EINRI Institution EINRI TN01 CHAR 4 0
ARCHV IS-H: Archived Data Indicator ARCHIV CHAR 1 0
X Yes
NULL No
LAND Country Key LAND1 T005 CHAR 3 0
PSTLZ IS-H: Postal Code RI_PLZ CHAR 10 0
ORT City ORT01 CHAR 25 0
STRAS IS-H: Street and Street Number of Organizational Unit STRAS_ORG CHAR 30 0
TELNR IS-H: Telephone Number of Organizational Unit TELF_ORG CHAR 16 0
TELFX Fax Number of Organizational Unit TELFX_ORG CHAR 31 0
TELTX IS-H: Teletex number of organizational unit TELTX_ORG CHAR 30 0
KZTXT IS-H: Comment on Organizational Unit TEXT_ORG CHAR 50 0
LGTXT Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
FACHR Specialty According to Federal Regulation for Hospitals FACHRTY1 CHAR 4 0
FACHR2 Specialty According to German Statistical Regulatory Req. FACHRTY2 CHAR 4 0
FACHR3 Specialty According to Nursing Staff Regulation FACHRTY3 CHAR 4 0
SPERR Blocking Indicator RI_SPERR CHAR 1 0
X Yes
NULL No
BEGDT IS-H: Valid-From Date of Record RI_BEGDT DATS 8 0
ENDDT IS-H: Valid-To Date of Record RI_ENDDT DATS 8 0
BELEG OU May Assign Patients to Beds on OU of Other Dept RI_BELKZ CHAR 1 0
X Yes
NULL No
FREIG Release Indicator FREIG CHAR 1 0
X Yes
NULL No
FAZUW Indicator that Departmental Assignment Is Allowed FAZUW CHAR 1 0
X Yes
NULL No
PFZUW Nursing Assignment Is Allowed ISH_PFZUW CHAR 1 0
X Yes
NULL No
AUFKZ Admitting Facility Indicator ORGAUF CHAR 1 0
X Yes
NULL No
INTKZ Interdepartmental Bed Assignment Possible RI_INTKZ CHAR 1 0
X Yes
NULL No
INTEN Intensive Care Indicator of Organizational Unit ISH_INTENS CHAR 1 0
X Yes
NULL No
AMBES Outpatient Visit Allowed AMBES CHAR 1 0
X Yes
NULL No
ORGDS Data Protection Applies to an Organizational Unit ORGDS CHAR 1 0
X Yes
NULL No
PPRKZ Ind. That OU Excluded from Nursing Acuity Classification ISH_PPRKZ CHAR 1 0
X Yes
NULL No
LOEKZ Deletion Flag/Indicator RI_LOEKZ CHAR 1 0
X Yes
NULL No
LOUSR User Who Deleted Record RI_LOUSR CHAR 12 0
LODAT Date of Deletion RI_LODAT DATS 8 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
ARCOE IS-H: Organizational Unit is Medical Record Archive ISH_ARCORG CHAR 1 0
X Yes
NULL No
SPVON Blocking Date From (Entry Block) ISH_SPERRV DATS 8 0
SPBIS IS-H: Blocking Date To (Entry Block To) ISH_SPERRB DATS 8 0
FACHR9 Specialty - User-Definable FACHRTY9 CHAR 4 0
PAEDKZ Indicator for Pediatrics ISH_PAED CHAR 1 0
X Yes
NULL No
ABRKZ IS-H: Indicator whether OU is Authorized to Bill Indepndtly ABR_ORGID CHAR 1 0
X Yes
NULL No
KSTKZ IS-H: Allocation Indicator Cost Center ISH_KSTKZ CHAR 1 0
X Yes
NULL No
N1ANFGP Locked for Request N1ANFGP CHAR 1 0
X Yes
NULL No
N1ANFKZ Can be Requested Indicator N1ANFKZ CHAR 1 0
X Yes
NULL No
N1DIKZ Scheduling Indicator N1DIKZ CHAR 1 0
X Yes
NULL No
N1ERBRKZ Performability Indicator N1ERBRKZ CHAR 1 0
X Yes
NULL No
N1AUFANZ Number of Standard Calls N1AUFANZ INT1 3 0
N1AUFZR Call Period N1AUFZR NUMC 3 0
N1CODEKZ Encoding Requirement Indicator N1CODEKZ CHAR 1 0
X Yes
NULL No
N1EXANKZ External Requestability Indicator N1EXANKZ CHAR 1 0
X Yes
NULL No
N1KABKZ Changing Room Assignment Indicator N1KABKZ CHAR 1 0
X Yes
NULL No
N1LEZWKZ Registration Dept. Indicator Obligatory N1LEZWKZ CHAR 1 0
X Yes
NULL No
N1LSTTYP Service Facility Categories N1LST_TYP TN1LST CHAR 3 0
N1TERVKZ Appointment Allocation Indicator N1TERVKZ CHAR 1 0
X Yes
NULL No
TALST Service in Service Catalog TARLS CHAR 10 0
ADDIN Additional Per Diem Indicator ISH_ADD_IND CHAR 1 0
X Yes
NULL No
FACHR1 Specialty According to Federal Regulation for Hospitals 1995 FACHRTY0 CHAR 4 0
FACHR4 Specialty According to KRAZAF FACHRTY4 CHAR 4 0
FACHR5 Specialty for Physicians FACHRTY5 CHAR 4 0
FACHRA Specialty - User-Definable FACHRTY9 CHAR 4 0
FACHRB Specialty - User-Definable FACHRTY9 CHAR 4 0
FACHRC Specialty - User-Definable FACHRTY9 CHAR 4 0
FACHR6 Specialty According to POLIS FACHRTY6 CHAR 4 0
CALEN IS-H: Calendar of an Organizational Unit ISH_ORGCAL TFACD CHAR 2 0
ADRNR IS-H: Address Number ISH_ADRNR NADR CHAR 10 0
ADROB IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
FACHR7 Specialty for Organizational Unit FACHRTY7 CHAR 4 0
SLWRK Plant of Care Unit Storage Facility for Org. Unit ISH_MOEWERKS TNM01 CHAR 4 0
SLLGO Plant of Care Unit Storage Facility for Org. Unit ISH_MOELGORT T001L CHAR 4 0
EANNR International Article Number (EAN) ISH_EANNR CHAR 13 0
BELAB External Physician Department ISH_EXTDPT CHAR 1 0
X Yes
NULL No
FACHRD Specialty acc. to KHStatV for Special Institutions FACHRTYD CHAR 4 0
MIGRATED_OBJID Object ID HROBJID NUMC 8 0
ESTABCODE Establishment Code ISH_ESTABCODE CHAR 2 0
AMBCODE Ambulatory Code ISH_IT_AMBCODE TN50AC CHAR 6 0

NORG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NORG ADRNR NORG MANDT NADR IS-H: Addresses (Central Address Management) MANDT
NORG ADRNR NORG ADRNR NADR IS-H: Addresses (Central Address Management) ADRNR
NORG ADRNR NORG ADROB NADR IS-H: Addresses (Central Address Management) ADROB
NORG AMBCODE NORG MANDT TN50AC Ambulatory Codes MANDT
NORG AMBCODE NORG EINRI TN50AC Ambulatory Codes EINRI
NORG AMBCODE NORG AMBCODE TN50AC Ambulatory Codes AMBCODE
NORG CALEN NORG CALEN TFACD Factory calendar definition IDENT
NORG EINRI NORG EINRI TN01 IS-H: Institutions EINRI
NORG EINRI NORG MANDT TN01 IS-H: Institutions MANDT
NORG LAND NORG MANDT T005 Countries MANDT
NORG LAND NORG LAND T005 Countries LAND1
NORG MANDT NORG MANDT T000 Clients MANDT
NORG N1LSTTYP NORG EINRI TN1LST i.s.h.med: Service Facility Categories EINRI
NORG N1LSTTYP NORG N1LSTTYP TN1LST i.s.h.med: Service Facility Categories N1LSTTYP
NORG N1LSTTYP NORG MANDT TN1LST i.s.h.med: Service Facility Categories MANDT
NORG ORGTY NORG MANDT TN10A IS-H: Categories of Organizational Units MANDT
NORG ORGTY NORG EINRI TN10A IS-H: Categories of Organizational Units EINRI
NORG ORGTY NORG ORGTY TN10A IS-H: Categories of Organizational Units ORGTY
NORG SLLGO NORG SLLGO T001L Storage Locations LGORT
NORG SLLGO NORG MANDT T001L Storage Locations MANDT
NORG SLLGO NORG SLWRK T001L Storage Locations WERKS
NORG SLWRK NORG EINRI TNM01 IS-H MM: Assign Plants to Institution EINRI
NORG SLWRK NORG SLWRK TNM01 IS-H MM: Assign Plants to Institution WERKS
NORG SLWRK NORG MANDT TNM01 IS-H MM: Assign Plants to Institution MANDT