R_AddrAddlRepresentationTP

DDL: R_ADDRADDLREPRESENTATIONTP Type: view_entity

Additional Representation - TP

R_AddrAddlRepresentationTP is a CDS View that provides data about "Additional Representation - TP" in SAP S/4HANA. It reads from 1 data source (I_AddrOrgNamePostalAddress) and exposes 58 fields with key fields AddressID, AddressRepresentationCode.

1 data source(s) 58 fields

Data Sources (1)

SourceAliasJoin Type
I_AddrOrgNamePostalAddress I_AddrOrgNamePostalAddress from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Additional Representation - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID
KEY 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
_Country _Country
_FormOfAddress _FormOfAddress
_Region _Region
_TransportationZone _TransportationZone
_OrganizationAddress _OrganizationAddress 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Additional Representation - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity R_AddrAddlRepresentationTP
  as select from I_AddrOrgNamePostalAddress
  association to parent R_OrganizationAddressTP as _OrganizationAddress on $projection.AddressID = _OrganizationAddress.AddressID
{
  key AddressID,
  key 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,
      _OrganizationAddress
}
where
  AddressRepresentationCode is not initial

Learn More