I_AddressMainWebsiteURL

DDL: I_ADDRESSMAINWEBSITEURL Type: view_entity COMPOSITE

Website

I_AddressMainWebsiteURL is a Composite CDS View that provides data about "Website" in SAP S/4HANA. It reads from 1 data source (AddressMainWebsiteURL_TF) and exposes 6 fields with key fields AddressID, AddressPersonID. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
AddressMainWebsiteURL_TF AddressMainWebsiteURL_TF from

Associations (2)

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'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Website 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 (6)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddresssMainWebsiteURL AddressID
KEY AddressPersonID AddresssMainWebsiteURL AddressPersonID
CommMediumSequenceNumber AddresssMainWebsiteURL CommMediumSequenceNumber
UniformResourceIdentifier AddresssMainWebsiteURL UniformResourceIdentifier
_AddressCommunicationRemark _AddressCommunicationRemark
_AddressCommunicationUsage _AddressCommunicationUsage 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: ['_AddressCommunicationRemark', '_AddressCommunicationUsage']
@EndUserText.label: 'Website'
//@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_AddressMainWebsiteURL
  as select from AddressMainWebsiteURL_TF( P_SAPClient : $session.client ) as AddresssMainWebsiteURL

  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'
{
  key  AddresssMainWebsiteURL.AddressID,
  key  AddresssMainWebsiteURL.AddressPersonID,
       AddresssMainWebsiteURL.CommMediumSequenceNumber,
       // AddresssMainWebsiteURL.AddressManagementURIType,

       // AddresssMainWebsiteURL.URIFieldLengthInChar,

       AddresssMainWebsiteURL.UniformResourceIdentifier,

       _AddressCommunicationRemark,
       _AddressCommunicationUsage
}

Learn More