I_ADDRESSWORKPLACEDETAILS

CDS View

Person Workplace Address Details

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

Used by 2 CDS view(s) 11 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PersonAddress view_entity from COMPOSITE Address of a Person
I_PersonWorkplaceAddress view_entity from COMPOSITE Corporate Workplace Address of a Person

Fields (11)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 2
KEY AddressPersonID AddressPersonID 2
KEY AddressRepresentationCode AddressRepresentationCode 2
WorkplaceBuilding WorkplaceBuilding 1
WorkplaceCorrespncShortName WorkplaceCorrespncShortName 1
WorkplaceDepartmentName WorkplaceDepartmentName 1
WorkplaceFloor WorkplaceFloor 1
WorkplaceFunctionalTitleName WorkplaceFunctionalTitleName 1
WorkplaceInhouseMail WorkplaceInhouseMail 1
WorkplacePrfrdCommMediumType WorkplacePrfrdCommMediumType 1
WorkplaceRoomNumber WorkplaceRoomNumber 1 
@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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADCP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More