I_BPEmplWorkplaceAddrTP

DDL: I_BPEMPLWORKPLACEADDRTP SQL: IBPWPADDRTP Type: view TRANSACTIONAL

Business Partner Employee Workplace address - TP

I_BPEmplWorkplaceAddrTP is a Transactional CDS View that provides data about "Business Partner Employee Workplace address - TP" in SAP S/4HANA. It reads from 1 data source (I_BPEmployeeWorkplaceAddr) and exposes 24 fields with key field BusinessPartner. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPEmployeeWorkplaceAddr BPWorkPlaceAddress from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBPWPADDRTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Business Partner Employee Workplace address - TP view
ObjectModel.writeEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence BPWPADDRESS_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPEmployeeWorkplaceAddr BusinessPartner
BusinessPartnerUUID I_BPEmployeeWorkplaceAddr BusinessPartnerUUID
AddressID I_BPEmployeeWorkplaceAddr AddressID
AddressPersonID I_BPEmployeeWorkplaceAddr AddressPersonID
StreetName
HouseNumber
AddressTimeZone
CityName
PostalCode
Country
Region
InternationalPhoneNumber
InternationalMobilePhoneNumber
InternationalFaxNumber
EmailAddress
WorkplaceBuilding
WorkplaceFloor
WorkplaceDepartmentName
WorkplaceFunctionalTitleName
WorkplaceRoomNumber
AuthorizationGroup I_BPEmployeeWorkplaceAddr AuthorizationGroup
IsBusinessPurposeCompleted I_BPEmployeeWorkplaceAddr IsBusinessPurposeCompleted
_BusinessPartner _BusinessPartner
_PersonWPAddr _PersonWPAddr
@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
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
        

}