SAP ABAP Table VRNG12N (IS-H: FI Customer Update Structure)

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	VRNG12N	Table Relationship Diagram
Short Description	IS-H: FI Customer Update Structure

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

Foreign Keys

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

History

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