R_WorkAssignmentAddressTP_3
Work Assignment Address Details
R_WorkAssignmentAddressTP_3 is a Transactional CDS View that provides data about "Work Assignment Address Details" in SAP S/4HANA. It reads from 2 data sources (R_WorkAssignmentAddress, I_BusinessPartner) and exposes 43 fields with key fields WorkforcePersonExternalID, WorkAssignmentExternalID, Country2DigitISOCode, AddressNumber. It has 2 associations to related views. Part of development package WFD_INT_RAP_ODATA.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| R_WorkAssignmentAddress | _Address | from |
| I_BusinessPartner | _BP | inner |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_BPProtectedAddress | _BPProtectedAddress | $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner and $projection.AddressNumber = _BPProtectedAddress.AddressID |
| [1..1] | R_WorkforcePersonTP_3 | _WorkforcePerson | _WorkforcePerson.WorkforcePersonExternalID = $projection.WorkforcePersonExternalID |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Work Assignment Address Details | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| AccessControl.personalData.blocking | #REQUIRED | view |
Fields (43)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | WorkforcePersonExternalID | R_WorkAssignmentAddress | WorkforcePersonExternalID | |
| KEY | WorkAssignmentExternalID | R_WorkAssignmentAddress | WorkAssignmentExternalID | |
| KEY | Country2DigitISOCode | R_WorkAssignmentAddress | Country2DigitISOCode | |
| KEY | AddressNumber | R_WorkAssignmentAddress | AddressNumber | |
| WorkAssignmentStartDate | R_WorkAssignmentAddress | WorkAssignmentStartDate | ||
| BusinessPartner | R_WorkAssignmentAddress | BusinessPartner | ||
| WorkAssignmentEndDate | R_WorkAssignmentAddress | WorkAssignmentEndDate | ||
| Country | R_WorkAssignmentAddress | Country | ||
| PostalCode | R_WorkAssignmentAddress | PostalCode | ||
| Region | R_WorkAssignmentAddress | Region | ||
| SecondaryRegion | R_WorkAssignmentAddress | SecondaryRegion | ||
| SecondaryRegionName | R_WorkAssignmentAddress | SecondaryRegionName | ||
| TertiaryRegion | R_WorkAssignmentAddress | TertiaryRegion | ||
| TertiaryRegionName | R_WorkAssignmentAddress | TertiaryRegionName | ||
| CityName | R_WorkAssignmentAddress | CityName | ||
| DistrictName | R_WorkAssignmentAddress | DistrictName | ||
| StreetPrefixName1 | R_WorkAssignmentAddress | StreetPrefixName1 | ||
| StreetPrefixName2 | R_WorkAssignmentAddress | StreetPrefixName2 | ||
| StreetName | R_WorkAssignmentAddress | StreetName | ||
| StreetSuffixName1 | R_WorkAssignmentAddress | StreetSuffixName1 | ||
| StreetSuffixName2 | R_WorkAssignmentAddress | StreetSuffixName2 | ||
| HouseNumber | R_WorkAssignmentAddress | HouseNumber | ||
| HouseNumberSupplementText | R_WorkAssignmentAddress | HouseNumberSupplementText | ||
| Floor | R_WorkAssignmentAddress | Floor | ||
| RoomNumber | R_WorkAssignmentAddress | RoomNumber | ||
| CareOfName | R_WorkAssignmentAddress | CareOfName | ||
| IsBlocked | R_WorkAssignmentAddress | IsBlocked | ||
| IsBusinessPurposeCompleted | I_BusinessPartner | IsBusinessPurposeCompleted | ||
| DataControllerSet | I_BusinessPartner | DataControllerSet | ||
| DataController1 | I_BusinessPartner | DataController1 | ||
| DataController2 | I_BusinessPartner | DataController2 | ||
| DataController3 | I_BusinessPartner | DataController3 | ||
| DataController4 | I_BusinessPartner | DataController4 | ||
| DataController5 | I_BusinessPartner | DataController5 | ||
| DataController6 | I_BusinessPartner | DataController6 | ||
| DataController7 | I_BusinessPartner | DataController7 | ||
| DataController8 | I_BusinessPartner | DataController8 | ||
| DataController9 | I_BusinessPartner | DataController9 | ||
| DataController10 | I_BusinessPartner | DataController10 | ||
| AuthorizationGroup | I_BusinessPartner | AuthorizationGroup | ||
| BPAddressIsProtected | _BPProtectedAddress | BPAddressIsProtected | ||
| _WorkAssignment | _WorkAssignment | |||
| _WorkforcePerson | _WorkforcePerson |
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Assignment Address Details'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #XL,
dataClass: #TRANSACTIONAL
}
@AccessControl.personalData.blocking: #REQUIRED
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]
define view entity R_WorkAssignmentAddressTP_3
as select from R_WorkAssignmentAddress as _Address
inner join I_BusinessPartner as _BP on _BP.BusinessPartner = _Address.BusinessPartner
association [0..1] to I_BPProtectedAddress as _BPProtectedAddress on $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner
and $projection.AddressNumber = _BPProtectedAddress.AddressID
association to parent R_WorkAssignmentTP_3 as _WorkAssignment on $projection.WorkAssignmentExternalID = _WorkAssignment.WorkAssignmentExternalID
and $projection.Country2DigitISOCode = _WorkAssignment.Country2DigitISOCode
and $projection.WorkforcePersonExternalID = _WorkAssignment.WorkforcePersonExternalID
association [1..1] to R_WorkforcePersonTP_3 as _WorkforcePerson on _WorkforcePerson.WorkforcePersonExternalID = $projection.WorkforcePersonExternalID
{
key _Address.WorkforcePersonExternalID,
key _Address.WorkAssignmentExternalID,
key _Address.Country2DigitISOCode,
key _Address.AddressNumber,
_Address.WorkAssignmentStartDate,
_Address.BusinessPartner,
_Address.WorkAssignmentEndDate,
_Address.Country,
_Address.PostalCode,
_Address.Region,
_Address.SecondaryRegion,
_Address.SecondaryRegionName,
_Address.TertiaryRegion,
_Address.TertiaryRegionName,
_Address.CityName,
_Address.DistrictName,
_Address.StreetPrefixName1,
_Address.StreetPrefixName2,
_Address.StreetName,
_Address.StreetSuffixName1,
_Address.StreetSuffixName2,
_Address.HouseNumber,
_Address.HouseNumberSupplementText,
_Address.Floor,
_Address.RoomNumber,
_Address.CareOfName,
_Address.IsBlocked,
@Semantics.booleanIndicator: true
_BP.IsBusinessPurposeCompleted,
_BP.DataControllerSet,
_BP.DataController1,
_BP.DataController2,
_BP.DataController3,
_BP.DataController4,
_BP.DataController5,
_BP.DataController6,
_BP.DataController7,
_BP.DataController8,
_BP.DataController9,
_BP.DataController10,
_BP.AuthorizationGroup,
_BPProtectedAddress.BPAddressIsProtected,
/* Associations */
// _BPProtectedAddress,
_WorkAssignment,
_WorkforcePerson
}
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