SAP ABAP Table NLDBC_007 (NL-DBC: DBC Struktur)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NNL1 (Package) Application development Hospital System Netherlands

Basic Data

Table Category	INTTAB	Structure
Structure	NLDBC_007	Table Relationship Diagram
Short Description	NL-DBC: DBC Struktur

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
2	DBC	☐	ISH_NL_DBC	ISH_NL_DBC	CHAR	30	0	ISH_NL: DBC
3	DBCNR	☐	ISH_NL_DBCNR	ISH_NL_DBCNR	NUMC	10	0	Laufende Nummer DBC-code
4	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
5	SPEC	☐	ISH_NL_SPEC	ISH_NL_SPEC	CHAR	2	0	DBC Spezialgebiet
6	ZORGT	☐	ISH_NL_ZORGT	ISH_NL_ZORGT	CHAR	10	0	IS-H NL: Sorgetype	*
7	OMSCHZORGT	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
8	ZORGVR	☐	ISH_NL_ZORGVR	ISH_NL_ZORGVR	CHAR	10	0	ISH_NL: Sorgfrage	*
9	OMSCHZORGVR	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
10	DIAGN	☐	ISH_NL_DIAGN	ISH_NL_DIAGN	CHAR	10	0	Diagnose	*
11	OMSCHDIAGN	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
12	DIAGN2	☐	ISH_NL_DIAGN2	ISH_NL_DIAGN	CHAR	10	0	ISH_NL: Alternative diagnose.	*
13	OMSCHDIAGN2	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
14	THERAP	☐	ISH_NL_THERAP	ISH_NL_THERAP	CHAR	10	0	ISH_NL: Therapie	*
15	OMSCHTHERAP	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
16	BEGDT	☐	ISH_NL_DAT	ISH_NL_DAT	DATS	8	0	ISH_NL: Datum
17	ENDDT	☐	ISH_NL_DAT	ISH_NL_DAT	DATS	8	0	ISH_NL: Datum
18	BEWDT	☐	ISH_NL_DAT	ISH_NL_DAT	DATS	8	0	ISH_NL: Datum
19	AFGESL	☐	ISH_NL_AFGSL	ISH_NL_AFGSL	CHAR	1	0	ISH_NL: DBC abgeschloßen
20	AFCODE	☐	ISH_NL_AFCODE	ISH_NL_AFCODE	CHAR	2	0	ISH_NL: Abschlußkode
21	OMSCHAFCODE	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
22	OMSCH1	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
23	OMSCH2	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
24	CHRON	☐	ISH_NL_CHRON	JANE	CHAR	1	0	ISH_NL:Chronisch
25	DKAT1	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
26	DKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code	NKDI
27	DTEXT1	☐	DIATXT	TEXT40	CHAR	40	0	IS-H: Diagnosis Text
28	DFALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
29	DSPEC	☐	ISH_NL_SPEC	ISH_NL_SPEC	CHAR	2	0	DBC Spezialgebiet
30	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
31	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
32	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
33	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
34	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
35	OMSCHSPEC	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
36	ACTCODE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
37	ACTCODE_TRJ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
38	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
39	TRJNR	☐	ISH_NL_TRJNR	ISH_NL_TRJNR	NUMC	10	0	ISH_NL: Sorgestreckenummer
40	TRJ_CLOSE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
41	BARNR	☐	ISH_NL_DBC_ARZT	RI_KUNNR	CHAR	10	0	IS-H NL: Personalnummer des Arztes verantwortlich für DBC	*
42	OMSCHBARNR	☐	ISH_NL_OMSCH	ISH_NL_OMSCH	CHAR	40	0	ISH_NL: Umschreibung
43	STATUS	☐	ISH_NL_STATUS	ISH_NL_STATUS	CHAR	1	0	ISH_NL: DBC interner status
44	DDBCNR	☐	ISH_NL_DBCNR	ISH_NL_DBCNR	NUMC	10	0	Laufende Nummer DBC-code
45	DDBC	☐	ISH_NL_DBC	ISH_NL_DBC	CHAR	30	0	ISH_NL: DBC
46	ESTATUS	☐	ISH_NL_ESTATUS	ISH_NL_ESTATUS	CHAR	1	0	ISH_NL: Externer DBC status
47	DISPERIODE	☐	ISH_NL_DIS_PERIODE		NUMC	8	0	ISH NL: Periode DIS anliefering
48	DISSTATUS	☐	ISH_NL_DIS_STATUS	ISH_NL_DIS_STATUS	CHAR	1	0	ISH NL: Status DIS anliefering
49	DISPERIODE_ALT	☐	ISH_NL_DIS_PERIODE		NUMC	8	0	ISH NL: Periode DIS anliefering
50	DISSTATUS_ALT	☐	ISH_NL_DIS_STATUS	ISH_NL_DIS_STATUS	CHAR	1	0	ISH NL: Status DIS anliefering
51	DISLOCNR	☐	ISH_NL_DIS_LOCNR	NUMC1	NUMC	1	0	ISH NL: Lokation-code für DIS anliefering
52	THERAP_EXT_ALT	☐	ISH_NL_THERAP_ALT	ISH_NL_THERAP	CHAR	10	0	ISH_NL: Therapie alternatief	*
53	DECL_CODE_ALT	☐	ISH_NL_DECLCODE	TARLS	CHAR	10	0	Deklaration kode	*
54	EVENT	☐	ISH_NL_DBC_EVENT	ISH_NL_DBC_EVENT	NUMC	2	0	IS-H NL: Ereignis, durch welches DBC's erzeugt wurden
55	OBJCT	☐	ISH_NL_DBC_OBJECT	ISH_OBJECT	CHAR	10	0	IS-H NL: Objekt, durch das DBC's erzeugt wurden
56	EVTUP	☐	ISH_NL_DBC_EVT_UP	ISH_NL_DBC_EVENT	NUMC	2	0	IS-H NL: Ereignis, durch welches DBC's geändert wurden
57	OBJUP	☐	ISH_NL_DBC_OBJ_UP	ISH_OBJ_UP	CHAR	10	0	IS-H NL: Objekt, durch das DBC's geändert wurden
58	ABADBC	☐	ISH_NL_ABADBC	ISH_NL_ABADBC	CHAR	2	0	Abrechnungs art DBC	TNLDBC_01

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NLDBC_007	ABADBC	TNLDBC_01	ABADBC
2	NLDBC_007	DKAT1	TNK00	KATID
3	NLDBC_007	DKEY1	NKDI	DKEY

History

Last changed by/on	SAP	20130529
SAP Release Created in	463