I_ADDRESSHOMEPAGEURL

CDS View

Homepage URL Address

I_ADDRESSHOMEPAGEURL is a CDS View in S/4HANA. Homepage URL Address. It contains 10 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_AddressHomePageURL view from BASIC Home Page URL
A_BPContactPersonWbsteURL view_entity inner BASIC Contact Person Website URL
A_BPContactWrkPlaceHomePageURL view inner BASIC BP Contact Work Place URL Address
I_BPContactWbsteURLTP view inner TRANSACTIONAL BO view for BP contact Website URL

Fields (10)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY IsDefaultURLAddress IsDefaultURLAddress 4
KEY OrdinalNumber OrdinalNumber,OrdinalNumberForEdit 4
KEY Person Person 1
KEY ValidityStartDate ValidityStartDate 1
CommNumberIsNotUsed CommNumberIsNotUsed 3
SearchURLAddress SearchURLAddress 3
UniformResourceIdentifierType UniformResourceIdentifierType 2
URLFieldLength URLFieldLength 2
WebsiteURL CorporateWebsiteURL,WebsiteURL 3

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.

-- Homepage URL Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRESSHOMEPAGEURL (
    ADDRESSID,
    ISDEFAULTURLADDRESS,
    ORDINALNUMBER,
    PERSON,
    VALIDITYSTARTDATE,
    COMMNUMBERISNOTUSED,
    SEARCHURLADDRESS,
    UNIFORMRESOURCEIDENTIFIERTYPE,
    URLFIELDLENGTH,
    WEBSITEURL,
    PRIMARY KEY (ADDRESSID, ISDEFAULTURLADDRESS, ORDINALNUMBER, PERSON, VALIDITYSTARTDATE)
);