I_BPCONTACTTOADDRESS

CDS View
5 Fields 17 CDS Views

Business Partner Contact To Address

I_BPCONTACTTOADDRESS is a CDS View in S/4HANA. Business Partner Contact To Address. It contains 5 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
A_BPContactPersonEmlAddr view_entity from BASIC Contact Person Email Address
A_BPContactPersonFaxNmbr view_entity from BASIC Contact Person Fax Number
A_BPContactPersonMblNmbr view_entity from BASIC Contact Person Mobile Number
A_BPContactPersonTelNmbr view_entity from BASIC Contact Person Telephone Number
A_BPContactPersonWbsteURL view_entity from BASIC Contact Person Website URL
A_BPContactToAddress view from BASIC Contact Person Address
A_BPContactWorkPlaceEmailAddr view from BASIC BP Contact Work Place Email Address
A_BPContactWorkPlaceFaxNumber view from BASIC BP Contact Work Place Fax Number
A_BPContactWrkPlaceHomePageURL view from BASIC BP Contact Work Place URL Address
A_BPContactWrkPlacePhoneNumber view from BASIC BP Contact Work Place Phone Number
I_BPContactAddressTP view from TRANSACTIONAL TP View for BP Contact Person Address
I_BPContactEmlAddrTP view from TRANSACTIONAL TP View BP Contact Person Email Address
I_BPContactFaxNmbrTP view from TRANSACTIONAL BO view for BP contact Fax number
I_BPContactMblNmbrTP view from TRANSACTIONAL BO view for BP contact Mobile number
I_BPContactTelNmbrTP view from TRANSACTIONAL TP View for BP Contact Person Telephone
I_BpContactToAddressStdVH view from COMPOSITE Business Partner Contact To Address
I_BPContactWbsteURLTP view from TRANSACTIONAL BO view for BP contact Website URL

Fields (5)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID,AddressIDForEdit 14
KEY BusinessPartnerCompany BusinessPartner1,BusinessPartner1ForEdit,BusinessPartnerCompany 14
KEY BusinessPartnerPerson BusinessPartner2,BusinessPartner2ForEdit,BusinessPartnerPerson 14
KEY RelationshipNumber RelationshipNumber,RelationshipNumberForEdit 14
KEY ValidityEndDate ValidityEndDate,ValidityEndDateForEdit 14

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.

-- Business Partner Contact To Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPCONTACTTOADDRESS (
    ADDRESSID,
    BUSINESSPARTNERCOMPANY,
    BUSINESSPARTNERPERSON,
    RELATIONSHIPNUMBER,
    VALIDITYENDDATE,
    PRIMARY KEY (ADDRESSID, BUSINESSPARTNERCOMPANY, BUSINESSPARTNERPERSON, RELATIONSHIPNUMBER, VALIDITYENDDATE)
);

Learn More