ADRC
Adressen (Business Address Services)
ADRC is an SAP database table in S/4HANA. Adressen (Business Address Services). It contains 100 fields. 34 CDS views read from this table.
CDS Views using this table (34)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /BOFU/CV_BPAddr | view | from | BOPF: /BOFU/BuPa Address (Old) | |
| /BOFU/CV_BPAddress | view_entity | from | BOPF: Business Partner Address | |
| CIC_PlantAddress | view_entity | from | Proj. view on Plant address | |
| ESH_N_COMPANY_ADDRESS_ADDRESS | view | from | Company Address | |
| FAC_AUDIT_Z3_TAX_GROUP | view | left_outer | Tax Group | |
| FARMLVD_APAR_ACCDOC | view_entity | 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 | GSTR1 Tax Items for Statutory Reporting | |
| FNDEI_ADRC_BLOCKINGINFO | view | from | Blocking View for table ADRC | |
| FNDEI_ADRC_FILTER | view | from | Filter View for table ADRC | |
| 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_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 |
| 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_entity | left_outer | COMPOSITE | Open Receivable Items |
| P_CN_CADEAddressID | view | left_outer | BASIC | CADE Fetch max address ID for BP |
| P_CN_CADEOrganizationName | view | left_outer | BASIC | CADE Organization Name |
| P_ContactCardPerson | view | from | COMPOSITE | ContactCard of Person (Address) |
| P_Emplprivpostaddr | view | from | BASIC | Employee Postal Address |
| P_NZ_HEADERDATA | view | left_outer | BASIC | Header data integration with master data |
| P_OrganizationAddress | view | from | COMPOSITE | Address Info |
| P_OrganizationAddressConsum | view | from | CONSUMPTION | Address Info |
| P_StRpWhldgTxIntlAddrVers | view_entity | from | BASIC | International Address Version |
| TSI_CONTACT_entry | view | inner | My Vendor Invoices: Contact | |
| v_sd_ci_item_party | view | left_outer | Customer Invoice Item Party | |
| v_sd_ci_party | view | left_outer | Party information of Customer Invoices |
Fields (100)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | client | mandt | |
| KEY | addrnumber | ad_addrnum | |
| KEY | date_from | ad_date_fr | |
| KEY | nation | ad_nation | |
| date_to | ad_date_to | ||
| title | ad_title | ||
| name1 | ad_name1 | ||
| name2 | ad_name2 | ||
| name3 | ad_name3 | ||
| name4 | ad_name4 | ||
| name_text | ad_nametxt | ||
| name_co | ad_name_co | ||
| city1 | ad_city1 | ||
| city2 | ad_city2 | ||
| city_code | ad_citynum | ||
| cityp_code | ad_citypnm | ||
| home_city | ad_city3 | ||
| cityh_code | ad_cityhnm | ||
| chckstatus | ad_checkst | ||
| regiogroup | regiogroup | ||
| post_code1 | ad_pstcd1 | ||
| post_code2 | ad_pstcd2 | ||
| post_code3 | ad_pstcd3 | ||
| pcode1_ext | ad_pst1xt | ||
| pcode2_ext | ad_pst2xt | ||
| pcode3_ext | ad_pst3xt | ||
| po_box | ad_pobx | ||
| dont_use_p | ad_no_usep | ||
| po_box_num | ad_pobxnum | ||
| po_box_loc | ad_pobxloc | ||
| city_code2 | ad_cit2num | ||
| po_box_reg | ad_pobxreg | ||
| po_box_cty | ad_pobxcty | ||
| postalarea | ad_pstlar | ||
| transpzone | lzone | ||
| street | ad_street | ||
| dont_use_s | ad_no_uses | ||
| streetcode | ad_strnum | ||
| streetabbr | ad_strabbr | ||
| house_num1 | ad_hsnm1 | ||
| house_num2 | ad_hsnm2 | ||
| house_num3 | ad_hsnm3 | ||
| str_suppl1 | ad_strspp1 | ||
| str_suppl2 | ad_strspp2 | ||
| str_suppl3 | ad_strspp3 | ||
| location | ad_lctn | ||
| building | ad_bldng | ||
| floor | ad_floor | ||
| roomnumber | ad_roomnum | ||
| country | land1 | ||
| langu | spras | ||
| region | regio | ||
| addr_group | ad_group | ||
| flaggroups | ad_flggp | ||
| pers_addr | ad_prsaddr | ||
| sort1 | ad_sort1 | ||
| sort2 | ad_sort2 | ||
| sort_phn | ad_srtphn | ||
| deflt_comm | ad_comm | ||
| tel_number | ad_tlnmbr1 | ||
| tel_extens | ad_tlxtns1 | ||
| fax_number | ad_fxnmbr1 | ||
| fax_extens | ad_fxxtns1 | ||
| flagcomm2 | ad_flgcm02 | ||
| flagcomm3 | ad_flgcm03 | ||
| flagcomm4 | ad_flgcm04 | ||
| flagcomm5 | ad_flgcm05 | ||
| flagcomm6 | ad_flgcm06 | ||
| flagcomm7 | ad_flgcm07 | ||
| flagcomm8 | ad_flgcm08 | ||
| flagcomm9 | ad_flgcm09 | ||
| flagcomm10 | ad_flgcm10 | ||
| flagcomm11 | ad_flgcm11 | ||
| flagcomm12 | ad_flgcm12 | ||
| flagcomm13 | ad_flgcm13 | ||
| addrorigin | ad_origina | ||
| mc_name1 | ad_mc_name | ||
| mc_city1 | ad_mc_city | ||
| mc_street | ad_mc_strt | ||
| extension1 | ad_extens1 | ||
| extension2 | ad_extens2 | ||
| time_zone | ad_tzone | ||
| taxjurcode | ad_txjcd | ||
| address_id | ad_addr_id | ||
| langu_crea | ad_langucr | ||
| adrc_uuid | ad_uuid | ||
| uuid_belated | ad_uuid_belated | ||
| id_category | ad_id_category | ||
| adrc_err_status | ad_err_status | ||
| po_box_lobby | ad_po_box_lby | ||
| deli_serv_type | ad_delivery_service_type | ||
| deli_serv_number | ad_delivery_service_number | ||
| county_code | ad_cntynum | ||
| county | ad_county | ||
| township_code | ad_twshpnum | ||
| township | ad_township | ||
| mc_county | ad_mc_county | ||
| mc_township | ad_mc_twshp | ||
| xpcpt | ad_xpcpt | ||
| _dataaging | data_temperature |