BUT020
BP: Addresses
BUT020 is an SAP database table in S/4HANA. BP: Addresses. It contains 13 fields. 35 CDS views read from this table.
CDS Views using this table (35)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /BOFU/CV_BP_AddressInformation | view | inner | BOPF: /BOFU/BuPa Node Addressinformation | |
| /BOFU/CV_BPCurrentDefaultAddr | view | from | BOPF: /BOFU/BuPa Current Default Address | |
| /BOFU/CV_Q_BPByAddress | view | left_outer | BOPF: Root Query on Address Data | |
| Fclm_Bm_Address | view | left_outer | Address data for bank master and business partner | |
| Fclm_Bm_Contacts | view | left_outer | Contact person for bank | |
| Fclm_Bm_Used_Bp_Adr | view | left_outer | Used business partner address for banks | |
| Fclm_Bm_Used_Unit | view | left_outer | Bank data of where used unit | |
| I_ACMBusinessPartnerDetailsVH | view | inner | BASIC | Business Partner Details |
| I_ACMCustPartnerDetailsVH | view | inner | BASIC | Customer Partner Details |
| I_BPContactPersonAddressGov | view_entity | inner | TRANSACTIONAL | Base Contact Person Workplace Address |
| I_BPCurrentDefaultAddress | view | from | BASIC | Business Partner Current Default Address |
| I_BPEmailAddress | view | inner | BASIC | Business Partner Email Core View |
| I_BPFaxNumber | view | inner | BASIC | BP Fax number core view |
| I_BPMobilePhoneNumber | view | inner | BASIC | Mobile Phone Number core view |
| I_BPTelephoneNumber | view | inner | BASIC | BusinessPartner Telephone Number |
| I_BPWebsiteURL | view | inner | BASIC | BP Website Core View |
| I_BPWebsiteURL_2 | view | inner | BASIC | BP Website |
| I_BusinessPartAddress_2 | view | from | COMPOSITE | Business Partner Address |
| I_BusinessPartnerAddress | view | from | BASIC | Core view for Business Partner Address |
| I_BusinessPartnerAddress_2 | view | from | BASIC | Basic View for BP Address |
| I_BusinessPartnerDefaultAddr | view | from | BASIC | Business Partner Default Address |
| I_BusPartAddress | view | from | BASIC | Business Partner Address |
| I_BusPartScriptedGroupAddress | view | from | BASIC | International version of a business partner address |
| I_BusPartScriptedOrgAddress | view | from | BASIC | International version of a business partner address |
| I_BusPartScriptedPersonAddress | view | from | COMPOSITE | International version of a business partner address |
| I_BusPartTelephoneNumberGov | view | left_outer | BASIC | BP Governance Telephone Number |
| I_EmplHomeAddress | view | inner | BASIC | Obsolete - DONOT USE_Employee Home Address |
| I_EmployeeHomeAddress | view | inner | BASIC | Employee Home Address |
| I_InvgCsMPersonAddress | view | from | BASIC | Composite/Basic view for ICM Person Address |
| I_MDGovBPAddrProtFltr | view | from | BASIC | MDG BP Protected Address Filter |
| ICM_PARTNER_ORGANIZATION | view | inner | BusinessPartner_Organization | |
| P_CN_CADEAddressID | view | from | BASIC | |
| SHSM_M_EKUNP | view | inner | Business Partner by Postal Code Search Help | |
| SHSM_V_BUT020 | view | from | Ersatz für V_BUT020 in Suchhilfe | |
| SHSM_V_BUT020_I | view | from | Ersatz für V_BUT020_I in Suchhilfe |
Fields (13)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | client | MANDT | |
| KEY | partner | BU_PARTNER | |
| KEY | addrnumber | AD_ADDRNUM | |
| xdfadr | BU_XDFADR | ||
| adext | BU_ADEXT | ||
| nation | AD_NATION | ||
| guid | SYSUUID_C | ||
| move_addr | BU_MOVE_ADDR | ||
| date_from | BU_DATE_OBSOLETE | ||
| address_guid | BU_ADDRESS_GUID | ||
| addr_valid_from | BU_ADDR_VALID_FROM | ||
| addr_valid_to | BU_ADDR_VALID_TO | ||
| addr_move_date | BU_ADDR_MOVE_DATE |