BW_HC_NORG SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
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 |
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 | ALPHA | ISH_FACHR | |||
FACHR2 | Specialty According to German Statistical Regulatory Req. | FACHRTY2 | CHAR | 4 | ALPHA | ISH_FACHR | |||
FACHR3 | Specialty According to Nursing Staff Regulation | FACHRTY3 | CHAR | 4 | ALPHA | ISH_FACHR | |||
SPERR | Blocking Indicator | RI_SPERR | CHAR | 1 | XFELD | ||||
DATEFROM | IS-H: Valid-From Date of Record | RI_BEGDT | DATS | 8 | RI_DATUM | ||||
DATETO | 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 | 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 | ALPHA | TARLS | TAL | ||
FACHR1 | Specialty According to Federal Regulation for Hospitals 1995 | FACHRTY0 | CHAR | 4 | ALPHA | ISH_FACHR | |||
FACHR4 | Specialty According to KRAZAF | FACHRTY4 | CHAR | 4 | ALPHA | ISH_FACHR | |||
FACHR5 | Specialty for Physicians | FACHRTY5 | CHAR | 4 | ALPHA | ISH_FACHR | |||
FACHRA | Specialty - User-Definable | FACHRTY9 | CHAR | 4 | ALPHA | ISH_FACHR | |||
FACHRB | Specialty - User-Definable | FACHRTY9 | CHAR | 4 | ALPHA | ISH_FACHR | |||
FACHRC | Specialty - User-Definable | FACHRTY9 | CHAR | 4 | ALPHA | ISH_FACHR | |||
FACHR6 | Specialty According to POLIS | FACHRTY6 | CHAR | 4 | 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 | 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 |
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 tableDATA: 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 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