SAP ABAP Table RNG99 (IS-H: Customer-specific fields for filling FI customer)
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
⤷ 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 | RNG99 | Table Relationship Diagram |
Short Description | IS-H: Customer-specific fields for filling FI customer |
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 | * | |
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 | * | |
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 | * | |
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 | MAHNA | MAHNA | MAHNA | CHAR | 4 | 0 | Dunning Procedure | * | |
30 | LANDX | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
31 | BANAM | BANAM | TEXT35 | CHAR | 35 | 0 | IS-H: Name of Bank | ||
32 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
33 | BEGRS | BRGRU | BRGRU | CHAR | 4 | 0 | Authorization Group | * | |
34 | ZWELS | DZWELS | ZWELS | CHAR | 10 | 0 | List of the Payment Methods to be Considered | ||
35 | BEGRF | BRGRU | BRGRU | CHAR | 4 | 0 | Authorization Group | * | |
36 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
37 | BUSAB_MA | BUSAB_MA | BUSAB | CHAR | 2 | 0 | Dunning clerk | * | |
38 | BUSAB | BUSAB | BUSAB | CHAR | 2 | 0 | Accounting clerk | * | |
39 | DEBNR | KH_DEBNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Customer (IS-H supplement) | * | |
40 | TOGRU | TOGRU | TOGRU | CHAR | 4 | 0 | Tolerance group for the business partner/G/L account | * | |
41 | MAHNA_2 | MAHNA | MAHNA | CHAR | 4 | 0 | Dunning Procedure | * | |
42 | BUSAB_MA2 | BUSAB_MA | BUSAB | CHAR | 2 | 0 | Dunning clerk | * | |
43 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | * | |
44 | MABER_2 | MABER | MABER | CHAR | 2 | 0 | Dunning Area | * | |
45 | FDGRV | FDGRV | FDGRP | CHAR | 10 | 0 | Planning group | * | |
46 | XZVER | XZVER | XFELD | CHAR | 1 | 0 | Indicator: Record Payment History ? | ||
47 | ZAHLS | DZAHLS | ZAHLS | CHAR | 1 | 0 | Block Key for Payment | * | |
48 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
49 | TITEL | RI_TITEL | TITEL | CHAR | 15 | 0 | IS-H: Title | * | |
50 | NAMZU | RI_NAMZU | TITEL | CHAR | 15 | 0 | IS-H: Name Affix | * | |
51 | VORSW | RI_VORSW | TITEL | CHAR | 15 | 0 | IS-H: Name Prefix | * | |
52 | MGRUP | MGRUP | MGRUP | CHAR | 2 | 0 | Key for dunning notice grouping | * | |
53 | BRSCH | BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | * | |
54 | ALTKN | ALTKN | CHAR10 | CHAR | 10 | 0 | Previous Master Record Number | ||
55 | ADRNR | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | * | |
56 | ADROB | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object | ||
57 | REGIO | ISH_REGION | REGIO | CHAR | 3 | 0 | IS-H: Region (Federal State, Province, County) | * | |
58 | STRAZ | ISH_STRASZ | TEXT40 | CHAR | 40 | 0 | IS-H: Other Designation Qualifying the Address | ||
59 | EINZG | EINZGEBIET | EINZGEBIET | CHAR | 9 | 0 | IS-H: Geographical Area | ||
60 | LANPF | ISH_LANDPB | LAND1 | CHAR | 3 | 0 | IS-H: Country of Post Office Box | * | |
61 | ORTPF | ISH_CITYPB | TEXT40 | CHAR | 40 | 0 | IS-H: PO Box City | ||
62 | PSTLF | ISH_PSTLZF | PSTLZ | CHAR | 10 | 0 | IS-H: Postal Code of Company (for Major Accounts) | ||
63 | TELXT | ISH_TELEXT | CHAR10 | CHAR | 10 | 0 | Telephone Number - Extension | ||
64 | FAXXT | ISH_FAXEXT | CHAR10 | CHAR | 10 | 0 | IS-H: Fax Number - Extension | ||
65 | BUILD | ISH_BUILD | TEXT10 | CHAR | 10 | 0 | IS-H: Block/House | ||
66 | FLOOR | ISH_FLOOR | TEXT10 | CHAR | 10 | 0 | IS-H: Block/House Level | ||
67 | ROOM | ISH_ROOM | TEXT10 | CHAR | 10 | 0 | IS-H: Unit Number | ||
68 | NAME4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
69 | BKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
70 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
71 | BKREF | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
72 | KOINH | KOINH_FI | KOINH | CHAR | 60 | 0 | Account Holder Name | ||
73 | STCD1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
74 | STCD2 | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
75 | KNRZA | KNRZA | KUNNR | CHAR | 10 | 0 | Account number of an alternative payer | KNA1 | |
76 | VZSKZ | VZSKZ | VZSKZ | CHAR | 2 | 0 | Interest calculation indicator | T056 | |
77 | ZINDT | DZINDT | DATUM | DATS | 8 | 0 | Key date of the last interest calculation | ||
78 | ZINRT | DZINRT | ZINRT | NUMC | 2 | 0 | Interest calculation frequency in months | ||
79 | ZSABE | DZSABE_D | TEXT15 | CHAR | 15 | 0 | User at customer | ||
80 | XAUSZ | XAUSZ | AUSZG | CHAR | 1 | 0 | Indicator for periodic account statements | T048K | |
81 | XZEMP | XZEMP | XFELD | CHAR | 1 | 0 | Indicator: Alternative payee in document allowed ? | ||
82 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | ||
83 | TELF2 | TELF2 | TEXT16 | CHAR | 16 | 0 | Second telephone number | ||
84 | KONZS | KONZS | KONZS | CHAR | 10 | 0 | Group key | ||
85 | COUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | T005E | |
86 | CITYC | CITYC | CITYC | CHAR | 4 | 0 | City Code | T005G | |
87 | SORT1 | AD_SORT1 | CHAR20 | CHAR | 20 | 0 | Search Term 1 | ||
88 | SORT2 | AD_SORT2 | CHAR20 | CHAR | 20 | 0 | Search Term 2 | ||
89 | HSNM1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
90 | HSNM2 | AD_HSNM2 | TEXT10 | CHAR | 10 | 0 | House number supplement | ||
91 | CITY3 | AD_CITY3 | TEXT40 | CHAR | 40 | 0 | City (different from postal city) | ||
92 | TZONE | AD_TZONE | TZNZONE | CHAR | 6 | 0 | Address time zone | * | |
93 | TXJCD | AD_TXJCD | AD_TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
94 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
95 | CONAM | AD_NAME_CO | TEXT40 | CHAR | 40 | 0 | c/o name | ||
96 | STREET2 | AD_STRSPP1 | TEXT40 | CHAR | 40 | 0 | Street 2 | ||
97 | STREET3 | AD_STRSPP2 | TEXT40 | CHAR | 40 | 0 | Street 3 | ||
98 | STKZA | STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
99 | STKZN | STKZN | STKZN | CHAR | 1 | 0 | Natural Person | ||
100 | STKZU | STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
101 | ANREDE | RI_ANTXT | TEXT25 | CHAR | 25 | 0 | IS-H: Form-of-Address Text | ||
102 | TELNR | ISH_TELNR | CHAR30 | CHAR | 30 | 0 | IS-H: Telephone Number | ||
103 | PO_BX_NUM | AD_POBXNUM | XFELD | CHAR | 1 | 0 | Flag: PO Box without number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RNG99 | CITYC | T005G | CITYC | REF | C | CN |
2 | RNG99 | COUNC | T005E | COUNC | REF | C | CN |
3 | RNG99 | KNRZA | KNA1 | KUNNR | REF | C | CN |
4 | RNG99 | VZSKZ | T056 | VZSKZ | REF | C | CN |
5 | RNG99 | XAUSZ | T048K | XAUSZ | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |