I_BPEMPLWORKPLACEADDRTP

CDS View

Business Partner Employee Workplace address - TP

I_BPEMPLWORKPLACEADDRTP is a CDS View in S/4HANA. Business Partner Employee Workplace address - TP. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BPEmplWorkplaceAddr view from CONSUMPTION Business Partner Employee Workplace address 
@AbapCatalog.sqlViewName: 'IBPWPADDRTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Business Partner Employee Workplace address - TP'
@ObjectModel.writeEnabled: true
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled
@ObjectModel.semanticKey: ['BusinessPartner']
@ObjectModel.writeDraftPersistence: 'BPWPADDRESS_D'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_BPEmplWorkplaceAddrTP
  as select from I_BPEmployeeWorkplaceAddr as BPWorkPlaceAddress

  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  
{
        @Search.defaultSearchElement: true
  key   BPWorkPlaceAddress.BusinessPartner,
        BPWorkPlaceAddress.BusinessPartnerUUID,
        BPWorkPlaceAddress.AddressID,
        BPWorkPlaceAddress.AddressPersonID,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._OrganizationAddress.StreetName                        as StreetName,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._OrganizationAddress.HouseNumber                       as HouseNumber,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._OrganizationAddress.AddressTimeZone                   as AddressTimeZone,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._OrganizationAddress.CityName                          as CityName,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._OrganizationAddress.PostalCode                        as PostalCode,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._OrganizationAddress.Country                           as Country,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._OrganizationAddress.Region                            as Region,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber as InternationalPhoneNumber,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._CurrentDfltMobilePhoneNumber.InternationalPhoneNumber as InternationalMobilePhoneNumber,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._CurrentDfltFaxNumber.InternationalFaxNumber           as InternationalFaxNumber,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr._CurrentDfltEmailAddress.EmailAddress                  as EmailAddress,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr.WorkplaceBuilding                                      as WorkplaceBuilding,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr.WorkplaceFloor                                         as WorkplaceFloor,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr.WorkplaceDepartmentName                                as WorkplaceDepartmentName,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr.WorkplaceFunctionalTitleName                           as WorkplaceFunctionalTitleName,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress._PersonWPAddr.WorkplaceRoomNumber                                    as WorkplaceRoomNumber,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress.AuthorizationGroup,
        @ObjectModel.readOnly: true
        BPWorkPlaceAddress.IsBusinessPurposeCompleted,

        @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
        _BusinessPartner,
        _PersonWPAddr
        

}

Learn More