SAP ABAP Table RNG12N (IS-H: FI Customer Data with Reference to NPIR)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPAS (Package) Application development patient accounting system

Basic Data

Table Category	INTTAB	Structure
Structure	RNG12N	Table Relationship Diagram
Short Description	IS-H: FI Customer Data with Reference to NPIR

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	LFDNR	☐	LFDVV	LFDVV	NUMC	3	0	IS-H: Sequence Number of Insurance Relationship
2	NUMKZ	☐	ISH_NUMKZ		CHAR	1	0	IS-H: (E)xternal or (I)nternal Number Assignment Customer
3	NO_B_SEGM	☐	ISH_NO_B_SEGM	ISH_ON_OFF	CHAR	1	0	IS-H: Company Code Data is Missing for Customer
4	.INCLUDE	☐				0	0	IS-H: Table for creating customer in RF/FI from IS-H
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
7	KUNNR	☐	RF_KUNNR	KUNNR	CHAR	10	0	Customer Number of FI Customer	*
8	PATKZ	☐	ISH_PATKZ	XFELD	CHAR	1	0	IS-H: Indicator for Self-Payer Insurance Relationship
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
11	NAME1	☐	GPNAM1	NAME	CHAR	35	0	IS-H: Last Name/ 1st Name
12	NAME2	☐	GPNAM2	NAME	CHAR	35	0	IS-H: First Name / 2nd Name
13	NAME3	☐	GPNAM3	NAME	CHAR	35	0	Third Name
14	ORT	☐	ORT01_GP	TEXT35	CHAR	35	0	City
15	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
16	ORT2	☐	ORT02_GP	TEXT35	CHAR	35	0	District
17	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
18	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
19	LAND	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
20	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
21	TELF1	☐	TELEFON_GP	TEXT16	CHAR	16	0	IS-H: Telephone Number of Business Partner
22	TELFX	☐	TELEFAX_GP	TEXT31	CHAR	31	0	Fax Number of Business Partner
23	TELEX	☐	TELEX_GP	TEXT30	CHAR	30	0	Telex Number of Business Partner
24	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
25	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
26	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
27	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
28	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
29	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
30	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKB1
31	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	*
32	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
33	VTEXT	☐	DZTERM_BEZ	TEXT30	CHAR	30	0	Description of terms of payment
34	MAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	*
35	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
36	BANAM	☐	BANAM	TEXT35	CHAR	35	0	IS-H: Name of Bank
37	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
38	BEGRS	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
39	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
40	BEGRF	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
41	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
42	BUSAB_MA	☐	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	*
43	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	*
44	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	*
45	SELBZ	☐	ISH_SELBZ	XFELD	CHAR	1	0	IS-H: Indicator whether Self-Payer or IS-H Customer Created
46	MAHNA_2	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	*
47	BUSAB_MA2	☐	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	*
48	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
49	MABER_2	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
50	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	*
51	XZVER	☐	XZVER	XFELD	CHAR	1	0	Indicator: Record Payment History ?
52	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	*
53	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
54	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
55	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	*
56	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	*
57	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	*
58	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
59	ALTKN	☐	ALTKN	CHAR10	CHAR	10	0	Previous Master Record Number
60	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	*
61	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
62	REGIO	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	*
63	STRAZ	☐	ISH_STRASZ	TEXT40	CHAR	40	0	IS-H: Other Designation Qualifying the Address
64	EINZG	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
65	LANPF	☐	ISH_LANDPB	LAND1	CHAR	3	0	IS-H: Country of Post Office Box	*
66	ORTPF	☐	ISH_CITYPB	TEXT40	CHAR	40	0	IS-H: PO Box City
67	PSTLF	☐	ISH_PSTLZF	PSTLZ	CHAR	10	0	IS-H: Postal Code of Company (for Major Accounts)
68	TELXT	☐	ISH_TELEXT	CHAR10	CHAR	10	0	Telephone Number - Extension
69	FAXXT	☐	ISH_FAXEXT	CHAR10	CHAR	10	0	IS-H: Fax Number - Extension
70	BUILD	☐	ISH_BUILD	TEXT10	CHAR	10	0	IS-H: Block/House
71	FLOOR	☐	ISH_FLOOR	TEXT10	CHAR	10	0	IS-H: Block/House Level
72	ROOM	☐	ISH_ROOM	TEXT10	CHAR	10	0	IS-H: Unit Number
73	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
74	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
75	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
76	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
77	KOINH	☐	KOINH_FI	KOINH	CHAR	60	0	Account Holder Name
78	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
79	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
80	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
81	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	T056
82	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
83	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
84	ZSABE	☐	DZSABE_D	TEXT15	CHAR	15	0	User at customer
85	XAUSZ	☐	XAUSZ	AUSZG	CHAR	1	0	Indicator for periodic account statements	T048K
86	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
87	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
88	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
89	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
90	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
91	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
92	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
93	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
94	HSNM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
95	HSNM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
96	CITY3	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
97	TZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
98	TXJCD	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
99	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
100	CONAM	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
101	STREET2	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
102	STREET3	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
103	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
104	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
105	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
106	ANREDE	☐	RI_ANTXT	TEXT25	CHAR	25	0	IS-H: Form-of-Address Text
107	TELNR	☐	ISH_TELNR	CHAR30	CHAR	30	0	IS-H: Telephone Number
108	PO_BX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
109	TITEL1	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
110	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
111	IBAN_DATE	☐	IBAN_VALFR	DATUM	DATS	8	0	Validity start of IBAN

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNG12N	AKONT	SKB1	SAKNR
2	RNG12N	BUKRS	T001	BUKRS
3	RNG12N	CITYC	T005G	CITYC	REF	C	CN
4	RNG12N	COUNC	T005E	COUNC	REF	C	CN
5	RNG12N	KNRZA	KNA1	KUNNR	REF	C	CN
6	RNG12N	MANDT	T000	MANDT
7	RNG12N	VZSKZ	T056	VZSKZ	REF	C	CN
8	RNG12N	XAUSZ	T048K	XAUSZ	REF	C	CN

History

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