SAP ABAP Table RN1PARTNER (IS-H*MED: Employees per Organizational Unit)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H-PM (Application Component) Patient Management
     ⤷ N1BASE (Package) IS-H: Basic Functionality; TSA Development

Basic Data

Table Category	INTTAB	Structure
Structure	RN1PARTNER	Table Relationship Diagram
Short Description	IS-H*MED: Employees per Organizational Unit

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	ORGID	☐	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key	*
2	EXTERN	☐	ISH_ON_OFF	ISH_ON_OFF	CHAR	1	0	IS-H: Boolscher Datentyp für ON (= 'X') und OFF (=' ')
3	.INCLUDE	☐				0	0	IS-H: Business Partners
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	GPART	☐	GPARTNER	RI_KUNNR	CHAR	10	0	IS-H: Business Partner	*
6	INSTN	☐	INSTNR	INSTNR	CHAR	10	0	IS-H: Institute Indicator
7	NAME1	☐	GPNAM1	NAME	CHAR	35	0	IS-H: Last Name/ 1st Name
8	NAM1S	☐	GPNAM1S	NAM35	CHAR	35	0	IS-H: Standardized Last Name of Business Partner
9	NAME2	☐	GPNAM2	NAME	CHAR	35	0	IS-H: First Name / 2nd Name
10	NAM2S	☐	GPNAM2S	NAM35	CHAR	35	0	Standardized First Name/2nd Name of Business Partner
11	NAME3	☐	GPNAM3	NAME	CHAR	35	0	Third Name
12	KNAME	☐	KZNAME	ISH_C12	CHAR	12	0	IS-H: Short Name of Business Partner
13	NPKZ	☐	NATPERKZ	XFELD	CHAR	1	0	IS-H: Indicator for Natural Person (for Address Control)
14	SPRAS	☐	SPRAS_GP	SPRAS	LANG	1	0	IS-H: Language of Business Partner	T002
15	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	*
16	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
17	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	*
18	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	*
19	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
20	LAND	☐	LAND_GP	LAND1	CHAR	3	0	IS-H: Country of Business Partner	T005
21	REGIO	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	T005S
22	PSTLZ	☐	PSTLZ_GP	PSTLZ	CHAR	10	0	IS-H: Postal Code of Business Partner
23	PFACH	☐	PFACH_GP	ISH_PFACH	CHAR	10	0	IS-H: PO Box of Business Partner
24	PLZPF	☐	PLZPF_GP	ISH_PLZPF	CHAR	10	0	IS-H: Postal Code for PO Box of Business Partner
25	ORT	☐	ORT_GP	TEXT25	CHAR	25	0	IS-H: City of Business Partner
26	ORTS	☐	ORTS_GP	ISH30	CHAR	30	0	Standardized Name of City where Business Partner is Located
27	ORT2	☐	ORT2_GP	TEXT25	CHAR	25	0	District of Business Partner
28	STRAS	☐	STRASSE_GP	STRAS	CHAR	30	0	IS-H: Street Name and Street Number of Business Partner
29	TELFN	☐	TELEFON_GP	TEXT16	CHAR	16	0	IS-H: Telephone Number of Business Partner
30	TELFX	☐	TELEFAX_GP	TEXT31	CHAR	31	0	Fax Number of Business Partner
31	TELEX	☐	TELEX_GP	TEXT30	CHAR	30	0	Telex Number of Business Partner
32	KZTXT	☐	TEXT_GPA	TEXT50	CHAR	50	0	IS-H: Comment on Business Partner
33	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
34	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
35	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
36	LODAT	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
37	SPVON	☐	ISH_SPERRV	RI_DATUM	DATS	8	0	IS-H: Blocking Date from (Entry Block)
38	SPBIS	☐	ISH_SPERRB	RI_DATUM	DATS	8	0	IS-H: Blocking Date To (Entry Block To)
39	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
40	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
41	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
42	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
43	GPAR	☐	GPART	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the General Business Partner Function
44	PERS	☐	PERS_D	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYEE Function
45	KOSTR	☐	KOSTR	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the INSURANCE PROVIDER Function
46	DEBIT	☐	DEBIT	RI_ROLLE	CHAR	1	0	Text Designating the CUSTOMER Function
47	ARBTG	☐	ARBTG	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYER Function
48	KRKHS	☐	KRKHS	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the HOSPITAL Function
49	KNAMS	☐	KZNAMS	ISH_C12	CHAR	12	0	Standard Short Name for Search
50	SPTXT	☐	ISH_SPTEXT	TEXT50	CHAR	50	0	Reason for Blocking
51	SPTKZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
52	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
53	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
54	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
55	PNUMB	☐	ISH_PNUMB	CHAR15	CHAR	15	0	IS-H: External Partner Number
56	PARTNER_GUID	☐	ISH_PARTNER_GUID	SYSUUID	RAW	16	0	IS-H: GUID of Business Partner
57	TITEL1	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RN1PARTNER	ADRNR	NADR	ADRNR	REF	C	C
2	RN1PARTNER	LAND	T005	LAND1	REF	1	CN
3	RN1PARTNER	MANDT	T000	MANDT	KEY	1	CN
4	RN1PARTNER	REGIO	T005S	BLAND	REF	C	CN
5	RN1PARTNER	SPRAS	T002	SPRAS	REF	1	CN

History

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