SAP ABAP Table N_VDIAPAT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VDIAPAT	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EINRI	☑	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
3	FALNR	☑	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
4	LFDNR	☑	LFDDIA	LFDDIA	NUMC	3	0	IS-H: Sequence Number of Diagnosis
5	LFDBEW	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement
6	PLANB	☐	PLANB	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Date of Movement
7	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
8	BWEDT	☐	BWEDT	RI_DATUM	DATS	8	0	IS-H: Movement End Date, Start Date of Subsequent Movement
9	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
10	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
11	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
12	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
13	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
14	DKAT1	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
15	DKEY1	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code	NKDI
16	DTYP1	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
17	DKAT2	☐	DIAKAT	KATID	CHAR	2	0	IS-H: Identification Key of Diagnosis Coding Catalog	TNK00
18	DKEY2	☐	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code	NKDI
19	DTYP2	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
20	DKAT_REF	☐	REF_DIAKAT	KATID	CHAR	2	0	IS-H: Catalog ID of Reference Catalog for Statistics	TNK00
21	DKEY_REF	☐	REF_DIAID	DIAID	CHAR	30	0	IS-H: Reference Diagnosis Code for Statistics	NKDI
22	DTYP_REF	☐	ISH_ICD10_DIATYP	ISH_DIATYP	CHAR	1	0	Type for ICD-10 Diagnoses
23	DITXT	☐	ISH_DITEXT	TEXT50	CHAR	50	0	IS-H: Free-Text Diagnosis
24	DILTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
25	DIADT	☐	DIADT	RI_DATUM	DATS	8	0	IS-H: Date on which Diagnosis Was Created
26	DIAZT	☐	DIAZT	UHRZT	TIMS	6	0	IS-H: Time at which Diagnosis Created
27	DIAPE	☐	DIA_PERS	RI_KUNNR	CHAR	10	0	IS-H: Identification of Diagnosing Person	NGPA
28	ANZOP	☐	ANZOP	NUM02	NUMC	2	0	IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis
29	EWDIA	☐	KZ_EINWD	XFELD	CHAR	1	0	IS-H: Referral Diagnosis Indicator
30	BHDIA	☐	KZ_BEHLD	XFELD	CHAR	1	0	IS-H: Treatment Diagnosis Indicator
31	AFDIA	☐	KZ_AUFND	XFELD	CHAR	1	0	IS-H: Admission Diagnosis Indicator
32	ENDIA	☐	KZ_ENTLD	XFELD	CHAR	1	0	IS-H: "Discharge Diagnosis" Indicator
33	FHDIA	☐	KZ_FAHPD	XFELD	CHAR	1	0	IS-H: "Department Main Diagnosis" Indicator
34	KHDIA	☐	KZ_KHHPD	XFELD	CHAR	1	0	IS-H: Hospital Main Diagnosis Indicator
35	OPDIA	☐	KZ_OPERD	XFELD	CHAR	1	0	IS-H: Surgery Diagnosis Indicator
36	DIALO	☐	N2_DIALO	N2_DIALO	CHAR	2	0	IS-H: Localization of Diagnosis	TN26E
37	DIAGW	☐	N2_DIASI	N2_DIASI	CHAR	2	0	Diagnostic Certainty	TN26C
38	SPERR	☐	RI_SPERR	XFELD	CHAR	1	0	Blocking Indicator
39	KZTXT	☐	TEXT_DIA	TEXT50	CHAR	50	0	IS-H: Comment on Diagnosis
40	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
41	DIASI	☐	DIASI	DIASI	CHAR	1	0	IS-H: Diagnostic Certainty
42	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
43	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
44	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
45	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
46	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
47	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
48	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
49	DRG_CATEGORY	☐	ISH_DRG_DIA_CATEGORY	ISH_DRG_DIA_CAT_TYPE	CHAR	1	0	IS-H: Category of DRG Diagnosis (Principal, Secondary)
50	DRG_RELEVANT	☐	ISH_DRG_DIA_RELEVANT	ISH_ON_OFF	CHAR	1	0	IS-H: Used to Determine DRG
51	DRG_CC	☐	ISH_DRG_DIA_CC	ISH_ON_OFF	CHAR	1	0	IS-H: Comorbidity and Complication (DRG Diagnosis)
52	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
53	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
54	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
55	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
56	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
57	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
58	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
59	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
60	EXTKH	☐	EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Identification of an External Hospital	NGPA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VDIAPAT	BWART	TN14B	BWART	REF	1	CN
2	N_VDIAPAT	DIAGW	TN26C	DIASI	KEY	1	CN
3	N_VDIAPAT	DIALO	TN26E	DIALO	KEY	1	CN
4	N_VDIAPAT	DIAPE	NGPA	GPART	KEY	1	CN
5	N_VDIAPAT	DKAT1	TNK00	KATID	REF	1	CN
6	N_VDIAPAT	DKAT2	TNK00	KATID	REF	1	CN
7	N_VDIAPAT	DKAT_REF	TNK00	KATID	REF	1	CN
8	N_VDIAPAT	DKEY1	NKDI	DKEY	REF	1	CN
9	N_VDIAPAT	DKEY2	NKDI	DKEY	REF	1	CN
10	N_VDIAPAT	DKEY_REF	NKDI	DKEY	REF	1	CN
11	N_VDIAPAT	EINRI	TN01	EINRI	KEY	1	CN
12	N_VDIAPAT	EXTKH	NGPA	GPART	REF	1	CN
13	N_VDIAPAT	FALNR	NFAL	FALNR	KEY	1	N
14	N_VDIAPAT	MANDT	T000	MANDT	KEY	1	CN
15	N_VDIAPAT	ORGFA	NORG	ORGID	REF	1	CN
16	N_VDIAPAT	ORGPF	NORG	ORGID	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in