I_ADDRESSPHONENUMBER

CDS View
9 Fields 2 CDS Views

Address Phone Number

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_AddressPhoneNumber view from BASIC Phone 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 2
KEY Person Person 1
DestinationLocationCountry DestinationLocationCountry 2
InternationalPhoneNumber InternationalPhoneNumber 2
IsDefaultPhoneNumber IsDefaultPhoneNumber 2
PhoneNumber PhoneNumber 2
PhoneNumberExtension PhoneNumberExtension 2
PhoneNumberType PhoneNumberType 2

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