I_EmployeeWorkplaceAddress

DDL: I_EMPLOYEEWORKPLACEADDRESS SQL: IEMPLOYEEWPADDR Type: view COMPOSITE Package: VDM_SHCM_EMPLOYEE
19 Fields 1 Data Sources

Employee Workplace Address

I_EmployeeWorkplaceAddress is a Composite CDS View that provides data about "Employee Workplace Address" in SAP S/4HANA. It reads from 1 data source (I_Employee_2) and exposes 19 fields with key field PersonnelNumber. Part of development package VDM_SHCM_EMPLOYEE.

Data Sources (1)

SourceAliasJoin Type
I_Employee_2 Employee inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEMPLOYEEWPADDR view
EndUserText.label Employee Workplace Address view
VDM.viewType #COMPOSITE 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_2 PersonnelNumber Personnel No.
Employee I_Employee_2 Employee Object ID
EmployeeInternalID I_Employee_2 EmployeeInternalID Busn. Partner
UserID I_Employee_2 UserID User Name
FullName I_Employee_2 FullName Name
BusinessPartnerUUID WPAddr 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 WPAddr Building Building code
RoomNumber WPAddr RoomNumber Room Number
ValidityStartDate WPAddr ValidityStartDate Validity Start Date
ValidityEndDate WPAddr 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
INNER JOIN I_Employee_2 AS Employee ON /* join condition not captured in parsed metadata */
;

Learn More