I_BPCNTCTPERSNMBLNUMBERPROC

CDS View
18 Fields 5 CDS Views

Workplace Address Mobile Number

I_BPCNTCTPERSNMBLNUMBERPROC is a CDS View in S/4HANA. Workplace Address Mobile Number. It contains 18 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPCntctPersnMblNmbrProcChgs view_entity from TRANSACTIONAL BP Contact Person Workplace Addr Mobile Phone Proc Changes
I_BPCntctPersnMblNmbrProcChgs view_entity union_all TRANSACTIONAL BP Contact Person Workplace Addr Mobile Phone Proc Changes
I_BPCntctPersnMblNumberProcTP view_entity from TRANSACTIONAL Workplace Addr Mobile Nmber Proc - TP
I_BPContactPersonMblNumberGov view_entity from TRANSACTIONAL Base Union for Workplace Mbl Number
I_BPContactPersonMblNumberGov view_entity union_all TRANSACTIONAL Base Union for Workplace Mbl Number

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 2
KEY MasterDataChangeProcess MasterDataChangeProcess 2
KEY MDChgProcessSrceObject MDChgProcessSrceObject 2
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 2
KEY MDChgProcessStep MDChgProcessStep 2
KEY OrdinalNumber OrdinalNumber 2
_BPRelProcess _BPRelProcess 1
_WorkplaceAddress _WorkplaceAddress 1
CommNumberIsNotUsed CommNumberIsNotUsed 1
CompleteTelephoneNumber InternationalPhoneNumber 1
IsDefaultPhoneNumber IsDefaultPhoneNumber 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
MobilePhoneCountry DestinationLocationCountry 1
MobilePhoneNumber PhoneNumber 1
PhoneIsSMSEnabled PhoneIsSMSEnabled 1
PhoneNumberType PhoneNumberType 1
ValidityEndDateTime ValidityEndDateTime 1
ValidityStartDateTime ValidityStartDateTime 1

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.

-- Workplace Address Mobile Number
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPCNTCTPERSNMBLNUMBERPROC (
    ADDRESSNUMBER,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECT,
    MDCHGPROCESSSRCESYSTEM,
    MDCHGPROCESSSTEP,
    ORDINALNUMBER,
    _BPRELPROCESS,
    _WORKPLACEADDRESS,
    COMMNUMBERISNOTUSED,
    COMPLETETELEPHONENUMBER,
    ISDEFAULTPHONENUMBER,
    MDCHGPROCESSSOURCEMODIFIED,
    MOBILEPHONECOUNTRY,
    MOBILEPHONENUMBER,
    PHONEISSMSENABLED,
    PHONENUMBERTYPE,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (ADDRESSNUMBER, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP, ORDINALNUMBER)
);

Learn More