I_ADDRESSURI

CDS View

URI Address

I_ADDRESSURI is a CDS View in S/4HANA. URI Address. It contains 8 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 8 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPAddressIndependentWebsite view from BASIC BP Address independent Website
I_BPRelshpCntctPersnWbsteURLTP view_entity inner TRANSACTIONAL BO view for Contact Person Website
I_BPWebsiteURL_2 view from BASIC BP Website
R_AddressURITP view_entity from Address URI - TP
R_URITP view_entity from TRANSACTIONAL Address URI - TP

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 2
KEY AddressPersonID Person 2
KEY CommMediumSequenceNumber OrdinalNumber,OrdinalNumberForEdit 3
_AddressCommunicationRemark _AddressCommunicationRemark 2
_AddressManagementURIType _AddressManagementURIType 2
AddressManagementURIType UniformResourceIdentifierType 2
UniformResourceIdentifier WebsiteURL 3
URLIsCurrentDefault IsDefaultURLAddress 3 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: ['_AddressCommunicationRemark', '_AddressCommunicationUsage']
@EndUserText.label: 'URI Address'
//@Metadata.allowExtensions: true

//@ObjectModel.representativeKey: 'AddressID'

@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
@VDM.viewType: #COMPOSITE

define view entity I_AddressURI
  as select from AddressURI_TF( P_SAPClient : $session.client )
  association [0..*] to I_AddressCommunicationRemark_2 as _AddressCommunicationRemark on  $projection.AddressID                               = _AddressCommunicationRemark.AddressID
                                                                                      and $projection.AddressPersonID                         = _AddressCommunicationRemark.AddressPersonID
                                                                                      and $projection.CommMediumSequenceNumber                = _AddressCommunicationRemark.CommMediumSequenceNumber
                                                                                      and _AddressCommunicationRemark.CommunicationMediumType = 'URI'

  association [0..*] to I_AddressCommunicationUsage    as _AddressCommunicationUsage  on  $projection.AddressID                              = _AddressCommunicationUsage.AddressID
                                                                                      and $projection.AddressPersonID                        = _AddressCommunicationUsage.AddressPersonID
                                                                                      and $projection.CommMediumSequenceNumber               = _AddressCommunicationUsage.CommMediumSequenceNumber
                                                                                      and _AddressCommunicationUsage.CommunicationMediumType = 'URI'

  association [0..1] to I_AddressManagementURIType     as _AddressManagementURIType   on  $projection.AddressManagementURIType = _AddressManagementURIType.AddressManagementURIType
{
  key AddressID,
  key AddressPersonID,
  key CommMediumSequenceNumber,
      @ObjectModel.foreignKey.association: '_AddressManagementURIType'
      AddressManagementURIType,    
      URLIsCurrentDefault,  
      // URIFieldLengthInChar,  /// Needed for technical reasons only

      UniformResourceIdentifier,

      _AddressCommunicationRemark,
      _AddressCommunicationUsage,
      _AddressManagementURIType
}

Learn More