ADRC

Transparent Table Application Table
106 Fields 61 CDS Views

Addresses (Business Address Services)

ADRC is an SAP database table in S/4HANA. Addresses (Business Address Services). It contains 106 fields. 61 CDS views read from this table.

CDS Views using this table (61)

ViewTypeJoinVDMDescription
/BOFU/CV_BPAddr view from BOPF: /BOFU/BuPa Address (Old)
/BOFU/CV_BPAddress view_entity from BOPF: Business Partner Address
/UCOM/I_MCM_ADRC view_entity from BASIC Address (Basic)
CIC_CustomerAddress view_entity inner Proj. View on Customer Address
CIC_PlantAddress view_entity from Proj. view on Plant address
CIC_SalesDocumentPartner view_entity left_outer Projection on Sales Doc. Partner (Industry Cloud Solutions)
CIC_SupplierAddress view_entity inner Proj. View on Supplier Address
CRMS4_IU_C_CONVAR view_entity inner Connection Object by Various Fields
CRMS4_IU_C_CONVAR_DEVPOD view_entity inner Con. Object by Various Fields (Dev, PoD)
CRMS4_IU_C_PRMADDR view from Premise by Address
ESH_N_COMPANY_ADDRESS_ADDRESS view from Company Address
FAC_AUDIT_Z3_TAX_GROUP view left_outer Tax Group
FARMLVD_APAR_ACCDOC view left_outer Cleared Receivable Item Information
Fclm_Bm_Adcp view from Linkage for adcp and adrc
Fclm_Bm_Address view from Address data for bank master and business partner
Fclm_Bm_Contacts view left_outer Contact person for bank
FISTRPGSTR1ITEM view left_outer
FNDEI_ADRC_BLOCKINGINFO view from Blocking View for table ADRC
FNDEI_ADRC_FILTER view from Filter View for table ADRC
I_ACMBusinessPartnerDetailsVH view inner BASIC Business Partner Details
I_ACMCustPartnerDetailsVH view inner BASIC Customer Partner Details
I_Address view from BASIC Address
I_AddressContactCard view from BASIC Address Contact Card
I_AddrOrgNamePostalAddress view_entity from BASIC Postal Address and Organization Name
I_DfsAddress view from BASIC Address
I_InvgCsMAddress view from BASIC ICM Address
I_OilBusinessLocation view inner BASIC TSW Business Location
I_ScriptedAddress view from BASIC Interational Address Version
I_ScriptedOrganizationAddress view from COMPOSITE Interational Address Version
I_ScriptedPersonAddress view inner BASIC Interational Address Version for Persons
I_SiloTankDipAnalysis view left_outer COMPOSITE Silo Tank Dip height analysis across a number of days
I_TankVisualization view left_outer COMPOSITE Tank Visualization Details
I_TicketPlantTimeZone view inner COMPOSITE Plant Time Zone
I_TrdgContrPartAddressDets view from BASIC Interface view for Trading Contract Partner Address details
I_TripItemLocationTimeZone view inner BASIC Location Time zone for Trip Item
I_TSWLocationTimeZone view inner BASIC TSW Location TimeZone
I_VisualLocations view left_outer COMPOSITE Location Master Data
I_VisualLocationTimeZone view inner BASIC Location Time Zone for Visualizations
I_VisualNominations view left_outer COMPOSITE Visual Nominations
I_VisualSimulation view left_outer COMPOSITE IPW Simulation in Visualization
ICM_EMPLOYEE_CONTACT view inner Employee
ICM_PARTNER_CONTACT view inner BusinessPartner_contact
ICM_PARTNER_ORGANIZATION view inner BusinessPartner_Organization
ICM_PARTNER_PERSON view inner BusinessPartner_person
P_Arbsitmopenitem view left_outer COMPOSITE
P_CN_CADEAddressID view left_outer BASIC
P_CN_CADEOrganizationName view left_outer BASIC
P_ContactCardPerson view from COMPOSITE
P_Emplprivpostaddr view from BASIC
P_FrcElmntOrgBusinessAddress view from BASIC
P_NZ_HEADERDATA view left_outer BASIC
P_OrganizationAddress view from COMPOSITE
P_OrganizationAddressConsum view from CONSUMPTION
P_StRpWhldgTxIntlAddrVers view_entity from BASIC
SHSM_M_EKUNP view inner Business Partner by Postal Code Search Help
TSI_CONTACT_entry view inner
UPOV_PR_DN_UOM view left_outer Delivery Network(UOM)
UPOV_PR_MP_UOM view left_outer Measurement Point (UOM)
UPOV_PR_WC_UOM view left_outer UOM: Well Completion
v_sd_ci_item_party view left_outer
v_sd_ci_party view left_outer

