P_ADDRESS_2
P_ADDRESS_2 is a CDS View in S/4HANA. It contains 83 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_Address_2 | view_entity | from | COMPOSITE | Address of an Organization or a Person |
Fields (83)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressID | AddressID | 1 |
| KEY | AddressPersonID | AddressPersonID | 1 |
| KEY | AddressRepresentationCode | AddressRepresentationCode | 1 |
| _AddressGroup | _AddressGroup | 1 | |
| _AddressObjectType | _AddressObjectType | 1 | |
| _AddressPersonName | _AddressPersonName | 1 | |
| _AddressRepresentationCode | _AddressRepresentationCode | 1 | |
| _CorrespondenceLanguage | _CorrespondenceLanguage | 1 | |
| _Country | _Country | 1 | |
| _DeliveryServiceTypeCode | _DeliveryServiceTypeCode | 1 | |
| _FormOfAddress | _FormOfAddress | 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 | |
| AddressChangedByUser | AddressChangedByUser | 1 | |
| AddressChangedOnDateTime | AddressChangedOnDateTime | 1 | |
| AddressCreatedByUser | AddressCreatedByUser | 1 | |
| AddressCreatedOnDateTime | AddressCreatedOnDateTime | 1 | |
| AddresseeFullName | AddresseeFullName | 1 | |
| AddressGroup | AddressGroup | 1 | |
| AddressObjectType | AddressObjectType | 1 | |
| AddressSearchTerm1 | AddressSearchTerm1 | 1 | |
| AddressSearchTerm2 | AddressSearchTerm2 | 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 | |
| Floor | Floor | 1 | |
| FormOfAddress | FormOfAddress | 1 | |
| HouseNumber | HouseNumber | 1 | |
| HouseNumberSupplementText | HouseNumberSupplementText | 1 | |
| OrganizationName1 | OrganizationName1 | 1 | |
| OrganizationName2 | OrganizationName2 | 1 | |
| OrganizationName3 | OrganizationName3 | 1 | |
| OrganizationName4 | OrganizationName4 | 1 | |
| PersonFamilyName | PersonFamilyName | 1 | |
| PersonGivenName | PersonGivenName | 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 | |
| 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 |
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
//@ObjectModel.representativeKey: 'AddressID'
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_Address_2
as select from I_PersonAddress
{
key AddressID,
key AddressPersonID,
key AddressRepresentationCode,
AddressObjectType,
CorrespondenceLanguage,
PrfrdCommMediumType,
PersonFullName as AddresseeFullName,
GivenName as PersonGivenName,
FamilyName as PersonFamilyName,
cast(' ' as ad_name1) as OrganizationName1,
cast(' ' as ad_name2) as OrganizationName2,
cast(' ' as ad_name3) as OrganizationName3,
cast(' ' as ad_name4) as OrganizationName4,
AddressPersonSearchTerm1 as AddressSearchTerm1,
AddressPersonSearchTerm2 as AddressSearchTerm2,
CityNumber,
CityName,
DistrictName,
VillageName,
PostalCode,
CompanyPostalCode,
Street,
StreetName,
@EndUserText.label: 'Street Address Non-Deliverable Reason'
StreetAddrNonDeliverableReason,
StreetPrefixName1,
StreetPrefixName2,
StreetSuffixName1,
StreetSuffixName2,
HouseNumber,
HouseNumberSupplementText,
Building,
Floor,
RoomNumber,
Country,
Region,
FormOfAddress,
TaxJurisdiction,
TransportZone,
POBox,
@EndUserText.label: 'PO Box Address Non-Deliverable Reason'
POBoxAddrNonDeliverableReason,
POBoxIsWithoutNumber,
POBoxPostalCode,
POBoxLobbyName,
POBoxDeviatingCityName,
POBoxDeviatingCityCode,
POBoxDeviatingRegion,
POBoxDeviatingCountry,
CareOfName,
DeliveryServiceTypeCode,
DeliveryServiceNumber,
AddressTimeZone,
SecondaryRegion,
SecondaryRegionName,
TertiaryRegion,
TertiaryRegionName,
RegionalStructureCheckStatus,
AddressGroup,
@Semantics.user.createdBy: true
AddressCreatedByUser,
@Semantics.systemDateTime.createdAt: true
@Analytics.hidden: true
AddressCreatedOnDateTime,
@Semantics.user.lastChangedBy: true
AddressChangedByUser,
@Semantics.systemDateTime.lastChangedAt: true
@Analytics.hidden: true
AddressChangedOnDateTime,
_Region,
_Country,
_FormOfAddress,
_StreetAddrNonDeliverableRsn,
_POBoxAddrNonDeliverableReason,
_TransportationZone,
_POBoxDeviatingRegion,
_POBoxDeviatingCountry,
_PrfrdCommMediumType,
_DeliveryServiceTypeCode,
_CorrespondenceLanguage,
_AddressObjectType,
_AddressRepresentationCode,
_SecondaryRegion,
_TertiaryRegion,
_PostalCity,
_TimeZone,
_RegionalStructureCheckStatus,
_Street,
_AddressGroup,
_AddressPersonName,
_POBoxDeviatingCityCode
}
union all
select from I_OrganizationAddress
{
key AddressID,
key AddressPersonID,
key AddressRepresentationCode,
AddressObjectType,
CorrespondenceLanguage,
PrfrdCommMediumType,
AddresseeFullName,
cast(' ' as ad_namefir) as PersonGivenName,
cast(' ' as ad_namelas) as PersonFamilyName,
AddresseeName1 as OrganizationName1,
AddresseeName2 as OrganizationName2,
AddresseeName3 as OrganizationName3,
AddresseeName4 as OrganizationName4,
AddressSearchTerm1,
AddressSearchTerm2,
CityNumber,
CityName,
DistrictName,
VillageName,
PostalCode,
CompanyPostalCode,
Street,
StreetName,
StreetAddrNonDeliverableReason,
StreetPrefixName1,
StreetPrefixName2,
StreetSuffixName1,
StreetSuffixName2,
HouseNumber,
HouseNumberSupplementText,
Building,
Floor,
RoomNumber,
Country,
Region,
FormOfAddress,
TaxJurisdiction,
TransportZone,
POBox,
POBoxAddrNonDeliverableReason,
POBoxIsWithoutNumber,
POBoxPostalCode,
POBoxLobbyName,
POBoxDeviatingCityName,
POBoxDeviatingCityCode,
POBoxDeviatingRegion,
POBoxDeviatingCountry,
CareOfName,
DeliveryServiceTypeCode,
DeliveryServiceNumber,
AddressTimeZone,
SecondaryRegion,
SecondaryRegionName,
TertiaryRegion,
TertiaryRegionName,
RegionalStructureCheckStatus,
AddressGroup,
AddressCreatedByUser,
AddressCreatedOnDateTime,
AddressChangedByUser,
AddressChangedOnDateTime,
_Region,
_Country,
_FormOfAddress,
_StreetAddrNonDeliverableRsn,
_POBoxAddrNonDeliverableReason,
_TransportationZone,
_POBoxDeviatingRegion,
_POBoxDeviatingCountry,
_PrfrdCommMediumType,
_DeliveryServiceTypeCode,
_CorrespondenceLanguage,
_AddressObjectType,
_AddressRepresentationCode,
_SecondaryRegion,
_TertiaryRegion,
_PostalCity,
_TimeZone,
_RegionalStructureCheckStatus,
_Street,
_AddressGroup,
_AddressPersonName,
_POBoxDeviatingCityCode
}