SAP ABAP View N_VDIABEW (IS-H: View of NDIA and NBEW - Diagnoses for Movements)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system

Basic Data

View Type	D	Database View
Database View	N_VDIABEW
Short Description	IS-H: View of NDIA and NBEW - Diagnoses for Movements
Root table	NDIA	IS-H: Diagnoses

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NDIA	NDIA
2	NBEW
3	NFAL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	NBEW	MANDT	JL	EQ				0	0
2	NDIA	MANDT	JR	EQ			AND	0	0
3	NBEW	EINRI	JL	EQ				0	0
4	NDIA	EINRI	JR	EQ			AND	0	0
5	NBEW	FALNR	JL	EQ				0	0
6	NDIA	FALNR	JR	EQ			AND	0	0
7	NBEW	LFDNR	JL	EQ				0	0
8	NDIA	LFDBEW	JR	EQ			AND	0	0
9	NFAL	MANDT	JL	EQ				0	0
10	NDIA	MANDT	JR	EQ			AND	0	0
11	NFAL	EINRI	JL	EQ				0	0
12	NDIA	EINRI	JR	EQ			AND	0	0
13	NFAL	FALNR	JL	EQ				0	0
14	NDIA	FALNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	NDIA	MANDT		☐	MANDT	☐	Client
2	EINRI	NDIA	EINRI		☐	EINRI	☐	IS-H: Institution
3	FALNR	NDIA	FALNR		☐	FALNR	☐	IS-H: Case Number
4	LFDNR	NDIA	LFDNR		☐	LFDDIA	☐	IS-H: Sequence Number of Diagnosis
5	LFDBEW	NDIA	LFDBEW		☐	LFDBEW	☐	IS-H: Sequence Number of Movement
6	PLANB	NBEW	PLANB		☐	PLANB	☐	IS-H: Planned Indicator for Date of Movement
7	BWIDT	NBEW	BWIDT		☐	BWIDT	☐	IS-H: Date of Movement
8	BWIZT	NBEW	BWIZT		☐	BWIZT	☐	IS-H: Time of Movement
9	BEWTY	NBEW	BEWTY		☐	BEWTY	☐	IS-H: Movement Category
10	ORGFA	NBEW	ORGFA		☐	NZUWFA	☐	IS-H: OU with Departmental Responsibility for Case
11	ORGPF	NBEW	ORGPF		☐	NZUWPF	☐	Organizational Unit Assigned to Case
12	DKAT1	NDIA	DKAT1		☐	DIAKAT	☐	IS-H: Identification Key of Diagnosis Coding Catalog
13	DKEY1	NDIA	DKEY1		☐	DIAID	☐	IS-H: Diagnosis Code
14	DKAT2	NDIA	DKAT2		☐	DIAKAT	☐	IS-H: Identification Key of Diagnosis Coding Catalog
15	DKEY2	NDIA	DKEY2		☐	DIAID	☐	IS-H: Diagnosis Code
16	DKAT_REF	NDIA	DKAT_REF		☐	REF_DIAKAT	☐	IS-H: Catalog ID of Reference Catalog for Statistics
17	DKEY_REF	NDIA	DKEY_REF		☐	REF_DIAID	☐	IS-H: Reference Diagnosis Code for Statistics
18	DITXT	NDIA	DITXT		☐	ISH_DITEXT	☐	IS-H: Free-Text Diagnosis
19	DILTX	NDIA	DILTX		☐	RI_LGTXT	☐	Indicator that Long Text Exists
20	DIADT	NDIA	DIADT		☐	DIADT	☐	IS-H: Date on which Diagnosis Was Created
21	DIAZT	NDIA	DIAZT		☐	DIAZT	☐	IS-H: Time at which Diagnosis Created
22	DIAPE	NDIA	DIAPE		☐	DIA_PERS	☐	IS-H: Identification of Diagnosing Person
23	ANZOP	NDIA	ANZOP		☐	ANZOP	☐	IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis
24	EWDIA	NDIA	EWDIA		☐	KZ_EINWD	☐	IS-H: Referral Diagnosis Indicator
25	BHDIA	NDIA	BHDIA		☐	KZ_BEHLD	☐	IS-H: Treatment Diagnosis Indicator
26	AFDIA	NDIA	AFDIA		☐	KZ_AUFND	☐	IS-H: Admission Diagnosis Indicator
27	ENDIA	NDIA	ENDIA		☐	KZ_ENTLD	☐	IS-H: "Discharge Diagnosis" Indicator
28	FHDIA	NDIA	FHDIA		☐	KZ_FAHPD	☐	IS-H: "Department Main Diagnosis" Indicator
29	KHDIA	NDIA	KHDIA		☐	KZ_KHHPD	☐	IS-H: Hospital Main Diagnosis Indicator
30	OPDIA	NDIA	OPDIA		☐	KZ_OPERD	☐	IS-H: Surgery Diagnosis Indicator
31	SPERR	NDIA	SPERR		☐	RI_SPERR	☐	Blocking Indicator
32	KZTXT	NDIA	KZTXT		☐	TEXT_DIA	☐	IS-H: Comment on Diagnosis
33	LGTXT	NDIA	LGTXT		☐	RI_LGTXT	☐	Indicator that Long Text Exists
34	DIASI	NDIA	DIASI		☐	DIASI	☐	IS-H: Diagnostic Certainty
35	ERDAT	NDIA	ERDAT		☐	RI_ERDAT	☐	IS-H: Date when Record Created
36	ERUSR	NDIA	ERUSR		☐	RI_ERNAM	☐	IS-H: Name of Employee who Created Record
37	UPDAT	NDIA	UPDAT		☐	RI_UPDAT	☐	IS-H: Date of Last Change
38	UPUSR	NDIA	UPUSR		☐	RI_UPNAM	☐	IS-H: Name of Person who Last Changed Data
39	FALAR	NFAL	FALAR		☐	FALLART	☐	IS-H: Case Type
40	STORN	NDIA	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
41	STUSR	NDIA	STUSR		☐	STORN_USER	☐	IS-H: Name of User who Canceled Data Record
42	STDAT	NDIA	STDAT		☐	STORN_DAT	☐	Date of Cancellation
43	ARDIA	NDIA	ARDIA		☐	N2_KZARDIA	☐	Working Diagnosis Indicator
44	PODIA	NDIA	PODIA		☐	N2_KZPODIA	☐	Preoperative Diagnosis Indicator
45	TUDIA	NDIA	TUDIA		☐	N2_KZTUDIA	☐	IS-H: Cause of Death Indicator
46	DIABZ	NDIA	DIABZ		☐	N2_DIABZ	☐	Diagnosis Reference
47	DIAPR	NDIA	DIAPR		☐	N2_DIAPR	☐	Medical Secondary Diagnosis Indicator
48	DIAGW	NDIA	DIAGW		☐	N2_DIASI	☐	Diagnostic Certainty
49	DIAZS	NDIA	DIAZS		☐	N2_DIAZS	☐	Diagnostic Suppl.
50	DIALO	NDIA	DIALO		☐	N2_DIALO	☐	IS-H: Localization of Diagnosis
51	EXTID	NDIA	EXTID		☐	N2_EXTID	☐	Internal Identifier of the Diagnosis Coding Tool
52	DIAFP	NDIA	DIAFP		☐	N2_DIAFP	☐	Flat Rate per Case
53	DTYP1	NDIA	DTYP1		☐	ISH_ICD10_DIATYP	☐	Type for ICD-10 Diagnoses
54	DTYP2	NDIA	DTYP2		☐	ISH_ICD10_DIATYP	☐	Type for ICD-10 Diagnoses
55	DTYP_REF	NDIA	DTYP_REF		☐	ISH_ICD10_DIATYP	☐	Type for ICD-10 Diagnoses
56	DRG_DIA_SEQNO	NDIA	DRG_DIA_SEQNO		☐	ISH_DRG_DIA_NB	☐	IS-H: Consecutive Numbering of DRG Diagnosis
57	DRG_CATEGORY	NDIA	DRG_CATEGORY		☐	ISH_DRG_DIA_CATEGORY	☐	IS-H: Category of DRG Diagnosis (Principal, Secondary)
58	DRG_CC	NDIA	DRG_CC		☐	ISH_DRG_DIA_CC	☐	IS-H: Comorbidity and Complication (DRG Diagnosis)
59	DRG_RELVANT	NDIA	DRG_RELVANT		☐	ISH_DRG_DIA_RELEVANT	☐	IS-H: Used to Determine DRG
60	ALTERN_DIATXT	NDIA	ALTERN_DIATXT		☐	ISH_ALTERN_DIATXT	☐	IS-H: Alternative Diagnosis Text (from External System)
61	TCODE	NDIA	TCODE		☐	ISH_TCODE	☐	IS-H: Report Control: Transaction Code for Application
62	DIA_LINK	NDIA	DIA_LINK		☐	ISH_DIA_LINK	☐	IS-H: Link to Another Diagnosis
63	CCL	NDIA	CCL		☐	ISH_CCL	☐	IS-H: Complication Level of Diagnoses (for DRGs)
64	BELNR	NDIA	BELNR		☐	KS_BELNR	☐	IS-H: Document Number of IV Document/Treatment Certificate
65	ERTIM	NDIA	ERTIM		☐	RI_ERTIM	☐	IS-H: Time Record Created
66	REFKY	NDIA	REFKY		☐	DIA_REFKEY	☐	IS-H: Reference Code of Diagnosis from External System
67	TIMESTAMP	NDIA	TIMESTAMP		☐	ISH_TIMESTAMP	☐	IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss)
68	DIAG_EXCF	NDIA	DIAG_EXCF		☐	ISH_DIA_EXCEPTION_FACTS	☐	IS-H: Diagnosenausnahmetatbestand

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20131127
SAP Release Created in