I_WorkAssignmentAddress
Work Assignment Address Details
I_WorkAssignmentAddress is a Composite CDS View that provides data about "Work Assignment Address Details" in SAP S/4HANA. It reads from 3 data sources (I_WorkAssignmentKeyMapping, I_WorkAssignmentBP, I_BusPartAddress) and exposes 44 fields with key fields WorkAssignmentExternalID, Country2DigitISOCode, AddressNumber. It has 4 associations to related views. Part of development package VDM_WFD_WORK_FORCE.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| I_WorkAssignmentKeyMapping | _Assignment | from |
| I_WorkAssignmentBP | _AssignmentBP | inner |
| I_BusPartAddress | _EmploymentAddress | inner |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_BPProtectedAddress | _BPProtectedAddress | $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner and $projection.AddressNumber = _BPProtectedAddress.AddressID |
| [0..1] | I_WorkAssignment_1 | _WorkAssignment | _WorkAssignment.WorkAssignmentExternalID = $projection.WorkAssignmentExternalID and _WorkAssignment.Country2DigitISOCode = $projection.Country2DigitISOCode |
| [1..1] | I_BusinessPartner | _BP | _BP.BusinessPartner = _EmploymentAddress.BusinessPartner |
| [1] | I_WorkforcePerson_1 | _WorkforcePerson | _WorkforcePerson.WorkforcePersonExternalID = $projection.WorkforcePersonExternalID |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| VDM.viewType | #COMPOSITE | view | |
| EndUserText.label | Work Assignment Address Details | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.modelingPattern | #NONE | view |
Fields (44)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | WorkAssignmentExternalID | I_WorkAssignmentKeyMapping | WorkAssignmentExternalID | |
| KEY | Country2DigitISOCode | I_WorkAssignmentKeyMapping | Country2DigitISOCode | |
| KEY | AddressNumber | I_BusPartAddress | AddressID | |
| WorkforcePersonExternalID | I_WorkAssignmentBP | WorkforcePersonExternalID | ||
| BusinessPartner | I_WorkAssignmentBP | BusinessPartner | ||
| clientNULLasvdm_v_start_dateasStartDate | ||||
| clientNULLasvdm_v_end_dateasEndDate | ||||
| Country | ||||
| PostalCode | ||||
| Region | ||||
| SecondaryRegion | ||||
| SecondaryRegionName | ||||
| TertiaryRegion | ||||
| TertiaryRegionName | ||||
| CityName | ||||
| DistrictName | ||||
| StreetPrefixName1 | ||||
| StreetPrefixName2 | ||||
| StreetName | ||||
| StreetSuffixName1 | ||||
| StreetSuffixName2 | ||||
| HouseNumber | ||||
| HouseNumberSupplementText | ||||
| Floor | ||||
| RoomNumber | ||||
| CareOfName | ||||
| POBoxPostalCode | ||||
| IsBlocked | I_WorkAssignmentKeyMapping | IsBlocked | ||
| IsBusinessPurposeCompleted | _BP | IsBusinessPurposeCompleted | ||
| DataControllerSet | _BP | DataControllerSet | ||
| DataController1 | _BP | DataController1 | ||
| DataController2 | _BP | DataController2 | ||
| DataController3 | _BP | DataController3 | ||
| DataController4 | _BP | DataController4 | ||
| DataController5 | _BP | DataController5 | ||
| DataController6 | _BP | DataController6 | ||
| DataController7 | _BP | DataController7 | ||
| DataController8 | _BP | DataController8 | ||
| DataController9 | _BP | DataController9 | ||
| DataController10 | _BP | DataController10 | ||
| AuthorizationGroup | _BP | AuthorizationGroup | ||
| _BPProtectedAddress | _BPProtectedAddress | |||
| _WorkAssignment | _WorkAssignment | |||
| _WorkforcePerson | _WorkforcePerson |
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Work Assignment Address Details'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #XL,
dataClass: #MIXED
}
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern:#NONE
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]
define view entity I_WorkAssignmentAddress
as select from I_WorkAssignmentKeyMapping as _Assignment
inner join I_WorkAssignmentBP as _AssignmentBP on _AssignmentBP.WorkAssignment = _Assignment.WorkAssignment
inner join I_BusPartAddress as _EmploymentAddress on _EmploymentAddress.BusinessPartner = _AssignmentBP.WorkAssignmentBusinessPartner
association [0..1] to I_BPProtectedAddress as _BPProtectedAddress on $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner
and $projection.AddressNumber = _BPProtectedAddress.AddressID
association [0..1] to I_WorkAssignment_1 as _WorkAssignment on _WorkAssignment.WorkAssignmentExternalID = $projection.WorkAssignmentExternalID
and _WorkAssignment.Country2DigitISOCode = $projection.Country2DigitISOCode
association [1..1] to I_BusinessPartner as _BP on _BP.BusinessPartner = _EmploymentAddress.BusinessPartner
association [1] to I_WorkforcePerson_1 as _WorkforcePerson on _WorkforcePerson.WorkforcePersonExternalID = $projection.WorkforcePersonExternalID
{
key _Assignment.WorkAssignmentExternalID,
key _Assignment.Country2DigitISOCode,
key _EmploymentAddress.AddressID as AddressNumber,
_AssignmentBP.WorkforcePersonExternalID,
_AssignmentBP.BusinessPartner,
cast (tstmp_to_dats( _EmploymentAddress.ValidityStartDate,
abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as vdm_v_start_date) as StartDate,
cast (tstmp_to_dats( _EmploymentAddress.ValidityEndDate,
abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as vdm_v_end_date) as EndDate,
_EmploymentAddress._AddressDefaultRepresentation.Country,
_EmploymentAddress._AddressDefaultRepresentation.PostalCode,
_EmploymentAddress._AddressDefaultRepresentation.Region,
_EmploymentAddress._AddressDefaultRepresentation.SecondaryRegion,
_EmploymentAddress._AddressDefaultRepresentation.SecondaryRegionName,
_EmploymentAddress._AddressDefaultRepresentation.TertiaryRegion,
_EmploymentAddress._AddressDefaultRepresentation.TertiaryRegionName,
_EmploymentAddress._AddressDefaultRepresentation.CityName,
_EmploymentAddress._AddressDefaultRepresentation.DistrictName,
_EmploymentAddress._AddressDefaultRepresentation.StreetPrefixName1,
_EmploymentAddress._AddressDefaultRepresentation.StreetPrefixName2,
_EmploymentAddress._AddressDefaultRepresentation.StreetName,
_EmploymentAddress._AddressDefaultRepresentation.StreetSuffixName1,
_EmploymentAddress._AddressDefaultRepresentation.StreetSuffixName2,
_EmploymentAddress._AddressDefaultRepresentation.HouseNumber,
_EmploymentAddress._AddressDefaultRepresentation.HouseNumberSupplementText,
_EmploymentAddress._AddressDefaultRepresentation.Floor,
_EmploymentAddress._AddressDefaultRepresentation.RoomNumber,
_EmploymentAddress._AddressDefaultRepresentation.CareOfName,
_EmploymentAddress._AddressDefaultRepresentation.POBoxPostalCode,
// _EmploymentAddress._AddressDefaultRepresentation.DeliveryServiceTypeCode,
// _EmploymentAddress._AddressDefaultRepresentation.DeliveryServiceNumber,
@Semantics.booleanIndicator: true
@UI.hidden: true
_Assignment.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,
/* 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