I_BUSPARTPHONENUMBERSPROC

CDS View
18 Fields 2 CDS Views

Core View: Bus Part All Phones (Process)

I_BUSPARTPHONENUMBERSPROC is a CDS View in S/4HANA. Core View: Bus Part All Phones (Process). It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BusPartMobileNumberProc view from BASIC Core View: Bus Part Mobile (Process)
I_BusPartTelephoneNumberProc view from BASIC Core View: Bus Part Telephone (Process)

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
AddrCommunicationValidFromDate AddrCommunicationValidFromDate 2
CommNumberIsNotUsed CommNumberIsNotUsed 2
DestinationLocationCountry DestinationLocationCountry,MobilePhoneCountry 2
InternationalPhoneNumber CompleteTelephoneNumber,InternationalPhoneNumber 2
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary 2
MDChgProcessSourceModified MDChgProcessSourceModified 2
PhoneIsSMSEnabled PhoneIsSMSEnabled 2
PhoneNumber MobilePhoneNumber,PhoneNumber 2
PhoneNumberExtension PhoneNumberExtension 1
PhoneNumberType PhoneNumberType 2
ValidityEndDateTime ValidityEndDateTime 2
ValidityStartDateTime ValidityStartDateTime 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.

-- Core View: Bus Part All Phones (Process)
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSPARTPHONENUMBERSPROC (
    ADDRESSNUMBER,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECT,
    MDCHGPROCESSSRCESYSTEM,
    MDCHGPROCESSSTEP,
    ORDINALNUMBER,
    ADDRCOMMUNICATIONVALIDFROMDATE,
    COMMNUMBERISNOTUSED,
    DESTINATIONLOCATIONCOUNTRY,
    INTERNATIONALPHONENUMBER,
    MDCHGPROCESSSOURCEMODIFBINARY,
    MDCHGPROCESSSOURCEMODIFIED,
    PHONEISSMSENABLED,
    PHONENUMBER,
    PHONENUMBEREXTENSION,
    PHONENUMBERTYPE,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (ADDRESSNUMBER, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP, ORDINALNUMBER)
);

Learn More