SAP NORG Table in S/4 HANA - NPA: Organizational Units
NORG is a standard SAP Table which is used to store NPA: Organizational Units data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the NORG table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: NORG
NORG table structure field list
Below is the full NORG field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
ORGID | Identification Key of Organizational or Building Unit | ISH_OM_ID | CHAR | 8(0) | ALPHA | ORGID | ||||
ORGTY | Object Category of Organizational Unit | ISH_OBJCAT | CHAR | 8(0) | TN10A | ORGTYP | ||||
ORGNA | Organizational Unit Name | ORGNA | CHAR | 30(0) | TEXT30 | |||||
ORGZU | Additional Name of Organizational Unit | ORGZU | CHAR | 30(0) | TEXT30 | |||||
ORGKB | Organizational Unit Short Text | ORGKB | CHAR | 12(0) | TEXT12 | |||||
OKURZ | Identifier of Organizational Unit in the Application | OEKURZ | CHAR | 5(0) | ORGKZ | |||||
EINRI | Institution | EINRI | CHAR | 4(0) | TN01 | ALPHA | EINRI | EIN | ||
ARCHV | Archived Data Indicator | ARCHIV | CHAR | 1(0) | XFELD | |||||
LAND | Country | KLAND | CHAR | 3(0) | T005 | LAND1 | ||||
PSTLZ | Postal Code | PD_PSTLZ | CHAR | 10(0) | PSTLZ | |||||
ORT | City | KORT | CHAR | 40(0) | TEXT40 | |||||
STRAS | Street and House Number | PD_STRAS | CHAR | 30(0) | TEXT30 | |||||
HAUSN | House number | HAUSN_BAS | CHAR | 6(0) | CHAR6 | |||||
TELNR | Telephone Number | TELENR | CHAR | 25(0) | CHAR25 | |||||
TELFX | Fax Number | FAXNR | CHAR | 25(0) | CHAR25 | |||||
KZTXT | Comment on Organizational Unit | TEXT_ORG | CHAR | 50(0) | TEXT50 | |||||
FACHR | Specialty | FACHRTY1 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
FACHR2 | Specialty | FACHRTY2 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
FACHR3 | Specialty | FACHRTY3 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
SPERR | Blocking Indicator | RI_SPERR | CHAR | 1(0) | XFELD | |||||
BEGDT | Valid-From Date of Record | RI_BEGDT | DATS | 8(0) | RI_DATUM | |||||
ENDDT | Valid-To Date of Record | RI_ENDDT | DATS | 8(0) | RI_DATUM | |||||
BELEG | OU May Assign Patients to Beds on OU of Other Dept | RI_BELKZ | CHAR | 1(0) | XFELD | |||||
FREIG | Release Indicator | FREIG | CHAR | 1(0) | XFELD | |||||
FAZUW | Indicator that Departmental Assignment Is Allowed | FAZUW | CHAR | 1(0) | XFELD | |||||
PFZUW | Nursing Assignment Is Allowed | ISH_PFZUW | CHAR | 1(0) | XFELD | |||||
AUFKZ | Admitting Facility Indicator | ORGAUF | CHAR | 1(0) | XFELD | |||||
INTKZ | Interdepartmental Bed Assignment Possible | RI_INTKZ | CHAR | 1(0) | XFELD | |||||
INTEN | Intensive Care Indicator of Organizational Unit | ISH_INTENS | CHAR | 1(0) | XFELD | |||||
AMBES | Outpatient Visit Allowed | AMBES | CHAR | 1(0) | XFELD | |||||
ORGDS | Data Protection Applies to an Organizational Unit | ORGDS | CHAR | 1(0) | XFELD | |||||
PPRKZ | Ind. That OU Excluded from Nursing Acuity Classification | ISH_PPRKZ | CHAR | 1(0) | XFELD | |||||
LOEKZ | Deletion Flag/Indicator | RI_LOEKZ | CHAR | 1(0) | XFELD | |||||
LOUSR | User Who Deleted Record | RI_LOUSR | CHAR | 12(0) | USNAM | |||||
LODAT | Date of Deletion | RI_LODAT | DATS | 8(0) | RI_DATUM | |||||
ERDAT | Date when Record Created | RI_ERDAT | DATS | 8(0) | RI_DATUM | |||||
ERUSR | Name of Employee who Created Record | RI_ERNAM | CHAR | 12(0) | USNAM | |||||
UPDAT | Date of Last Change | RI_UPDAT | DATS | 8(0) | RI_DATUM | |||||
UPUSR | Name of Person Who Last Changed Data | RI_UPNAM | CHAR | 12(0) | USNAM | |||||
ARCOE | Organizational Unit is Medical Record Archive | ISH_ARCORG | CHAR | 1(0) | XFELD | |||||
SPVON | Blocking Date From (Entry Block) | ISH_SPERRV | DATS | 8(0) | RI_DATUM | |||||
SPBIS | Blocking Date To (Entry Block To) | ISH_SPERRB | DATS | 8(0) | RI_DATUM | |||||
FACHR9 | Specialty - User-Definable | FACHRTY9 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
PAEDKZ | Indicator for Pediatrics | ISH_PAED | CHAR | 1(0) | XFELD | |||||
ABRKZ | Indicator whether OU is Authorized to Bill Indepndtly | ABR_ORGID | CHAR | 1(0) | XFELD | |||||
KSTKZ | Allocation Indicator Cost Center | ISH_KSTKZ | CHAR | 1(0) | XFELD | |||||
TALST | Catalog Item ID | TARLS | CHAR | 10(0) | ALPHA | TARLS | TAL | |||
ADDIN | Additional Per Diem Indicator | ISH_ADD_IND | CHAR | 1(0) | XFELD | |||||
FACHR1 | Specialty | FACHRTY0 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
FACHR4 | Specialt | FACHRTY4 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
FACHR5 | Specialty | FACHRTY5 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
FACHRA | Specialty - User-Definable | FACHRTY9 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
FACHRB | Specialty - User-Definable | FACHRTY9 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
FACHRC | Specialty - User-Definable | FACHRTY9 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
FACHR6 | Specialty | FACHRTY6 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
CALEN | Calendar of an Organizational Unit | ISH_ORGCAL | CHAR | 2(0) | TFACD | WFCID | ||||
FACHR7 | Specialty for Organizational Unit | FACHRTY7 | CHAR | 4(0) | ALPHA | ISH_FACHR | ||||
BELAB | External Physician Department | ISH_EXTDPT | CHAR | 1(0) | XFELD | |||||
FACHRD | Specialty acc. to KHStatV for Special Institutions | FACHRTYD | CHAR | 4(0) | ALPHA | ISH_FACHR |
Search for further information about these or an SAP related objects