BW_HC_NORG SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




Table View field list including key, data, relationships and ABAP select examples

BW_HC_NORG is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The BW_HC_NORG table consists of various fields, each holding specific information or linking keys about Generated Table for View 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP BW_HC_NORG table view 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 FACHRTY1CHAR4ALPHAISH_FACHR
FACHR2Specialty According to German Statistical Regulatory Req. FACHRTY2CHAR4ALPHAISH_FACHR
FACHR3Specialty According to Nursing Staff Regulation FACHRTY3CHAR4ALPHAISH_FACHR
SPERRBlocking Indicator RI_SPERRCHAR1XFELD
DATEFROMIS-H: Valid-From Date of Record RI_BEGDTDATS8RI_DATUM
DATETOIS-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 FACHRTY9CHAR4ALPHAISH_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 TARLSCHAR10ALPHATARLSTAL
FACHR1Specialty According to Federal Regulation for Hospitals 1995 FACHRTY0CHAR4ALPHAISH_FACHR
FACHR4Specialty According to KRAZAF FACHRTY4CHAR4ALPHAISH_FACHR
FACHR5Specialty for Physicians FACHRTY5CHAR4ALPHAISH_FACHR
FACHRASpecialty - User-Definable FACHRTY9CHAR4ALPHAISH_FACHR
FACHRBSpecialty - User-Definable FACHRTY9CHAR4ALPHAISH_FACHR
FACHRCSpecialty - User-Definable FACHRTY9CHAR4ALPHAISH_FACHR
FACHR6Specialty According to POLIS FACHRTY6CHAR4ALPHAISH_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 FACHRTY7CHAR4ALPHAISH_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

Key field Non-key field



How do I retrieve data from SAP table BW_HC_NORG using ABAP code

The following ABAP code Example will allow you to do a basic selection on BW_HC_NORG to SELECT all data from the table
DATA: WA_BW_HC_NORG TYPE BW_HC_NORG.

SELECT SINGLE *
FROM BW_HC_NORG
INTO CORRESPONDING FIELDS OF WA_BW_HC_NORG
WHERE...

How to access SAP table BW_HC_NORG

Within an ECC or HANA version of SAP you can also view further information about BW_HC_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!