R_WorkAssgmtPrivateAddressTP_2

DDL: R_WORKASSGMTPRIVATEADDRESSTP_2 Type: view_entity TRANSACTIONAL Package: ODATA_CA_BUM_WF
43 Fields 2 Data Sources 6 Associations

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.

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 Busn. Partner
KEY AddressNumber _BPAddressUsage AddressNumber Src Address No
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 Issuing Authority
_CountryText _CountryText
_RegionText _RegionText
_TaxJurisdictionText _TaxJurisdictionText
_BusPartDelivSrvcTxt _BusPartDelivSrvcTxt
_WorkAssignment _WorkAssignment
_WorkforcePerson _WorkforcePerson
_BPProtectedAddress _BPProtectedAddress

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_WorkAssgmtPrivateAddressTP_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_WorkAssgmtPrivateAddressTP_2 AS
SELECT
  _BuPaIdentification.WorkAssignmentBusinessPartner AS WorkAssignmentBusinessPartner,
  _BPAddressUsage.AddressNumber AS AddressNumber,
  _BPAddress._AddressDefaultRepresentation.HouseNumber AS HouseNumber,
  _BPAddress._AddressDefaultRepresentation.HouseNumberSupplementText AS HouseNumberSupplementText,
  _BPAddress._AddressDefaultRepresentation.Region AS Region,
  _BPAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _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,
  _BPAddress._AddressDefaultRepresentation.Floor AS Floor,
  _BPAddress._AddressDefaultRepresentation.Country AS Country,
  _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,
  _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,
  _BPAddress._AddressDefaultRepresentation.POBoxPostalCode AS POBoxPostalCode,
  _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
INNER JOIN R_WorkAssignmentBP AS _BuPaIdentification ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusPartAddress AS _BPAddress ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BPProtectedAddress AS _BPProtectedAddress ON BusinessPartner = _BPProtectedAddress.BusinessPartner AND AddressNumber = _BPProtectedAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON Country = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RegionText AS _RegionText ON Region = _RegionText.Region AND Country = _RegionText.Country AND _RegionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdictionText AS _TaxJurisdictionText ON TaxJurisdiction = _TaxJurisdictionText.TaxJurisdiction AND _TaxJurisdictionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusPartDelivSrvcTxt AS _BusPartDelivSrvcTxt ON DeliveryServiceTypeCode = _BusPartDelivSrvcTxt.DeliveryServiceTypeCode AND _BusPartDelivSrvcTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_WorkforcePersonTP_2 AS _WorkforcePerson ON BusinessPartner = _WorkforcePerson.BusinessPartner  -- association [1..1]
;

Learn More