I_BPCONTACTADDRESSTP

CDS View
29 Fields 1 CDS Views

TP View for BP Contact Person Address

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BPContactAddress view from CONSUMPTION C View for BP Contact Address

Fields (29)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY BusinessPartner1 BusinessPartner1 1
KEY BusinessPartner2 BusinessPartner2 1
KEY RelationshipNumber RelationshipNumber 1
KEY ValidityEndDate ValidityEndDate 1
AddressIDForEdit AddressIDForEdit 1
AddressTimeZone AddressTimeZone 1
Building Building 1
BusinessPartner1ForEdit BusinessPartner1ForEdit 1
BusinessPartner2ForEdit BusinessPartner2ForEdit 1
CityName CityName 1
ContactRelationshipDepartment ContactRelationshipDepartment 1
ContactRelationshipFunction ContactRelationshipFunction 1
CorrespondenceShortName CorrespondenceShortName 1
Country Country 1
Floor Floor 1
FormattedAddress FormattedAddress 1
FormOfAddress FormOfAddress 1
FullName FullName 1
HouseNumber HouseNumber 1
InhouseMail InhouseMail 1
IsDefaultAddress IsDefaultAddress 1
PostalCode PostalCode 1
PrfrdCommMediumType PrfrdCommMediumType 1
Region Region 1
RelationshipNumberForEdit RelationshipNumberForEdit 1
RoomNumber RoomNumber 1
StreetName StreetName 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 Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPCONTACTADDRESSTP (
    ADDRESSID,
    BUSINESSPARTNER1,
    BUSINESSPARTNER2,
    RELATIONSHIPNUMBER,
    VALIDITYENDDATE,
    ADDRESSIDFOREDIT,
    ADDRESSTIMEZONE,
    BUILDING,
    BUSINESSPARTNER1FOREDIT,
    BUSINESSPARTNER2FOREDIT,
    CITYNAME,
    CONTACTRELATIONSHIPDEPARTMENT,
    CONTACTRELATIONSHIPFUNCTION,
    CORRESPONDENCESHORTNAME,
    COUNTRY,
    FLOOR,
    FORMATTEDADDRESS,
    FORMOFADDRESS,
    FULLNAME,
    HOUSENUMBER,
    INHOUSEMAIL,
    ISDEFAULTADDRESS,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    RELATIONSHIPNUMBERFOREDIT,
    ROOMNUMBER,
    STREETNAME,
    VALIDITYENDDATEFOREDIT,
    PRIMARY KEY (ADDRESSID, BUSINESSPARTNER1, BUSINESSPARTNER2, RELATIONSHIPNUMBER, VALIDITYENDDATE)
);

Learn More