I_BUSINESSPARTNERCONTACT

CDS View
36 Fields 7 CDS Views

Business Partner Contact

I_BUSINESSPARTNERCONTACT is a CDS View in S/4HANA. Business Partner Contact. It contains 36 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_NL_SAFTBusinessPartner view left_outer CONSUMPTION SAF-T NL Business Partner
I_CustomerContact view from COMPOSITE CustomerContact
I_QuickCreateContactTP view from TRANSACTIONAL Quick create of contact person TP View
I_SrcgProjQtnPotntlSuplrCntct view_entity from COMPOSITE Potential Supplier Contact in SPQtn
I_Suppliercontact view from COMPOSITE SupplierContact
P_NL_SAFTBusinessPartnerCntct view inner COMPOSITE
P_SlsDocFlfmtSDDocContacts1 view inner CONSUMPTION

Fields (36)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerCompany BusinessPartner,BusinessPartnerCompany,BusinessPartnerForEdit 3
KEY BusinessPartnerPerson BusinessPartnerPerson,BusinessPartnerPersonForEdit,CustomerContact 4
_BusinessPartnerCompany _BusinessPartnerCompany 2
_BusinessPartnerPerson _BusinessPartnerPerson 3
_ContactPersonDepartment _ContactPersonDepartment 2
_ContactPersonFunction _ContactPersonFunction 2
_StandardAddress _StandardAddress 1
AddressID AddressID 1
AuthorizationGroup AuthorizationGroup 3
BusinessPartnerName BusinessPartnerName 2
ContactPersonDepartment ContactPersonDepartment 3
ContactPersonFunction ContactPersonFunction 4
EmailAddress EmailAddress 4
FaxCountry FaxCountry 2
FaxNumber FaxNumber 2
FaxNumberExtension FaxNumberExtension 2
FirstName FirstName 3
FormOfAddress FormOfAddress 1
InternationalFaxNumber InternationalFaxNumber 2
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 2
InternationalPhoneNumber InternationalPhoneNumber 3
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
IsDefaultAddress IsDefaultAddress 1
IsStandardRelationship IsStandardRelationship 2
LastName LastName 3
MobilePhoneCountry MobilePhoneCountry 2
MobilePhoneNumber MobilePhoneNumber 2
MobilePhoneNumberExtension MobilePhoneNumberExtension 2
PartnerUUID PartnerUUID 2
PersonUUID PersonUUID 3
PhoneNumber PhoneNumber 3
PhoneNumberCountry PhoneNumberCountry 3
PhoneNumberExtension PhoneNumberExtension 3
RelationshipNumber RelationshipNumber,RelationshipNumberForEdit 3
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERCONTACT (
    BUSINESSPARTNERCOMPANY,
    BUSINESSPARTNERPERSON,
    _BUSINESSPARTNERCOMPANY,
    _BUSINESSPARTNERPERSON,
    _CONTACTPERSONDEPARTMENT,
    _CONTACTPERSONFUNCTION,
    _STANDARDADDRESS,
    ADDRESSID,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNERNAME,
    CONTACTPERSONDEPARTMENT,
    CONTACTPERSONFUNCTION,
    EMAILADDRESS,
    FAXCOUNTRY,
    FAXNUMBER,
    FAXNUMBEREXTENSION,
    FIRSTNAME,
    FORMOFADDRESS,
    INTERNATIONALFAXNUMBER,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    ISBUSINESSPURPOSECOMPLETED,
    ISDEFAULTADDRESS,
    ISSTANDARDRELATIONSHIP,
    LASTNAME,
    MOBILEPHONECOUNTRY,
    MOBILEPHONENUMBER,
    MOBILEPHONENUMBEREXTENSION,
    PARTNERUUID,
    PERSONUUID,
    PHONENUMBER,
    PHONENUMBERCOUNTRY,
    PHONENUMBEREXTENSION,
    RELATIONSHIPNUMBER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BUSINESSPARTNERCOMPANY, BUSINESSPARTNERPERSON)
);

Learn More