NORG SAP (IS-H: Organizational Units) Table details
Dictionary Type: Table
Description: IS-H: Organizational Units
Description: IS-H: Organizational Units
Table field list including key, data, relationships and ABAP select examples
NORG is a standard SAP Table which is used to store IS-H: Organizational Units data and is available within R/3 SAP systems depending on the version and release level.
The NORG table consists of various fields, each holding specific information or linking keys about IS-H: Organizational Units data available in SAP. These include ORGID (Identification Key of Organizational Unit), ORGTY (IS-H: Category of Organizational Unit), ORGNA (IS-H: Organizational Unit Name), ORGZU (Additional Name of Organizational Unit).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP NORG table 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 | |||
ORGID | Identification Key of Organizational Unit | ORGID | CHAR | 8 | ALPHA | ORGID | OGE | ||
ORGTY | IS-H: Category of Organizational Unit | ORGTYP | CHAR | 2 | TN10A | ORGTYP | OTY | ||
ORGNA | IS-H: Organizational Unit Name | ORGNA | CHAR | 30 | TEXT30 | ||||
ORGZU | Additional Name of Organizational Unit | ORGZU | CHAR | 30 | TEXT30 | ||||
ORGKB | IS-H: Organizational Unit Short Text | ORGKB | CHAR | 12 | TEXT12 | ||||
OKURZ | IS-H: Identifier of Organizational Unit in the Application | OEKURZ | CHAR | 5 | ORGKZ | ||||
EINRI | Institution | EINRI | CHAR | 4 | TN01 | ALPHA | EINRI | EIN | |
ARCHV | IS-H: Archived Data Indicator | ARCHIV | CHAR | 1 | XFELD | ||||
LAND | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
PSTLZ | IS-H: Postal Code | RI_PLZ | CHAR | 10 | PSTLZ | ||||
ORT | City | ORT01 | CHAR | 25 | TEXT25 | ||||
STRAS | IS-H: Street and Street Number of Organizational Unit | STRAS_ORG | CHAR | 30 | TEXT30 | ||||
TELNR | IS-H: Telephone Number of Organizational Unit | TELF_ORG | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number of Organizational Unit | TELFX_ORG | CHAR | 31 | TEXT31 | ||||
TELTX | IS-H: Teletex number of organizational unit | TELTX_ORG | CHAR | 30 | TEXT30 | ||||
KZTXT | IS-H: Comment on Organizational Unit | TEXT_ORG | CHAR | 50 | TEXT50 | ||||
LGTXT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
FACHR | Specialty According to Federal Regulation for Hospitals | FACHRTY1 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
FACHR2 | Specialty According to German Statistical Regulatory Req. | FACHRTY2 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
FACHR3 | Specialty According to Nursing Staff Regulation | FACHRTY3 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
SPERR | Blocking Indicator | RI_SPERR | 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 | ||||
BELEG | OU May Assign Patients to Beds on OU of Other Dept | RI_BELKZ | CHAR | 1 | XFELD | ||||
FREIG | Release Indicator | FREIG | CHAR | 1 | XFELD | ||||
FAZUW | Indicator that Departmental Assignment Is Allowed | FAZUW | CHAR | 1 | XFELD | ||||
PFZUW | Nursing Assignment Is Allowed | ISH_PFZUW | CHAR | 1 | XFELD | ||||
AUFKZ | Admitting Facility Indicator | ORGAUF | CHAR | 1 | XFELD | ||||
INTKZ | Interdepartmental Bed Assignment Possible | RI_INTKZ | CHAR | 1 | XFELD | ||||
INTEN | Intensive Care Indicator of Organizational Unit | ISH_INTENS | CHAR | 1 | XFELD | ||||
AMBES | Outpatient Visit Allowed | AMBES | CHAR | 1 | XFELD | ||||
ORGDS | Data Protection Applies to an Organizational Unit | ORGDS | CHAR | 1 | XFELD | ||||
PPRKZ | Ind. That OU Excluded from Nursing Acuity Classification | ISH_PPRKZ | CHAR | 1 | XFELD | ||||
LOEKZ | Deletion Flag/Indicator | RI_LOEKZ | CHAR | 1 | XFELD | ||||
LOUSR | User Who Deleted Record | RI_LOUSR | CHAR | 12 | USNAM | ||||
LODAT | Date of Deletion | RI_LODAT | DATS | 8 | RI_DATUM | ||||
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 | ||||
ARCOE | IS-H: Organizational Unit is Medical Record Archive | ISH_ARCORG | CHAR | 1 | XFELD | ||||
SPVON | Blocking Date From (Entry Block) | ISH_SPERRV | DATS | 8 | RI_DATUM | ||||
SPBIS | IS-H: Blocking Date To (Entry Block To) | ISH_SPERRB | DATS | 8 | RI_DATUM | ||||
FACHR9 | Specialty - User-Definable | FACHRTY9 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
PAEDKZ | Indicator for Pediatrics | ISH_PAED | CHAR | 1 | ISH_XFELD | ||||
ABRKZ | IS-H: Indicator whether OU is Authorized to Bill Indepndtly | ABR_ORGID | CHAR | 1 | XFELD | ||||
KSTKZ | IS-H: Allocation Indicator Cost Center | ISH_KSTKZ | CHAR | 1 | XFELD | ||||
N1ANFGP | Locked for Request | N1ANFGP | CHAR | 1 | XFELD | ||||
N1ANFKZ | Can be Requested Indicator | N1ANFKZ | CHAR | 1 | XFELD | ||||
N1DIKZ | Scheduling Indicator | N1DIKZ | CHAR | 1 | XFELD | ||||
N1ERBRKZ | Performability Indicator | N1ERBRKZ | CHAR | 1 | XFELD | ||||
N1AUFANZ | Number of Standard Calls | N1AUFANZ | INT1 | 3 | INT1 | ||||
N1AUFZR | Call Period | N1AUFZR | NUMC | 3 | INT3 | ||||
N1CODEKZ | Encoding Requirement Indicator | N1CODEKZ | CHAR | 1 | XFELD | ||||
N1EXANKZ | External Requestability Indicator | N1EXANKZ | CHAR | 1 | XFELD | ||||
N1KABKZ | Changing Room Assignment Indicator | N1KABKZ | CHAR | 1 | XFELD | ||||
N1LEZWKZ | Registration Dept. Indicator Obligatory | N1LEZWKZ | CHAR | 1 | XFELD | ||||
N1LSTTYP | Service Facility Categories | N1LST_TYP | CHAR | 3 | TN1LST | N1LST_TYP | |||
N1TERVKZ | Appointment Allocation Indicator | N1TERVKZ | CHAR | 1 | XFELD | ||||
TALST | Service in Service Catalog | TARLS | CHAR | 10 | Assigned to domain | ALPHA | TARLS | TAL | |
ADDIN | Additional Per Diem Indicator | ISH_ADD_IND | CHAR | 1 | XFELD | ||||
FACHR1 | Specialty According to Federal Regulation for Hospitals 1995 | FACHRTY0 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
FACHR4 | Specialty According to KRAZAF | FACHRTY4 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
FACHR5 | Specialty for Physicians | FACHRTY5 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
FACHRA | Specialty - User-Definable | FACHRTY9 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
FACHRB | Specialty - User-Definable | FACHRTY9 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
FACHRC | Specialty - User-Definable | FACHRTY9 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
FACHR6 | Specialty According to POLIS | FACHRTY6 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
CALEN | IS-H: Calendar of an Organizational Unit | ISH_ORGCAL | CHAR | 2 | TFACD | WFCID | |||
ADRNR | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | NADR | ALPHA | ISH_ADRNR | ||
ADROB | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
FACHR7 | Specialty for Organizational Unit | FACHRTY7 | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
SLWRK | Plant of Care Unit Storage Facility for Org. Unit | ISH_MOEWERKS | CHAR | 4 | TNM01 | WERKS | |||
SLLGO | Plant of Care Unit Storage Facility for Org. Unit | ISH_MOELGORT | CHAR | 4 | T001L | LGORT | |||
EANNR | International Article Number (EAN) | ISH_EANNR | CHAR | 13 | CHAR013 | ||||
BELAB | External Physician Department | ISH_EXTDPT | CHAR | 1 | XFELD | ||||
FACHRD | Specialty acc. to KHStatV for Special Institutions | FACHRTYD | CHAR | 4 | Assigned to domain | ALPHA | ISH_FACHR | ||
MIGRATED_OBJID | Object ID | HROBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
ESTABCODE | Establishment Code | ISH_ESTABCODE | CHAR | 2 | ISH_ESTABCODE | ||||
AMBCODE | Ambulatory Code | ISH_IT_AMBCODE | CHAR | 6 | TN50AC | ISH_IT_AMBCODE |
Key field | Non-key field |
How do I retrieve data from SAP table NORG using ABAP code
The following ABAP code Example will allow you to do a basic selection on NORG to SELECT all data from the tableDATA: WA_NORG TYPE NORG.
SELECT SINGLE *
FROM NORG
INTO CORRESPONDING FIELDS OF WA_NORG
WHERE...
How to access SAP table NORG
Within an ECC or HANA version of SAP you can also view further information about NORG 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