I_BPCONTACTTOFUNCANDDEPT

CDS View
13 Fields 8 CDS Views

BP Contact To Function and Department

I_BPCONTACTTOFUNCANDDEPT is a CDS View in S/4HANA. BP Contact To Function and Department. It contains 13 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
A_BPContactToFuncAndDept view from BASIC Function and Department
I_BPContactPersonVH view from COMPOSITE Value help for BP contact person
I_SrvcMgmtContactPersonVH view from COMPOSITE Value help for Contact Person
P_BPConToFuncAndDeptUnion view from Business Partner Contact To function and Department
P_BPConToFuncAndDeptUnion view union_all Business Partner Contact To function and Department
P_BPGovContactPersonList view_entity union_all BASIC Base list for all Contact Persons of BP
P_CPBUPAEMAILALL view union CONSUMPTION Business Partner Emails from all sources
P_Cpbupafaxall view from CONSUMPTION Business Partner Emails from all sources

Fields (13)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerCompany BusinessPartner 4
KEY BusinessPartnerPerson ContactPerson,ContactPersonBusinessPartnerId 4
_BusinessPartnerCompany _BusinessPartnerCompany 2
_BusinessPartnerPerson _BusinessPartnerPerson 2
BPContactPersonFunction ContactPersonFunction 1
ContactPersonAuthorityType ContactPersonAuthorityType 1
ContactPersonDepartment ContactPersonDepartment 1
ContactPersonRemarkText ContactPersonRemarkText 1
ContactPersonVIPType ContactPersonVIPType 1
EmailAddress EmailAddress 2
PhoneNumber PhoneNumber 2
PhoneNumberExtension PhoneNumberExtension 2
RelationshipCategory RelationshipCategory 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 To Function and Department
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPCONTACTTOFUNCANDDEPT (
    BUSINESSPARTNERCOMPANY,
    BUSINESSPARTNERPERSON,
    _BUSINESSPARTNERCOMPANY,
    _BUSINESSPARTNERPERSON,
    BPCONTACTPERSONFUNCTION,
    CONTACTPERSONAUTHORITYTYPE,
    CONTACTPERSONDEPARTMENT,
    CONTACTPERSONREMARKTEXT,
    CONTACTPERSONVIPTYPE,
    EMAILADDRESS,
    PHONENUMBER,
    PHONENUMBEREXTENSION,
    RELATIONSHIPCATEGORY,
    PRIMARY KEY (BUSINESSPARTNERCOMPANY, BUSINESSPARTNERPERSON)
);

Learn More