R_WORKASSIGNMENTADDRESS

CDS View

Work Assignment Address Details

R_WORKASSIGNMENTADDRESS is a CDS View in S/4HANA. Work Assignment Address Details. It contains 30 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 30 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_WorkAssignmentAddressTP view_entity from TRANSACTIONAL Work Assignment Address Details
R_WorkAssignmentAddressTP_3 view_entity from TRANSACTIONAL Work Assignment Address Details

Fields (30)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 2
KEY Country2DigitISOCode Country2DigitISOCode 2
KEY WorkAssignmentExternalID WorkAssignmentExternalID 2
KEY WorkAssignmentStartDate WorkAssignmentStartDate 2
KEY WorkforcePersonExternalID WorkforcePersonExternalID 2
BusinessPartner BusinessPartner 2
CareOfName CareOfName 2
CityName CityName 2
Country Country 2
DeliveryServiceNumber DeliveryServiceNumber 1
DeliveryServiceTypeCode DeliveryServiceTypeCode 1
DistrictName DistrictName 2
Floor Floor 2
HouseNumber HouseNumber 2
HouseNumberSupplementText HouseNumberSupplementText 2
IsBlocked IsBlocked 2
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 2
Region Region 2
RoomNumber RoomNumber 2
SecondaryRegion SecondaryRegion 2
SecondaryRegionName SecondaryRegionName 2
StreetName StreetName 2
StreetPrefixName1 StreetPrefixName1 2
StreetPrefixName2 StreetPrefixName2 2
StreetSuffixName1 StreetSuffixName1 2
StreetSuffixName2 StreetSuffixName2 2
TertiaryRegion TertiaryRegion 2
TertiaryRegionName TertiaryRegionName 2
WorkAssignmentEndDate WorkAssignmentEndDate 2 
@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