SAP ABAP Table N_PFLISTEN (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_PFLISTEN	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	☑	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement
5	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
6	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
7	STATUF	☐	FALLSTATUS	FALLSTATUS	CHAR	1	0	IS-H: Case Status
8	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
9	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
10	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
11	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
12	PLANB	☐	PLANB	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Date of Movement
13	BWEDT	☐	BWEDT	RI_DATUM	DATS	8	0	IS-H: Movement End Date, Start Date of Subsequent Movement
14	BWEZT	☐	BWEZT	UHRZT	TIMS	6	0	IS-H: Movement End Time, Start Time of Subsequent Movement
15	TELNR	☐	TELF_INT	TEXT16	CHAR	16	0	IS-H: Telephone Number of Patient in Institution
16	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
17	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
18	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
19	BETT	☐	BETTID	BAUID	CHAR	8	0	IS-H: Building ID of Bed Location	NBAU
20	PLANR	☐	ISH_PLANR	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Room Assignment
21	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
22	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
23	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
24	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
25	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
26	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
27	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
28	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
29	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
30	KONFE	☐	RI_KONFE	RI_KONFE	CHAR	2	0	IS-H: Religion
31	NATIO	☐	RI_NATIO	LAND1	CHAR	3	0	IS-H: Nationality	T005
32	LAND	☐	LAND_PAT	LAND1	CHAR	3	0	IS-H: Country of patient's place of residence	T005
33	PSTLZ	☐	PSTLZ_PAT	PSTLZ	CHAR	10	0	IS-H: Patient Postal Code
34	ORT	☐	ORT01_PAT	TEXT25	CHAR	25	0	IS-H: City where Patient Resides
35	STRAS	☐	STRAS_PAT	STRAS	CHAR	30	0	IS-H: Street and House Number of Patient
36	VIPKZ	☐	VIPKZ	XFELD	CHAR	1	0	IS-H: VIP Indicator
37	STATU	☐	PAT_STATUS	PAT_STATUS	CHAR	1	0	Patient Status
38	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
39	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
40	PLANE	☐	PLANE	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for End Date of Movement
41	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
42	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
43	ADRN2	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
44	ADRO2	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
45	PLSNR	☐	ISH_EXTNR_PLS	ISH_EXTNR_PLS	CHAR	20	0	IS-H: PRS Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_PFLISTEN	ADRN2	NADR	ADRNR	REF	1	C
2	N_PFLISTEN	ADRNR	NADR	ADRNR	REF	1	C
3	N_PFLISTEN	BETT	NBAU	BAUID	REF	1	CN
4	N_PFLISTEN	BWART	TN14B	BWART	REF	1	CN
5	N_PFLISTEN	EINRI	TN01	EINRI	KEY	1	CN
6	N_PFLISTEN	FALNR	NFAL	FALNR	KEY	1	N
7	N_PFLISTEN	LAND	T005	LAND1	REF	1	CN
8	N_PFLISTEN	MANDT	T000	MANDT	KEY	1	CN
9	N_PFLISTEN	NATIO	T005	LAND1	REF	1	CN
10	N_PFLISTEN	ORGFA	NORG	ORGID	REF	1	CN
11	N_PFLISTEN	ORGPF	NORG	ORGID	REF	1	CN
12	N_PFLISTEN	PATNR	NPAT	PATNR	REF	1	CN
13	N_PFLISTEN	ZIMMR	NBAU	BAUID	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in