I_BPCONTACTPERSONADDRESSPROC

CDS View
16 Fields 5 CDS Views

BP Contact Person Workplace Address

I_BPCONTACTPERSONADDRESSPROC is a CDS View in S/4HANA. BP Contact Person Workplace Address. It contains 16 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPContactPersonAddressGov view_entity from TRANSACTIONAL Base Contact Person Workplace Address
I_BPContactPersonAddressGov view_entity union_all TRANSACTIONAL Base Contact Person Workplace Address
I_BPContactPersonAddressProcTP view_entity from TRANSACTIONAL Base Cntact Persn WplcAddr Proc - TP
I_BPContactPersonAddrProcChgs view_entity from TRANSACTIONAL BP Contact Person WplcAddr Process Chgs
I_BPContactPersonAddrProcChgs view_entity union_all TRANSACTIONAL BP Contact Person WplcAddr Process Chgs

Fields (16)

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
BusinessPartner1 BusinessPartner1,BusinessPartner2 1
BusinessPartner2 BusinessPartner1,BusinessPartner2 1
BusinessPartnerAddressUUID BusinessPartnerAddressUUID 1
ContactRelationshipDepartment ContactRelationshipDepartment 1
ContactRelationshipFunction ContactRelationshipFunction 1
Floor Floor 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
PrfrdCommMediumType PrfrdCommMediumType 1
RoomNumber RoomNumber 1
StandardUsage StandardUsage 1
WorkplaceBuilding WorkplaceBuilding 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 Contact Person Workplace Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPCONTACTPERSONADDRESSPROC (
    ADDRESSNUMBER,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECT,
    MDCHGPROCESSSRCESYSTEM,
    MDCHGPROCESSSTEP,
    BUSINESSPARTNER1,
    BUSINESSPARTNER2,
    BUSINESSPARTNERADDRESSUUID,
    CONTACTRELATIONSHIPDEPARTMENT,
    CONTACTRELATIONSHIPFUNCTION,
    FLOOR,
    MDCHGPROCESSSOURCEMODIFIED,
    PRFRDCOMMMEDIUMTYPE,
    ROOMNUMBER,
    STANDARDUSAGE,
    WORKPLACEBUILDING,
    PRIMARY KEY (ADDRESSNUMBER, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP)
);

Learn More