I_AddressURI

DDL: I_ADDRESSURI Type: view_entity COMPOSITE

URI Address

I_AddressURI is a Composite CDS View that provides data about "URI Address" in SAP S/4HANA. It reads from 1 data source (AddressURI_TF) and exposes 9 fields with key fields AddressID, AddressPersonID, CommMediumSequenceNumber. It has 3 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
AddressURI_TF AddressURI_TF from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_AddressCommunicationRemark_2 _AddressCommunicationRemark $projection.AddressID = _AddressCommunicationRemark.AddressID and $projection.AddressPersonID = _AddressCommunicationRemark.AddressPersonID and $projection.CommMediumSequenceNumber = _AddressCommunicationRemark.CommMediumSequenceNumber and _AddressCommunicationRemark.CommunicationMediumType = 'URI'
[0..*] I_AddressCommunicationUsage _AddressCommunicationUsage $projection.AddressID = _AddressCommunicationUsage.AddressID and $projection.AddressPersonID = _AddressCommunicationUsage.AddressPersonID and $projection.CommMediumSequenceNumber = _AddressCommunicationUsage.CommMediumSequenceNumber and _AddressCommunicationUsage.CommunicationMediumType = 'URI'
[0..1] I_AddressManagementURIType _AddressManagementURIType $projection.AddressManagementURIType = _AddressManagementURIType.AddressManagementURIType

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label URI Address view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID
KEY AddressPersonID AddressPersonID
KEY CommMediumSequenceNumber CommMediumSequenceNumber
AddressManagementURIType AddressManagementURIType
URLIsCurrentDefault URLIsCurrentDefault
UniformResourceIdentifier UniformResourceIdentifier
_AddressCommunicationRemark _AddressCommunicationRemark
_AddressCommunicationUsage _AddressCommunicationUsage
_AddressManagementURIType _AddressManagementURIType 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[],
"ASSOCIATED":
[
"I_ADDRESSCOMMUNICATIONREMARK_2",
"I_ADDRESSCOMMUNICATIONUSAGE",
"I_ADDRESSMANAGEMENTURITYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More