I_BPCNTCTPERSNWEBSITEURLPROC

CDS View

BP Workplace Website URL Process

I_BPCNTCTPERSNWEBSITEURLPROC is a CDS View in S/4HANA. BP Workplace Website URL Process. It contains 15 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPCntctPersnWbsteURLProcChgs view_entity from TRANSACTIONAL BP Contact Person Workplace Address Website Process Changes
I_BPCntctPersnWbsteURLProcChgs view_entity union_all TRANSACTIONAL BP Contact Person Workplace Address Website Process Changes
I_BPCntctPersnWebsiteURLProcTP view_entity from TRANSACTIONAL Business Partner Workplace Website Proc - TP
I_BPContactPersonWebsiteURLGov view_entity from TRANSACTIONAL Base Union WplcAddr Websites
I_BPContactPersonWebsiteURLGov view_entity union_all TRANSACTIONAL Base Union WplcAddr Websites

Fields (15)

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
IsDefaultURLAddress IsDefaultURLAddress 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
SearchURLAddress SearchURLAddress 1
UniformResourceIdentifierType UniformResourceIdentifierType 1
URLFieldLength URLFieldLength 1
WebsiteURL WebsiteURL 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.

-- BP Workplace Website URL Process
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPCNTCTPERSNWEBSITEURLPROC (
    ADDRESSNUMBER,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECT,
    MDCHGPROCESSSRCESYSTEM,
    MDCHGPROCESSSTEP,
    ORDINALNUMBER,
    _BPRELPROCESS,
    _WORKPLACEADDRESS,
    COMMNUMBERISNOTUSED,
    ISDEFAULTURLADDRESS,
    MDCHGPROCESSSOURCEMODIFIED,
    SEARCHURLADDRESS,
    UNIFORMRESOURCEIDENTIFIERTYPE,
    URLFIELDLENGTH,
    WEBSITEURL,
    PRIMARY KEY (ADDRESSNUMBER, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP, ORDINALNUMBER)
);