I_BPCONTACTTELNMBRTP

CDS View
20 Fields 1 CDS Views

TP View for BP Contact Person Telephone

I_BPCONTACTTELNMBRTP is a CDS View in S/4HANA. TP View for BP Contact Person Telephone. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BPContactTelNmbr view from CONSUMPTION C View for BP Contact Telephone number

Fields (20)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY BusinessPartner1 BusinessPartner1 1
KEY BusinessPartner2 BusinessPartner2 1
KEY OrdinalNumber OrdinalNumber 1
KEY RelationshipNumber RelationshipNumber 1
KEY ValidityEndDate ValidityEndDate 1
AddressCommunicationRemarkText AddressCommunicationRemarkText 1
AddressIDForEdit AddressIDForEdit 1
BusinessPartner1ForEdit BusinessPartner1ForEdit 1
BusinessPartner2ForEdit BusinessPartner2ForEdit 1
CommNumberIsNotUsed CommNumberIsNotUsed 1
CountryDialingCode CountryDialingCode 1
DestinationLocationCountry DestinationLocationCountry 1
IsDefaultPhoneNumber IsDefaultPhoneNumber 1
OrdinalNumberForEdit OrdinalNumberForEdit 1
PhoneNumber PhoneNumber 1
PhoneNumberExtension PhoneNumberExtension 1
PhoneNumberType PhoneNumberType 1
RelationshipNumberForEdit RelationshipNumberForEdit 1
ValidityEndDateForEdit ValidityEndDateForEdit 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.

-- TP View for BP Contact Person Telephone
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPCONTACTTELNMBRTP (
    ADDRESSID,
    BUSINESSPARTNER1,
    BUSINESSPARTNER2,
    ORDINALNUMBER,
    RELATIONSHIPNUMBER,
    VALIDITYENDDATE,
    ADDRESSCOMMUNICATIONREMARKTEXT,
    ADDRESSIDFOREDIT,
    BUSINESSPARTNER1FOREDIT,
    BUSINESSPARTNER2FOREDIT,
    COMMNUMBERISNOTUSED,
    COUNTRYDIALINGCODE,
    DESTINATIONLOCATIONCOUNTRY,
    ISDEFAULTPHONENUMBER,
    ORDINALNUMBERFOREDIT,
    PHONENUMBER,
    PHONENUMBEREXTENSION,
    PHONENUMBERTYPE,
    RELATIONSHIPNUMBERFOREDIT,
    VALIDITYENDDATEFOREDIT,
    PRIMARY KEY (ADDRESSID, BUSINESSPARTNER1, BUSINESSPARTNER2, ORDINALNUMBER, RELATIONSHIPNUMBER, VALIDITYENDDATE)
);

Learn More