I_PERSONADDRESS
Address of a Person
I_PERSONADDRESS is a CDS View in S/4HANA. Address of a Person. It contains 99 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PersonAddressDefaultRprstn | view_entity | from | COMPOSITE | Dflt Represention of a Person Address |
| P_Address_2 | view_entity | from | COMPOSITE | Union of Person and Organization Address |
Fields (99)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressID | AddressID | 1 |
| KEY | AddressPersonID | AddressPersonID | 1 |
| _AcademicTitle | _AcademicTitle | 1 | |
| _AcademicTitle2 | _AcademicTitle2 | 1 | |
| _AddressGroup | _AddressGroup | 1 | |
| _AddressObjectType | _AddressObjectType | 1 | |
| _AddressPersonName | _AddressPersonName | 1 | |
| _AddressRepresentationCode | _AddressRepresentationCode | 1 | |
| _CorrespondenceLanguage | _CorrespondenceLanguage | 1 | |
| _Country | _Country | 1 | |
| _CurrentDfltEmailAddress | _CurrentDfltEmailAddress | 1 | |
| _CurrentDfltFaxNumber | _CurrentDfltFaxNumber | 1 | |
| _CurrentDfltLandlinePhoneNmbr | _CurrentDfltLandlinePhoneNmbr | 1 | |
| _CurrentDfltMobilePhoneNumber | _CurrentDfltMobilePhoneNumber | 1 | |
| _DeliveryServiceTypeCode | _DeliveryServiceTypeCode | 1 | |
| _EmailAddress | _EmailAddress | 1 | |
| _FamilyNamePrefix | _FamilyNamePrefix | 1 | |
| _FamilyNameSecondPrefix | _FamilyNameSecondPrefix | 1 | |
| _FaxNumber | _FaxNumber | 1 | |
| _FormOfAddress | _FormOfAddress | 1 | |
| _MainWebsiteURL | _MainWebsiteURL | 1 | |
| _NameSupplement | _NameSupplement | 1 | |
| _PhoneNumber | _PhoneNumber | 1 | |
| _POBoxAddrNonDeliverableReason | _POBoxAddrNonDeliverableReason | 1 | |
| _POBoxDeviatingCityCode | _POBoxDeviatingCityCode | 1 | |
| _POBoxDeviatingCountry | _POBoxDeviatingCountry | 1 | |
| _POBoxDeviatingRegion | _POBoxDeviatingRegion | 1 | |
| _PostalCity | _PostalCity | 1 | |
| _PrfrdCommMediumType | _PrfrdCommMediumType | 1 | |
| _Region | _Region | 1 | |
| _RegionalStructureCheckStatus | _RegionalStructureCheckStatus | 1 | |
| _SecondaryRegion | _SecondaryRegion | 1 | |
| _Street | _Street | 1 | |
| _StreetAddrNonDeliverableRsn | _StreetAddrNonDeliverableRsn | 1 | |
| _TertiaryRegion | _TertiaryRegion | 1 | |
| _TimeZone | _TimeZone | 1 | |
| _TransportationZone | _TransportationZone | 1 | |
| _UniformResourceIdentifier | _UniformResourceIdentifier | 1 | |
| AcademicTitle | AcademicTitle | 1 | |
| AcademicTitle2 | AcademicTitle2 | 1 | |
| AddressGroup | AddressGroup | 1 | |
| AddressObjectType | AddressObjectType | 1 | |
| AddressPersonSearchTerm1 | AddressPersonSearchTerm1 | 1 | |
| AddressPersonSearchTerm2 | AddressPersonSearchTerm2 | 1 | |
| AddressRepresentationCode | AddressRepresentationCode | 1 | |
| AddressTimeZone | AddressTimeZone | 1 | |
| Building | Building | 1 | |
| CareOfName | CareOfName | 1 | |
| CityName | CityName | 1 | |
| CityNumber | CityNumber | 1 | |
| CompanyPostalCode | CompanyPostalCode | 1 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 1 | |
| Country | Country | 1 | |
| DeliveryServiceNumber | DeliveryServiceNumber | 1 | |
| DeliveryServiceTypeCode | DeliveryServiceTypeCode | 1 | |
| DistrictName | DistrictName | 1 | |
| FamilyName | FamilyName | 1 | |
| FamilyNamePrefix | FamilyNamePrefix | 1 | |
| FamilyNameSecondPrefix | FamilyNameSecondPrefix | 1 | |
| Floor | Floor | 1 | |
| FormOfAddress | FormOfAddress | 1 | |
| GivenName | GivenName | 1 | |
| HouseNumber | HouseNumber | 1 | |
| HouseNumberSupplementText | HouseNumberSupplementText | 1 | |
| NameInitials | NameInitials | 1 | |
| PersonBirthName | PersonBirthName | 1 | |
| PersonFullName | PersonFullName | 1 | |
| PersonMiddleName | PersonMiddleName | 1 | |
| PersonNameSupplementCode | PersonNameSupplementCode | 1 | |
| PersonNickname | PersonNickname | 1 | |
| POBox | POBox | 1 | |
| POBoxAddrNonDeliverableReason | POBoxAddrNonDeliverableReason | 1 | |
| POBoxDeviatingCityCode | POBoxDeviatingCityCode | 1 | |
| POBoxDeviatingCityName | POBoxDeviatingCityName | 1 | |
| POBoxDeviatingCountry | POBoxDeviatingCountry | 1 | |
| POBoxDeviatingRegion | POBoxDeviatingRegion | 1 | |
| POBoxIsWithoutNumber | POBoxIsWithoutNumber | 1 | |
| POBoxLobbyName | POBoxLobbyName | 1 | |
| POBoxPostalCode | POBoxPostalCode | 1 | |
| PostalCode | PostalCode | 1 | |
| PrfrdCommMediumType | PrfrdCommMediumType | 1 | |
| Region | Region | 1 | |
| RegionalStructureCheckStatus | RegionalStructureCheckStatus | 1 | |
| RoomNumber | RoomNumber | 1 | |
| SecondaryRegion | SecondaryRegion | 1 | |
| SecondaryRegionName | SecondaryRegionName | 1 | |
| SecondFamilyName | SecondFamilyName | 1 | |
| Street | Street | 1 | |
| StreetAddrNonDeliverableReason | StreetAddrNonDeliverableReason | 1 | |
| StreetName | StreetName | 1 | |
| StreetPrefixName1 | StreetPrefixName1 | 1 | |
| StreetPrefixName2 | StreetPrefixName2 | 1 | |
| StreetSuffixName1 | StreetSuffixName1 | 1 | |
| StreetSuffixName2 | StreetSuffixName2 | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TertiaryRegion | TertiaryRegion | 1 | |
| TertiaryRegionName | TertiaryRegionName | 1 | |
| TransportZone | TransportZone | 1 | |
| VillageName | VillageName | 1 |
@Analytics : {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true }
}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: ['_EmailAddress', '_CurrentDfltEmailAddress', '_PhoneNumber', '_CurrentDfltLandlinePhoneNmbr', '_CurrentDfltMobilePhoneNumber', '_FaxNumber', '_CurrentDfltFaxNumber', '_UniformResourceIdentifier', '_MainWebsiteURL']
@EndUserText.label: 'Address of a Person'
//@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE,
#EXTRACTION_DATA_SOURCE ]
@ObjectModel.representativeKey: 'AddressID'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.sapObjectNodeType.name: 'PersonAddress'
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
define view entity I_PersonAddress
as select from I_AddressWorkplaceDetails
association [0..1] to I_AddrOrgNamePostalAddress as _OrgNamePostalAddress on _OrgNamePostalAddress.AddressID = $projection.AddressID
and _OrgNamePostalAddress.AddressRepresentationCode = $projection.AddressRepresentationCode
and _OrgNamePostalAddress.AddressIsPersonAddress = 'X'
association [0..1] to I_AddressPersonName as _PersonName on _PersonName.AddressPersonID = $projection.AddressPersonID
and _PersonName.AddressRepresentationCode = $projection.AddressRepresentationCode
association [0..*] to I_AddressEmailAddress_2 as _EmailAddress on _EmailAddress.AddressID = $projection.AddressID
and _EmailAddress.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddrCurDefaultEmailAddress as _CurrentDfltEmailAddress on _CurrentDfltEmailAddress.AddressID = $projection.AddressID
and _CurrentDfltEmailAddress.AddressPersonID = $projection.AddressPersonID
association [0..*] to I_AddressPhoneNumber_2 as _PhoneNumber on _PhoneNumber.AddressID = $projection.AddressID
and _PhoneNumber.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddrCurDfltLandlinePhoneNmbr as _CurrentDfltLandlinePhoneNmbr on _CurrentDfltLandlinePhoneNmbr.AddressID = $projection.AddressID
and _CurrentDfltLandlinePhoneNmbr.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddrCurDfltMobilePhoneNumber as _CurrentDfltMobilePhoneNumber on _CurrentDfltMobilePhoneNumber.AddressID = $projection.AddressID
and _CurrentDfltMobilePhoneNumber.AddressPersonID = $projection.AddressPersonID
association [0..*] to I_AddressFaxNumber_2 as _FaxNumber on _FaxNumber.AddressID = $projection.AddressID
and _FaxNumber.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddrCurDefaultFaxNumber as _CurrentDfltFaxNumber on _CurrentDfltFaxNumber.AddressID = $projection.AddressID
and _CurrentDfltFaxNumber.AddressPersonID = $projection.AddressPersonID
association [0..*] to I_AddressURI as _UniformResourceIdentifier on _UniformResourceIdentifier.AddressID = $projection.AddressID
and _UniformResourceIdentifier.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddressMainWebsiteURL as _MainWebsiteURL on _MainWebsiteURL.AddressID = $projection.AddressID
and _MainWebsiteURL.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_Region as _Region on $projection.region = _Region.Region
and $projection.country = _Region.Country
association [0..1] to I_Country as _Country on $projection.country = _Country.Country
association [0..1] to I_FormOfAddress as _FormOfAddress on $projection.formofaddress = _FormOfAddress.FormOfAddress
association [0..1] to I_AddressNonDeliverableReason as _POBoxAddrNonDeliverableReason on $projection.poboxaddrnondeliverablereason = _POBoxAddrNonDeliverableReason.AddressNonDeliverableReason
association [0..1] to I_AddressNonDeliverableReason as _StreetAddrNonDeliverableRsn on $projection.streetaddrnondeliverablereason = _StreetAddrNonDeliverableRsn.AddressNonDeliverableReason
association [0..1] to I_TransportationZone as _TransportationZone on $projection.transportzone = _TransportationZone.TransportZone
and $projection.country = _TransportationZone.CountryCode
association [0..1] to I_Region as _POBoxDeviatingRegion on $projection.poboxdeviatingregion = _POBoxDeviatingRegion.Region
and $projection.poboxdeviatingcountry = _POBoxDeviatingRegion.Country
association [0..1] to I_Country as _POBoxDeviatingCountry on $projection.poboxdeviatingcountry = _POBoxDeviatingCountry.Country
association [0..1] to I_AddressCommunicationMethod as _PrfrdCommMediumType on $projection.prfrdcommmediumtype = _PrfrdCommMediumType.CommunicationMediumType
association [0..1] to I_AddressDeliveryServiceType as _DeliveryServiceTypeCode on $projection.deliveryservicetypecode = _DeliveryServiceTypeCode.DeliveryServiceTypeCode
association [0..1] to I_Language as _CorrespondenceLanguage on $projection.correspondencelanguage = _CorrespondenceLanguage.Language
association [0..1] to I_AddressObjectType as _AddressObjectType on $projection.AddressObjectType = _AddressObjectType.AddressObjectType
association [0..1] to I_AddressRepresentation as _AddressRepresentationCode on $projection.AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode
association [0..1] to I_SecondaryRegion as _SecondaryRegion on $projection.secondaryregion = _SecondaryRegion.SecondaryRegion
and $projection.country = _SecondaryRegion.Country
and $projection.region = _SecondaryRegion.Region
association [0..1] to I_TertiaryRegion as _TertiaryRegion on $projection.tertiaryregion = _TertiaryRegion.TertiaryRegion
and $projection.secondaryregion = _TertiaryRegion.SecondaryRegion
and $projection.country = _TertiaryRegion.Country
and $projection.region = _TertiaryRegion.Region
association [0..1] to I_PostalCity as _PostalCity on $projection.citynumber = _PostalCity.CityNumber
and $projection.country = _PostalCity.Country
association [0..1] to I_PostalCity as _POBoxDeviatingCityCode on $projection.poboxdeviatingcitycode = _POBoxDeviatingCityCode.CityNumber
and $projection.country = _POBoxDeviatingCityCode.Country
association [0..1] to I_TimeZone as _TimeZone on $projection.addresstimezone = _TimeZone.TimeZoneID
association [0..1] to I_NameSupplement as _NameSupplement on $projection.personnamesupplementcode = _NameSupplement.PersonNameSupplementCode
association [0..1] to I_FamilyNamePrefix as _FamilyNamePrefix on $projection.familynameprefix = _FamilyNamePrefix.FamilyNamePrefix
association [0..1] to I_FamilyNamePrefix as _FamilyNameSecondPrefix on $projection.familynamesecondprefix = _FamilyNameSecondPrefix.FamilyNamePrefix
association [0..1] to I_RegionalStructureCheckStatus as _RegionalStructureCheckStatus on $projection.regionalstructurecheckstatus = _RegionalStructureCheckStatus.RegionalStructureCheckStatus
association [0..1] to I_AcademicTitle as _AcademicTitle on $projection.academictitle = _AcademicTitle.AcademicTitle
association [0..1] to I_AcademicTitle as _AcademicTitle2 on $projection.academictitle2 = _AcademicTitle2.AcademicTitle
association [0..1] to I_Street as _Street on $projection.country = _Street.Country
and $projection.street = _Street.Street
association [0..1] to I_AddressGroup as _AddressGroup on $projection.addressgroup = _AddressGroup.AddressGroup
association [0..1] to I_AddressPersonName as _AddressPersonName on $projection.AddressPersonID = _AddressPersonName.AddressPersonID
and $projection.AddressRepresentationCode = _AddressPersonName.AddressRepresentationCode
association [0..*] to I_AddressRemark_2 as _AddressRemark on $projection.AddressID = _AddressRemark.AddressID
and $projection.AddressRepresentationCode = _AddressRemark.AddressRepresentationCode
{
key I_AddressWorkplaceDetails.AddressID as AddressID,
@ObjectModel.foreignKey.association: '_AddressPersonName'
key I_AddressWorkplaceDetails.AddressPersonID as AddressPersonID,
@ObjectModel.foreignKey.association: '_AddressRepresentationCode'
@ObjectModel.sapObjectNodeTypeReference: 'AddressRepresentationCode'
key I_AddressWorkplaceDetails.AddressRepresentationCode as AddressRepresentationCode,
@ObjectModel.foreignKey.association: '_AddressObjectType'
@ObjectModel.sapObjectNodeTypeReference: 'AddressObjectType'
cast('2' as ad_adrtype) as AddressObjectType,
@ObjectModel.foreignKey.association: '_CorrespondenceLanguage'
_PersonName.CorrespondenceLanguage,
_PersonName.GivenName,
_PersonName.FamilyName,
_PersonName.PersonBirthName,
_PersonName.PersonMiddleName,
_PersonName.SecondFamilyName,
@ObjectModel.foreignKey.association: '_AcademicTitle'
@ObjectModel.sapObjectNodeTypeReference: 'AcademicTitle'
_PersonName.AcademicTitle,
@ObjectModel.foreignKey.association: '_AcademicTitle2'
@ObjectModel.sapObjectNodeTypeReference: 'AcademicTitle'
_PersonName.AcademicTitle2,
@ObjectModel.foreignKey.association: '_FamilyNamePrefix'
@ObjectModel.sapObjectNodeTypeReference: 'FamilyNamePrefix'
_PersonName.FamilyNamePrefix,
@ObjectModel.foreignKey.association: '_FamilyNameSecondPrefix'
@ObjectModel.sapObjectNodeTypeReference: 'FamilyNameSecondPrefix'
_PersonName.FamilyNameSecondPrefix,
@ObjectModel.foreignKey.association: '_NameSupplement'
@ObjectModel.sapObjectNodeTypeReference: 'NameSupplement'
_PersonName.PersonNameSupplementCode,
_PersonName.PersonNickname,
_PersonName.NameInitials,
_PersonName.PersonFullName,
@ObjectModel.foreignKey.association: '_FormOfAddress'
@ObjectModel.sapObjectNodeTypeReference: 'FormOfAddress'
_PersonName.FormOfAddress,
_PersonName.AddressPersonSearchTerm1,
_PersonName.AddressPersonSearchTerm2,
_PersonName.PersonFullNameFormattingCode,
_PersonName.PersonFullNameFormattingCntry,
_PersonName.converted,
@ObjectModel.foreignKey.association: '_PrfrdCommMediumType'
@ObjectModel.sapObjectNodeTypeReference: 'CommunicationMediumType'
_OrgNamePostalAddress.PrfrdCommMediumType,
@ObjectModel.foreignKey.association: '_PostalCity'
@ObjectModel.sapObjectNodeTypeReference: 'PostalCity'
_OrgNamePostalAddress.CityNumber,
_OrgNamePostalAddress.CityName,
_OrgNamePostalAddress.DistrictName,
_OrgNamePostalAddress.VillageName,
_OrgNamePostalAddress.PostalCode,
_OrgNamePostalAddress.CompanyPostalCode,
@ObjectModel.foreignKey.association: '_Street'
@ObjectModel.sapObjectNodeTypeReference: 'Street'
_OrgNamePostalAddress.Street,
_OrgNamePostalAddress.StreetName,
@ObjectModel.foreignKey.association: '_StreetAddrNonDeliverableRsn'
@ObjectModel.sapObjectNodeTypeReference: 'StreetAddrNonDeliverableRsn'
@EndUserText.label: 'AddressNonDeliverableReason'
_OrgNamePostalAddress.StreetAddrNonDeliverableReason,
_OrgNamePostalAddress.StreetPrefixName1,
_OrgNamePostalAddress.StreetPrefixName2,
_OrgNamePostalAddress.StreetSuffixName1,
_OrgNamePostalAddress.StreetSuffixName2,
_OrgNamePostalAddress.HouseNumber,
_OrgNamePostalAddress.HouseNumberSupplementText,
_OrgNamePostalAddress.Building,
_OrgNamePostalAddress.Floor,
_OrgNamePostalAddress.RoomNumber,
@ObjectModel.foreignKey.association: '_Country'
@ObjectModel.sapObjectNodeTypeReference: 'Country'
_OrgNamePostalAddress.Country,
@ObjectModel.foreignKey.association: '_Region'
@ObjectModel.sapObjectNodeTypeReference: 'Region'
_OrgNamePostalAddress.Region,
_OrgNamePostalAddress.TaxJurisdiction,
@ObjectModel.foreignKey.association: '_TransportationZone'
@ObjectModel.sapObjectNodeTypeReference: 'TransportationZone'
_OrgNamePostalAddress.TransportZone,
_OrgNamePostalAddress.POBox,
@ObjectModel.foreignKey.association: '_POBoxAddrNonDeliverableReason'
@ObjectModel.sapObjectNodeTypeReference: 'AddressNonDeliverableReason'
@EndUserText.label: 'AddressNonDeliverableReason'
_OrgNamePostalAddress.POBoxAddrNonDeliverableReason,
_OrgNamePostalAddress.POBoxIsWithoutNumber,
_OrgNamePostalAddress.POBoxPostalCode,
_OrgNamePostalAddress.POBoxLobbyName,
_OrgNamePostalAddress.POBoxDeviatingCityName,
@ObjectModel.foreignKey.association: '_POBoxDeviatingCityCode'
@ObjectModel.sapObjectNodeTypeReference: 'CityNumber'
_OrgNamePostalAddress.POBoxDeviatingCityCode,
@ObjectModel.foreignKey.association: '_POBoxDeviatingRegion'
@ObjectModel.sapObjectNodeTypeReference: 'Region'
_OrgNamePostalAddress.POBoxDeviatingRegion,
@ObjectModel.foreignKey.association: '_POBoxDeviatingCountry'
@ObjectModel.sapObjectNodeTypeReference: 'Country'
_OrgNamePostalAddress.POBoxDeviatingCountry,
_OrgNamePostalAddress.CareOfName,
@ObjectModel.foreignKey.association: '_DeliveryServiceTypeCode'
@ObjectModel.sapObjectNodeTypeReference: 'DeliveryServiceTypeCode'
_OrgNamePostalAddress.DeliveryServiceTypeCode,
_OrgNamePostalAddress.DeliveryServiceNumber,
@ObjectModel.foreignKey.association: '_TimeZone'
@ObjectModel.sapObjectNodeTypeReference: 'TimeZone'
_OrgNamePostalAddress.AddressTimeZone,
@ObjectModel.foreignKey.association: '_SecondaryRegion'
@ObjectModel.sapObjectNodeTypeReference: 'SecondaryRegion'
_OrgNamePostalAddress.SecondaryRegion,
_OrgNamePostalAddress.SecondaryRegionName,
@ObjectModel.foreignKey.association: '_TertiaryRegion'
@ObjectModel.sapObjectNodeTypeReference: 'TertiaryRegion'
_OrgNamePostalAddress.TertiaryRegion,
_OrgNamePostalAddress.TertiaryRegionName,
@ObjectModel.foreignKey.association: '_RegionalStructureCheckStatus'
@ObjectModel.sapObjectNodeTypeReference: 'RegionalStructureCheckStatus'
_OrgNamePostalAddress.RegionalStructureCheckStatus,
@ObjectModel.foreignKey.association: '_AddressGroup'
@ObjectModel.sapObjectNodeTypeReference: 'AddressGroup'
_OrgNamePostalAddress.AddressGroup,
_OrgNamePostalAddress.DistrictNumber,
_OrgNamePostalAddress.Village,
_OrgNamePostalAddress.RegionalStructureGroup,
@Semantics.user.createdBy: true
_OrgNamePostalAddress.AddressCreatedByUser,
@Semantics.systemDateTime.createdAt: true
@Analytics.hidden: true
_OrgNamePostalAddress.AddressCreatedOnDateTime,
@Semantics.user.lastChangedBy: true
_OrgNamePostalAddress.AddressChangedByUser,
@Semantics.systemDateTime.lastChangedAt: true
@Analytics.hidden: true
_OrgNamePostalAddress.AddressChangedOnDateTime,
_EmailAddress,
_PhoneNumber,
_FaxNumber,
_UniformResourceIdentifier,
_CurrentDfltEmailAddress,
_CurrentDfltLandlinePhoneNmbr,
_CurrentDfltMobilePhoneNumber,
_CurrentDfltFaxNumber,
_MainWebsiteURL,
_Region,
_Country,
_FormOfAddress,
_POBoxAddrNonDeliverableReason,
_StreetAddrNonDeliverableRsn,
_TransportationZone,
_POBoxDeviatingCountry,
_POBoxDeviatingRegion,
_PrfrdCommMediumType,
_DeliveryServiceTypeCode,
_CorrespondenceLanguage,
_AddressObjectType,
_AddressRepresentationCode,
_SecondaryRegion,
_TertiaryRegion,
_PostalCity,
_TimeZone,
_NameSupplement,
_FamilyNamePrefix,
_FamilyNameSecondPrefix,
_RegionalStructureCheckStatus,
_AcademicTitle,
_AcademicTitle2,
_Street,
_AddressGroup,
_AddressPersonName,
_POBoxDeviatingCityCode,
_AddressRemark
}
where
PersonAddressObjectType = 'P'