SAP ABAP Table NLDBC_005 (NL-DBC: DBC Tabelle.)
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 TRANSP    Transparent table 
Transparent table NLDBC_005   Table Relationship Diagram
Short Description NL-DBC: DBC Tabelle.    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 EINRI EINRI EINRI CHAR 4   0   IS-H: Institution TN01
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 NPAT
5 DBC ISH_NL_DBC ISH_NL_DBC CHAR 30   0   ISH_NL: DBC  
6 SPEC ISH_NL_SPEC ISH_NL_SPEC CHAR 2   0   DBC Spezialgebiet  
7 ZORGT ISH_NL_ZORGT ISH_NL_ZORGT CHAR 10   0   IS-H NL: Sorgetype *
8 ZORGVR ISH_NL_ZORGVR ISH_NL_ZORGVR CHAR 10   0   ISH_NL: Sorgfrage *
9 DIAGN ISH_NL_DIAGN ISH_NL_DIAGN CHAR 10   0   Diagnose *
10 DIAGN2 ISH_NL_DIAGN ISH_NL_DIAGN CHAR 10   0   Diagnose *
11 THERAP ISH_NL_THERAP ISH_NL_THERAP CHAR 10   0   ISH_NL: Therapie *
12 DKAT1 DIAKAT KATID CHAR 2   0   IS-H: Identification Key of Diagnosis Coding Catalog  
13 DKEY1 DIAID DIAID CHAR 30   0   IS-H: Diagnosis Code  
14 DFALNR FALNR FALNR CHAR 10   0   IS-H: Case Number *
15 DSPEC ISH_NL_SPEC ISH_NL_SPEC CHAR 2   0   DBC Spezialgebiet  
16 BEGDT ISH_NL_DBC_BEGDT DATUM DATS 8   0   ISH_NL: Anfang datum  
17 ENDDT ISH_NL_DBC_ENDDT DATUM DATS 8   0   ISH_NL: Ende datum  
18 AFGESL ISH_NL_AFGSL ISH_NL_AFGSL CHAR 1   0   ISH_NL: DBC abgeschloßen  
19 AFCODE ISH_NL_AFCODE ISH_NL_AFCODE CHAR 2   0   ISH_NL: Abschlußkode  
20 CHRON ISH_NL_CHRON JANE CHAR 1   0   ISH_NL:Chronisch  
21 TRJNR ISH_NL_TRJNR ISH_NL_TRJNR NUMC 10   0   ISH_NL: Sorgestreckenummer  
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 ERDAT RI_ERDAT RI_DATUM DATS 8   0   IS-H: Date when Record Created  
25 ERUSR RI_ERNAM USNAM CHAR 12   0   IS-H: Name of Employee who Created Record  
26 UPDAT RI_UPDAT RI_DATUM DATS 8   0   IS-H: Date of Last Change  
27 UPUSR RI_UPNAM USNAM CHAR 12   0   IS-H: Name of Person who Last Changed Data  
28 STORN RI_STORN XFELD CHAR 1   0   IS-H: Cancellation Indicator  
29 TCODE TCODE TCODE CHAR 20   0   Transaction Code *
30 TRJ_CLOSE CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
31 BARNR ISH_NL_DBC_ARZT RI_KUNNR CHAR 10   0   IS-H NL: Personalnummer des Arztes verantwortlich für DBC *
32 STATUS ISH_NL_STATUS ISH_NL_STATUS CHAR 1   0   ISH_NL: DBC interner status  
33 DDBCNR ISH_NL_DBCNR ISH_NL_DBCNR NUMC 10   0   Laufende Nummer DBC-code  
34 DDBC ISH_NL_DBC ISH_NL_DBC CHAR 30   0   ISH_NL: DBC  
35 ESTATUS ISH_NL_ESTATUS ISH_NL_ESTATUS CHAR 1   0   ISH_NL: Externer DBC status  
36 DISPERIODE ISH_NL_DIS_PERIODE   NUMC 8   0   ISH NL: Periode DIS anliefering  
37 DISSTATUS ISH_NL_DIS_STATUS ISH_NL_DIS_STATUS CHAR 1   0   ISH NL: Status DIS anliefering  
38 DISPERIODE_ALT ISH_NL_DIS_PERIODE   NUMC 8   0   ISH NL: Periode DIS anliefering  
39 DISSTATUS_ALT ISH_NL_DIS_STATUS ISH_NL_DIS_STATUS CHAR 1   0   ISH NL: Status DIS anliefering  
40 DISLOCNR ISH_NL_DIS_LOCNR NUMC1 NUMC 1   0   ISH NL: Lokation-code für DIS anliefering  
41 THERAP_EXT_ALT ISH_NL_THERAP_ALT ISH_NL_THERAP CHAR 10   0   ISH_NL: Therapie alternatief *
42 EVENT ISH_NL_DBC_EVENT ISH_NL_DBC_EVENT NUMC 2   0   IS-H NL: Ereignis, durch welches DBC's erzeugt wurden  
43 DECL_CODE_ALT ISH_NL_DECLCODE TARLS CHAR 10   0   Deklaration kode *
44 OBJCT ISH_NL_DBC_OBJECT ISH_OBJECT CHAR 10   0   IS-H NL: Objekt, durch das DBC's erzeugt wurden  
45 EVTUP ISH_NL_DBC_EVT_UP ISH_NL_DBC_EVENT NUMC 2   0   IS-H NL: Ereignis, durch welches DBC's geändert wurden  
46 OBJUP ISH_NL_DBC_OBJ_UP ISH_OBJ_UP CHAR 10   0   IS-H NL: Objekt, durch das DBC's geändert wurden  
47 ABADBC ISH_NL_ABADBC ISH_NL_ABADBC CHAR 2   0   Abrechnungs art DBC *
48 EXP_CPCOD ISH_NL_CP_COD ISH_NL_CP_COD CHAR 9   0   Sorge produkt kode  
49 EXP_CPCAT ISH_NL_CP_CAT ISH_NL_CP_CAT CHAR 4   0   Sorge produkt Kategorie  
50 CLAIM ISH_NL_CLAIM_IND ISH_NL_CLAIM_IND CHAR 1   0   Haftung ZVW indikation  
51 TYPE ISH_NL_CURE_TYPE ISH_NL_CURE_TYPE CHAR 1   0   Somatisch DBC type  
52 BILLING_BLOCK ISH_NL_DBC_BILLING_BLOCK ISH_ON_OFF CHAR 1   0   DBC Fakturasperre  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 NLDBC_005 EINRI TN01 EINRI KEY 1 CN
2 NLDBC_005 MANDT T000 MANDT KEY 1 CN
3 NLDBC_005 PATNR NPAT PATNR KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 463