BUT_ADRC_IMOUT

Transparent Table Application Table
101 Fields 1 CDS Views

Master Data Consolidation: Process Table for ADRC

BUT_ADRC_IMOUT is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for ADRC. It contains 101 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPAddrInfoManagementOut view from BASIC BP Address IM in HANA

Fields (101)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY source_addrnumber ad_addrnum Address Number
KEY date_from ad_date_fr From
KEY nation ad_nation Address Version
addrnumber ad_addrnum Address Number
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
source_recency mdc_recency Last Changed On

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.

-- Master Data Consolidation: Process Table for ADRC
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT_ADRC_IMOUT (
    CLIENT,             -- Client [mandt]
    SOURCE_ADDRNUMBER,  -- Address Number [ad_addrnum]
    DATE_FROM,          -- From [ad_date_fr]
    NATION,             -- Address Version [ad_nation]
    ADDRNUMBER,         -- Address Number [ad_addrnum]
    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]
    SOURCE_RECENCY,     -- Last Changed On [mdc_recency]
    PRIMARY KEY (CLIENT, SOURCE_ADDRNUMBER, DATE_FROM, NATION)
);

Learn More