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