I_BPMOBILEPHONENUMBER

CDS View

Mobile Phone Number core view

I_BPMOBILEPHONENUMBER is a CDS View in S/4HANA. Mobile Phone Number core view. It contains 8 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPAddlCustMblPhNumberTP view from TRANSACTIONAL BO view for Mob Ph of MLTAS Customers
I_BPAddlSuplrMblPhNumberTP view from TRANSACTIONAL BO view for Mobile nos of MLTAS Suppliers
I_BPMobilePhoneNumberTP view from TRANSACTIONAL BP Mobile Phone number BO view
I_BusPartMobileNumberGov view union_all BASIC BP Governance Telephone Number
I_BusPartMobilePhoneNumberTP_2 view_entity from TRANSACTIONAL Transactional View for BP Mobile Number

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 3
KEY BusinessPartner BusinessPartner 1
KEY OrdinalNumber OrdinalNumber 3
KEY Person Person 3
IsDefaultPhoneNumber IsDefaultPhoneNumber 3
MobilePhoneCountry MobilePhoneCountry 3
MobilePhoneNumber MobilePhoneNumber 3
PhoneNumberType PhoneNumberType 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.

-- Mobile Phone Number core view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPMOBILEPHONENUMBER (
    ADDRESSID,
    BUSINESSPARTNER,
    ORDINALNUMBER,
    PERSON,
    ISDEFAULTPHONENUMBER,
    MOBILEPHONECOUNTRY,
    MOBILEPHONENUMBER,
    PHONENUMBERTYPE,
    PRIMARY KEY (ADDRESSID, BUSINESSPARTNER, ORDINALNUMBER, PERSON)
);