I_SiteToSiteProfile

DDL: I_SITETOSITEPROFILE SQL: ISITETSP Type: view BASIC Package: VDM_RFM_SITE

CDS view for Site to Site Profile

I_SiteToSiteProfile is a Basic CDS View that provides data about "CDS view for Site to Site Profile" in SAP S/4HANA. It reads from 1 data source (t001w) and exposes 5 fields with key field Site. It has 2 associations to related views. Part of development package VDM_RFM_SITE.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
t001w Plant from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SiteProfile _SiteProfile $projection.SiteProfile = _SiteProfile.SiteProfile
[0..1] I_SiteMasterCustomizing _SiteMasterCustomizing $projection.Site = _SiteMasterCustomizing.Site

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISITETSP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS view for Site to Site Profile view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Site t001w werks
SiteCustomer Site locnr
SiteProfileendasSiteProfile
_SiteProfile _SiteProfile
_SiteMasterCustomizing _SiteMasterCustomizing 
@AbapCatalog.sqlViewName: 'ISITETSP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS view for Site to Site Profile'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     sizeCategory:   #M,
     serviceQuality: #C
   }
}

define view I_SiteToSiteProfile
  as select from           t001w as Plant
  left outer to one join wrf1  as Site on Site.locnr = Plant.kunnr
  association [0..1] to I_SiteProfile     as _SiteProfile     on $projection.SiteProfile = _SiteProfile.SiteProfile
  association [0..1] to I_SiteMasterCustomizing as _SiteMasterCustomizing on $projection.Site = _SiteMasterCustomizing.Site
{
  key Plant.werks as Site,
      Site.locnr  as SiteCustomer,
      case when Site.betrp is not initial then  Site.betrp
      else _SiteMasterCustomizing.SiteProfile
      end         as SiteProfile,
      _SiteProfile,
      _SiteMasterCustomizing
}

Learn More