R_WorkAssgmtPrivateAddressTP_2

DDL: R_WORKASSGMTPRIVATEADDRESSTP_2 Type: view_entity TRANSACTIONAL Package: ODATA_CA_BUM_WF

Private Address for Work Assignment

R_WorkAssgmtPrivateAddressTP_2 is a Transactional CDS View that provides data about "Private Address for Work Assignment" in SAP S/4HANA. It reads from 2 data sources (I_BusPartAddress, R_WorkAssignmentBP) and exposes 43 fields with key fields WorkAssignmentBusinessPartner, AddressNumber. It has 6 associations to related views. Part of development package ODATA_CA_BUM_WF.

2 data source(s) 43 fields

Data Sources (2)

SourceAliasJoin Type
I_BusPartAddress _BPAddress inner
R_WorkAssignmentBP _BuPaIdentification inner

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_BPProtectedAddress _BPProtectedAddress $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner and $projection.AddressNumber = _BPProtectedAddress.AddressID
[0..1] I_CountryText _CountryText $projection.Country = _CountryText.Country and _CountryText.Language = $session.system_language
[0..1] I_RegionText _RegionText $projection.Region = _RegionText.Region and $projection.Country = _RegionText.Country and _RegionText.Language = $session.system_language
[0..1] I_TaxJurisdictionText _TaxJurisdictionText $projection.TaxJurisdiction = _TaxJurisdictionText.TaxJurisdiction and _TaxJurisdictionText.Language = $session.system_language
[0..1] I_BusPartDelivSrvcTxt _BusPartDelivSrvcTxt $projection.DeliveryServiceTypeCode = _BusPartDelivSrvcTxt.DeliveryServiceTypeCode and _BusPartDelivSrvcTxt.Language = $session.system_language
[1..1] R_WorkforcePersonTP_2 _WorkforcePerson $projection.BusinessPartner = _WorkforcePerson.BusinessPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Private Address for Work Assignment view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentBusinessPartner R_WorkAssignmentBP WorkAssignmentBusinessPartner
KEY AddressNumber _BPAddressUsage AddressNumber
HouseNumber
HouseNumberSupplementText
Region
PostalCode
DistrictName
Street
StreetName
CityNumber
CityName
Floor
Country
RoomNumber
TaxJurisdiction
CareOfName
StreetPrefixName1
StreetPrefixName2
StreetSuffixName1
StreetSuffixName2
SecondaryRegion
SecondaryRegionName
TertiaryRegion
TertiaryRegionName
AddressRepresentationCode
POBoxPostalCode
POBox
POBoxLobbyName
POBoxDeviatingCountry
POBoxDeviatingRegion
POBoxDeviatingCityCode
POBoxDeviatingCityName
POBoxIsWithoutNumber
DeliveryServiceTypeCode
DeliveryServiceNumber
BusinessPartner R_WorkAssignmentBP BusinessPartner
_CountryText _CountryText
_RegionText _RegionText
_TaxJurisdictionText _TaxJurisdictionText
_BusPartDelivSrvcTxt _BusPartDelivSrvcTxt
_WorkAssignment _WorkAssignment
_WorkforcePerson _WorkforcePerson
_BPProtectedAddress _BPProtectedAddress 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Private Address for Work Assignment'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@AccessControl.personalData.blocking: #NOT_REQUIRED
//@Consumption.dbHints: ['USE_HEX_PLAN']

