ADRC
Addresses (Business Address Services)
ADRC is an SAP database table in S/4HANA. Addresses (Business Address Services). It contains 106 fields. 57 CDS views read from this table.
CDS Views using this table (57)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /BOFU/CV_BPAddress | view | from | BOPF: /BOFU/BuPa Address | |
| 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_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 | BASIC | 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 | |
| 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)
| 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 | ||
| addresscreatedbyuser | ABP_CREATION_USER | ||
| addresscreatedondatetime | ABP_CREATION_UTCL | ||
| addresschangedbyuser | ABP_LASTCHANGE_USER | ||
| addresschangedondatetime | ABP_LASTCHANGE_UTCL | ||
| duns | /SAPHT/RN_DUNS | ||
| dunsp4 | /SAPHT/RN_DUNSP4 |