ADR12 is a standard SAP table in SAP ECC (or) S/4HANA which stores FTP and URL (Business Address Services) data. There are total 14 fields in ADR12 table.This blog post provides key technical details of SAP table ADR12, including its availability across SAP S/4HANA versions and the list of CDS views for ADR12 table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | SAP Technology – Business Services: Address Management (SZAD) |
| Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADR12 Table Fields
The following is the list of fields that are available in SAP ADR12 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | T000 | CLNT (3) |
| ADDRNUMBER | Address Number | AD_ADDRNUM | AD_ADDRNUM | ADRC | CHAR (10) |
| PERSNUMBER | Person Number | AD_PERSNUM | AD_PERSNUM | ADRP | CHAR (10) |
| DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATUM | DATS (8) | |
| CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC3 | NUMC (3) | |
| FLGDEFAULT | Flag: this address is the default address | AD_FLGDFAD | XFELD | CHAR (1) | |
| FLG_NOUSE | Flag: This Communication Number is Not Used | AD_FLNOUSE | XFELD | CHAR (1) | |
| HOME_FLAG | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | XFELD | CHAR (1) | |
| URI_TYPE | URI type flag | AD_URITYPE | AD_URITYPE | CHAR (3) | |
| URI_SRCH | URI address search field | AD_URI2 | CHAR50 | CHAR (50) | |
| DFT_RECEIV | Flag: Recipient is standard recipient for this address | AD_DFTRCAD | XFELD | CHAR (1) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATA_TEMPERATURE | DATS (8) | |
| URI_LENGTH | URI field length | AD_URILNG | AD_URILNG | INT2 (5) | |
| URI_ADDR | Universal Resource Identifier (URI) | AD_URI | AD_URI | LCHR (2048) |
Availability
The SAP table ADR12 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ADR12 table
The following is the list of ADR12 CDS views, which can also be used instead of ADR12 table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| A_ADDRESSHOMEPAGEURL | BASIC | Home Page URL |
| I_ADDRESSHOMEPAGEURL | BASIC | Homepage URL Address |
| I_BANKACCOUNTWITHREVISION | BASIC | Bank Account With Revision |
| I_BANKACCTREVEMAILTEMPLATE | BASIC | Email Template for Bank Account Revision |
| I_BPWEBSITEURL | BASIC | BP Website Core View |
| I_BUSINESSPARTNERADDRESS | BASIC | Core view for Business Partner Address |
| I_BUSPARTWEBSITEURLGOV | BASIC | BP Website URL Governance |
| I_BANKACCOUNTCOUNT | COMPOSITE | Bank Account Regardless Revision |
| I_BANKACCOUNTREVISIONCOUNT | COMPOSITE | Bank Account Revision Count |
| I_BUSINESSPARTNERADDRESSGOV | COMPOSITE | Business Partner Address (Governance) |
| I_CADISPUTECASECONTACTVH | COMPOSITE | Dispute case contact in contract account |
| I_KR_STRPWITHHOLDINGTAXITEMC | COMPOSITE | Business and Other income withholding tax Items for Korea |
| I_NO_SAFTGENLEDGERCUSTOMER | COMPOSITE | SAF-T Norway General Ledger Customer |
| I_NO_SAFTGENLEDGERSUPPLIER | COMPOSITE | SAF-T Norway General Ledger Supplier |
| I_PT_DELDOCCUSTADDRHIST | COMPOSITE | SAF-T PT Delivery Doc CustAddr History |
| I_PT_DELIVCUSTTAXREGNMBR | COMPOSITE | SAF-T Delivery Tax Registration Number |
| I_PT_SAFTACCOUNTINGCUSTOMER | COMPOSITE | SAF-T PT Accounting Customer |
| I_PT_SAFTACCTGCUSTTAXREGNNMBR | COMPOSITE | SAF-T Accounting Tax Registration Number |
| I_PT_SAFTACCTGDOCCUSTADDRHIST | COMPOSITE | SAF-T PT AccountingDoc CustAddr History |
| I_PT_SAFTACCTGONETIMECUSTOMER | COMPOSITE | SAF-T PT Accounting One Time Customer |
| I_PT_SAFTACCTGSUPTAXREGNNMBR | COMPOSITE | SAF-T PT Registration Number Suppliers |
| I_PT_SAFTBILLGCUSTTAXREGNNMBR | COMPOSITE | SAF-T Billing Tax Registration Number |
| I_PT_SAFTBILLGDOCCUSTADDRHIST | COMPOSITE | SAF-T PT BillingDoc CustAddr History |
| I_PT_SAFTBILLINGCUSTOMER | COMPOSITE | SAF-T PT Billing Customer |
| I_PT_SAFTBILLINGONETIMECUST | COMPOSITE | SAF-T PT Billing One Time Custmer |
| I_PT_SAFTCUSTADDRHIST | COMPOSITE | SAF-T PT Customer Address History |
| I_PT_SAFTDELIVERYCUSTDETAIL | COMPOSITE | Details of Portugal SAFT Customer |
| I_PT_SAFTDELIVERYCUSTOMER | COMPOSITE | SAF-T PT Delivery Customer |
| I_PT_SAFTDELIVERYHEADER | COMPOSITE | SAFT Movement of Goods Header Portugal |
| I_PT_SAFTDELIVERYONETIMECUST | COMPOSITE | SAF-T PT Billing One Time Custmer |
| I_PT_SAFTGENLDGRONETMESUPPLIER | COMPOSITE | SAFT PT GLEntries OTS |
| I_PT_SAFTGENLEDCUSTTAXREGNNMBR | COMPOSITE | SAF-T PT GL Registration Number Customer |
| I_PT_SAFTGENLEDGERCUSTOMER | COMPOSITE | SAF-T PT Gen Ledger Customer |
| I_PT_SAFTGENLEDGERONETIMECUST | COMPOSITE | SAF-T PT Gen Ledger OneTimeCustomer |
| I_PT_SAFTGENLEDGERSUPPLIER | COMPOSITE | SAFT PT GLEntries Supplier |
| I_PT_SAFTPAYMENTCUSTOMER | COMPOSITE | SAF-T Payment Customer |
| I_PT_SAFTPAYMENTONETIMECUST | COMPOSITE | SAF-T Payment One Time Customer |
| I_PT_SAFTPAYTCUSTTAXREGNNMBR | COMPOSITE | SAF-T Payment Tax Registration Number |
| I_PT_SAFTSELFBILLGCUSTADDRHIST | COMPOSITE | SAF-T PT Self-Billing CustAddr History |
| I_PT_SAFTSELFBILLGINVOICEHDR | COMPOSITE | SAF-T PT Self-Billing Invoice Header |
| I_PT_SAFTSELFBILLGSUPLRINVCHDR | COMPOSITE | SAF-T PT Self-Billing SupplierInv Header |
| I_PT_SAFTSETTLEMENTMGMTHEADER | COMPOSITE | SAF-T PT Settlement Management Header |
| I_PT_SAFTSETTLMTMGMTCUSTOMER | COMPOSITE | SAF-T PT Settlement Management Customer |
| I_PT_SAFTSETTLMTMGMTTAXREGNMBR | COMPOSITE | SAF-T PT Settlement Mgm Tax Reg Customer |
| I_SAFTACCTGONETIMECUSTOMER | COMPOSITE | SAF-T Accounting OneTimeCustomers |
| I_SAFTBILLINGONETIMECUSTOMER | COMPOSITE | SAF-T Billing OneTimeCustomers |
| I_SAFTDELIVERYONETIMECUSTOMER | COMPOSITE | SAF-T Delivery OneTimeCustomers |
| I_SAFTGENLEDGERONETIMECUSTOMER | COMPOSITE | SAF-T Gen Ledger One Time Customer |
| P_BPCURRENTADDRESS | COMPOSITE | Business Partner Current Address |
| P_NO_SAFTCUSTADDR | COMPOSITE | SAFT NO Customer Address Max |
| P_NO_SAFTCUSTMAX | COMPOSITE | SAFT NO Customer Max |
| P_NO_SAFTSUPADDR | COMPOSITE | SAFT NO Supplier Address Max |
| P_NO_SAFTSUPMAX | COMPOSITE | SAFT NO Supplier Max |
| P_PT_SAFTCUSTADDR | COMPOSITE | Get Cust addr max |
| P_PT_SAFTCUSTMAX | COMPOSITE | Get Cust max |
| P_PT_SAFTSUPADDR | COMPOSITE | SAF-T Get Supplier addr max |
| P_PT_SAFTSUPMAX | COMPOSITE | SAF-T Get Supplier max |
| C_BANKACCOUNTREVISIONPROFILES | CONSUMPTION | Bank Account Revision Profiles |
| C_BANKACCOUNTWITHREVISION | CONSUMPTION | Bank Account With Revision |
| C_BKACCOUNTOUTPUTPARAMDET | CONSUMPTION | Bank Correspondence Parameter |
| C_BPADDLCUSTWEBSITEURL | CONSUMPTION | C view for Web URL of MLTAS Customers |
| C_BPADDLSUPLRPARTFUNC | CONSUMPTION | Additional Supplier Partner Function |
| C_BPADDLSUPLRWEBSITEURL | CONSUMPTION | C view for Web URL of MLTAS Suppliers |
| C_BPADDRESSVALUEHELP | CONSUMPTION | Value Help view for list of addresses of a BP |
| C_BPWEBSITEURL | CONSUMPTION | Consumption View for BP website |
| C_BUSINESSPARTNER | CONSUMPTION | Consumption view for BusinessPartner App |
| C_BUSINESSPARTNERADDRESS | CONSUMPTION | BP Address Consumption View |
| C_BUSINESSPARTNERCUSTOMER | CONSUMPTION | Business Partner |
| C_BUSINESSPARTNERSUPPLIER | CONSUMPTION | Business Partner Supplier |
| C_CPBUPAEMAILVH | CONSUMPTION | Contact Information – Email |
| C_CPBUPAFAXVH | CONSUMPTION | Contact Information – Fax |
| C_CUSTOMEROP | CONSUMPTION | Root consumption view for customer object page |
| C_INSURCUST360CUSTDETAILS | CONSUMPTION | Customer 360 – Customer Information |
| C_INSURCUST360PAYTITEMS | CONSUMPTION | Customer 360 – Payment Items |
| C_INSURCUST360POLICIES | CONSUMPTION | Customer 360 – Policies |
| C_INSURCUST360SUBMISSIONS | CONSUMPTION | Customer 360 – Submissions |
| C_INVGCSMLOCSTAFFUNITTP | CONSUMPTION | Transactional View:ICM Staff and Units |
| C_INVGCSMOBJECTSTAFFUNITTP | CONSUMPTION | Transactional View:ICM Staff and Units |
| C_KR_STRPWITHHOLDINGTAXITEMQ | CONSUMPTION | Business and Other income tax Items for Korea Query |
| C_NL_SAFTBUSINESSPARTNER | CONSUMPTION | SAF-T NL Business Partner |
| C_NL_SAFTBUSPARTNERBANKACCT | CONSUMPTION | SAFT NL Business Partner Bank Accounts |
| C_NL_SAFTBUSPARTNERPOSTALADDR | CONSUMPTION | SAFT NL Business Partner Postal Address |
| C_NL_SAFTBUSPARTNERSTADDRESS | CONSUMPTION | SAFT NL Business Partner Street Address |
| C_NO_SAFTGENLEDGERANALYTICS | CONSUMPTION | SAF-T Norway General Ledger Analytics |
| C_NO_SAFTGENLEDGERCUSTCONTACTS | CONSUMPTION | SAF-T Norway GL Customer Contacts |
| C_NO_SAFTGENLEDGERCUSTOMER | CONSUMPTION | SAF-T Norway General Ledger Customer |
| C_NO_SAFTGENLEDGERSUPLRCNTCTS | CONSUMPTION | SAF-T Norway GL Supplier Contacts |
| C_NO_SAFTGENLEDGERSUPPLIER | CONSUMPTION | SAF-T Norway General Ledger Supplier |
| C_NO_SAFTJOURNALENTRYTOTCHECK | CONSUMPTION | SAF-T Norway Journal Entry Total Check |
| C_NO_SAFTJOURNALITEMANALYTICS | CONSUMPTION | SAF-T Norway Journal Item Analytics |
| C_NO_SAFTJOURNALITEMCUBE | CONSUMPTION | SAF-T Norway Journal Item Cube |
| C_NO_SAFTJOURNALITEMQUERY | CONSUMPTION | SAF-T Norway Journal Item Query |
| C_NO_SAFTJOURNALITEMTAX | CONSUMPTION | SAF-T Norway Journal Item Tax |
| C_PT_SAFTCUSTOMER | CONSUMPTION | SAF-T PT Customers |
| C_PT_SAFTDELIVERYDOCTOTCHECK | CONSUMPTION | SAFT Delvery Doc Total Check |
| C_PT_SAFTDELIVERYHDRCUBE | CONSUMPTION | SAFT Delivery Document Header cube view |
| C_PT_SAFTDELIVERYHDRQRY | CONSUMPTION | SAFT Delivery Document Header query view |
| C_PT_SAFTGENLEDGERCUSTOMER | CONSUMPTION | SAFT PT GLEntries Customer |
| C_PT_SAFTGENLEDGERENTRYCUBE | CONSUMPTION | SAF-T PT General Ledger Entries Cube |
| C_PT_SAFTGENLEDGERENTRYQRY | CONSUMPTION | SAF-T PT General Ledger Entries Query |
| C_PT_SAFTHEADER | CONSUMPTION | SAF-T PT Header |
| C_PT_SAFTINTEGRATEDCUSTOMER | CONSUMPTION | SAF-T Integrated Customers |
| C_PT_SAFTPAYMENTHEADERCUBE | CONSUMPTION | SAF-T PT Payment Header Cube |
| C_PT_SAFTPAYMENTHEADERQRY | CONSUMPTION | SAF-T PT Payment Header Query |
| C_PT_SAFTSALESINVOICEHEADERC | CONSUMPTION | SAF-T PT Sales Invoice Header Cube |
| C_PT_SAFTSALESINVOICEHEADERQRY | CONSUMPTION | SAF-T PT Sales Invoice Header Query |
| C_PT_SAFTSELFBILLGCUSTOMER | CONSUMPTION | SAF-T PT Self-Billing Customer |
| C_PT_SAFTSELFBILLGINVOICEHDRC | CONSUMPTION | SAF-T PT Self-Billing InvoiceHeader Cube |
| C_PT_SAFTSELFBILLGINVOICEHDRQ | CONSUMPTION | SAF-T PT Self-Billing Inv. Header Query |
| C_PT_SAFTSELFBILLGSUPPLIER | CONSUMPTION | SAF-T PT Self-Billing Supplier |
| C_PT_SAFTSELFBILLGTOTALS | CONSUMPTION | SAF-T PT Self-Billing Totals |
| C_PT_SAFTSLSINVOICENMBRENTRIES | CONSUMPTION | SAF-T PT Sales Invoice Number Entries |
| C_PT_SAFTSUPPLIER | CONSUMPTION | SAF-T PT Suppliers |
| C_PT_SAFTWORKINGDOCHEADERC | CONSUMPTION | SAF-T PT Working Documents Header Cube |
| C_PT_SAFTWORKINGDOCHEADERQRY | CONSUMPTION | SAF-T PT Working Documents Header Query |
| C_PT_SAFTWORKINGDOCNMBRENTRIES | CONSUMPTION | SAF-T PT Working Doc Number Entries |
| C_PT_SAFTWORKINGDOCTOTALCHECK | CONSUMPTION | SAF-T PT Working Documents Total Check |
| P_CPBUPAEMAILALL | CONSUMPTION | Business Partner Emails from all sources |
| P_CPBUPAEMAILUNIQUE | CONSUMPTION | Contact Information – Email |
| P_CPBUPAEMAILVH | CONSUMPTION | Contact Information – Email |
| P_CPBUPAEMAILWONAMES | CONSUMPTION | Busines Partner email WithOut first and last names |
