NORG SAP (IS-H: Organizational Units) Table details

Dictionary Type: Table
Description: IS-H: Organizational Units




ABAP Code to SELECT data from NORG
Related tables to NORG
Access table NORG




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
MANDTClient MANDTCLNT3T000MANDT
ORGIDIdentification Key of Organizational Unit ORGIDCHAR8ALPHAORGIDOGE
ORGTYIS-H: Category of Organizational Unit ORGTYPCHAR2TN10AORGTYPOTY
ORGNAIS-H: Organizational Unit Name ORGNACHAR30TEXT30
ORGZUAdditional Name of Organizational Unit ORGZUCHAR30TEXT30
ORGKBIS-H: Organizational Unit Short Text ORGKBCHAR12TEXT12
OKURZIS-H: Identifier of Organizational Unit in the Application OEKURZCHAR5ORGKZ
EINRIInstitution EINRICHAR4TN01ALPHAEINRIEIN
ARCHVIS-H: Archived Data Indicator ARCHIVCHAR1XFELD
LANDCountry Key LAND1CHAR3T005LAND1LND
PSTLZIS-H: Postal Code RI_PLZCHAR10PSTLZ
ORTCity ORT01CHAR25TEXT25
STRASIS-H: Street and Street Number of Organizational Unit STRAS_ORGCHAR30TEXT30
TELNRIS-H: Telephone Number of Organizational Unit TELF_ORGCHAR16TEXT16
TELFXFax Number of Organizational Unit TELFX_ORGCHAR31TEXT31
TELTXIS-H: Teletex number of organizational unit TELTX_ORGCHAR30TEXT30
KZTXTIS-H: Comment on Organizational Unit TEXT_ORGCHAR50TEXT50
LGTXTIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
FACHRSpecialty According to Federal Regulation for Hospitals FACHRTY1CHAR4Assigned to domainALPHAISH_FACHR
FACHR2Specialty According to German Statistical Regulatory Req. FACHRTY2CHAR4Assigned to domainALPHAISH_FACHR
FACHR3Specialty According to Nursing Staff Regulation FACHRTY3CHAR4Assigned to domainALPHAISH_FACHR
SPERRBlocking Indicator RI_SPERRCHAR1XFELD
BEGDTIS-H: Valid-From Date of Record RI_BEGDTDATS8RI_DATUM
ENDDTIS-H: Valid-To Date of Record RI_ENDDTDATS8RI_DATUM
BELEGOU May Assign Patients to Beds on OU of Other Dept RI_BELKZCHAR1XFELD
FREIGRelease Indicator FREIGCHAR1XFELD
FAZUWIndicator that Departmental Assignment Is Allowed FAZUWCHAR1XFELD
PFZUWNursing Assignment Is Allowed ISH_PFZUWCHAR1XFELD
AUFKZAdmitting Facility Indicator ORGAUFCHAR1XFELD
INTKZInterdepartmental Bed Assignment Possible RI_INTKZCHAR1XFELD
INTENIntensive Care Indicator of Organizational Unit ISH_INTENSCHAR1XFELD
AMBESOutpatient Visit Allowed AMBESCHAR1XFELD
ORGDSData Protection Applies to an Organizational Unit ORGDSCHAR1XFELD
PPRKZInd. That OU Excluded from Nursing Acuity Classification ISH_PPRKZCHAR1XFELD
LOEKZDeletion Flag/Indicator RI_LOEKZCHAR1XFELD
LOUSRUser Who Deleted Record RI_LOUSRCHAR12USNAM
LODATDate of Deletion RI_LODATDATS8RI_DATUM
ERDATIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
ERUSRIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
ARCOEIS-H: Organizational Unit is Medical Record Archive ISH_ARCORGCHAR1XFELD
SPVONBlocking Date From (Entry Block) ISH_SPERRVDATS8RI_DATUM
SPBISIS-H: Blocking Date To (Entry Block To) ISH_SPERRBDATS8RI_DATUM
FACHR9Specialty - User-Definable FACHRTY9CHAR4Assigned to domainALPHAISH_FACHR
PAEDKZIndicator for Pediatrics ISH_PAEDCHAR1ISH_XFELD
ABRKZIS-H: Indicator whether OU is Authorized to Bill Indepndtly ABR_ORGIDCHAR1XFELD
KSTKZIS-H: Allocation Indicator Cost Center ISH_KSTKZCHAR1XFELD
N1ANFGPLocked for Request N1ANFGPCHAR1XFELD
N1ANFKZCan be Requested Indicator N1ANFKZCHAR1XFELD
N1DIKZScheduling Indicator N1DIKZCHAR1XFELD
N1ERBRKZPerformability Indicator N1ERBRKZCHAR1XFELD
N1AUFANZNumber of Standard Calls N1AUFANZINT13INT1
N1AUFZRCall Period N1AUFZRNUMC3INT3
N1CODEKZEncoding Requirement Indicator N1CODEKZCHAR1XFELD
N1EXANKZExternal Requestability Indicator N1EXANKZCHAR1XFELD
N1KABKZChanging Room Assignment Indicator N1KABKZCHAR1XFELD
N1LEZWKZRegistration Dept. Indicator Obligatory N1LEZWKZCHAR1XFELD
N1LSTTYPService Facility Categories N1LST_TYPCHAR3TN1LSTN1LST_TYP
N1TERVKZAppointment Allocation Indicator N1TERVKZCHAR1XFELD
TALSTService in Service Catalog TARLSCHAR10Assigned to domainALPHATARLSTAL
ADDINAdditional Per Diem Indicator ISH_ADD_INDCHAR1XFELD
FACHR1Specialty According to Federal Regulation for Hospitals 1995 FACHRTY0CHAR4Assigned to domainALPHAISH_FACHR
FACHR4Specialty According to KRAZAF FACHRTY4CHAR4Assigned to domainALPHAISH_FACHR
FACHR5Specialty for Physicians FACHRTY5CHAR4Assigned to domainALPHAISH_FACHR
FACHRASpecialty - User-Definable FACHRTY9CHAR4Assigned to domainALPHAISH_FACHR
FACHRBSpecialty - User-Definable FACHRTY9CHAR4Assigned to domainALPHAISH_FACHR
FACHRCSpecialty - User-Definable FACHRTY9CHAR4Assigned to domainALPHAISH_FACHR
FACHR6Specialty According to POLIS FACHRTY6CHAR4Assigned to domainALPHAISH_FACHR
CALENIS-H: Calendar of an Organizational Unit ISH_ORGCALCHAR2TFACDWFCID
ADRNRIS-H: Address Number ISH_ADRNRCHAR10NADRALPHAISH_ADRNR
ADROBIS-H: Address Object ISH_ADROBJCHAR4ISH_ADROBJ
FACHR7Specialty for Organizational Unit FACHRTY7CHAR4Assigned to domainALPHAISH_FACHR
SLWRKPlant of Care Unit Storage Facility for Org. Unit ISH_MOEWERKSCHAR4TNM01WERKS
SLLGOPlant of Care Unit Storage Facility for Org. Unit ISH_MOELGORTCHAR4T001LLGORT
EANNRInternational Article Number (EAN) ISH_EANNRCHAR13CHAR013
BELABExternal Physician Department ISH_EXTDPTCHAR1XFELD
FACHRDSpecialty acc. to KHStatV for Special Institutions FACHRTYDCHAR4Assigned to domainALPHAISH_FACHR
MIGRATED_OBJIDObject ID HROBJIDNUMC8Assigned to domainHROBJIDPON
ESTABCODEEstablishment Code ISH_ESTABCODECHAR2ISH_ESTABCODE
AMBCODEAmbulatory Code ISH_IT_AMBCODECHAR6TN50ACISH_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!