I_EmployeeWorkplaceAddress

DDL: I_EMPLOYEEWORKPLACEADDRESS SQL: IEMPLOYEEWPADDR Type: view BASIC
19 Fields 2 Data Sources

Employee Workplace Address

I_EmployeeWorkplaceAddress is a Basic CDS View that provides data about "Employee Workplace Address" in SAP S/4HANA. It reads from 2 data sources (I_Employee, I_WorkplaceAddress) and exposes 19 fields with key field PersonnelNumber.

Data Sources (2)

SourceAliasJoin Type
I_Employee Employee inner
I_WorkplaceAddress WPAddr from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEMPLOYEEWPADDR view
EndUserText.label Employee Workplace Address view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber I_Employee PersonnelNumber Personnel No.
Employee I_Employee Employee Object ID
EmployeeInternalID I_Employee EmployeeInternalID Busn. Partner
UserID I_Employee UserID User Name
FullName I_Employee FullName Name
BusinessPartnerUUID I_WorkplaceAddress BusinessPartnerUUID UUID
AddressID AddressID Ship-to address
DestinationLocationCountry DestinationLocationCountry Country/Region
PhoneNumber PhoneNumber Telephone no.
PhoneNumberExtension PhoneNumberExtension Extension
NormalizedPhoneNumber NormalizedPhoneNumber
MblPhoneDestinationLocCountry MblPhoneDestinationLocCountry
MobilePhoneNumber MobilePhoneNumber Telephone
MblNormalizedPhoneNumber MblNormalizedPhoneNumber
DefaultEmailAddress DefaultEmailAddress
Building I_WorkplaceAddress Building Building code
RoomNumber I_WorkplaceAddress RoomNumber Room Number
ValidityStartDate I_WorkplaceAddress ValidityStartDate Validity Start Date
ValidityEndDate I_WorkplaceAddress ValidityEndDate ValidTo

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EmployeeWorkplaceAddress.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IEMPLOYEEWPADDR

CREATE VIEW I_EmployeeWorkplaceAddress AS
SELECT
  Employee.PersonnelNumber AS PersonnelNumber,
  Employee.Employee AS Employee,
  Employee.EmployeeInternalID AS EmployeeInternalID,
  Employee.UserID AS UserID,
  Employee.FullName AS FullName,
  WPAddr.BusinessPartnerUUID AS BusinessPartnerUUID,
  AddressID,
  DestinationLocationCountry,
  PhoneNumber,
  PhoneNumberExtension,
  NormalizedPhoneNumber,
  MblPhoneDestinationLocCountry,
  MobilePhoneNumber,
  MblNormalizedPhoneNumber,
  DefaultEmailAddress,
  WPAddr.Building AS Building,
  WPAddr.RoomNumber AS RoomNumber,
  WPAddr.ValidityStartDate AS ValidityStartDate,
  WPAddr.ValidityEndDate AS ValidityEndDate
FROM I_WorkplaceAddress AS WPAddr
INNER JOIN I_Employee AS Employee ON /* join condition not captured in parsed metadata */
;

Learn More