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