I_BPCONTACTPERSONFAXNUMBERPROC

CDS View

Workplace Address Fax Number

I_BPCONTACTPERSONFAXNUMBERPROC is a CDS View in S/4HANA. Workplace Address Fax Number. It contains 17 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPCntctPersnFaxNmbrProcChgs view_entity from TRANSACTIONAL CntctPrsn WrkplceAddr FaxNmbr Proc Chngs
I_BPCntctPersnFaxNmbrProcChgs view_entity union_all TRANSACTIONAL CntctPrsn WrkplceAddr FaxNmbr Proc Chngs
I_BPCntctPersnFaxNumberProcTP view_entity from TRANSACTIONAL BP Wrkplace Addr Fax Number Proc Data - TP
I_BPContactPersonFaxNumberGov view_entity from TRANSACTIONAL Base Union for Workplace Fax Number
I_BPContactPersonFaxNumberGov view_entity union_all TRANSACTIONAL Base Union for Workplace Fax Number

Fields (17)

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
AddressFaxNumber AddressFaxNumber 1
CommNumberIsNotUsed CommNumberIsNotUsed 1
FaxCountry FaxCountry 1
FaxNumberExtension FaxNumberExtension 1
InternationalFaxNumber InternationalFaxNumber 1
IsDefaultFaxNumber IsDefaultFaxNumber 1
MDChgProcessSourceModified MDChgProcessSourceModified 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 Fax Number
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPCONTACTPERSONFAXNUMBERPROC (
    ADDRESSNUMBER,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECT,
    MDCHGPROCESSSRCESYSTEM,
    MDCHGPROCESSSTEP,
    ORDINALNUMBER,
    _BPRELPROCESS,
    _WORKPLACEADDRESS,
    ADDRESSFAXNUMBER,
    COMMNUMBERISNOTUSED,
    FAXCOUNTRY,
    FAXNUMBEREXTENSION,
    INTERNATIONALFAXNUMBER,
    ISDEFAULTFAXNUMBER,
    MDCHGPROCESSSOURCEMODIFIED,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (ADDRESSNUMBER, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP, ORDINALNUMBER)
);