R_OrganizationAddressTP

DDL: R_ORGANIZATIONADDRESSTP Type: view_entity

Organization Address - TP

R_OrganizationAddressTP is a CDS View that provides data about "Organization Address - TP" in SAP S/4HANA. It reads from 1 data source (I_AddrOrgNamePostalAddress) and exposes 66 fields with key field AddressID. It has 5 associations to related views.

1 data source(s) 66 fields

Data Sources (1)

SourceAliasJoin Type
I_AddrOrgNamePostalAddress I_AddrOrgNamePostalAddress from

Associations (5)

CardinalityTargetAliasCondition
[0..*] R_AddressPhoneNumberTP _AddressPhoneNumber
[0..*] R_AddressEmailAddressTP _AddressEmailAddress
[0..*] R_AddressFaxNumberTP _AddressFaxNumber
[0..*] R_AddressURITP _AddressURI
[0..*] R_AddrAddlRepresentationTP _AddrAdditionalRepresentation

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Organization Address - TP view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID
AddressRepresentationCode AddressRepresentationCode
AddressIsPersonAddress AddressIsPersonAddress
CorrespondenceLanguage CorrespondenceLanguage
PrfrdCommMediumType PrfrdCommMediumType
CityNumber CityNumber
CityName CityName
DistrictName DistrictName
VillageName VillageName
PostalCode PostalCode
CompanyPostalCode CompanyPostalCode
POBox POBox
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason
POBoxIsWithoutNumber POBoxIsWithoutNumber
POBoxPostalCode POBoxPostalCode
POBoxLobbyName POBoxLobbyName
POBoxDeviatingCityName POBoxDeviatingCityName
POBoxDeviatingCityCode POBoxDeviatingCityCode
POBoxDeviatingRegion POBoxDeviatingRegion
POBoxDeviatingCountry POBoxDeviatingCountry
Street Street
StreetName StreetName
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason
StreetPrefixName1 StreetPrefixName1
StreetPrefixName2 StreetPrefixName2
StreetSuffixName1 StreetSuffixName1
StreetSuffixName2 StreetSuffixName2
HouseNumber HouseNumber
HouseNumberSupplementText HouseNumberSupplementText
Building Building
Floor Floor
RoomNumber RoomNumber
Country Country
Region Region
CareOfName CareOfName
FormOfAddress FormOfAddress
AddresseeName1 AddresseeName1
AddresseeName2 AddresseeName2
AddresseeName3 AddresseeName3
AddresseeName4 AddresseeName4
TaxJurisdiction TaxJurisdiction
TransportZone TransportZone
DeliveryServiceTypeCode DeliveryServiceTypeCode
DeliveryServiceNumber DeliveryServiceNumber
AddressTimeZone AddressTimeZone
SecondaryRegion SecondaryRegion
SecondaryRegionName SecondaryRegionName
TertiaryRegion TertiaryRegion
TertiaryRegionName TertiaryRegionName
AddressSearchTerm1 AddressSearchTerm1
AddressSearchTerm2 AddressSearchTerm2
RegionalStructureCheckStatus RegionalStructureCheckStatus
AddressGroup AddressGroup
AddressCreatedByUser AddressCreatedByUser
AddressCreatedOnDateTime AddressCreatedOnDateTime
AddressChangedByUser AddressChangedByUser
AddressChangedOnDateTime AddressChangedOnDateTime
_Country _Country
_FormOfAddress _FormOfAddress
_Region _Region
_TransportationZone _TransportationZone
_AddressPhoneNumber _AddressPhoneNumber
_AddressEmailAddress _AddressEmailAddress
_AddressFaxNumber _AddressFaxNumber
_AddressURI _AddressURI
_AddrAdditionalRepresentation _AddrAdditionalRepresentation 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Organization Address - TP'
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define root view entity R_OrganizationAddressTP
  as select from I_AddrOrgNamePostalAddress
  composition [0..*] of R_AddressPhoneNumberTP     as _AddressPhoneNumber
  composition [0..*] of R_AddressEmailAddressTP    as _AddressEmailAddress
  composition [0..*] of R_AddressFaxNumberTP       as _AddressFaxNumber
  composition [0..*] of R_AddressURITP             as _AddressURI
  composition [0..*] of R_AddrAddlRepresentationTP as _AddrAdditionalRepresentation
{
  key AddressID,
      AddressRepresentationCode,
      AddressIsPersonAddress,
      CorrespondenceLanguage,
      PrfrdCommMediumType,
      CityNumber,
      CityName,
      DistrictName,
      VillageName,
      PostalCode,
      CompanyPostalCode,
      POBox,
      POBoxAddrNonDeliverableReason,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingCityCode,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,
      Street,
      StreetName,
      StreetAddrNonDeliverableReason,
      StreetPrefixName1,
      StreetPrefixName2,
      StreetSuffixName1,
      StreetSuffixName2,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      Country,
      Region,
      CareOfName,
      FormOfAddress,
      AddresseeName1,
      AddresseeName2,
      AddresseeName3,
      AddresseeName4,
      TaxJurisdiction,
      TransportZone,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,
      SecondaryRegion,
      SecondaryRegionName,
      TertiaryRegion,
      TertiaryRegionName,
      AddressSearchTerm1,
      AddressSearchTerm2,
      RegionalStructureCheckStatus,
      AddressGroup,
      AddressCreatedByUser,
      AddressCreatedOnDateTime,
      AddressChangedByUser,
      AddressChangedOnDateTime,
      /* Associations */
      _Country,
      _FormOfAddress,
      _Region,
      _TransportationZone,
      _AddressPhoneNumber,
      _AddressEmailAddress,
      _AddressFaxNumber,
      _AddressURI,
      _AddrAdditionalRepresentation
}
where
  AddressRepresentationCode is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRORGNAMEPOSTALADDRESS"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_FORMOFADDRESS",
"I_REGION",
"I_TRANSPORTATIONZONE",
"R_ADDRADDLREPRESENTATIONTP",
"R_ADDRESSEMAILADDRESSTP",
"R_ADDRESSFAXNUMBERTP",
"R_ADDRESSPHONENUMBERTP",
"R_ADDRESSURITP"
],
"BASE":
[
"I_ADDRORGNAMEPOSTALADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More