I_PostalWorkplaceAddress

DDL: I_POSTALWORKPLACEADDRESS Type: view_entity BASIC Package: S_ADDRESS_VDM
141 Fields 2 Data Sources 1 Associations

Person Address type from ADRC & ADCP

I_PostalWorkplaceAddress is a Basic CDS View that provides data about "Person Address type from ADRC & ADCP" in SAP S/4HANA. It reads from 2 data sources (I_AddrOrgNamePostalAddress, I_AddressWorkplaceDetails) and exposes 141 fields with key fields AddressID, AddressPersonID, AddressPersonID. It has 1 association to related views. Part of development package S_ADDRESS_VDM.

Data Sources (2)

SourceAliasJoin Type
I_AddrOrgNamePostalAddress _Postal_2 union
I_AddressWorkplaceDetails wp from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_AddrOrgNamePostalAddress _Postal_1 $projection.AddressID = _Postal_1.AddressID and $projection.AddressRepresentationCode = _Postal_1.AddressRepresentationCode

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Person Address type from ADRC & ADCP view

Fields (141)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_AddressWorkplaceDetails AddressID Ship-to address
KEY AddressPersonID I_AddressWorkplaceDetails AddressPersonID Person Number
AddressRepresentationCode I_AddressWorkplaceDetails AddressRepresentationCode Address Version
PersonAddressObjectType I_AddressWorkplaceDetails PersonAddressObjectType Company/Person
WorkplaceBuilding I_AddressWorkplaceDetails WorkplaceBuilding Building code
WorkplaceFloor I_AddressWorkplaceDetails WorkplaceFloor Floor
WorkplaceRoomNumber I_AddressWorkplaceDetails WorkplaceRoomNumber Room Number
WorkplaceFunctionalTitleName I_AddressWorkplaceDetails WorkplaceFunctionalTitleName Unit Func.
WorkplaceDepartmentName I_AddressWorkplaceDetails WorkplaceDepartmentName Department
WorkplacePrfrdCommMediumType I_AddressWorkplaceDetails WorkplacePrfrdCommMediumType Comm. Method
WorkplaceCorrespncShortName I_AddressWorkplaceDetails WorkplaceCorrespncShortName Short name
WorkplaceInhouseMail I_AddressWorkplaceDetails WorkplaceInhouseMail Internal mail
CorrespondenceLanguage _Postal_1 CorrespondenceLanguage Language
AddressIsPersonAddress _Postal_1 AddressIsPersonAddress pers. address
PrfrdCommMediumType _Postal_1 PrfrdCommMediumType Comm. Method
CityNumber _Postal_1 CityNumber City Code
CityName _Postal_1 CityName Name
DistrictName _Postal_1 DistrictName District
VillageName _Postal_1 VillageName Different City
PostalCode _Postal_1 PostalCode Postal Code
CompanyPostalCode _Postal_1 CompanyPostalCode Company Post Cd
POBox _Postal_1 POBox PO Box
POBoxAddrNonDeliverableReason _Postal_1 POBoxAddrNonDeliverableReason Undeliverable
POBoxIsWithoutNumber _Postal_1 POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode _Postal_1 POBoxPostalCode PO Box Postal Code
POBoxLobbyName _Postal_1 POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName _Postal_1 POBoxDeviatingCityName PO Box City
POBoxDeviatingCityCode _Postal_1 POBoxDeviatingCityCode City Code
POBoxDeviatingRegion _Postal_1 POBoxDeviatingRegion PO Region
POBoxDeviatingCountry _Postal_1 POBoxDeviatingCountry PO Box C/R
Street _Postal_1 Street Street Code
StreetName _Postal_1 StreetName Text
StreetAddrNonDeliverableReason _Postal_1 StreetAddrNonDeliverableReason Undeliverable
StreetPrefixName1 _Postal_1 StreetPrefixName1 Street 2
StreetPrefixName2 _Postal_1 StreetPrefixName2 Street 3
StreetSuffixName1 _Postal_1 StreetSuffixName1 Street 4
StreetSuffixName2 _Postal_1 StreetSuffixName2 Street 5
HouseNumber _Postal_1 HouseNumber House Number
HouseNumberSupplementText _Postal_1 HouseNumberSupplementText Supplement
Building _Postal_1 Building Building code
Floor _Postal_1 Floor Floor
RoomNumber _Postal_1 RoomNumber Room Number
Country _Postal_1 Country Venue: Ctry/Reg
Region _Postal_1 Region Venue Region
FormOfAddress _Postal_1 FormOfAddress Title Key
CareOfName _Postal_1 CareOfName c/o
AddresseeName1 _Postal_1 AddresseeName1 PA text
AddresseeName2 _Postal_1 AddresseeName2 Name2/First nme
AddresseeName3 _Postal_1 AddresseeName3 Name 3
AddresseeName4 _Postal_1 AddresseeName4 Name 4
TaxJurisdiction _Postal_1 TaxJurisdiction Tax Jurisdiction
TransportZone _Postal_1 TransportZone Transport Zone
DeliveryServiceTypeCode _Postal_1 DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceNumber _Postal_1 DeliveryServiceNumber Delivery Service No.
AddressTimeZone _Postal_1 AddressTimeZone Time Zone
SecondaryRegion _Postal_1 SecondaryRegion County code
SecondaryRegionName _Postal_1 SecondaryRegionName County
TertiaryRegion _Postal_1 TertiaryRegion Township code
TertiaryRegionName _Postal_1 TertiaryRegionName Township
AddressSearchTerm1 _Postal_1 AddressSearchTerm1 Search Term 1
AddressSearchTerm2 _Postal_1 AddressSearchTerm2 Search Term 2
RegionalStructureCheckStatus _Postal_1 RegionalStructureCheckStatus Check Status
AddressGroup _Postal_1 AddressGroup Address group
AddressCreatedByUser _Postal_1 AddressCreatedByUser Created By
AddressCreatedOnDateTime _Postal_1 AddressCreatedOnDateTime Created On
AddressChangedByUser _Postal_1 AddressChangedByUser Changed By
AddressChangedOnDateTime _Postal_1 AddressChangedOnDateTime Changed On
_Country _Postal_1 _Country
_Region _Postal_1 _Region
_TransportationZone _Postal_1 _TransportationZone
AddressID Ship-to address
KEY AddressPersonID Person Number
AddressRepresentationCode I_AddrOrgNamePostalAddress AddressRepresentationCode Address Version
PersonAddressObjectType Company/Person
WorkplaceBuilding Building code
WorkplaceFloor Floor
WorkplaceRoomNumber Room Number
WorkplaceFunctionalTitleName Unit Func.
WorkplaceDepartmentName Department
WorkplacePrfrdCommMediumType Comm. Method
WorkplaceCorrespncShortName Short name
WorkplaceInhouseMail Internal mail
CorrespondenceLanguage I_AddrOrgNamePostalAddress CorrespondenceLanguage Language
AddressIsPersonAddress I_AddrOrgNamePostalAddress AddressIsPersonAddress pers. address
PrfrdCommMediumType I_AddrOrgNamePostalAddress PrfrdCommMediumType Comm. Method
CityNumber I_AddrOrgNamePostalAddress CityNumber City Code
CityName I_AddrOrgNamePostalAddress CityName Name
DistrictName I_AddrOrgNamePostalAddress DistrictName District
VillageName I_AddrOrgNamePostalAddress VillageName Different City
PostalCode I_AddrOrgNamePostalAddress PostalCode Postal Code
CompanyPostalCode I_AddrOrgNamePostalAddress CompanyPostalCode Company Post Cd
POBox I_AddrOrgNamePostalAddress POBox PO Box
POBoxAddrNonDeliverableReason I_AddrOrgNamePostalAddress POBoxAddrNonDeliverableReason Undeliverable
POBoxIsWithoutNumber I_AddrOrgNamePostalAddress POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode I_AddrOrgNamePostalAddress POBoxPostalCode PO Box Postal Code
POBoxLobbyName I_AddrOrgNamePostalAddress POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName I_AddrOrgNamePostalAddress POBoxDeviatingCityName PO Box City
POBoxDeviatingCityCode I_AddrOrgNamePostalAddress POBoxDeviatingCityCode City Code
POBoxDeviatingRegion I_AddrOrgNamePostalAddress POBoxDeviatingRegion PO Region
POBoxDeviatingCountry I_AddrOrgNamePostalAddress POBoxDeviatingCountry PO Box C/R
Street I_AddrOrgNamePostalAddress Street Street Code
StreetName I_AddrOrgNamePostalAddress StreetName Text
StreetAddrNonDeliverableReason I_AddrOrgNamePostalAddress StreetAddrNonDeliverableReason Undeliverable
StreetPrefixName1 I_AddrOrgNamePostalAddress StreetPrefixName1 Street 2
StreetPrefixName2 I_AddrOrgNamePostalAddress StreetPrefixName2 Street 3
StreetSuffixName1 I_AddrOrgNamePostalAddress StreetSuffixName1 Street 4
StreetSuffixName2 I_AddrOrgNamePostalAddress StreetSuffixName2 Street 5
HouseNumber I_AddrOrgNamePostalAddress HouseNumber House Number
HouseNumberSupplementText I_AddrOrgNamePostalAddress HouseNumberSupplementText Supplement
Building I_AddrOrgNamePostalAddress Building Building code
Floor I_AddrOrgNamePostalAddress Floor Floor
RoomNumber I_AddrOrgNamePostalAddress RoomNumber Room Number
Country I_AddrOrgNamePostalAddress Country Venue: Ctry/Reg
Region I_AddrOrgNamePostalAddress Region Venue Region
FormOfAddress I_AddrOrgNamePostalAddress FormOfAddress Title Key
CareOfName I_AddrOrgNamePostalAddress CareOfName c/o
AddresseeName1 I_AddrOrgNamePostalAddress AddresseeName1 PA text
AddresseeName2 I_AddrOrgNamePostalAddress AddresseeName2 Name2/First nme
AddresseeName3 I_AddrOrgNamePostalAddress AddresseeName3 Name 3
AddresseeName4 I_AddrOrgNamePostalAddress AddresseeName4 Name 4
TaxJurisdiction I_AddrOrgNamePostalAddress TaxJurisdiction Tax Jurisdiction
TransportZone I_AddrOrgNamePostalAddress TransportZone Transport Zone
DeliveryServiceTypeCode I_AddrOrgNamePostalAddress DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceNumber I_AddrOrgNamePostalAddress DeliveryServiceNumber Delivery Service No.
AddressTimeZone I_AddrOrgNamePostalAddress AddressTimeZone Time Zone
SecondaryRegion I_AddrOrgNamePostalAddress SecondaryRegion County code
SecondaryRegionName I_AddrOrgNamePostalAddress SecondaryRegionName County
TertiaryRegion I_AddrOrgNamePostalAddress TertiaryRegion Township code
TertiaryRegionName I_AddrOrgNamePostalAddress TertiaryRegionName Township
AddressSearchTerm1 I_AddrOrgNamePostalAddress AddressSearchTerm1 Search Term 1
AddressSearchTerm2 I_AddrOrgNamePostalAddress AddressSearchTerm2 Search Term 2
RegionalStructureCheckStatus I_AddrOrgNamePostalAddress RegionalStructureCheckStatus Check Status
AddressGroup I_AddrOrgNamePostalAddress AddressGroup Address group
AddressCreatedByUser I_AddrOrgNamePostalAddress AddressCreatedByUser Created By
AddressCreatedOnDateTime I_AddrOrgNamePostalAddress AddressCreatedOnDateTime Created On
AddressChangedByUser I_AddrOrgNamePostalAddress AddressChangedByUser Changed By
AddressChangedOnDateTime I_AddrOrgNamePostalAddress AddressChangedOnDateTime Changed On
_Country I_AddrOrgNamePostalAddress _Country
_Region I_AddrOrgNamePostalAddress _Region
_TransportationZone I_AddrOrgNamePostalAddress _TransportationZone
AddressType

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 I_PostalWorkplaceAddress.
-- 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 I_PostalWorkplaceAddress AS
SELECT
  wp.AddressID AS AddressID,
  wp.AddressPersonID AS AddressPersonID,
  wp.AddressRepresentationCode AS AddressRepresentationCode,
  wp.PersonAddressObjectType AS PersonAddressObjectType,
  wp.WorkplaceBuilding AS WorkplaceBuilding,
  wp.WorkplaceFloor AS WorkplaceFloor,
  wp.WorkplaceRoomNumber AS WorkplaceRoomNumber,
  wp.WorkplaceFunctionalTitleName AS WorkplaceFunctionalTitleName,
  wp.WorkplaceDepartmentName AS WorkplaceDepartmentName,
  wp.WorkplacePrfrdCommMediumType AS WorkplacePrfrdCommMediumType,
  wp.WorkplaceCorrespncShortName AS WorkplaceCorrespncShortName,
  wp.WorkplaceInhouseMail AS WorkplaceInhouseMail,
  _Postal_1.CorrespondenceLanguage AS CorrespondenceLanguage,
  _Postal_1.AddressIsPersonAddress AS AddressIsPersonAddress,
  _Postal_1.PrfrdCommMediumType AS PrfrdCommMediumType,
  _Postal_1.CityNumber AS CityNumber,
  _Postal_1.CityName AS CityName,
  _Postal_1.DistrictName AS DistrictName,
  _Postal_1.VillageName AS VillageName,
  _Postal_1.PostalCode AS PostalCode,
  _Postal_1.CompanyPostalCode AS CompanyPostalCode,
  _Postal_1.POBox AS POBox,
  _Postal_1.POBoxAddrNonDeliverableReason AS POBoxAddrNonDeliverableReason,
  _Postal_1.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _Postal_1.POBoxPostalCode AS POBoxPostalCode,
  _Postal_1.POBoxLobbyName AS POBoxLobbyName,
  _Postal_1.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _Postal_1.POBoxDeviatingCityCode AS POBoxDeviatingCityCode,
  _Postal_1.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _Postal_1.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _Postal_1.Street AS Street,
  _Postal_1.StreetName AS StreetName,
  _Postal_1.StreetAddrNonDeliverableReason AS StreetAddrNonDeliverableReason,
  _Postal_1.StreetPrefixName1 AS StreetPrefixName1,
  _Postal_1.StreetPrefixName2 AS StreetPrefixName2,
  _Postal_1.StreetSuffixName1 AS StreetSuffixName1,
  _Postal_1.StreetSuffixName2 AS StreetSuffixName2,
  _Postal_1.HouseNumber AS HouseNumber,
  _Postal_1.HouseNumberSupplementText AS HouseNumberSupplementText,
  _Postal_1.Building AS Building,
  _Postal_1.Floor AS Floor,
  _Postal_1.RoomNumber AS RoomNumber,
  _Postal_1.Country AS Country,
  _Postal_1.Region AS Region,
  _Postal_1.FormOfAddress AS FormOfAddress,
  _Postal_1.CareOfName AS CareOfName,
  _Postal_1.AddresseeName1 AS AddresseeName1,
  _Postal_1.AddresseeName2 AS AddresseeName2,
  _Postal_1.AddresseeName3 AS AddresseeName3,
  _Postal_1.AddresseeName4 AS AddresseeName4,
  _Postal_1.TaxJurisdiction AS TaxJurisdiction,
  _Postal_1.TransportZone AS TransportZone,
  _Postal_1.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _Postal_1.DeliveryServiceNumber AS DeliveryServiceNumber,
  _Postal_1.AddressTimeZone AS AddressTimeZone,
  _Postal_1.SecondaryRegion AS SecondaryRegion,
  _Postal_1.SecondaryRegionName AS SecondaryRegionName,
  _Postal_1.TertiaryRegion AS TertiaryRegion,
  _Postal_1.TertiaryRegionName AS TertiaryRegionName,
  _Postal_1.AddressSearchTerm1 AS AddressSearchTerm1,
  _Postal_1.AddressSearchTerm2 AS AddressSearchTerm2,
  _Postal_1.RegionalStructureCheckStatus AS RegionalStructureCheckStatus,
  _Postal_1.AddressGroup AS AddressGroup,
  _Postal_1.AddressCreatedByUser AS AddressCreatedByUser,
  _Postal_1.AddressCreatedOnDateTime AS AddressCreatedOnDateTime,
  _Postal_1.AddressChangedByUser AS AddressChangedByUser,
  _Postal_1.AddressChangedOnDateTime AS AddressChangedOnDateTime,
  _Postal_1._Country AS _Country,
  _Postal_1._Region AS _Region,
  _Postal_1._TransportationZone AS _TransportationZone,
  '1' AS AddressType
FROM I_AddressWorkplaceDetails AS wp
LEFT OUTER JOIN I_AddrOrgNamePostalAddress AS _Postal_1 ON AddressID = _Postal_1.AddressID AND AddressRepresentationCode = _Postal_1.AddressRepresentationCode  -- association [0..1]
-- UNION with additional select branch(es): I_AddrOrgNamePostalAddress
;

Learn More