SAP ABAP Table ISH_NL_BAPI1084SRCH_EXT (BAPI1084SRCH plus extra textfield)

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	INTTAB	Structure
Structure	ISH_NL_BAPI1084SRCH_EXT	Table Relationship Diagram
Short Description	BAPI1084SRCH plus extra textfield

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	.INCLUDE	☐				0	0	IS-H BAPI Patient List
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PATIENTID	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
4	CHKDIGITPAT	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
5	EXT_PAT_ID	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
6	INSTITUTION	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
7	INST_STEXT	☐	EINKB	TEXT15	CHAR	15	0	IS-H: Short Text for Institution
8	CANCEL_IND	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
9	LAST_NAME_PAT	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
10	STD_LNAME_PAT	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
11	FRST_NAME_PAT	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
12	STD_FNAME_PAT	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
13	PREFIX	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	T535N
14	AFFIX	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	T535N
15	TITLE	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	T535N
16	PSEUDO	☐	NAME2_PAT	TEXT30	CHAR	30	0	Pseudonym, Order Name
17	FULL_NAME_PAT	☐	RI_NAME	TEXT30	CHAR	30	0	IS-H: Patient Name
18	BIRTH_NAME	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
19	STD_BNAME_PAT	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
20	DOB	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
21	SEX	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
22	SEX_EXT	☐	GSCHLE	GSCHLE	CHAR	1	0	IS-H: Sex Indicator - User-Specific	TN17G
23	SEX_STEXT	☐	TEXT_GES	TEXT10	CHAR	10	0	IS-H: Sex Specification - User-Specific
24	SSN	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
25	DOC_TYPE	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
26	DOC_TYPE_TEXT	☐	ISH_PASSTX	TEXT15	CHAR	15	0	Text for Identification Document Type
27	DOC_NO	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
28	NON_RESIDENT	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
29	EXPIRED	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
30	C_OF_DEATH	☐	TODUR	TODUR	CHAR	3	0	IS-H: Cause of Death	TN18A
31	C_OF_DEATHTXT	☐	TUTXT	TEXT20	CHAR	20	0	IS-H: Cause of Death Text
32	QUICK_ADM	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
33	EMERG_ADM	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
34	COUNTRY	☐	LAND_PAT	LAND1	CHAR	3	0	IS-H: Country of patient's place of residence	T005
35	COUNTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
36	COUNTRY_TEXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
37	PCD	☐	ISH_PSTLZO	PSTLZ	CHAR	10	0	IS-H: Postal Code of City
38	CITY	☐	ISH_CITY1	TEXT40	CHAR	40	0	IS-H: City
39	DISTRICT	☐	ISH_CITY2	TEXT40	CHAR	40	0	IS-H: District
40	STR_NO	☐	ISH_STRASS	TEXT40	CHAR	40	0	IS-H: Street
41	PHONENO	☐	ISH_TELNR	CHAR30	CHAR	30	0	IS-H: Telephone Number
42	ADDRESS	☐	ISH_PADRES	TEXT50	CHAR	50	0	IS-H: Patient address
43	PAT_REF	☐	RFPAT	PATNR	CHAR	10	0	Reference to Patient Number in Merging
44	APPT_ID	☐	ISH_TMNID	ISH_LNRAPP	CHAR	10	0	IS-H: Identification of Appointment
45	VIP	☐	VIPKZ	XFELD	CHAR	1	0	IS-H: VIP Indicator
46	INACTIVE	☐	ISH_INACTIVE	XFELD	CHAR	1	0	'Inactive' Indicator
47	KD_ICO	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISH_NL_BAPI1084SRCH_EXT	AFFIX	T535N	TITEL	KEY	1	CN
2	ISH_NL_BAPI1084SRCH_EXT	CLIENT	T000	MANDT	KEY	1	CN
3	ISH_NL_BAPI1084SRCH_EXT	COUNTRY	T005	LAND1	KEY	1	CN
4	ISH_NL_BAPI1084SRCH_EXT	C_OF_DEATH	TN18A	TODUR	KEY	1	CN
5	ISH_NL_BAPI1084SRCH_EXT	DOC_TYPE	TN17D	PASSTY	KEY	1	CN
6	ISH_NL_BAPI1084SRCH_EXT	INSTITUTION	TN01	EINRI	KEY	1	CN
7	ISH_NL_BAPI1084SRCH_EXT	PREFIX	T535N	TITEL	KEY	1	CN
8	ISH_NL_BAPI1084SRCH_EXT	SEX_EXT	TN17G	GSCHLE	KEY	1	CN
9	ISH_NL_BAPI1084SRCH_EXT	TITLE	T535N	TITEL	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	700