ADRNR in VBPA

Table Field AD_ADDRNUM

Address Number (DE: Adressnummer)

ADRNR is a field in SAP table VBPA (Sales Document: Partners). It represents "Address Number". Data element: AD_ADDRNUM. Available in 149 CDS view(s) as AddressID, adrnr, SoldToPartyAddressID.

Business Meaning

Description (EN)Address Number
Beschreibung (DE)Adressnummer
Data ElementAD_ADDRNUM
Key FieldNo

CDS Views & Technical Names (149)

VBPA.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 (120 views)

ViewAccessVDMReleaseDescription
I_SDDocumentCompletePartners direct BASIC SD Document Complete Partners
A_InbDeliveryPartner via 2 level BASIC CDS View for Business Partner
A_InbDeliveryPartner_1 via 2 level BASIC CDS View for Business Partner
A_OutbDeliveryPartner via 2 level BASIC CDS view for API exposure
A_OutbDeliveryPartner_1 via 2 level BASIC CDS view for API exposure
A_ReturnsDeliveryPartner via 2 level BASIC Returns Delivery Partner
A_ReturnsDeliveryPartner_1 via 2 level BASIC Returns Delivery Partner
C_SDDocumentPartnerCard via 2 level CONSUMPTION Business Partner for Fact Sheets
C_SlsDocFlfmtSDDocContacts via 2 level CONSUMPTION Sales Doc Fulfillment: Contacts
C_SlsDocNonStdPartner via 2 level CONSUMPTION SD Document Non Std Complete Partners
FAC_AUDIT_Z3_SDPARTNER via 2 level Sales Document Partner
I_CFinSalesDocumentPartner via 2 level COMPOSITE Central Finance Sales Document: Partner
I_DeliveryDocumentAddress via 2 level COMPOSITE Delivery Document Address
I_DeliveryPartnerAddress via 2 level COMPOSITE Delivery Partner Address
I_PT_SAFTBillingOneTimeAddr via 2 level COMPOSITE One Time Customer Addr for Billing Docs
I_PT_SAFTDeliveryPartner via 2 level COMPOSITE SAFT Delivery OneTimeCustomers
I_SAFTBillingOneTimeCustomer via 2 level COMPOSITE SAF-T Billing OneTimeCustomers
I_SAFTDeliveryOneTimeCustomer via 2 level COMPOSITE SAF-T Delivery OneTimeCustomers
I_SDDocCompltPartWthAddlData via 2 level COMPOSITE Complete Partners with Additional Data
I_SDDocumentItemPartner via 2 level BASIC SD Document Item Partner
I_SDDocumentPartner via 2 level BASIC SD Document Partner
I_SlsDocNonStdPartner via 2 level COMPOSITE SD Document Non Std Complete Partners
P_RU_SDPartnerData1 via 2 level CONSUMPTION SD Partner Data
P_SDDocItemPartnerComplete via 2 level CONSUMPTION SD Document Item Complete Partner
A_OutbDeliveryAddress_2 via 3 levels COMPOSITE Outbound Delivery Address
A_SalesOrderHeaderPartner via 3 levels COMPOSITE Header Partner
A_SalesOrderItemPartner via 3 levels COMPOSITE Item Partner
I_BillingDocItemPartnerBasic via 3 levels BASIC Item Partner in Billing Process Document
I_BillingDocumentPartnerBasic via 3 levels BASIC Partner in Billing Process Document
I_DeliveryDocumentPartner via 3 levels COMPOSITE Delivery Document Partner
I_SalesDocumentItemPartner via 3 levels COMPOSITE Sales Document Item Partner
I_SalesDocumentPartner via 3 levels COMPOSITE Sales Document Partner
I_SDDocumentContactPerson via 3 levels BASIC SD Document Contact Person
I_SDDocumentCustomer via 3 levels BASIC SD Document Customer
I_SDDocumentPartWthAddlData via 3 levels COMPOSITE Document Partner with Additional Data
I_SDDocumentPersonnel via 3 levels COMPOSITE SD Document Personnel
P_RU_SDPartnerData via 3 levels CONSUMPTION SD Partner Data
P_SalesDocumentPartnerObsolete via 3 levels BASIC Sls Doc Part - Delaware SLT Data Rplctn
P_SalesOrderFlfmtContact3 via 3 levels COMPOSITE SOFM Sales Order Fulfillment Contact 3
P_SalesOrderFlfmtContact4 via 3 levels COMPOSITE SOFM Sales Order Fulfillment Contact 4
P_SlsDocCntdNonStdPartner via 3 levels CONSUMPTION SD Document with Count of non Std Partners
C_SlsDocOfOneTimeCustVH_F8712 via 4 levels CONSUMPTION Sales Document of One Time Customer
I_BillingDocItemPartner via 4 levels COMPOSITE Billing Document Item Partner
I_BillingDocReqItemPartner via 4 levels COMPOSITE Billing Document Request Item Partner
I_BillingDocReqPartner via 4 levels COMPOSITE Billing Document Request Partner
I_BillingDocumentPartner via 4 levels COMPOSITE Billing Document Partner
I_CreditMemoReqItemPartner via 4 levels COMPOSITE Credit Memo Request Item Partner
I_CreditMemoReqPartner via 4 levels COMPOSITE Credit Memo Request Partner
I_CustomerReturnPartner via 4 levels COMPOSITE Returns Order Partner
I_DebitMemoReqItemPartner via 4 levels COMPOSITE Debit Memo Request Item Partner
I_DebitMemoReqPartner via 4 levels COMPOSITE Debit Memo Request Partner
I_InvoiceListPartner via 4 levels COMPOSITE Invoice List Partner
I_PrelimBillingDocItemPartner via 4 levels COMPOSITE Preliminary Billing Document Item Partner
I_PrelimBillingDocPartner via 4 levels COMPOSITE Preliminary Billing Document Partner
I_SalesOrderItemPartner via 4 levels COMPOSITE Sales Order Item Partner
I_SalesOrderPartner via 4 levels COMPOSITE Sales Order Partner
I_SalesQuotationItemPartner via 4 levels COMPOSITE Sales Quotation Item Partner
I_SalesQuotationPartner via 4 levels COMPOSITE Sales Quotation Partner
I_SalesSchedgAgrmtItemPartner via 4 levels COMPOSITE Sales Scheduling Agreement Item Partner
I_SalesSchedgAgrmtPartner via 4 levels COMPOSITE Sales Scheduling Agreement Partner
I_SlsOrdWthoutChrgItmPartner via 4 levels COMPOSITE Item Partner for Sales Order Without Charge
I_SlsOrdWthoutChrgPartner via 4 levels COMPOSITE Partner for Sales Order Without Charge
P_BillgProcDocItemCmpltPartner via 4 levels COMPOSITE Union of item specific partners and inherited partners.
P_BillgProcDocItemInhtdPartner via 4 levels COMPOSITE Billing process document item inherited partner(from header)
P_BillgProcDocPartnerAddress via 4 levels COMPOSITE Billing Process Document Partner Address
P_SalesDocItemCompletePartner via 4 levels COMPOSITE Sales Doc Inherited and Item Partner
P_SalesDocItemInheritedPartner via 4 levels COMPOSITE Inherited Partners of Sales Document
R_CustRetDelivPartnerTP via 4 levels TRANSACTIONAL Customer Returns Delivery Partner - TP
R_InbDeliveryPartnerTP via 4 levels TRANSACTIONAL Inbound Delivery Partner - TP
R_OutboundDeliveryPartnerTP via 4 levels TRANSACTIONAL Outbound Delivery Partner - TP
R_SalesContractShipToPartyTP via 4 levels TRANSACTIONAL Sales Contract Ship-to Party - TP
A_SalesSchedgAgrmtItemPartner via 5 levels COMPOSITE Item Partner
A_SalesSchedgAgrmtPartner via 5 levels COMPOSITE Header Partner
C_InboundDeliveryPartnerManage via 5 levels CONSUMPTION Inbound Delivery Partner - Manage
I_BillgProcDocItemCmpltPartner via 5 levels COMPOSITE Billg Proc Doc Item Complete Partners
I_CustProjSlsOrdItemPartner via 5 levels COMPOSITE Sales Order Item Partner for Cust Proj
I_CustProjSlsOrdPartner via 5 levels COMPOSITE Sales Order Partner for Customer Project
I_CustRetDelivPartnerTP via 5 levels TRANSACTIONAL Customer Returns Delivery Partner - TP
I_InbDeliveryPartnerTP via 5 levels TRANSACTIONAL Inbound Delivery Partner - TP
I_OutboundDeliveryPartnerTP via 5 levels TRANSACTIONAL Outbound Delivery Partner - TP
I_SalesDocItemCompletePartner via 5 levels COMPOSITE Sales Doc Item and Inherited Partners
P_BillgProcDocItemCmpltParAddr via 5 levels COMPOSITE Billg Proc Doc Itm Cmplt Partner Address
R_BillingDocumentPartnerTP via 5 levels TRANSACTIONAL Billing Document Partner - TP
R_CreditMemoReqShipToPartyTP via 5 levels TRANSACTIONAL Credit Memo Request Ship-to Party - TP
R_CreditMemoRequestPartnerTP via 5 levels TRANSACTIONAL Credit Memo Request Partner - TP
R_CustomerReturnPartnerTP via 5 levels TRANSACTIONAL Returns Order Partner - TP
R_CustomerReturnShipToPartyTP via 5 levels TRANSACTIONAL Returns Order Ship-to Party - TP
R_DebitMemoRequestPartnerTP via 5 levels TRANSACTIONAL Debit Memo Request Partner - TP
R_PrelimBillgDocPartnerTP via 5 levels TRANSACTIONAL Prelim Billing Document Partner - TP
R_SalesOrderPartnerTP via 5 levels TRANSACTIONAL Sales Order Partner - TP
R_SalesOrderShipToPartyTP via 5 levels TRANSACTIONAL Sales Order Ship-to Party - TP
R_SalesQuotationPartnerTP via 5 levels TRANSACTIONAL Sales Quotation Partner - TP
R_SalesQuotationShipToPartyTP via 5 levels TRANSACTIONAL Ship-to Party for Sales Quotation - TP
R_SlOrWtCrShipToPartyTP via 5 levels TRANSACTIONAL Sls Ord Without Charge ShipToParty - TP
R_SlsOrdWithoutChargePartnerTP via 5 levels TRANSACTIONAL Sales Order Without Charge Partner - TP
R_SlsSchedgAgrmtPartnerTP via 5 levels TRANSACTIONAL Partner for Sls Schedg Agrmt - TP
R_SlsSchedgAgrmtShipToPartyTP via 5 levels TRANSACTIONAL Ship To Party for Sls Sched Agr - TP
A_BillingDocumentPartner_2 via 6 levels CONSUMPTION Header Partners
A_CustProjSlsOrdItemPartner via 6 levels COMPOSITE Sales Order Item Partner
A_CustProjSlsOrdPartner via 6 levels COMPOSITE Sales Order Header Partner
C_BillingDocumentPartnerManage via 6 levels CONSUMPTION Billing Document Partner
C_PrelimBillgDocPrtnTP_F6990 via 6 levels CONSUMPTION Preliminary Billing Document Partner
C_ProjBillgElmntPartnerDetails via 6 levels CONSUMPTION Project Billing Element Partner Details
C_SlsDocItmNonStdPartner via 6 levels CONSUMPTION Sls Doc Item Non Std Complete Partners
I_SlsDocItmNonStdPartner via 6 levels COMPOSITE Sls Doc Item Non Std Complete Partners
R_BillgDocRequestItemPartnerTP via 6 levels TRANSACTIONAL Billing Document Request Item Partner - TP
R_BillingDocumentItemPartnerTP via 6 levels TRANSACTIONAL Billing Document Item Partner - TP
R_CreditMemoReqItemPartnerTP via 6 levels TRANSACTIONAL Credit Memo Request Item Partner - TP
R_CustomerReturnItemPartnerTP via 6 levels TRANSACTIONAL Returns Order Item Partner - TP
R_DebitMemoReqItemPartnerTP via 6 levels TRANSACTIONAL Debit Memo Request Item Partner - TP
R_PrelimBillgDocItemPartnerTP via 6 levels TRANSACTIONAL Prelim Billing Doc Item Partner - TP
R_SalesContractItemPartnerTP via 6 levels TRANSACTIONAL Sales Contract Item Partner - TP
R_SalesOrderItemPartnerTP via 6 levels TRANSACTIONAL Partner for Sales Order Item - TP
R_SalesQuotationItemPartnerTP via 6 levels TRANSACTIONAL Sales Quotation Item Partner - TP
R_SlsOrdWthoutChrgItmPartnerTP via 6 levels TRANSACTIONAL Sls Ord Without Charge Item Partner - TP
R_SlsSchedgAgrmtItemPartnerTP via 6 levels TRANSACTIONAL Partner for Sls Sched Agr Item - TP
A_BillingDocumentItemPartner_2 via 7 levels CONSUMPTION Item Partners
C_BillgDocItemPartnerManage via 7 levels CONSUMPTION Billing Document Item Partner
C_PBDItemPartnerTP_F6990 via 7 levels CONSUMPTION Prelim Billing Document Item Partner
P_SlsDocItmCntdNonStdPartner via 7 levels CONSUMPTION Sls Doc Item with Count of non Std Partners

