I_ADDRESSWORKPLACEDETAILS

CDS View

Person Workplace Address Details

I_ADDRESSWORKPLACEDETAILS is a CDS View in S/4HANA. Person Workplace Address Details. It contains 12 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 12 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PersonAddress view_entity from COMPOSITE Address of a Person
I_PersonWorkplaceAddress view_entity from COMPOSITE Corporate Workplace Address of a Person
I_PostalWorkplaceAddress view_entity from BASIC Person Address type from ADRC & ADCP

Fields (12)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 3
KEY AddressPersonID AddressPersonID 3
KEY AddressRepresentationCode AddressRepresentationCode 3
PersonAddressObjectType PersonAddressObjectType 1
WorkplaceBuilding WorkplaceBuilding 2
WorkplaceCorrespncShortName WorkplaceCorrespncShortName 2
WorkplaceDepartmentName WorkplaceDepartmentName 2
WorkplaceFloor WorkplaceFloor 2
WorkplaceFunctionalTitleName WorkplaceFunctionalTitleName 2
WorkplaceInhouseMail WorkplaceInhouseMail 2
WorkplacePrfrdCommMediumType WorkplacePrfrdCommMediumType 2
WorkplaceRoomNumber WorkplaceRoomNumber 2 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Person Workplace Address Details'
//@Metadata.allowExtensions: true

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
//@ObjectModel.representativeKey: 'AddressPersonID'

@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}

define view entity I_AddressWorkplaceDetails as select from adcp
{
  key addrnumber as AddressID,
  key persnumber as AddressPersonID,
  key nation     as AddressRepresentationCode,
      case comp_pers
         when 'C' then cast('X' as ad_isworkplaceaddress preserving type )
         else cast(' ' as ad_isworkplaceaddress preserving type )
      end        as AddressIsWorkplaceAddress,
      comp_pers  as PersonAddressObjectType,
      building   as WorkplaceBuilding,
      floor      as WorkplaceFloor,
      roomnumber as WorkplaceRoomNumber,
      function   as WorkplaceFunctionalTitleName,
      department as WorkplaceDepartmentName,
      deflt_comm as WorkplacePrfrdCommMediumType,
      id_code    as WorkplaceCorrespncShortName,
      ih_mail    as WorkplaceInhouseMail
}
where date_from = '00010101'

Learn More