Fields (106)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY addrnumber AD_ADDRNUM Address Number
KEY date_from AD_DATE_FR From
KEY nation AD_NATION Address Version
date_to AD_DATE_TO To
title AD_TITLE Title Key
name1 AD_NAME1 Name
name2 AD_NAME2 Name 2
name3 AD_NAME3 Name 3
name4 AD_NAME4 Name 4
name_text AD_NAMETXT Conv. name
name_co AD_NAME_CO c/o
city1 AD_CITY1 City
city2 AD_CITY2 District
city_code AD_CITYNUM City Code
cityp_code AD_CITYPNM District
home_city AD_CITY3 Different City
cityh_code AD_CITYHNM City Code
chckstatus AD_CHECKST Check Status
regiogroup REGIOGROUP Structure Group
post_code1 AD_PSTCD1 Postal Code
post_code2 AD_PSTCD2 PO Box Post Cde
post_code3 AD_PSTCD3 Company Post Cd
pcode1_ext AD_PST1XT Postal Code Ext
pcode2_ext AD_PST2XT Postal Code Ext
pcode3_ext AD_PST3XT Postal Code Ext
po_box AD_POBX PO Box
dont_use_p AD_NO_USEP Undeliverable
po_box_num AD_POBXNUM PO Box w/o No.
po_box_loc AD_POBXLOC PO Box City
city_code2 AD_CIT2NUM City Code
po_box_reg AD_POBXREG PO Region
po_box_cty AD_POBXCTY PO Box C/R
postalarea AD_PSTLAR Delivery Dist.
transpzone LZONE Transport Zone
street AD_STREET Street
dont_use_s AD_NO_USES Undeliverable
streetcode AD_STRNUM Street Code
streetabbr AD_STRABBR Street Abbrev.
house_num1 AD_HSNM1 House Number
house_num2 AD_HSNM2 Supplement
house_num3 AD_HSNM3 Number Range
str_suppl1 AD_STRSPP1 Street 2
str_suppl2 AD_STRSPP2 Street 3
str_suppl3 AD_STRSPP3 Street 4
location AD_LCTN Street 5
building AD_BLDNG Building Code
floor AD_FLOOR Floor
roomnumber AD_ROOMNUM Room Number
country LAND1 Country/Reg.
langu SPRAS Language
region REGIO Region
addr_group AD_GROUP Address group
flaggroups AD_FLGGP Flag: There are more address group assignments
pers_addr AD_PRSADDR pers. address
sort1 AD_SORT1 Search Term 1
sort2 AD_SORT2 Search Term 2
sort_phn AD_SRTPHN Phonet. Sort.
deflt_comm AD_COMM Comm. Method
tel_number AD_TLNMBR1 Telephone
tel_extens AD_TLXTNS1 Extension
fax_number AD_FXNMBR1 Fax
fax_extens AD_FXXTNS1 Extension
flagcomm2 AD_FLGCM02 Telephone...
flagcomm3 AD_FLGCM03 Fax...
flagcomm4 AD_FLGCM04 Teletex
flagcomm5 AD_FLGCM05 Telex
flagcomm6 AD_FLGCM06 E-Mail Defined
flagcomm7 AD_FLGCM07 R/Mail
flagcomm8 AD_FLGCM08 X.400
flagcomm9 AD_FLGCM09 RFC
flagcomm10 AD_FLGCM10 Printer
flagcomm11 AD_FLGCM11 SSF
flagcomm12 AD_FLGCM12 URI/FTP
flagcomm13 AD_FLGCM13 Pager
addrorigin AD_ORIGINA Address Source
mc_name1 AD_MC_NAME Name
mc_city1 AD_MC_CITY City
mc_street AD_MC_STRT Street
extension1 AD_EXTENS1 Data line
extension2 AD_EXTENS2 Telebox
time_zone AD_TZONE Time Zone
taxjurcode AD_TXJCD Tax Jurisdiction
address_id AD_ADDR_ID Address ID
langu_crea AD_LANGUCR Creation lang.
adrc_uuid AD_UUID Address UUID
uuid_belated AD_UUID_BELATED Subsequent UUID
id_category AD_ID_CATEGORY ID Category
adrc_err_status AD_ERR_STATUS Error Status
po_box_lobby AD_PO_BOX_LBY PO Box Lobby
deli_serv_type AD_DELIVERY_SERVICE_TYPE Delvry Serv Type
deli_serv_number AD_DELIVERY_SERVICE_NUMBER Delivery Service No.
county_code AD_CNTYNUM County code
county AD_COUNTY County
township_code AD_TWSHPNUM Township code
township AD_TOWNSHIP Township
mc_county AD_MC_COUNTY County
mc_township AD_MC_TWSHP Township
xpcpt AD_XPCPT PurposeComplete Flag
_dataaging DATA_TEMPERATURE Data Aging
addresscreatedbyuser ABP_CREATION_USER Created By
addresscreatedondatetime ABP_CREATION_UTCL Created On
addresschangedbyuser ABP_LASTCHANGE_USER Changed By
addresschangedondatetime ABP_LASTCHANGE_UTCL Changed On
duns /SAPHT/RN_DUNS DUNS Number
dunsp4 /SAPHT/RN_DUNSP4 DUNS+4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Addresses (Business Address Services)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADRC (
    CLIENT,                    -- Client [MANDT]
    ADDRNUMBER,                -- Address Number [AD_ADDRNUM]
    DATE_FROM,                 -- From [AD_DATE_FR]
    NATION,                    -- Address Version [AD_NATION]
    DATE_TO,                   -- To [AD_DATE_TO]
    TITLE,                     -- Title Key [AD_TITLE]
    NAME1,                     -- Name [AD_NAME1]
    NAME2,                     -- Name 2 [AD_NAME2]
    NAME3,                     -- Name 3 [AD_NAME3]
    NAME4,                     -- Name 4 [AD_NAME4]
    NAME_TEXT,                 -- Conv. name [AD_NAMETXT]
    NAME_CO,                   -- c/o [AD_NAME_CO]
    CITY1,                     -- City [AD_CITY1]
    CITY2,                     -- District [AD_CITY2]
    CITY_CODE,                 -- City Code [AD_CITYNUM]
    CITYP_CODE,                -- District [AD_CITYPNM]
    HOME_CITY,                 -- Different City [AD_CITY3]
    CITYH_CODE,                -- City Code [AD_CITYHNM]
    CHCKSTATUS,                -- Check Status [AD_CHECKST]
    REGIOGROUP,                -- Structure Group [REGIOGROUP]
    POST_CODE1,                -- Postal Code [AD_PSTCD1]
    POST_CODE2,                -- PO Box Post Cde [AD_PSTCD2]
    POST_CODE3,                -- Company Post Cd [AD_PSTCD3]
    PCODE1_EXT,                -- Postal Code Ext [AD_PST1XT]
    PCODE2_EXT,                -- Postal Code Ext [AD_PST2XT]
    PCODE3_EXT,                -- Postal Code Ext [AD_PST3XT]
    PO_BOX,                    -- PO Box [AD_POBX]
    DONT_USE_P,                -- Undeliverable [AD_NO_USEP]
    PO_BOX_NUM,                -- PO Box w/o No. [AD_POBXNUM]
    PO_BOX_LOC,                -- PO Box City [AD_POBXLOC]
    CITY_CODE2,                -- City Code [AD_CIT2NUM]
    PO_BOX_REG,                -- PO Region [AD_POBXREG]
    PO_BOX_CTY,                -- PO Box C/R [AD_POBXCTY]
    POSTALAREA,                -- Delivery Dist. [AD_PSTLAR]
    TRANSPZONE,                -- Transport Zone [LZONE]
    STREET,                    -- Street [AD_STREET]
    DONT_USE_S,                -- Undeliverable [AD_NO_USES]
    STREETCODE,                -- Street Code [AD_STRNUM]
    STREETABBR,                -- Street Abbrev. [AD_STRABBR]
    HOUSE_NUM1,                -- House Number [AD_HSNM1]
    HOUSE_NUM2,                -- Supplement [AD_HSNM2]
    HOUSE_NUM3,                -- Number Range [AD_HSNM3]
    STR_SUPPL1,                -- Street 2 [AD_STRSPP1]
    STR_SUPPL2,                -- Street 3 [AD_STRSPP2]
    STR_SUPPL3,                -- Street 4 [AD_STRSPP3]
    LOCATION,                  -- Street 5 [AD_LCTN]
    BUILDING,                  -- Building Code [AD_BLDNG]
    FLOOR,                     -- Floor [AD_FLOOR]
    ROOMNUMBER,                -- Room Number [AD_ROOMNUM]
    COUNTRY,                   -- Country/Reg. [LAND1]
    LANGU,                     -- Language [SPRAS]
    REGION,                    -- Region [REGIO]
    ADDR_GROUP,                -- Address group [AD_GROUP]
    FLAGGROUPS,                -- Flag: There are more address group assignments [AD_FLGGP]
    PERS_ADDR,                 -- pers. address [AD_PRSADDR]
    SORT1,                     -- Search Term 1 [AD_SORT1]
    SORT2,                     -- Search Term 2 [AD_SORT2]
    SORT_PHN,                  -- Phonet. Sort. [AD_SRTPHN]
    DEFLT_COMM,                -- Comm. Method [AD_COMM]
    TEL_NUMBER,                -- Telephone [AD_TLNMBR1]
    TEL_EXTENS,                -- Extension [AD_TLXTNS1]
    FAX_NUMBER,                -- Fax [AD_FXNMBR1]
    FAX_EXTENS,                -- Extension [AD_FXXTNS1]
    FLAGCOMM2,                 -- Telephone... [AD_FLGCM02]
    FLAGCOMM3,                 -- Fax... [AD_FLGCM03]
    FLAGCOMM4,                 -- Teletex [AD_FLGCM04]
    FLAGCOMM5,                 -- Telex [AD_FLGCM05]
    FLAGCOMM6,                 -- E-Mail Defined [AD_FLGCM06]
    FLAGCOMM7,                 -- R/Mail [AD_FLGCM07]
    FLAGCOMM8,                 -- X.400 [AD_FLGCM08]
    FLAGCOMM9,                 -- RFC [AD_FLGCM09]
    FLAGCOMM10,                -- Printer [AD_FLGCM10]
    FLAGCOMM11,                -- SSF [AD_FLGCM11]
    FLAGCOMM12,                -- URI/FTP [AD_FLGCM12]
    FLAGCOMM13,                -- Pager [AD_FLGCM13]
    ADDRORIGIN,                -- Address Source [AD_ORIGINA]
    MC_NAME1,                  -- Name [AD_MC_NAME]
    MC_CITY1,                  -- City [AD_MC_CITY]
    MC_STREET,                 -- Street [AD_MC_STRT]
    EXTENSION1,                -- Data line [AD_EXTENS1]
    EXTENSION2,                -- Telebox [AD_EXTENS2]
    TIME_ZONE,                 -- Time Zone [AD_TZONE]
    TAXJURCODE,                -- Tax Jurisdiction [AD_TXJCD]
    ADDRESS_ID,                -- Address ID [AD_ADDR_ID]
    LANGU_CREA,                -- Creation lang. [AD_LANGUCR]
    ADRC_UUID,                 -- Address UUID [AD_UUID]
    UUID_BELATED,              -- Subsequent UUID [AD_UUID_BELATED]
    ID_CATEGORY,               -- ID Category [AD_ID_CATEGORY]
    ADRC_ERR_STATUS,           -- Error Status [AD_ERR_STATUS]
    PO_BOX_LOBBY,              -- PO Box Lobby [AD_PO_BOX_LBY]
    DELI_SERV_TYPE,            -- Delvry Serv Type [AD_DELIVERY_SERVICE_TYPE]
    DELI_SERV_NUMBER,          -- Delivery Service No. [AD_DELIVERY_SERVICE_NUMBER]
    COUNTY_CODE,               -- County code [AD_CNTYNUM]
    COUNTY,                    -- County [AD_COUNTY]
    TOWNSHIP_CODE,             -- Township code [AD_TWSHPNUM]
    TOWNSHIP,                  -- Township [AD_TOWNSHIP]
    MC_COUNTY,                 -- County [AD_MC_COUNTY]
    MC_TOWNSHIP,               -- Township [AD_MC_TWSHP]
    XPCPT,                     -- PurposeComplete Flag [AD_XPCPT]
    _DATAAGING,                -- Data Aging [DATA_TEMPERATURE]
    ADDRESSCREATEDBYUSER,      -- Created By [ABP_CREATION_USER]
    ADDRESSCREATEDONDATETIME,  -- Created On [ABP_CREATION_UTCL]
    ADDRESSCHANGEDBYUSER,      -- Changed By [ABP_LASTCHANGE_USER]
    ADDRESSCHANGEDONDATETIME,  -- Changed On [ABP_LASTCHANGE_UTCL]
    DUNS,                      -- DUNS Number [/SAPHT/RN_DUNS]
    DUNSP4,                    -- DUNS+4 [/SAPHT/RN_DUNSP4]
    PRIMARY KEY (CLIENT, ADDRNUMBER, DATE_FROM, NATION)
);

Learn More