I_ADDRESSPHONENUMBER_2

CDS View
15 Fields 16 CDS Views

Phone Number

I_ADDRESSPHONENUMBER_2 is a CDS View in S/4HANA. Phone Number. It contains 15 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
C_Arberp_Address view left_outer CONSUMPTION CDS View for Addresses
I_AddrCurDfltLandlinePhoneNmbr view_entity from BASIC Current Default Landline Phone Number
I_AddrCurDfltMobilePhoneNumber view_entity from BASIC Current Default Mobile PhoneNumber
I_Addressindependentmobile view from BASIC Core View Addr Indp Mobile
I_Addressindependentphone view from BASIC Core view for address independent phone details
I_BPAddressIndependentMobile view from BASIC Root view for AddrIndMob
I_BPAddressIndependentPhone view from BASIC Core view for address independent phone
I_BPContactMblNmbrTP view inner TRANSACTIONAL BO view for BP contact Mobile number
I_BPContactTelNmbrTP view inner TRANSACTIONAL TP View for BP Contact Person Telephone
I_BPMobilePhoneNumber view from BASIC Mobile Phone Number core view
I_BPRelshpCntctPersnMblNmbrTP view_entity inner TRANSACTIONAL BO view for Contact Person Mobile Number
I_BPRelshpCntctPersnTelNmbrTP view_entity inner TRANSACTIONAL RAP BO Contact Person Telephone Number
I_BPTelephoneNumber view from BASIC BusinessPartner Telephone Number
P_KR_BusinessPlace view left_outer COMPOSITE
R_AddressPhoneNumberTP view_entity from Phone Number - TP
R_PhoneNumberTP view_entity from TRANSACTIONAL Phone Number - TP

Fields (15)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID,AddressIDForEdit 6
KEY AddressPersonID Person 6
KEY CommMediumSequenceNumber OrdinalNumber,OrdinalNumberForEdit 10
_AddressCommunicationRemark _AddressCommunicationRemark 1
_PhoneNumberCountry _PhoneNumberCountry 2
_PhoneNumberType _PhoneNumberType 2
CommLineNotForUnsolicitedCntct CommNumberIsNotUsed 4
InternationalPhoneNumber CompleteTelephoneNumber,InternationalMobilePhoneNumber,InternationalPhoneNumber 6
PhoneAreaCodeSubscriberNumber AddressPhoneNumber,MobilePhoneNumber,PhoneNumber 11
PhoneExtensionNumber MobilePhoneNumberExtension,PhoneExtensionNumber,PhoneNumberExtension 7
PhoneIsSMSEnabled PhoneIsSMSEnabled 4
PhoneNumberCountry DestinationLocationCountry,MobilePhoneCountry,PhoneNumberCountry 10
PhoneNumberType PhoneNumberType 10
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 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.

-- Phone Number
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRESSPHONENUMBER_2 (
    ADDRESSID,
    ADDRESSPERSONID,
    COMMMEDIUMSEQUENCENUMBER,
    _ADDRESSCOMMUNICATIONREMARK,
    _PHONENUMBERCOUNTRY,
    _PHONENUMBERTYPE,
    COMMLINENOTFORUNSOLICITEDCNTCT,
    INTERNATIONALPHONENUMBER,
    PHONEAREACODESUBSCRIBERNUMBER,
    PHONEEXTENSIONNUMBER,
    PHONEISSMSENABLED,
    PHONENUMBERCOUNTRY,
    PHONENUMBERTYPE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ADDRESSID, ADDRESSPERSONID, COMMMEDIUMSEQUENCENUMBER)
);

Learn More