ADRNR in BNKA
Address Number (DE: Adressnummer)
ADRNR is a field in SAP table BNKA (Bankenstamm). It represents "Address Number". Data element: AD_ADDRNUM. Available in 15 CDS view(s) as AddressID, adrnr, BankAddressNo.
Business Meaning
| Description (EN) | Address Number |
|---|---|
| Beschreibung (DE) | Adressnummer |
| Data Element | AD_ADDRNUM |
| Key Field | No |
CDS Views & Technical Names (15)
BNKA.ADRNR is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
AddressID
(8 views)
Address Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_Bank | direct | BASIC | Bank | |
| I_Bank_2 | direct | BASIC | Bank | |
| I_BankForBusinessPartner | direct | BASIC | Bank Master for Business Partner | |
| I_BankAccountTP | via 2 level | TRANSACTIONAL | Bank Account BO active and draft | |
| R_BankDepTP | via 2 level | TRANSACTIONAL | Transactional Bank | |
| R_BankTP | via 2 level | TRANSACTIONAL | Transactional Bank | |
| C_BankAccountTP | via 3 levels | CONSUMPTION | Bank Account Administrative Data | |
| R_CashBankTP | via 3 levels | TRANSACTIONAL | Cash Transactional Bank TP |
adrnr
(6 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /BSNAGT/P_BNKA | direct | BNKA P View | ||
| /PF1/P_BNKA | direct | P View for BNKA | ||
| ESH_N_BANK_BANK | direct | Bank master record | ||
| /BSNAGT/I_BNKA | via 2 level | BNKA I View | ||
| /PF1/I_BNKA | via 2 level | Bank Keys | ||
| ESH_S_BANK | via 2 level | Banks |
BankAddressNo
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| VFCLM_BAM_DDL_FBAR01 | direct | Account Result for FBAR |
Other Tables with Field ADRNR (50+)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /PRA/BP_AD | ADRNR | KEY | Business Partner (Customer/Vendor) Multiple Address |
| BSEC | ADRNR | Belegsegment CPD-Daten | |
| CVLC06 | ADRNR | VELO : Current Location | |
| DFKKBPTAXNUM_ADR | AD_ADDRNUM | KEY | Address-Dependent Tax Numbers |
| DFKKCOH | CREC_AD_KK | Korrespondenz - Korrespondenzkopf | |
| DPAYP | AD_ADDRNUM | Zahlungsprogramm - Daten zum bezahlten Posten | |
| EBAN | ADRNR_MM | Purchase Requisition | |
| IHPA | AD_ADDRNUM | Plant Maintenance: Partners | |
| J_1BBRANCH | ADRNR | Geschäftsort | |
| KNA1 | ADRNR | General Data in Customer Master | |
| KNA1_ADDR | BU_ADDRNUM | KEY | General Data in Customer Master : Address dep. attributes |
| KNA1_PRC | ADRNR | Master Data Consolidation: Process Table for KNA1 | |
| KNADDR_EXT | BU_ADDRNUM | KEY | Seller-Defined Customer Address ID for EDI |
| KNMT_ADDR | BU_ADDRNUM | KEY | Customer-Material Info Record - Address dep. attributes |
| KNVA_ADDR | BU_ADDRNUM | KEY | Customer Master Address dependent Unloading Points |
| KNVI_ADDR | BU_ADDRNUM | KEY | Customer Master Tax Indicator: Address Dependent |
| KNVP | BU_ADDRNUM | Customer Master Partner Functions | |
| KNVP_PRC | BU_ADDRNUM | Master Data Consolidation: Process Table for KNVP | |
| KNVV_ADDR | BU_ADDRNUM | KEY | Customer Master Sales Data - Address dep. attributes |
| LFA1 | ADRNR | Supplier Master (General Section) | |
| LFA1_ADDR | BU_ADDRNUM | KEY | Supplier Master (General Section): Address dep. attributes |
| LFA1_PRC | ADRNR | Master Data Consolidation: Process Table for LFA1 | |
| LFADDR_EXT | BU_ADDRNUM | KEY | Buyer-Defined Supplier Address ID for EDI |
| LFM1_ADDR | BU_ADDRNUM | KEY | Supplier master purchasing org data: Address dep. attributes |
| NAST | AD_ADDRNUM | Nachrichtenstatus | |
| OIGSPA | ADRNR | Partner in TD-shipment | |
| QMEL | CADNR | Quality Notification | |
| REGUH | AD_ADDRNUM | Regulierungsdaten aus Zahlprogramm | |
| RESB | CADNR | Reservation/dependent requirements | |
| SECCODE | AD_ADDRNUM | Quellensteuer Sektion | |
| SIPT_HIST_KUNNR | ADRNR | Signature PT: History specific customer data for print out | |
| SOES | SO_ADR_NR | SAPoffice: externer Sendevorgang | |
| T000 | CHAR10 | Clients | |
| T001 | ADRNR | Buchungskreise | |
| T001E | ADRNR | Buchungskreisabhängige Adressdaten | |
| T001N | ADRNR | Buchungskreis - EG-Steuernummern / Meldungen an Behörden | |
| T007F | ADRNR | Umsatzsteuerkreise | |
| T049L | ADRNR | Lockboxes bei unseren Hausbanken | |
| T500P | ADRNR | Personalbereiche | |
| TTDS | ADRNR | Organizational Unit: Transportation Scheduling Point | |
| TVKN | ADRNR | Routes: Transportation Connection Points | |
| TVST | ADRNR | Organizational Unit: Shipping Points | |
| TWLAD | AD_ADDRNUM | Determination of Address from Plant and Storage Location | |
| VBPA | AD_ADDRNUM | Sales Document: Partner | |
| VBPA2 | ADRNR | Sales document: Partner (used several times) | |
| VKDFS | ADRNR_AG | SD Index: Billing Initiator | |
| VSRESB_CN | CADNR | Version: Reservation/Dependent requirements | |
| WBHP | ADRNR | Trading Contract: Partner Assignment | |
| WRF12_ADDR | BU_ADDRNUM | KEY | Customer General: Address Dependent Receiving points |
| WRF4_ADDR | BU_ADDRNUM | KEY | Customer General: Address Dependent Departments |
Showing the first 50 tables. Search all occurrences →
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA