I_BPCONTACTTOADDRESS

CDS View
5 Fields 12 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. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
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 9
KEY BusinessPartnerCompany BusinessPartner1,BusinessPartner1ForEdit,BusinessPartnerCompany 9
KEY BusinessPartnerPerson BusinessPartner2,BusinessPartner2ForEdit,BusinessPartnerPerson 9
KEY RelationshipNumber RelationshipNumber,RelationshipNumberForEdit 9
KEY ValidityEndDate ValidityEndDate,ValidityEndDateForEdit 9

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