Monday, March 4, 2024

SAP Table ADR12 – FTP and URL (Business Address Services)

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