adrnr (18 views)

ViewAccessVDMReleaseDescription
V_VAKPA_AB direct unloading point suv view for V_VAKPA
V_VAKPA_AP direct contact person sub view for V_VAKPA
V_VAKPA_KU direct customer partner sub-view for V_VAKPA
V_VAKPA_LI direct supplier sub view for V_VAKPA
V_VAKPA_PE direct employee sub view for V_VAKPA
v_vapma direct view equivalent fot VAPMA
V_VLKPA_AB direct unloading point sub view for V_VLKPA
V_VLKPA_AP direct contact person sub view for V_VLKPA
V_VLKPA_KU direct customer sub view for V_VLKPA
V_VLKPA_LI direct supplier sub view for V_VLKPA
V_VLKPA_PE direct employee sub view for V_VLKPA
v_vlpma direct views equivalentto VLPMA
V_VRKPA_AB direct unloading point sub view for V_VRKPA
V_VRKPA_AP direct contact person sub view for V_VRKPA
V_VRKPA_KU direct customer sub view for V_VRKPA
V_VRKPA_LI direct supplier sub view for V_VRKPA
V_VRKPA_PE direct employee sub view for V_VRKPA
v_vrpma direct view equivalent to VRPMA

SoldToPartyAddressID (7 views)

ViewAccessVDMReleaseDescription
R_CustomerReturnTP via 5 levels TRANSACTIONAL Returns Order - TP
R_SalesOrderTP via 5 levels TRANSACTIONAL Sales Order - TP
R_SalesOrderWithoutChargeTP via 5 levels TRANSACTIONAL Sales Order Without Charge - TP
R_SalesQuotationTP via 5 levels TRANSACTIONAL Sales Quotation - TP
C_SalesOrderManage via 6 levels CONSUMPTION Sales Order
C_SalesQuotationManageTP via 6 levels CONSUMPTION Sales Quotation
C_SlsOrdWithoutChargeManageTP via 6 levels CONSUMPTION Sales Order Without Charge - Manage

