I_BPEmplWorkplaceAddrTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_BPEmployeeWorkplaceAddr | BPWorkPlaceAddress | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_BusinessPartnerTP | _BusinessPartner | $projection.BusinessPartner = _BusinessPartner.BusinessPartner |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA