I_SiteValnAndInvtryManagement

DDL: I_SITEVALNANDINVTRYMANAGEMENT SQL: ISTVALINVMGMT Type: view BASIC Package: VDM_RFM_SITE

Site Valuation and inventory mgmt

I_SiteValnAndInvtryManagement is a Basic CDS View that provides data about "Site Valuation and inventory mgmt" in SAP S/4HANA. It reads from 1 data source (wrf1) and exposes 4 fields with key field SiteCustomer. It has 2 associations to related views. Part of development package VDM_RFM_SITE.

Data Sources (1)

SourceAliasJoin Type
wrf1 wrf1 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Site _Site $projection.SiteCustomer = _Site.SiteCustomer
[1..1] I_Customer _Customer $projection.SiteCustomer = _Customer.Customer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISTVALINVMGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.representativeKey SiteCustomer view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Site Valuation and inventory mgmt view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SiteCustomer locnr
ProfitCenter prctr
_Site _Site
_Customer _Customer
@AbapCatalog.sqlViewName: 'ISTVALINVMGMT'

@AbapCatalog: {
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl: {
    authorizationCheck: #NOT_REQUIRED,
    personalData.blocking: #NOT_REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@ObjectModel: {
    semanticKey: ['SiteCustomer'],
    representativeKey: 'SiteCustomer',
    usageType: {
        serviceQuality: #A,
        sizeCategory: #M,
        dataClass: #MASTER
   }
}
@EndUserText.label: 'Site Valuation and inventory mgmt'
define view I_SiteValnAndInvtryManagement
  as select from wrf1
  association [1..1] to I_Site     as _Site     on $projection.SiteCustomer = _Site.SiteCustomer
  association [1..1] to I_Customer as _Customer on $projection.SiteCustomer = _Customer.Customer
{
  key locnr as SiteCustomer,
      prctr as ProfitCenter,
//      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]

      _Site,
      _Customer
}