ShipToPartyAddressID (4 views)

ViewAccessVDMReleaseDescription
C_RDPDeliveryDocumentDEX via 2 level CONSUMPTION Delivery Documents Extractor for RDP
C_RDPDeliveryDocumentItemDEX via 2 level CONSUMPTION Delivery Document Item Extractor for RDP
C_SustDeliveryDocumentDEX via 3 levels CONSUMPTION Delivery Documents Extractor
C_SustDeliveryDocumentItemDEX via 3 levels CONSUMPTION Delivery Document Item Extractor

AddressNumber (3 views)

ViewAccessVDMReleaseDescription
I_PT_SAFTBillingOneTimeAddr via 2 level COMPOSITE One Time Customer Addr for Billing Docs
I_SAFTBillingOneTimeCustomer via 2 level COMPOSITE SAF-T Billing OneTimeCustomers
I_SAFTDeliveryOneTimeCustomer via 2 level COMPOSITE SAF-T Delivery OneTimeCustomers

Other Tables with Field ADRNR (47)

TableData ElementKeyDescription
BNKA AD_ADDRNUM Bankenstamm
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
QCOMPLPARTNER AD_ADDRNUM Quality Complaint Partner
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
TVST ADRNR Organizational Unit: Shipping Points
TWLAD AD_ADDRNUM Determination of Address from Plant and Storage Location
VBPA2 ADRNR Sales Document: Additional Partners of a Partner Function
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
WTY_PARTNER_TAB ADRNR Partner for Warranty Claim

Learn More