@Consumption.dbHints: [ '&PREFER_JOIN_WITH_FDA 0&', 'USE_HEX_PLAN' ]
define view entity R_WorkAssgmtPrivateAddressTP_2
  as select distinct from I_Businesspartneraddressusage as _BPAddressUsage
    inner join            R_WorkAssignmentBP            as _BuPaIdentification on _BuPaIdentification.WorkAssignmentBusinessPartner = _BPAddressUsage.BusinessPartner

    inner join            I_BusPartAddress              as _BPAddress          on  _BPAddressUsage.BusinessPartner = _BPAddress.BusinessPartner
                                                                               and _BPAddressUsage.AddressNumber   = _BPAddress.AddressID
  association [0..1] to I_BPProtectedAddress        as _BPProtectedAddress  on  $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner
                                                                            and $projection.AddressNumber   = _BPProtectedAddress.AddressID
  association [0..1] to I_CountryText               as _CountryText         on  $projection.Country   = _CountryText.Country
                                                                            and _CountryText.Language = $session.system_language
  association [0..1] to I_RegionText                as _RegionText          on  $projection.Region   = _RegionText.Region
                                                                            and $projection.Country  = _RegionText.Country
                                                                            and _RegionText.Language = $session.system_language
  association [0..1] to I_TaxJurisdictionText       as _TaxJurisdictionText on  $projection.TaxJurisdiction   = _TaxJurisdictionText.TaxJurisdiction
                                                                            and _TaxJurisdictionText.Language = $session.system_language
  association [0..1] to I_BusPartDelivSrvcTxt       as _BusPartDelivSrvcTxt on  $projection.DeliveryServiceTypeCode = _BusPartDelivSrvcTxt.DeliveryServiceTypeCode
                                                                            and _BusPartDelivSrvcTxt.Language       = $session.system_language
  //Below associations for handling DCL

  association [1..1] to R_WorkforcePersonTP_2       as _WorkforcePerson    on  $projection.BusinessPartner  = _WorkforcePerson.BusinessPartner 
  association        to parent R_WorkAssignmentTP_2 as _WorkAssignment     on  $projection.WorkAssignmentBusinessPartner = _WorkAssignment.WorkAssignmentBusinessPartner
{
  key      _BuPaIdentification.WorkAssignmentBusinessPartner                                              as WorkAssignmentBusinessPartner,
  key      _BPAddressUsage.AddressNumber                                                                  as AddressNumber,
  key      cast (tstmp_to_dats( _BPAddressUsage.ValidityStartDate,
           abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as vdm_v_start_date) as ValidityStartDate,
           cast (tstmp_to_dats( _BPAddressUsage.ValidityEndDate,
           abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as vdm_v_end_date)   as ValidityEndDate,
           _BPAddress._AddressDefaultRepresentation.HouseNumber                                           as HouseNumber,
           _BPAddress._AddressDefaultRepresentation.HouseNumberSupplementText                             as HouseNumberSupplementText, //HouseSupplement,

           _BPAddress._AddressDefaultRepresentation.Region                                                as Region, //AddressRegion,

           _BPAddress._AddressDefaultRepresentation.PostalCode                                            as PostalCode, //AddressPostalCode,

           //           _BPAddress._AddressDefaultRepresentation.DistrictNumber                                        as DistrictNumber,

           _BPAddress._AddressDefaultRepresentation.DistrictName                                          as DistrictName,
           _BPAddress._AddressDefaultRepresentation.Street                                                as Street,
           _BPAddress._AddressDefaultRepresentation.StreetName                                            as StreetName,
           _BPAddress._AddressDefaultRepresentation.CityNumber                                            as CityNumber,
           _BPAddress._AddressDefaultRepresentation.CityName                                              as CityName, //City,

           _BPAddress._AddressDefaultRepresentation.Floor                                                 as Floor,
           _BPAddress._AddressDefaultRepresentation.Country                                               as Country, //CountryOrRegion

           _BPAddress._AddressDefaultRepresentation.RoomNumber                                            as RoomNumber,
           _BPAddress._AddressDefaultRepresentation.TaxJurisdiction                                       as TaxJurisdiction,
           _BPAddress._AddressDefaultRepresentation.CareOfName                                            as CareOfName,
           _BPAddress._AddressDefaultRepresentation.StreetPrefixName1                                     as StreetPrefixName1,
           _BPAddress._AddressDefaultRepresentation.StreetPrefixName2                                     as StreetPrefixName2,
           _BPAddress._AddressDefaultRepresentation.StreetSuffixName1                                     as StreetSuffixName1,
           _BPAddress._AddressDefaultRepresentation.StreetSuffixName2                                     as StreetSuffixName2,

           //API Fields to avoid Data loss

           _BPAddress._AddressDefaultRepresentation.SecondaryRegion                                       as SecondaryRegion,
           _BPAddress._AddressDefaultRepresentation.SecondaryRegionName                                   as SecondaryRegionName,
           _BPAddress._AddressDefaultRepresentation.TertiaryRegion                                        as TertiaryRegion,
           _BPAddress._AddressDefaultRepresentation.TertiaryRegionName                                    as TertiaryRegionName,
           _BPAddress._AddressDefaultRepresentation.AddressRepresentationCode                             as AddressRepresentationCode,

           //PO BOX related fields

           _BPAddress._AddressDefaultRepresentation.POBoxPostalCode                                       as POBoxPostalCode, //PostOfficeBoxPostalCode,

           _BPAddress._AddressDefaultRepresentation.POBox                                                 as POBox,
           _BPAddress._AddressDefaultRepresentation.POBoxLobbyName                                        as POBoxLobbyName,
           _BPAddress._AddressDefaultRepresentation.POBoxDeviatingCountry                                 as POBoxDeviatingCountry,
           _BPAddress._AddressDefaultRepresentation.POBoxDeviatingRegion                                  as POBoxDeviatingRegion,
           _BPAddress._AddressDefaultRepresentation.POBoxDeviatingCityCode                                as POBoxDeviatingCityCode,
           _BPAddress._AddressDefaultRepresentation.POBoxDeviatingCityName                                as POBoxDeviatingCityName,
           _BPAddress._AddressDefaultRepresentation.POBoxIsWithoutNumber                                  as POBoxIsWithoutNumber,

           _BPAddress._AddressDefaultRepresentation.DeliveryServiceTypeCode                               as DeliveryServiceTypeCode,
           _BPAddress._AddressDefaultRepresentation.DeliveryServiceNumber                                 as DeliveryServiceNumber,
           _BuPaIdentification.BusinessPartner                                                            as BusinessPartner,

           /* Associations */
           _CountryText,
           _RegionText,
           _TaxJurisdictionText,
           _BusPartDelivSrvcTxt,
           _WorkAssignment,
           _WorkforcePerson,
           _BPProtectedAddress
}
where
  _BPAddressUsage.AddressUsage = 'HCM001'

Learn More