SAP ABAP Table RNPRQ_TRACHG (IS-H: BAdI ISH_API_PREREQUISITS - Change Transfer)

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

Table Category	INTTAB	Structure
Structure	RNPRQ_TRACHG	Table Relationship Diagram
Short Description	IS-H: BAdI ISH_API_PREREQUISITS - Change Transfer

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 Change Structure Transfer and Case
2	CASETYPE_EXT	☐	FALLARTE	FALLARTE	CHAR	1	0	IS-H: Case Type - User-Specific	*
3	CASETYPE_EXTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
4	CASE_COMMENT	☐	TEXT_NFAL	RI_BEMERK	CHAR	30	0	IS-H: Comment on Case
5	CASE_COMMENTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
6	CASE_CATEGORY	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category	TN15C
7	CASE_CATEGORYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
8	FOREIGN_CASE	☐	ISH_FOREIG	XFELD	CHAR	1	0	IS-H: Foreign Case
9	FOREIGN_CASEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
10	NON_RESIDENT	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
11	NON_RESIDENTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
12	GEOGR_AREA	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
13	GEOGR_AREAX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
14	EMERG_ADM	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
15	EMERG_ADMX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
16	QUICK_ADM	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
17	QUICK_ADMX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
18	START_DATE	☐	BEGDT_FAL	RI_DATUM	DATS	8	0	IS-H: Start Date of Case
19	START_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
20	END_DATE	☐	ENDDT_FAL	RI_DATUM	DATS	8	0	IS-H: End Date of Case
21	END_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
22	CASEENDTYPE	☐	ISH_CASEEND	ISH_CASEEND	CHAR	2	0	IS-H: Type of Case End	TN15D
23	CASEENDTYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
24	HEALED_DATE	☐	ISH_FPEDT	ISH_FPEDT	DATS	8	0	IS-H: Date of Wound Healing
25	HEALED_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
26	RESTRICTED	☐	SICHV	XFELD	CHAR	1	0	IS-H: Indicator for Restricted Patient
27	RESTRICTEDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
28	BILL_BLOCK	☐	FSPER	ISH_FSPER	CHAR	1	0	IS-H: Billing Block for Case
29	BILL_BLOCKX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
30	STATSTC_BLOCK	☐	ISH_STASP	XFELD	CHAR	1	0	IS-H: Indicator for Admission Type "Statistics Block"
31	STATSTC_BLOCKX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
32	PPA_RELEV	☐	ISH_KV_KZ	XFELD	CHAR	1	0	IS-H: Relevant for Panel Physician Association Billing
33	PPA_RELEVX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
34	REC_ORDER	☐	ISH_EAUFN	AUFNR	CHAR	12	0	IS-HCO: Receiver (Order)	AUFK
35	REC_ORDERX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
36	PREVIOUS_DAYS	☐	VOR_GRVER	GRVER	NUMC	3	0	IS-H: Previous Days to Be Deducted from Max. Length of Stay
37	PREVIOUS_DAYSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
38	CHILDREN	☐	ISH_CHILD	ISH_CHILD	CHAR	2	0	IS-H: Number of Children
39	CHILDRENX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
40	EMPLOYEE_TYPE	☐	ISH_EMTYPE	ISH_EMTYPE	CHAR	2	0	IS-H: Employee Type	TN15G
41	EMPLOYEE_TYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
42	CANTON_TARIFF	☐	NCH_TARCDE	NCH_TARCDE	CHAR	3	0	IS-H CH: Canton Tariff	TNCH12
43	CANTON_TARIFFX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
44	CANTON_CONVTN	☐	NCH_AGREEMENT	NCH_AGREEMENT	CHAR	3	0	IS-H CH: Convention (Hospital <-> Canton)	TNCH13
45	CANTON_CONVTNX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
46	APPLSTATUS	☐	ISH_APSTATE	ISH_APSTATE	CHAR	2	0	IS-H: Application Status	TNC301SA
47	APPLSTATUSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
48	SPECIALTY	☐	FACHRTY7	ISH_FACHR	CHAR	4	0	IS-H: Specialty for Organizational Unit	*
49	SPECIALTYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
50	MOVEMNT_TYPE	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
51	MOVEMNT_TYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
52	MOVEMNT_DATE	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
53	MOVEMNT_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
54	MOVEMNT_TIME	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
55	MOVEMNT_TIMEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
56	STATUS_IND	☐	PLANB	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Date of Movement
57	STATUS_INDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
58	PHONENO	☐	TELF_INT	TEXT16	CHAR	16	0	IS-H: Telephone Number of Patient in Institution
59	PHONENOX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
60	TV	☐	TVKZ	XFELD	CHAR	1	0	IS-H: TV Indicator
61	TVX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
62	DEPARTMENT	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
63	DEPARTMENTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
64	NURS_TREAT_OU	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
65	NURS_TREAT_OUX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
66	ROOM	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
67	ROOMX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
68	BED	☐	BETTID	BAUID	CHAR	8	0	IS-H: Building ID of Bed Location	NBAU
69	BEDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
70	ROOM_STATUS_IND	☐	ISH_PLANR	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Room Assignment
71	ROOM_STATUS_INDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
72	TREATMCATEGORY	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
73	TREATMCATEGORYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
74	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class	TNP01
75	CLASSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
76	UPDATE_DATE	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
77	UPDATE_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
78	UPDATE_USER	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
79	UPDATE_USERX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
80	DOC_TYPE	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
81	DOC_TYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
82	DOC_NO	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
83	DOC_NOX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
84	CHOICE_CL	☐	ISH_WKAT	ISH_WKAT	CHAR	1	0	IS-H: Choice of Ward Class	*
85	CHOICE_CLX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
86	PAT_WEIGHT	☐	ISH_PATGEW	ISH_GEWICH	QUAN	7	3	IS-H: Weight of Patient at Admission
87	PAT_WEIGHTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
88	WEIGHT_UNIT	☐	ISH_EINGEW	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Weight	*
89	WEIGHT_UNIT_ISO	☐	ISH_EINGEW_ISO	ISOCD_UNIT	CHAR	3	0	IS-H: ISO Unit of Measurement for Patient Weight	*
90	WEIGHT_UNITX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
91	PAT_HEIGHT	☐	ISH_PATGRO	ISH_GROESS	QUAN	5	2	IS-H: Height of Patient at Admission
92	PAT_HEIGHTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
93	HEIGHT_UNIT	☐	ISH_EINGRO	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Size	*
94	HEIGHT_UNIT_ISO	☐	ISH_EINGRO_ISO	ISOCD_UNIT	CHAR	3	0	IS-H: ISO Unit of Measurement for Patient Height (Size)	*
95	HEIGHT_UNITX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
96	SPECIALTY_TRANSFER	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty	TNKFA
97	SPECIALTY_TRANSFERX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
98	RESPIRATION	☐	ISH_RESPIRATION	NUM5	NUMC	5	0	IS-H: Duration of Mechanical Ventilation in Hours
99	RESPIRATIONX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
100	EXT_CASE_ID	☐	ISH_EXTNR_FAL	ISH_EXTNR_FAL	CHAR	20	0	IS-H: External Case Identification
101	EXT_CASE_IDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
102	EXT_MOVEMENT_ID	☐	ISH_EXTNR_BEW	ISH_EXTNR_BEW	CHAR	20	0	IS-H: External Movement Identification
103	EXT_MOVEMENT_IDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
104	ATT_PHYS	☐	BARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Attending Physician	*
105	ATT_PHYSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
106	NOBILL_DAYS	☐	ISH_TOB		NUMC	3	0	IS-H: Days Without Calculation
107	NOBILL_DAYSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
108	ATT_PHYS_LANR	☐	ISH_LANR_BA	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer des behandelnden Arztes
109	ATT_PHYS_LANRX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
110	MOVEMENT_TEXT	☐	ISH_T_TLINE		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNPRQ_TRACHG	APPLSTATUS	TNC301SA	APSTATE	KEY	1	CN
2	RNPRQ_TRACHG	BED	NBAU	BAUID		1	CN
3	RNPRQ_TRACHG	CANTON_CONVTN	TNCH13	AGREEMENT	KEY	1	CN
4	RNPRQ_TRACHG	CANTON_TARIFF	TNCH12	TARCDE	KEY	1	CN
5	RNPRQ_TRACHG	CASEENDTYPE	TN15D	ENDTYP	KEY	1	CN
6	RNPRQ_TRACHG	CASE_CATEGORY	TN15C	CASETY	KEY	1	CN
7	RNPRQ_TRACHG	CLASS	TNP01	CLASS	REF	1	CN
8	RNPRQ_TRACHG	DEPARTMENT	NORG	ORGID	REF	1	CN
9	RNPRQ_TRACHG	DOC_TYPE	TN17D	PASSTY	REF	1	CN
10	RNPRQ_TRACHG	EMPLOYEE_TYPE	TN15G	EMTYP	KEY	1	CN
11	RNPRQ_TRACHG	MOVEMNT_TYPE	TN14B	BWART	KEY	1	CN
12	RNPRQ_TRACHG	NURS_TREAT_OU	NORG	ORGID	REF	1	CN
13	RNPRQ_TRACHG	REC_ORDER	AUFK	AUFNR	KEY	1	CN
14	RNPRQ_TRACHG	ROOM	NBAU	BAUID	KEY	1	CN
15	RNPRQ_TRACHG	SPECIALTY_TRANSFER	TNKFA	FACHR	KEY	1	CN
16	RNPRQ_TRACHG	TREATMCATEGORY	TN24	BEKAT	KEY	1	CN

History

Last changed by/on	SAP	20110809
SAP Release Created in