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