ADDRNUMBER in BUT020
Address Number (DE: Adressnummer)
ADDRNUMBER is a field in SAP table BUT020 (BP: Addresses). It represents "Address Number". Data element: AD_ADDRNUM. Available in 84 CDS view(s) as AddressNumber, AddressID, ActiveAddressID.
Business Meaning
| Description (EN) | Address Number |
|---|---|
| Beschreibung (DE) | Adressnummer |
| Data Element | AD_ADDRNUM |
| Key Field | Yes |
CDS Views & Technical Names (84)
BUT020.ADDRNUMBER 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.
AddressNumber
(48 views)
Address Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BusinessPartAddress_2 | direct | COMPOSITE | Business Partner Address | |
| I_BusinessPartnerAddress | direct | BASIC | Core view for Business Partner Address | |
| I_BusinessPartnerAddress_2 | direct | BASIC | Basic View for BP Address | |
| I_BusPartScriptedGroupAddress | direct | BASIC | International version of a business partner address | |
| I_BusPartScriptedOrgAddress | direct | BASIC | International version of a business partner address | |
| I_BusPartScriptedPersonAddress | direct | COMPOSITE | International version of a business partner address | |
| C_BPAddressValueHelp | via 2 level | CONSUMPTION | Value Help view for list of addresses of a BP | |
| C_EHSBusinessPartnerAddressVH | via 2 level | CONSUMPTION | CmplRq Permit Issuing Authority | |
| C_EnvrmtWastePartDsplFcltyVH | via 2 level | CONSUMPTION | Waste Partner Disposal Fclty Value Help | |
| C_EnvrmtWastePartFcltyParamVH | via 2 level | CONSUMPTION | Disposal Facility val help with Parametr | |
| C_EnvrmtWastePartnerDfltAddr | via 2 level | CONSUMPTION | Waste Partner Default Address | |
| CIC_CustBPAddress | via 2 level | Proj. View on BP Address | ||
| CIC_SupplierBPASsociation | via 2 level | Proj. View for Supplier-BP Assoc. | ||
| I_BPCompanyAddressVH | via 2 level | COMPOSITE | Value Help for Company Address | |
| I_BusinessPartnerAddressGov | via 2 level | COMPOSITE | Business Partner Address (Governance) | |
| I_BusinessPartnerAddressTP | via 2 level | TRANSACTIONAL | Business Partner Address | |
| I_BusinessPartnerAddressTP_2 | via 2 level | TRANSACTIONAL | Business Partner Address | |
| I_BusPartScriptedGroupAddrTP | via 2 level | TRANSACTIONAL | Business partner scripted addresses | |
| I_BusPartScriptedOrgAddressTP | via 2 level | TRANSACTIONAL | Business partner scripted addresses | |
| I_BusPartScriptedPersonAddrTP | via 2 level | TRANSACTIONAL | Business partner scripted addresses | |
| I_CADisputeCaseContactVH | via 2 level | COMPOSITE | Dispute Case Contact in Contract Account | |
| I_INS_ClaimParticipantMiniBP | via 2 level | COMPOSITE | Insurance Claim Participant Mini BP | |
| I_INS_ClmPrtcpntStdAddress | via 2 level | BASIC | Basic Interface Participant Address | |
| P_Cpbupafaxall | via 2 level | CONSUMPTION | Business Partner Emails from all sources | |
| P_CustNameCombinedSDMSts | via 2 level | COMPOSITE | ||
| P_CustSuplrNameCombinedSDMSts | via 2 level | BASIC | ||
| P_SalesCustomerContacts | via 2 level | CONSUMPTION | Sales Customer Contacts | |
| P_SLSORDREQBPCONTACTS | via 2 level | BASIC | BP Contact Information | |
| P_SuplrNameCombinedSDMSts | via 2 level | COMPOSITE | ||
| R_WorkAssgmtPrivateAddressTP | via 2 level | TRANSACTIONAL | Private Address for Work Assignment | |
| A_BPContactToAddress | via 3 levels | BASIC | Contact Person Address | |
| C_BusinessPartnerAddress | via 3 levels | CONSUMPTION | Business Partner Address | |
| C_BusinessPartnerAddressTP_2 | via 3 levels | CONSUMPTION | Projection View Business Partner Address | |
| C_BusPartScriptedGroupAddrTP | via 3 levels | CONSUMPTION | Business partner scripted addresses | |
| C_BusPartScriptedOrgAddressTP | via 3 levels | CONSUMPTION | Business partner scripted addresses | |
| C_BusPartScriptedPersonAddrTP | via 3 levels | CONSUMPTION | Business partner scripted addresses | |
| C_SalesCustomerContacts | via 3 levels | CONSUMPTION | Sales Customer Contacts | |
| CIC_CustomerAddress | via 3 levels | Proj. View on Customer Address | ||
| CIC_SupplierAddress | via 3 levels | Proj. View on Supplier Address | ||
| I_BusinessPartnerAddressGovTP | via 3 levels | TRANSACTIONAL | Business Partner Address with RAP (Governance) | |
| I_BusinessPartnerAddressTP_3 | via 3 levels | TRANSACTIONAL | Business Partner Address | |
| I_BusPartCompanyAddressGov | via 3 levels | TRANSACTIONAL | Base for Company Address | |
| I_BusPartScriptedOrgAddrTP_2 | via 3 levels | TRANSACTIONAL | BP Scripted Org address | |
| I_BusPartScriptGroupAddrTP_2 | via 3 levels | TRANSACTIONAL | BP Scripted Group address | |
| I_BusPartScriptPersonAddrTP_2 | via 3 levels | TRANSACTIONAL | BP Scripted Person address | |
| P_Cpbupafaxunique | via 3 levels | CONSUMPTION | ||
| C_BusinessPartnerAddressGovTP | via 4 levels | CONSUMPTION | BP Address Governance | |
| C_Cpbupafaxvh | via 4 levels | CONSUMPTION | Contact Information Fax |
AddressID
(29 views)
Address Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /BOFU/CV_BPCurrentDefaultAddr | direct | BOPF: Business Partner Current Address | ||
| /BOFU/CV_BPCurrentDfltAddr | direct | BOPF: /BOFU/BuPa Current Default Address (Old) | ||
| Fclm_Bm_Contacts | direct | Contact person for bank | ||
| I_BPCurrentDefaultAddress | direct | BASIC | Business Partner Current Default Address | |
| I_BusPartAddress | direct | BASIC | Business Partner Address | |
| I_EmplHomeAddress | direct | BASIC | Obsolete - DONOT USE_Employee Home Address | |
| A_BPIntlAddressVersion | via 2 level | COMPOSITE | BP International Address Version | |
| A_BusinessPartnerAddress | via 2 level | BASIC | Address | |
| C_CustomerBPAddressVH | via 2 level | CONSUMPTION | Business Partner Addresses of Customers | |
| C_ProdCmplncBPAddrVH | via 2 level | CONSUMPTION | PC Business Partner Multi Address | |
| C_PurgCustomerBPShipToAddrVH | via 2 level | CONSUMPTION | Customer Ship to Addresses | |
| I_BPCustomerGeneralAddressInfo | via 2 level | COMPOSITE | BP and Cust Addr Depdnt Info | |
| I_BPCustomerMultiAddrVH | via 2 level | COMPOSITE | Customers by Multiple Addresses | |
| I_BPCustomerSalesAddressInfo | via 2 level | COMPOSITE | BP and Cust sls Addr Depdnt Info | |
| I_BPSuplrAddrDepdntPurgOrgInfo | via 2 level | COMPOSITE | Supplier addr depnt purch info | |
| I_BPSupplierAddrDepdntGenInfo | via 2 level | COMPOSITE | BP Supp Add Dep Gen Info | |
| P_BPCurrentAddress | via 2 level | COMPOSITE | ||
| P_CPBUPAEMAILALL | via 2 level | CONSUMPTION | Business Partner Emails from all sources | |
| C_BPCustomerMultiAddrVH | via 3 levels | CONSUMPTION | Customers by All Addresses | |
| C_ProdCmplncCustAddrVH | via 3 levels | CONSUMPTION | PC Customer Address | |
| I_JP_InvcSmmryPyrMultiAddrVH | via 3 levels | COMPOSITE | Payers by Multiple Addresses | |
| I_JP_InvcSmmryRcpntMultiAddrVH | via 3 levels | COMPOSITE | Recipients by Multiple Addresses | |
| P_CpBupaEmailWoNames | via 3 levels | CONSUMPTION | ||
| P_LU_SAFTJournalItemBP | via 3 levels | COMPOSITE | ||
| C_Q2CCustomerMultiAddrVH | via 4 levels | CONSUMPTION | Customers by All Addresses | |
| P_Cpbupaemailvh | via 4 levels | CONSUMPTION | ||
| C_Cpbupaemailvh | via 5 levels | CONSUMPTION | Contact Information Email | |
| C_SlsOrdReqCustomerMultiAddrVH | via 5 levels | CONSUMPTION | Customer by Sales Area and Multi Address | |
| C_SoldToMultipleAddressVH | via 5 levels | CONSUMPTION | Sold to Party by All Addresses |
ActiveAddressID
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_ACMBusinessPartnerDetailsVH | direct | BASIC | Business Partner Details | |
| I_ACMCustPartnerDetailsVH | direct | BASIC | Customer Partner Details | |
| C_ACMContractBusinessPartnerVH | via 2 level | CONSUMPTION | Search for Business Partner |
addrnumber
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /BOFU/CV_BP_AddressInformation | direct | BOPF: /BOFU/BuPa Node Addressinformation | ||
| /BOFU/CV_Q_BPByAddress | direct | BOPF: BP Query on Address Data | ||
| /BOFU/VE_BPAI | direct | BOPF: Business Partner Address Inf. |
BusinessPartnerAddressID
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_InvgCsMPersonAddress | direct | BASIC | Composite/Basic view for ICM Person Address |
AddressIDForEdit
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BusinessPartnerAddressTP_2 | via 2 level | TRANSACTIONAL | Business Partner Address | |
| C_BusinessPartnerAddressTP_2 | via 3 levels | CONSUMPTION | Projection View Business Partner Address | |
| I_BusinessPartnerAddressTP_3 | via 3 levels | TRANSACTIONAL | Business Partner Address |
Other Tables with Field ADDRNUMBER (50+)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /BOFU/ADRCUUID | AD_ADDRNUM | Table for ADRC-UUID (Downport 7.10 to 7.0) | |
| /ECRS/V_ORGBPP | AD_ADDRNUM | KEY | Generated Table for View |
| /SAPAPO/LOCASGMT | AD_ADDRNUM | KEY | Location Assignment |
| /SAPAPO/TPSRC | AD_ADDRNUM | Contracts: External Procurement | |
| /SAPSLL/V_ORGBPP | AD_ADDRNUM | KEY | Generated Table for View |
| ADCP | AD_ADDRNUM | KEY | Person/Address Assignment (Business Address Services) |
| ADR12 | AD_ADDRNUM | KEY | FTP and URL (Business Address Services) |
| ADR13 | AD_ADDRNUM | KEY | Pager (Business Address Services) |
| ADR2 | AD_ADDRNUM | KEY | Telephone Numbers (Business Address Services) |
| ADR3 | AD_ADDRNUM | KEY | Fax Numbers (Business Address Services) |
| ADR6 | AD_ADDRNUM | KEY | E-Mail Addresses (Business Address Services) |
| ADRC | AD_ADDRNUM | KEY | Addresses (Business Address Services) |
| ADRCT | AD_ADDRNUM | KEY | Address Texts (Business Address Services) |
| ADRT | AD_ADDRNUM | KEY | Communication Data Text (Business Address Services) |
| ADRU | AD_ADDRNUM | KEY | Table for Communication Usages |
| BUR_ADCP_PRC | AD_ADDRNUM | Process Records Of OTC 1405, Table ADCP | |
| BUR_ADR12_PRC | AD_ADDRNUM | Process Records Of OTC 1405, Table ADR12 | |
| BUR_ADR2_PRC | AD_ADDRNUM | Process Records Of OTC 1405, Table ADR2 | |
| BUR_ADR3_PRC | AD_ADDRNUM | Process Records Of OTC 1405, Table ADR3 | |
| BUR_ADR6_PRC | AD_ADDRNUM | Process Records Of OTC 1405, Table ADR6 | |
| BUT_ADR12_IN_PRC | AD_ADDRNUM | Process Records Of OTC 147, Table ADR12_IN | |
| BUT_ADR12_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADR12 | |
| BUT_ADR2_IN_PRC | AD_ADDRNUM | Process Records Of OTC 147, Table ADR2_IN | |
| BUT_ADR2_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADR2 | |
| BUT_ADR3_IN_PRC | AD_ADDRNUM | Process Records Of OTC 147, Table ADR3_IN | |
| BUT_ADR3_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADR3 | |
| BUT_ADR6_IN_PRC | AD_ADDRNUM | Process Records Of OTC 147, Table ADR6_IN | |
| BUT_ADR6_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADR12 | |
| BUT_ADRC_IMOUT | AD_ADDRNUM | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRC_IN_PRC | AD_ADDRNUM | Process Records Of OTC 147, Table ADRC_IN | |
| BUT_ADRC_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRCT_PRC | AD_ADDRNUM | Process Records Of OTC 147, Table ADRCT | |
| BUT020_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for BUT020 | |
| BUT021_FS | AD_ADDRNUM | KEY | Time-Dependent Address Usages |
| BUT021_FS_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for BUT021_FS | |
| BUT022 | AD_ADDRNUM | KEY | BP: Address-Dependent Attributes |
| BUT022_PRC | AD_ADDRNUM | Process Records Of OTC 147, Table BUT022 | |
| BUT052 | AD_ADDRNUM | KEY | BP Relationship: Addresses |
| BUT052_PRC | AD_ADDRNUM | MDC: Process Table (BUT052) - BP Rel. Addresses | |
| CRMS4C_SRVC_ORG | AD_ADDRNUM | Enterprise Service Organization | |
| CRMS4D_ICM_LOC | AD_ADDRNUM | ICM Location | |
| EDOINGSTRSLSREG | AD_ADDRNUM | eDocument India GST Returns: Sales Register | |
| EDPAR | AD_ADDRNUM | Convert External < > Internal Partner Number | |
| FITHA_PBUPL_D | AD_ADDRNUM | Thailand: Branch codes for Customers | |
| FITHA_PBUPL_K | AD_ADDRNUM | Thailand: Branch codes for Vendors | |
| GEOLOC | AD_ADDRNUM | Geo location (lon/lat/alt/...) | |
| HRP1952 | AD_ADDRNUM | DB Table for Infotype 1952 | |
| ICL_BENSPLIT_ITM | ICL_ADDRNUM | Benefit Split Item (One-Time) | |
| ICL_BENSPPER_ITM | ICL_ADDRNUM | Benefit Split Item (Periodic) | |
| ICLCCEVENTL | AD_ADDRNUM | KEY | Claim Bundle - Location Address - Assignment |
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