I_ADDRESSPHONENUMBER

CDS View
9 Fields 4 CDS Views

Address Phone Number

I_ADDRESSPHONENUMBER is a CDS View in S/4HANA. Address Phone Number. It contains 9 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_AddressPhoneNumber view from BASIC Phone Number
A_BPContactPersonMblNmbr view_entity inner BASIC Contact Person Mobile Number
A_BPContactPersonTelNmbr view_entity inner BASIC Contact Person Telephone Number
A_BPContactWrkPlacePhoneNumber view inner BASIC BP Contact Work Place Phone Number

Fields (9)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY OrdinalNumber OrdinalNumber 4
KEY Person Person 1
DestinationLocationCountry DestinationLocationCountry 4
InternationalPhoneNumber InternationalPhoneNumber 4
IsDefaultPhoneNumber IsDefaultPhoneNumber 4
PhoneNumber MobilePhoneNumber,PhoneNumber 4
PhoneNumberExtension PhoneNumberExtension 4
PhoneNumberType PhoneNumberType 4

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.

-- Address Phone Number
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRESSPHONENUMBER (
    ADDRESSID,
    ORDINALNUMBER,
    PERSON,
    DESTINATIONLOCATIONCOUNTRY,
    INTERNATIONALPHONENUMBER,
    ISDEFAULTPHONENUMBER,
    PHONENUMBER,
    PHONENUMBEREXTENSION,
    PHONENUMBERTYPE,
    PRIMARY KEY (ADDRESSID, ORDINALNUMBER, PERSON)
);

Learn More