SAP ABAP Table N_PAP_PIX (Generated Table for View N_PAP_PIX)

Basic Data

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

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	NNAMS	☑	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
3	NNAME	☑	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
4	CH_NAME	☑	CH_NAME	XFELD	CHAR	1	0	IS-H: Indicator for changed last name
5	VNAMS	☑	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
6	PAPID	☑	ISH_PAPID	ISH_PAPID	CHAR	10	0	IS-H: Provisional Patient Number
7	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
8	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
9	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
10	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
11	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
12	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	T535N
13	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	T535N
14	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	T535N
15	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key
16	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
17	RVNUM	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
18	PASSTY	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
19	PASSNR	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
20	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
21	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
22	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
23	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
24	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
25	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
26	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
27	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
28	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
29	NNAMP	☐	NNAME_PHON	CHAR30	CHAR	30	0	IS-H: Phonetic last name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_PAP_PIX	ADRNR	NADR	ADRNR	REF	1	C
2	N_PAP_PIX	MANDT	T000	MANDT	KEY	1	CN
3	N_PAP_PIX	NAMZU	T535N	TITEL	REF	1	CN
4	N_PAP_PIX	PASSTY	TN17D	PASSTY	REF	1	CN
5	N_PAP_PIX	TITEL	T535N	TITEL	REF	1	CN
6	N_PAP_PIX	VORSW	T535N	TITEL	REF	1	CN

History

Last changed by/on	SAP	20060313
SAP Release Created in