NLDBC_007 SAP () Structure details

Dictionary Type: Structure
Description:




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




Structure field list including key, data, relationships and ABAP select examples

NLDBC_007 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_NLDBC_007 TYPE NLDBC_007.

The NLDBC_007 table consists of various fields, each holding specific information or linking keys about data available in SAP. These include DBC (), DBCNR (), PATNR (IS-H: Patient Number), SPEC ().. 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: Can be enhanced (character-type)


SAP NLDBC_007 structure 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
EINRIInstitution EINRICHAR4Assigned to domainALPHAEINRIEIN
DBC ISH_NL_DBCCHAR30ISH_NL_DBC
DBCNR ISH_NL_DBCNRNUMC10ISH_NL_DBCNR
PATNRIS-H: Patient Number PATNRCHAR10Assigned to domainALPHAPATNRPAT
SPEC ISH_NL_SPECCHAR2ISH_NL_SPECNLDBC_SPEC
ZORGT ISH_NL_ZORGTCHAR10Assigned to domainISH_NL_ZORGT
OMSCHZORGT ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
ZORGVR ISH_NL_ZORGVRCHAR10Assigned to domainISH_NL_ZORGVR
OMSCHZORGVR ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
DIAGN ISH_NL_DIAGNCHAR10Assigned to domainISH_NL_DIAGN
OMSCHDIAGN ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
DIAGN2 ISH_NL_DIAGN2CHAR10Assigned to domainISH_NL_DIAGN
OMSCHDIAGN2 ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
THERAP ISH_NL_THERAPCHAR10Assigned to domainISH_NL_THERAP
OMSCHTHERAP ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
BEGDT ISH_NL_DATDATS8ISH_NL_DAT
ENDDT ISH_NL_DATDATS8ISH_NL_DAT
BEWDT ISH_NL_DATDATS8ISH_NL_DAT
AFGESL ISH_NL_AFGSLCHAR1ISH_NL_AFGSL
AFCODE ISH_NL_AFCODECHAR2ISH_NL_AFCODE
OMSCHAFCODE ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
OMSCH1 ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
OMSCH2 ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
CHRON ISH_NL_CHRONCHAR1JANE
DKAT1IS-H: Identification Key of Diagnosis Coding Catalog DIAKATCHAR2TNK00KATID
DKEY1IS-H: Diagnosis Code DIAIDCHAR30NKDIDIAID
DTEXT1Diagnosis Text DIATXTCHAR40TEXT40
DFALNRIS-H: Case Number FALNRCHAR10Assigned to domainALPHAFALNRFAL
DSPEC ISH_NL_SPECCHAR2ISH_NL_SPECNLDBC_SPEC
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
STORNIS-H: Cancellation Indicator RI_STORNCHAR1XFELD
OMSCHSPEC ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
ACTCODESingle-Character Indicator CHAR1CHAR1CHAR1
ACTCODE_TRJSingle-Character Indicator CHAR1CHAR1CHAR1
TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
TRJNR ISH_NL_TRJNRNUMC10ISH_NL_TRJNR
TRJ_CLOSESingle-Character Indicator CHAR1CHAR1CHAR1
BARNR ISH_NL_DBC_ARZTCHAR10Assigned to domainALPHARI_KUNNR
OMSCHBARNR ISH_NL_OMSCHCHAR40ISH_NL_OMSCH
STATUS ISH_NL_STATUSCHAR1ISH_NL_STATUS
DDBCNR ISH_NL_DBCNRNUMC10ISH_NL_DBCNR
DDBC ISH_NL_DBCCHAR30ISH_NL_DBC
ESTATUS ISH_NL_ESTATUSCHAR1ISH_NL_ESTATUSNLDBC_STATUST
DISPERIODE ISH_NL_DIS_PERIODENUMC8
DISSTATUS ISH_NL_DIS_STATUSCHAR1ISH_NL_DIS_STATUS
DISPERIODE_ALT ISH_NL_DIS_PERIODENUMC8
DISSTATUS_ALT ISH_NL_DIS_STATUSCHAR1ISH_NL_DIS_STATUS
DISLOCNR ISH_NL_DIS_LOCNRNUMC1NUMC1
THERAP_EXT_ALT ISH_NL_THERAP_ALTCHAR10Assigned to domainISH_NL_THERAP
DECL_CODE_ALT ISH_NL_DECLCODECHAR10Assigned to domainALPHATARLS
EVENT ISH_NL_DBC_EVENTNUMC2ISH_NL_DBC_EVENT
OBJCT ISH_NL_DBC_OBJECTCHAR10ISH_OBJECT
EVTUP ISH_NL_DBC_EVT_UPNUMC2ISH_NL_DBC_EVENT
OBJUP ISH_NL_DBC_OBJ_UPCHAR10ISH_OBJ_UP
ABADBC ISH_NL_ABADBCCHAR2TNLDBC_01ISH_NL_ABADBC

Key field Non-key field



How do I retrieve data from SAP structure NLDBC_007 using ABAP code?

As NLDBC_007 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on NLDBC_007 as there is no data to select.

How to access SAP table NLDBC_007

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