I_AddressWorkplaceDetails

DDL: I_ADDRESSWORKPLACEDETAILS Type: view_entity BASIC

Person Workplace Address Details

I_AddressWorkplaceDetails is a Basic CDS View that provides data about "Person Workplace Address Details" in SAP S/4HANA. It reads from 1 data source (adcp) and exposes 12 fields with key fields AddressID, AddressPersonID, AddressRepresentationCode.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
adcp adcp from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Person Workplace Address Details view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY AddressID addrnumber
KEY AddressPersonID persnumber
KEY AddressRepresentationCode nation
PersonAddressObjectType comp_pers
WorkplaceBuilding building
WorkplaceFloor floor
WorkplaceRoomNumber roomnumber
WorkplaceFunctionalTitleName function
WorkplaceDepartmentName department
WorkplacePrfrdCommMediumType deflt_comm
WorkplaceCorrespncShortName id_code
WorkplaceInhouseMail ih_mail 
@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