I_BPEMPLOYEEWORKPLACEADDR

CDS View

Business Partner Employee Workplace address

I_BPEMPLOYEEWORKPLACEADDR is a CDS View in S/4HANA. Business Partner Employee Workplace address. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPEmplWorkplaceAddrTP view from TRANSACTIONAL Business Partner Employee Workplace address - TP

Fields (6)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
AddressID AddressID 1
AddressPersonID AddressPersonID 1
AuthorizationGroup AuthorizationGroup 1
BusinessPartnerUUID BusinessPartnerUUID 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1 
@AbapCatalog.sqlViewName: 'IWPADDRESS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: [ '_PersonWPAddr' ]
@EndUserText.label: 'Business Partner Employee Workplace address'
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: '_PersonWPAddr'

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC

@Analytics : {dataCategory: #DIMENSION, dataExtraction.enabled : true}
@Analytics.internalName:#LOCAL
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET,
                                     #EXTRACTION_DATA_SOURCE]

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL

@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true

define view I_BPEmployeeWorkplaceAddr

  as select from mom052 as BPEmployeeWorkplaceAddr

    inner join   I_BusinessPartner on I_BusinessPartner.BusinessPartnerUUID = BPEmployeeWorkplaceAddr.partner_guid

  association [1..1] to I_PersonWorkplaceAddress as _PersonWPAddr on  _PersonWPAddr.AddressID                 = BPEmployeeWorkplaceAddr.org_addr_number
                                                                  and _PersonWPAddr.AddressPersonID           = I_BusinessPartner.PersonNumber
                                                                  and _PersonWPAddr.AddressRepresentationCode = ' '
   
{

  key  BPEmployeeWorkplaceAddr.partner_guid                                                                       as BusinessPartnerUUID,
       BPEmployeeWorkplaceAddr.org_addr_number                                                                    as AddressID,
       I_BusinessPartner.PersonNumber                                                                             as AddressPersonID,
       I_BusinessPartner.BusinessPartner                                                                          as BusinessPartner,
       //Addition of validity dates

       cast ( substring( cast( BPEmployeeWorkplaceAddr.from_timestamp as abap.char( 17 ) ), 1, 8 ) as abap.dats ) as ValidityStartDate,
       cast ( substring( cast( BPEmployeeWorkplaceAddr.to_timestamp as abap.char( 17 ) ), 1, 8 ) as abap.dats )   as ValidityEndDate,


       I_BusinessPartner.AuthorizationGroup                                                                       as AuthorizationGroup,
       @Semantics.booleanIndicator: true
       I_BusinessPartner.IsBusinessPurposeCompleted                                                               as IsBusinessPurposeCompleted,
       I_BusinessPartner.DataControllerSet                                                                        as DataControllerSet,
       I_BusinessPartner.DataController1                                                                          as DataController1,
       I_BusinessPartner.DataController2                                                                          as DataController2,
       I_BusinessPartner.DataController3                                                                          as DataController3,
       I_BusinessPartner.DataController4                                                                          as DataController4,
       I_BusinessPartner.DataController5                                                                          as DataController5,
       I_BusinessPartner.DataController6                                                                          as DataController6,
       I_BusinessPartner.DataController7                                                                          as DataController7,
       I_BusinessPartner.DataController8                                                                          as DataController8,
       I_BusinessPartner.DataController9                                                                          as DataController9,
       I_BusinessPartner.DataController10                                                                         as DataController10,
       _PersonWPAddr
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"MOM052"
],
"ASSOCIATED":
[
"I_PERSONWORKPLACEADDRESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More