SAP ABAP Table RNADRGPA (IS-H: Structure with address data for business partners)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NBAS (Package) Appl. development Hospital System master data, catalogs

Basic Data

Table Category	INTTAB	Structure
Structure	RNADRGPA	Table Relationship Diagram
Short Description	IS-H: Structure with address data for business partners

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: Business Partners
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	GPART	☐	GPARTNER	RI_KUNNR	CHAR	10	0	IS-H: Business Partner	*
4	INSTN	☐	INSTNR	INSTNR	CHAR	10	0	IS-H: Institute Indicator
5	NAME1	☐	GPNAM1	NAME	CHAR	35	0	IS-H: Last Name/ 1st Name
6	NAM1S	☐	GPNAM1S	NAM35	CHAR	35	0	IS-H: Standardized Last Name of Business Partner
7	NAME2	☐	GPNAM2	NAME	CHAR	35	0	IS-H: First Name / 2nd Name
8	NAM2S	☐	GPNAM2S	NAM35	CHAR	35	0	Standardized First Name/2nd Name of Business Partner
9	NAME3	☐	GPNAM3	NAME	CHAR	35	0	Third Name
10	KNAME	☐	KZNAME	ISH_C12	CHAR	12	0	IS-H: Short Name of Business Partner
11	NPKZ	☐	NATPERKZ	XFELD	CHAR	1	0	IS-H: Indicator for Natural Person (for Address Control)
12	SPRAS	☐	SPRAS_GP	SPRAS	LANG	1	0	IS-H: Language of Business Partner	T002
13	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	*
14	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
15	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	*
16	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	*
17	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
18	LAND	☐	LAND_GP	LAND1	CHAR	3	0	IS-H: Country of Business Partner	T005
19	REGIO	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	T005S
20	PSTLZ	☐	PSTLZ_GP	PSTLZ	CHAR	10	0	IS-H: Postal Code of Business Partner
21	PFACH	☐	PFACH_GP	ISH_PFACH	CHAR	10	0	IS-H: PO Box of Business Partner
22	PLZPF	☐	PLZPF_GP	ISH_PLZPF	CHAR	10	0	IS-H: Postal Code for PO Box of Business Partner
23	ORT	☐	ORT_GP	TEXT25	CHAR	25	0	IS-H: City of Business Partner
24	ORTS	☐	ORTS_GP	ISH30	CHAR	30	0	Standardized Name of City where Business Partner is Located
25	ORT2	☐	ORT2_GP	TEXT25	CHAR	25	0	District of Business Partner
26	STRAS	☐	STRASSE_GP	STRAS	CHAR	30	0	IS-H: Street Name and Street Number of Business Partner
27	TELFN	☐	TELEFON_GP	TEXT16	CHAR	16	0	IS-H: Telephone Number of Business Partner
28	TELFX	☐	TELEFAX_GP	TEXT31	CHAR	31	0	Fax Number of Business Partner
29	TELEX	☐	TELEX_GP	TEXT30	CHAR	30	0	Telex Number of Business Partner
30	KZTXT	☐	TEXT_GPA	TEXT50	CHAR	50	0	IS-H: Comment on Business Partner
31	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
32	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
33	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
34	LODAT	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
35	SPVON	☐	ISH_SPERRV	RI_DATUM	DATS	8	0	IS-H: Blocking Date from (Entry Block)
36	SPBIS	☐	ISH_SPERRB	RI_DATUM	DATS	8	0	IS-H: Blocking Date To (Entry Block To)
37	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
38	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
39	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
40	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
41	GPAR	☐	GPART	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the General Business Partner Function
42	PERS	☐	PERS_D	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYEE Function
43	KOSTR	☐	KOSTR	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the INSURANCE PROVIDER Function
44	DEBIT	☐	DEBIT	RI_ROLLE	CHAR	1	0	Text Designating the CUSTOMER Function
45	ARBTG	☐	ARBTG	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYER Function
46	KRKHS	☐	KRKHS	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the HOSPITAL Function
47	KNAMS	☐	KZNAMS	ISH_C12	CHAR	12	0	Standard Short Name for Search
48	SPTXT	☐	ISH_SPTEXT	TEXT50	CHAR	50	0	Reason for Blocking
49	SPTKZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
50	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
51	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
52	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
53	PNUMB	☐	ISH_PNUMB	CHAR15	CHAR	15	0	IS-H: External Partner Number
54	PARTNER_GUID	☐	ISH_PARTNER_GUID	SYSUUID	RAW	16	0	IS-H: GUID of Business Partner
55	TITEL1	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
56	.INCLU-ADR	☐				0	0	IS-H: Addresses (Central Address Management)
57	MANDTADR	☐	MANDT	MANDT	CLNT	3	0	Client	T000
58	ADRNRADR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	*
59	ADROBADR	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
60	PSTLZADR	☐	ISH_PSTLZO	PSTLZ	CHAR	10	0	IS-H: Postal Code of City
61	LANDADR	☐	ISH_LAND	LAND1	CHAR	3	0	IS-H: Country	T005
62	REGIOADR	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	T005S
63	ORTADR	☐	ISH_CITY1	TEXT40	CHAR	40	0	IS-H: City
64	ORT2ADR	☐	ISH_CITY2	TEXT40	CHAR	40	0	IS-H: District
65	STRASADR	☐	ISH_STRASS	TEXT40	CHAR	40	0	IS-H: Street
66	STRAZADR	☐	ISH_STRASZ	TEXT40	CHAR	40	0	IS-H: Other Designation Qualifying the Address
67	EINZGADR	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
68	PSTLPADR	☐	ISH_PSTLZP	PSTLZ	CHAR	10	0	IS-H: Postal Code of P.O. Box
69	PFACHADR	☐	ISH_POBOX	ISH_PFACH	CHAR	10	0	IS-H: Post Office Box
70	LANPFADR	☐	ISH_LANDPB	LAND1	CHAR	3	0	IS-H: Country of Post Office Box	T005
71	ORTPFADR	☐	ISH_CITYPB	TEXT40	CHAR	40	0	IS-H: PO Box City
72	PSTLFADR	☐	ISH_PSTLZF	PSTLZ	CHAR	10	0	IS-H: Postal Code of Company (for Major Accounts)
73	TELNRADR	☐	ISH_TELNR	CHAR30	CHAR	30	0	IS-H: Telephone Number
74	TELXTADR	☐	ISH_TELEXT	CHAR10	CHAR	10	0	Telephone Number - Extension
75	FAXNRADR	☐	ISH_FAXNR	CHAR30	CHAR	30	0	Fax Number
76	FAXXTADR	☐	ISH_FAXEXT	CHAR10	CHAR	10	0	IS-H: Fax Number - Extension
77	TEXNRADR	☐	ISH_TELETX	TEXT30	CHAR	30	0	IS-H: Telex Number
78	BUILDADR	☐	ISH_BUILD	TEXT10	CHAR	10	0	IS-H: Block/House
79	FLOORADR	☐	ISH_FLOOR	TEXT10	CHAR	10	0	IS-H: Block/House Level
80	ROOMADR	☐	ISH_ROOM	TEXT10	CHAR	10	0	IS-H: Unit Number
81	STORTADR	☐	ISH_STCITY	CHAR40	CHAR	40	0	Standardized City Name
82	STOTTADR	☐	ISH_STCIT2	CHAR40	CHAR	40	0	Standardized District
83	STSTRADR	☐	ISH_STSTR	CHAR40	CHAR	40	0	Standardized Street
84	STSTZADR	☐	ISH_STSTRZ	CHAR40	CHAR	40	0	IS-H: Standardized Street Supplement
85	STORPADR	☐	ISH_STCITP	CHAR40	CHAR	40	0	Standardized City Name of P.O. Box
86	TELKZADR	☐	ISH_WTELKZ	XFELD	CHAR	1	0	IS-H: Indicator that More Tel. Nos. Exist for Address
87	EMAILADR	☐	ISH_SMTPADR	AD_SMTPADR	CHAR	241	0	IS-H: Internet Mail (SMTP) Address

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNADRGPA	ADRNR	NADR	ADRNR
2	RNADRGPA	LAND	T005	LAND1	REF	1	CN
3	RNADRGPA	LANDADR	T005	LAND1		1	CN
4	RNADRGPA	LANPFADR	T005	LAND1		1	CN
5	RNADRGPA	MANDT	T000	MANDT	KEY	1	CN
6	RNADRGPA	MANDTADR	T000	MANDT		1	CN
7	RNADRGPA	REGIO	T005S	BLAND	REF	C	CN
8	RNADRGPA	REGIOADR	T005S	BLAND		1	CN
9	RNADRGPA	SPRAS	T002	SPRAS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in