R_WorkAssignmentAddress

DDL: R_WORKASSIGNMENTADDRESS Type: view_entity TRANSACTIONAL Package: WFD_INT_RAP

Work Assignment Address Details

R_WorkAssignmentAddress is a Transactional CDS View that provides data about "Work Assignment Address Details" in SAP S/4HANA. It reads from 4 data sources (I_Businesspartneraddressusage, I_BusPartAddress, I_WorkAssignmentBP, I_WorkAssignmentKeyMapping) and exposes 30 fields with key fields WorkforcePersonExternalID, WorkAssignmentExternalID, Country2DigitISOCode, WorkAssignmentStartDate, AddressNumber. Part of development package WFD_INT_RAP.

4 data source(s) 30 fields

Data Sources (4)

SourceAliasJoin Type
I_Businesspartneraddressusage _BPAddressUsage inner
I_BusPartAddress _EmploymentAddress inner
I_WorkAssignmentBP _EmploymentBP inner
I_WorkAssignmentKeyMapping _WorkAssignmentDet from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Assignment Address Details view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY WorkforcePersonExternalID I_WorkAssignmentKeyMapping WorkforcePersonExternalID
KEY WorkAssignmentExternalID I_WorkAssignmentKeyMapping WorkAssignmentExternalID
KEY Country2DigitISOCode I_WorkAssignmentKeyMapping Country2DigitISOCode
KEY WorkAssignmentStartDate I_WorkAssignmentKeyMapping WorkAssignmentStartDate
KEY AddressNumber I_BusPartAddress AddressID
BusinessPartner I_WorkAssignmentBP BusinessPartner
WorkAssignmentEndDate I_WorkAssignmentKeyMapping WorkAssignmentEndDate
Country
PostalCode
Region
SecondaryRegion
SecondaryRegionName
TertiaryRegion
TertiaryRegionName
CityName
DistrictName
StreetPrefixName1
StreetPrefixName2
StreetName
StreetSuffixName1
StreetSuffixName2
HouseNumber
HouseNumberSupplementText
Floor
RoomNumber
CareOfName
POBoxPostalCode
DeliveryServiceTypeCode
DeliveryServiceNumber
IsBlocked I_WorkAssignmentKeyMapping IsBlocked 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Work Assignment Address Details'
@VDM.viewType: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #L,
  dataClass: #MIXED
}
define view entity R_WorkAssignmentAddress
//  as select distinct from R_WorkAssignmentDetail_1 as _WorkAssignmentDet

//    inner join            R_WorkAssignmentBP       as _EmploymentBP      on _EmploymentBP.WorkforceAssignment = _WorkAssignmentDet.WorkAssignment

//

//    inner join            I_BusPartAddress         as _EmploymentAddress on _EmploymentAddress.BusinessPartner = _EmploymentBP.WorkAssignmentBusinessPartner

  as select from I_WorkAssignmentKeyMapping as _WorkAssignmentDet

    inner join   I_WorkAssignmentBP         as _EmploymentBP     on _EmploymentBP.WorkAssignment = _WorkAssignmentDet.WorkAssignment
    inner join   I_Businesspartneraddressusage as _BPAddressUsage on _BPAddressUsage.BusinessPartner = _EmploymentBP.WorkAssignmentBusinessPartner
                                                                  and _BPAddressUsage.AddressUsage   = 'HCM001'
    inner join   I_BusPartAddress           as _EmploymentAddress on _EmploymentAddress.BusinessPartner = _EmploymentBP.WorkAssignmentBusinessPartner
                                                                  and  _BPAddressUsage.AddressNumber   = _EmploymentAddress.AddressID

{
  key     _WorkAssignmentDet.WorkforcePersonExternalID,
  key     _WorkAssignmentDet.WorkAssignmentExternalID,
  key     _WorkAssignmentDet.Country2DigitISOCode,
  key     _WorkAssignmentDet.WorkAssignmentStartDate,
  key     _EmploymentAddress.AddressID as AddressNumber,
          _EmploymentBP.BusinessPartner,
          _WorkAssignmentDet.WorkAssignmentEndDate,
          _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,
          _WorkAssignmentDet.IsBlocked
}

Learn More