I_WORKPLACEADDRESS

CDS View
6 Fields 2 CDS Views

Employee Workplace Address

I_WORKPLACEADDRESS is a CDS View in S/4HANA. Employee Workplace Address. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_SrcgProjContactAddress view_entity from BASIC Contact Address
I_EmployeeWorkplaceAddress view from BASIC Employee Workplace Address

Fields (6)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerUUID BusinessPartnerUUID 2
Building Building 1
DefaultEmailAddress DefaultEmailAddress 1
RoomNumber RoomNumber 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Employee Workplace Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKPLACEADDRESS (
    BUSINESSPARTNERUUID,
    BUILDING,
    DEFAULTEMAILADDRESS,
    ROOMNUMBER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BUSINESSPARTNERUUID)
);

Learn More